Tools · Financial Health

Small Business Bookkeeping & Tax-Prep Organizer

Small Business Bookkeeping & Tax-Prep Organizer

Most small businesses do their bookkeeping in March, for the year that ended in December, out of a carrier bag.

$24 one-off

Buy — $24

Small-Business-Bookkeeping-and-Tax-Prep-Organizer.xlsx · 8 tabs, 1,323 live formulas, no macros

Instant download, nothing ships. Works in Excel, no subscription. If it does not do what you needed, tell me and I will make it right.

It takes a miserable weekend. It produces numbers nobody trusts. And it means every decision made during the year was made blind.

Here's the other way: ten minutes a week.

Friday afternoon, bank feed open, enter the week, set aside the tax, close the file.

What makes this different from the other bookkeeping templates

It tells you how much to set aside for tax — every month. Not a total at year end. A monthly figure, calculated on your profit at the percentage your accountant gives you, with a running total against what you've already paid.

In the example: $63,548 of profit → $17,793 to set aside.

Move it to a separate account the same week you earn it and a tax bill stops being an event. Leave it in the operating account and you'll spend it — because it looks exactly like your money right up until it isn't.

It catches your mistakes before your accountant does. The Categories tab has a cell labeled "UNCATEGORISED — must be zero." If you misspell a category anywhere in 500 expense rows, that cell stops being zero. You find it in the same week, not in March when nothing adds up and you can't remember what half the entries were.

It tracks receipts honestly. A Y/N column per expense, and a live total on the summary: "Expenses missing a receipt: $512.80." Find the documents or expect them to be removed. A Y you typed without keeping the document is worse than an honest N.

It has a real mileage log — 200 trips, with a business-purpose field and automatic deduction at whatever rate you enter. This is the deduction people most often lose simply for want of a record. Four words written at the time — "site measure for quote" — beats a reconstruction a year later.

And a year-end checklist in the order your accountant will ask. Twelve items, including the one that catches everybody: collect contractor tax details before you pay them. Chasing somebody in January, after the work is done and the cheque has cleared, is a genuinely unpleasant job.

What's inside

  • 300 income rows and 500 expense rows, with the month tagged automatically
  • 18 expense categories following common small-business headings, with year totals
  • A 200-trip mileage log
  • Twelve months of income, expenses, profit, tax reserve and running totals
  • A year-end checklist you can hand to your accountant

Please read this before buying

This is an organizer, not tax advice and not accounting software. The categories follow the common headings a small business return uses, but what is deductible, at what rate, and how you must substantiate it depends on your business, your entity type and your jurisdiction — those are questions for your accountant.

The tax reserve percentage and the mileage rate are cells you fill in. Ask your accountant for the first. Check the current official rate for the second. Both change, and a template that hard-codes them will be wrong within a year.

Built for

Sole traders and single-member LLCs · contractors and trades · freelancers and consultants · Etsy and online sellers · anyone whose bookkeeping currently lives in a shoebox and a bank app.

What you get

One .xlsx file, eight tabs, instant download. Excel, Google Sheets, Apple Numbers, LibreOffice. No macros, no add-ins, no subscription, no monthly fee.

A partial year of realistic sample data is loaded so you can see it working. Delete it and start.

A look inside

More in Financial Health

Small Business Financial Health Dashboard

Stop guessing whether your business is actually making money.

$29

How Much Can I Pay Myself?

How much are you actually paying yourself per hour?

$27

If Revenue Drops: The Downturn Playbook

If your revenue dropped 30% next month, what would you cut first? And second? And how long would you have?

$29