Sample Expense Data
Dated business expenses by category, department and payment status — for budget tracking and SUMIFS by month.
What is in the file
7 columns, 160 data rows by default, plus a header row. These are the first ten rows of the default file.
| Expense ID | Date | Category | Department | Vendor | Amount | Status |
|---|---|---|---|---|---|---|
| EXP-1000 | 2026-06-27 | Software | Operations | Dubois | 24078.69 | Pending |
| EXP-1001 | 2026-04-13 | Software | Sales | Kowalski | 18706.92 | Paid |
| EXP-1002 | 2026-01-27 | Software | Operations | Dubois | 13335.14 | Refunded |
| EXP-1003 | 2026-11-12 | Software | Sales | Kowalski | 7963.37 | Overdue |
| EXP-1004 | 2026-08-29 | Marketing | Marketing | Dubois | 19610.78 | Pending |
| EXP-1005 | 2026-06-14 | Marketing | Support | Bennett | 14239.01 | Paid |
| EXP-1006 | 2026-03-31 | Marketing | Marketing | Andersen | 8867.24 | Refunded |
| EXP-1007 | 2026-01-14 | Marketing | Support | Bennett | 3495.46 | Overdue |
| EXP-1008 | 2026-02-21 | Marketing | Marketing | Rossi | 7059.5 | Pending |
| EXP-1009 | 2026-12-08 | Rent | Support | Sharma | 1687.73 | Paid |
Download 160 rows
7 columns · header included · no signup
Direct files work without JavaScript. Choose another size below.
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
Use these synthetic expense rows to practise summaries by category, department and month. Each row has one date, one category and one amount, so the table can feed a PivotTable without turning month headings into separate data fields. Amounts are generated independently of category; the file does not model recurring rent or seasonal travel costs.
The Excel download stores date columns as numeric Excel dates with a date format. CSV and JSON contain ISO date text; convert those fields to dates during import before using date arithmetic or grouping by month.
What you can practise with it
- SUMIFS spend by category and month
- Add your own budget values, then calculate budget-vs-actual variance and percentage
- Group dates by month or quarter in a PivotTable
- Filter to overdue items and total them
Try a related exercise
- Total a column with SUM — The first formula everybody learns, and the one place a typed-out chain of plus signs still costs people an afternoon.
- Total only the rows that match, with SUMIF — Aggregating a slice of the data instead of all of it — the step from a total to a report.
Tools that work on this data
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this sample expense data free to use?
Yes — for practice, teaching, demos and commercial work alike. The rows are generated, so there is no personal data in the file. Attribution is not required; if you would like to credit it, there is a ready-made line at the bottom of this page.
Do I have to sign up or give an email address?
No. Direct links download the default-size files without JavaScript. The row-count control builds other supported sizes in your browser. Your spreadsheet contents are not uploaded and no account is involved.
Which formats can I download?
The original dataset is available as Excel (.xlsx), CSV and JSON. All three contain the same source rows, so you can use the CSV for an import exercise and the .xlsx for a formula exercise.
Can I choose how many rows I get?
Yes. The browser control offers 25, 100, 160, 500 data rows, plus a header. Direct source links contain 160 data rows; the preview shows the first ten of those rows.