Small Business Bookkeeping Template (Free + Exactly How to Use It)
If you run a small business or an Etsy shop, bookkeeping is the task everyone puts off — until tax time makes it painful. The good news: you don’t need accounting software or a bookkeeper to stay organized. A well-built small business bookkeeping template does the math for you, so you always know your profit and you’re ready for taxes.
Here’s a simple system that takes about two minutes a week, and a free template to get you started.
What bookkeeping actually needs to do
Ignore the jargon. For a small business, good bookkeeping answers four questions:
- How much money came in? (income)
- How much went out? (expenses)
- What’s my profit? (income minus expenses)
- What can I deduct? (tax-deductible expenses, by category)
That’s it. Everything else — dashboards, charts, tax summaries — is just a nicer way of showing those four numbers.
The simple weekly system
Once a week, do two things:
- Log your income. Every sale or payment gets one row: date, description, category, amount. If you sell on Etsy, log the payout and note the fees separately (more on that below).
- Log your expenses. Every cost gets one row: date, vendor, category, amount, and whether it’s tax-deductible.
If your template is built well, that’s the entire job. Your profit-and-loss total, your monthly trend, and your expenses-by-category update automatically the moment you type.
Use Schedule C-style categories from day one
In the US, sole proprietors report business income on Schedule C, which groups expenses into standard categories (advertising, supplies, shipping, software, home office, and so on). If you tag every expense with one of those categories as you go, your taxes get dramatically easier — you can hand your accountant a clean summary, or fill out the form yourself in minutes.
Common categories to set up:
- Materials & supplies
- Platform/Etsy fees and payment processing fees
- Shipping & postage, packaging
- Advertising & marketing
- Software & subscriptions
- Office expense, home office, utilities
- Mileage (tracked separately at the IRS standard rate)
Etsy sellers: track your platform fees and payment processing fees as their own categories. They add up fast, and they’re deductible — but only if you record them. A tracker with those categories built in shows your real profit after fees.
Don’t forget mileage and sales tax
Two things small businesses routinely miss:
- Mileage. Business driving (supply runs, post office, markets) is deductible at the IRS standard rate. Log the date, purpose and miles, and let the template multiply it out.
- Sales tax. If you collect sales tax, track what you collected versus what you’ve remitted so you always know what you owe.
Grab the free template
Want to start today? Our free Income & Expense Tracker gives you the core of the system — log money in and out, and it totals your income, expenses and net profit automatically. It’s a one-tab taste of the full tool.
When you’re ready to go further, the Small Business Bookkeeping Spreadsheet adds an automatic Profit & Loss dashboard, all the Schedule C-style categories, a deductible flag for instant write-off totals, and built-in mileage and sales-tax trackers — in both Google Sheets and Excel, light and dark. It’s built for Etsy sellers, freelancers and solopreneurs who want their books done in two minutes a week.
This is a bookkeeping tool, not tax advice — check with your accountant for filing.