How to use the record sheet
- Download the three files: sales, costs and mileage. Skip the mileage log if you never drive for your business.
- Open the sales file in your spreadsheet app, then add the other two as extra tabs. In Google Sheets, use File → Import and choose to insert a new sheet. In Excel or Numbers, open each file and move or copy its sheet into one workbook.
- Once a month, copy the totals from each platform's sales report into the sales tab, and add each business purchase to the costs tab.
The example rows on this page show what goes in each column. The downloaded files have the column headings only, so you start with a clean sheet.
What goes in each tab
Sales has one row per month, per platform. Record your sales as items plus the shipping buyers paid, before any fees. Keep the sales tax the platform collected in its own column: the platform passes it on to the state, so it isn't your income. Each platform's downloadable sales report has these totals, so you don't need to type in each order.
Costs has one row per purchase: the date, who you paid, what you bought, a category, the amount, and where the receipt is. The IRS says your records should show who you paid, how much, the date and what you bought, so a card statement alone isn't enough. Platform fees and labels count too: add them from each platform's monthly statement.
Mileage is a log of business trips: the date, the purpose and the miles. Record the date of every trip, because the IRS mileage rate changed partway through 2026.
Categories for the costs tab
Use the same category names every time, so you can total each one at the end of the year. The list on this page covers most small sellers. Add your own if something doesn't fit, but keep the list short.
How long to keep your records
The IRS says to keep records for 3 years in most cases, and longer in some situations, such as for equipment you still own. Our guide to record-keeping for small sellers covers the periods, the platform reports to download, and a 20-minute monthly routine.
This record sheet is general information, not tax advice. For your specific situation, talk to a tax professional.