Log deductions, file receipts under matching codes, and end the year with a tax-ready summary.
View on EtsyTax 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.
Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.
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.
The things buyers ask us most.
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.
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.
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.
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.
Three more workbooks from the same shelf.
Log deductions, file receipts under matching codes, and end the year with a tax-ready summary.
View on EtsySales, purchases and the nine box VAT return, worked out as you log each line.
View on Etsy