● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Taxes & VAT›Receipt Tracker Spreadsheet
Hero image of the Receipt Tracker Spreadsheet, showing the full workbook at a glance
TAXES & VAT

Receipt Tracker Spreadsheet

Tax time should not mean a shoebox of receipts, a glove box full of paper and a rising sense of panic. This receipt tracker spreadsheet gives every business receipt one calm home: log it once, note where the proof lives, and let the file keep the totals, the missing list and the tax page.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Receipts in order all year, not rebuilt in a panic

This tracker was built for freelancers and small business owners who buy things all year and dread sorting them in March. The Receipt Log holds 500 lines, so one file honestly covers a full year of spending. Each line takes the date, receipt number, vendor, description, category, amount, tax included and payment method, plus the detail most systems skip: whether you actually have the receipt, and where it lives.

Anything without proof lands on the Missing Receipts tab on its own, sorted biggest amount first, so you chase the receipts that matter most. The moment you find one and flip its log line to Yes, it clears itself from the list. Monthly and Category Summaries keep running totals by month, category and quarter, including the percentage of spending that has a receipt behind it and how much has none.

Every line is marked Business or Personal, and the Tax Summary shows that split with deductible totals by category, ready to hand to your accountant. The Dashboard answers the January question at a glance: receipts logged, total spent, percentage with receipts, the missing count and amount, and charts of where the money went. One honest note: the tracker organises records and does the arithmetic; it is not tax advice.

Inside the workbook: 9 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the workbook into your own Google account
  • BLANK Excel workbook, clean and ready for your own numbers
  • EXAMPLE Excel workbook filled with sample data, so you can see how everything works first
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files delivered as an instant download, with no ZIP to unpack

Good to know

  • Runs in Microsoft Excel (2021 or Microsoft 365) and in free Google Sheets
  • Works on your computer, tablet and phone, with no macros and nothing to install
  • Pay once and use it every year; duplicate the file for a new tax year
  • Your records stay in your own file; nothing connects to your bank account
  • Questions after purchase? Message us through Etsy and we will help you out

Questions about this template

The things buyers ask us most.

How many receipts can it hold?

The Receipt Log has 500 lines, which covers a full year for most freelancers and small businesses. Every summary, the missing list and the tax page all read the whole log, so nothing needs re-adding or re-totalling as the year fills up. When a new tax year starts, duplicate the file and begin clean.

What if I lose a receipt?

Log the purchase anyway and mark Receipt Kept as No, with a note of where it should be, a Drive folder, your email or the famous shoebox. The Missing Receipts tab lists it, biggest amount first, and it clears itself the moment you find the receipt and flip the log line to Yes.

Does it split business and personal spending?

Yes. Every log line is marked Business or Personal, and the Tax Summary shows the split with deductible totals by category. Personal spending stays visible in your records but separate from the business figures, so the page you hand to your accountant shows exactly what it should and nothing it should not.

I am not good with spreadsheets. Will I manage?

Yes. You type in one table and pick from dropdowns for category, payment method and receipt kept, and everything else fills itself in. The Start Here tab walks you through setup in plain English, and the Quick Start Guide covers the same steps on one page, so help is never far away.

More in Taxes & VAT

All templates in this category →

Three more workbooks from the same shelf.

Tax Deduction Tracker Spreadsheet

Log deductions, file receipts under matching codes, and end the year with a tax-ready summary.

$7.50 $3.00
View on Etsy
VAT Tracker Spreadsheet

Sales, purchases and the nine box VAT return, worked out as you log each line.

$7.50 $3.00
View on Etsy
Freelancer Tax Tracker

Log every payment and see what to set aside for tax each quarter.

$6.99 $2.80
View on Etsy
View on Etsy · $3.00