Business Expense Tracker for Excel: Free Template & Formulas
Download a free Excel expense tracker (.xlsx) with monthly totals, category summaries, and a currency filter. No signup. Includes formulas, examples, and a CSV option.
Free Excel workbook. No signup.
Excel tracker with monthly totals
An .xlsx workbook with a transaction sheet, monthly totals, category summaries, and a currency filter. Includes 3 illustrative transactions and formula ranges for 1,000 entries.
Replace the examples and reconcile your records. Currencies are summarized separately, not converted. No macros.
Example summary (USD)
| Category | Expenses |
|---|---|
| Rent | 2,100.00 |
| Software | 312.00 |
| Marketing | 850.00 |
| Total | 3,262.00 |
A business expense tracker for Excel records each transaction once, then summarizes spending by month and category. Use the free workbook above if you want working formulas, or the CSV below if you only need a transaction table to import into another tool.
The Excel workbook (.xlsx) includes a Summary sheet and a Transactions sheet. Change the reporting month and currency on Summary; replace the three example transactions on Transactions. The formulas cover rows 6–1005. Extend those ranges before adding more than 1,000 transactions. Amounts in different currencies are kept separate, not converted.
The data-only CSV contains ten columns: Date, Vendor, Description, Amount, Currency, Category, Payment Account, Receipt or Invoice, Recurring, and Notes. Unlike the workbook, it has no saved formulas or formatting. Both formats contain examples, not customer data, and neither includes receipt attachments.
Use the Excel workbook or set up the CSV
For the workbook, open the .xlsx file and use the two sheets already provided. Reconcile the first month to your source accounts before using the totals. For the CSV version, follow these steps to build your own summary:
- Open the CSV and check that Date contains real dates and Amount contains numbers.
- Save a working copy as an Excel workbook (.xlsx) so formulas and formatting persist.
- Select the transactions, choose Insert → Table, and name the table
Expenses. - Keep one currency per summary, or convert amounts with a documented exchange rate before combining them.
- Add a Summary sheet; keep formulas outside the source transaction table.
Excel formulas for monthly and category totals
Put the first day of the reporting month in Summary!B1. With the table named Expenses, use:
=SUMIFS(Expenses[Amount],Expenses[Date],">="&B1,Expenses[Date],"<"&EDATE(B1,1))
For a category named in A5, add the category condition:
=SUMIFS(Expenses[Amount],Expenses[Category],A5,Expenses[Date],">="&$B$1,Expenses[Date],"<"&EDATE($B$1,1))
These formulas assume all included amounts share one currency and that refunds use negative amounts. Some Excel locales use semicolons instead of commas between arguments. Check the first monthly total against the bank or card statement before relying on the summary.
The three example transactions—rent of 2,100, hosting of 312, and advertising of 850—sum to 3,262. A category summary should reconcile to the same total when it includes those same three rows.
Recommended columns
Reconciliation example: a refund, a transfer, and a duplicate
Extend the three-row teaching example with an advertising refund of $100, an internal transfer of $500, and a duplicate hosting import of $312. These extra entries illustrate the review process; they are not additional rows in the downloadable CSV.
| Entry | Included expense | Reason |
|---|---|---|
| Rent, hosting, and advertising | $3,262 | Original example expense rows |
| Advertising refund | −$100 | Reduces the included expense |
| Transfer between company accounts | $0 | Account movement, not a new expense |
| Confirmed duplicate hosting import | $0 | Keep one verified transaction |
| Reconciled expense total | $3,162 | $3,262 − $100 |
Keep excluded rows in a separate review log rather than erasing the evidence. Confirm the refund belongs to the same reporting basis before netting it against expense. If the bank balance still differs, check missing accounts, timing, tax treatment, and unpaid bills; do not force the tracker to match by adding an unexplained adjustment.
The IRS recordkeeping guide describes keeping supporting documents alongside income and expense records. Its tax context is U.S.-specific; this example is a management control, not tax advice.
For the formulas above, see Microsoft's documentation for SUMIFS and EDATE. Test your locale's separators and verify the first month manually.
Use one row per transaction. Include date, vendor, description, category, department, payment account, amount, tax, currency, recurring status, receipt reference, approver, and notes. Do not merge cells or place subtotals inside the transaction table.
Maintain a separate controlled category list. Categories should be useful enough to explain performance but stable enough to compare periods. Read the small-business expense-category guide before redesigning the chart.
A dependable monthly workflow
For the broader process—including receipts, recurring costs, and which changes to investigate—see how to track small-business expenses each month. The steps below show where the workbook fits.
- Import bank, card, cash, and reimbursement activity.
- Remove transfers and confirmed duplicates.
- Attach or reference supporting documents.
- Assign categories and owners consistently.
- Reconcile totals to each source account.
- Review exceptions and material changes.
- Lock the reviewed period before reporting.
Excel formulas and pivot tables can summarize category totals, but the source table should remain unchanged. Calculate ratios from consolidated totals rather than averaging percentages from departments.
Useful monthly calculations
Calculate category variance, expense growth, recurring-cost concentration, and the expense-to-revenue ratio. Always use net revenue from the same period as the expenses.
Use the operating expense ratio formula guide to keep the numerator, net-revenue basis, and reporting period consistent before comparing months or departments.
Variance = Actual expense − Budgeted expense
Variance % = (Actual − Budget) ÷ Budget × 100
Explain material movements using price, volume, timing, mix, or one-off drivers. Avoid assigning a cause unless the file or supporting evidence establishes it.
Common spreadsheet failures
Watch for inconsistent date formats, amounts stored as text, mixed currencies, overwritten formulas, hidden rows, duplicate imports, blank categories, and totals embedded in raw data. Preserve the original export and work from a controlled copy.
For subscriptions and contracts, maintain the separate recurring expense tracker. Then use the monthly expense report guide to present the reviewed results.
Want to see what comes after the tracker? Review the public sample report before creating an account. When your records are reconciled, start a free trial to prepare a management-report draft for review. The trial requires no card and does not start an automatic paid subscription.
Frequently Asked Questions
Can Excel track business expenses reliably?
Yes, for a controlled process with consistent columns, access, reconciliation, and review. Complexity and transaction volume may eventually justify an accounting or expense platform.
Should receipts be embedded in the workbook?
Usually it is better to store the documents securely and record a stable reference or link in the tracker.
Can I upload the tracker to Raavue?
Yes. Reconcile it first, keep one record per row, and use clear column headings.
Put this guide into practice
Related articles
Analyze your Excel expense file
Create a source-backed management analysis from a reconciled transaction export.