Business Expense Tracker Template
Detailed expense logging with receipt tracking, mileage integration, and HMRC-compliant categorisation.
File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice compatible)
Expense Tracker
- Detailed expense logging
- Receipt reference tracking
- Payment method recording
- HMRC expense categories
What is a Business Expense Tracker?
A Business Expense Tracker is a detailed log for recording every penny your business spends. It goes beyond a simple list — it categorises each expense by HMRC-approved type, tracks receipt references, flags potentially disallowable items, and produces monthly and annual summaries that make tax time painless.
Common use cases:
- Logging every business expense with full details for HMRC compliance
- Tracking receipts and matching them to expense entries
- Identifying which expenses are fully allowable vs partially disallowable
- Monitoring spending patterns to find cost-cutting opportunities
- Producing clean expense summaries for accountants or Self Assessment
When to use this template
- You have regular business expenses and want detailed records
- You need to track receipts and match them to bank transactions
- You want to spot disallowable expenses before your accountant does
- You have multiple payment methods (bank, card, cash, PayPal) to reconcile
What Your Template Contains
Everything you need, pre-built and ready to use. Just enter your data in the blue cells.
Detailed Expense Logging
Record date, vendor, description, category, payment method, and amount for every expense.
Receipt Reference Tracking
Assign a receipt number to each entry and note where the physical or digital receipt is stored.
Payment Method Recording
Track whether each expense was paid by bank transfer, card, cash, or PayPal for easy reconciliation.
HMRC Expense Categories
All categories align with HMRC Self Assessment SA103 — no recategorising needed at year-end.
Monthly & Annual Summaries
See spending by category for any month or the full year. Spot trends and overspending instantly.
Disallowable Item Flagging
The template flags expenses that may not be fully tax-deductible — entertaining, personal portions, fines, etc.
How This Template Helps Your Business
Never Lose a Receipt Again
Every expense gets a reference number. When HMRC asks (or your accountant does), you know exactly where to find the proof.
Catch Disallowable Expenses Early
The template flags items that might not be tax-deductible — saving you from claiming too much and facing HMRC penalties.
Understand Your Spending
Monthly summaries reveal where your money actually goes. Often the biggest surprise for small business owners.
Get Started in Minutes
No accounting knowledge required. Follow these simple steps and you'll be tracking your finances in no time.
Download TemplateDownload the template and open in Excel or Google Sheets
Enter your business details and tax year on the cover sheet
For each expense, fill in: date, vendor, description, category, payment method, and amount
Add a receipt reference number and note where the receipt is filed
Review the monthly summary to see spending by category and spot trends
At year-end, use the annual summary for your Self Assessment or send to your accountant
Related Templates
You might also find these useful
Cash Book
Track income and expenses month by month with automatic running balance, bank reconciliation, and profit summary.
Self-Employed Log
Designed for sole traders and freelancers. Simple transaction list that auto-summarises into HMRC-friendly categories.
Mileage Log
Track business journeys for mileage claims at HMRC-approved rates. Essential for sole traders and small businesses.
Home Office
Calculate the business proportion of home expenses when working from home. HMRC compliant.
Frequently Asked Questions
Quick answers about this template
Ready to Get Started?
Download this free template and take control of your business finances today.
Free download, no email required. Works in Excel and Google Sheets.