Skip to content

Free Excel and CSV templates

Free Excel expense tracker

Record transactions and review monthly and category totals in the Excel workbook. Prefer a plain transaction table? Choose the CSV. Both downloads are free and require no account.

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)

CategoryExpenses
Rent2,100.00
Software312.00
Marketing850.00
Total3,262.00
View the recurring-expense tracker

What the template includes

Date
Vendor
Description
Amount
Currency
Category
Payment account
Receipt or invoice
Recurring?
Notes

How to use it

  1. 1Open the Excel workbook, select the reporting month and currency, and replace the example transactions. The data-only CSV remains available.
  2. 2Record one row per transaction in rows 6–1005. Extend the formula ranges before adding more than 1,000 entries.
  3. 3Use consistent categories and keep the receipt or invoice reference with each entry. Enter refunds as negative amounts.
  4. 4Reconcile the tracker with each account, then review category and monthly totals. Different currencies are not converted or combined.

Useful for

Weekly transaction recordingMonthly expense reviewsCompany subscription and renewal auditsAccountant handoff preparation

From records to decisions

Turn the completed tracker into a monthly management report

Reconcile the transactions, summarize material movements, calculate ratios from matching periods, preserve evidence, and assign actions with owners and deadlines.

Frequently asked questions

Can I use this expense tracker in Excel or Google Sheets?

Yes. Download the CSV and open or import it in Excel, Google Sheets, Numbers, or another spreadsheet application.

What business expenses should I enter?

Record every business outflow from bank accounts, cards, cash, payment platforms, and employee reimbursements. Identify transfers separately so they are not counted twice.

Does this replace accounting software?

No. This tracker is a practical recording and management-review tool. Use accounting software and a qualified adviser for bookkeeping, tax, payroll, and statutory reporting requirements.

Can this track recurring expenses for a company?

Yes. The page includes a separate recurring-cost register for the vendor, owner, billing frequency, renewal date, cancellation window, seats, utilization, and normalized monthly cost of each subscription or contract.

Related templates

See the product before uploading data

Review a sample, then try your own file.

Check the calculations, evidence, and limitations in the sample. Then decide whether the workflow fits your monthly review.

7 days free. No card. No automatic paid subscription.

Try CSV or Excel files and HTML reports, plus one watermarked PDF report during your trial. PDF input and ongoing PDF export require Professional or an eligible Enterprise agreement.