Small Business Bookkeeping Spreadsheet: Income, Expense & Tax Tracker

Know where your business money is going with a small business bookkeeping spreadsheet that tracks income, expenses, profit and loss, sales tax and cash flow. Use it in Excel or Google Sheets and own it once—without another accounting software subscription.

Most bookkeeping templates stop at an income expense list. This is a connected system: one ledger feeds a monthly profit and loss, a rolling cash flow forecast, a quarterly tax summary and a bank reconciliation — 20,523 formulas doing the work so you never write one. Built for the self employed and small businesses that want clean books — an accounting template for people who do not speak accountant.

WHY IT KEEPS YOUR BOOKS HONEST
· Drawings stay out of profit — owner drawings, loan payments and transfers show up in the ledger and the bank balance but never inflate the P&L. That is the most common way a home-made sheet misleads its owner.
· A forecast that looks forward — 13 weeks, auto-rolling from the current Monday, built from your actual unpaid invoices and bills by due date plus recurring costs as a weekly run-rate, with a cash cushion alert and your lowest week flagged.
· A tax summary that proves itself — 16 tax categories across four quarters plus the year, sales tax collected vs paid, and a built-in cross-check: income less costs must equal net profit on the P&L; if not, something is miscoded and the file shows you.
· An invoice tracker that chases itself — Paid / Open / OVERDUE status with days late, on both the customer and supplier side, with overdue tiles on the dashboard.
· Bank reconciliation, the calm way — book balance vs statement, uncleared items both ways, ending in RECONCILED or OUT BY with the amount.

THE TWELVE TABS
· START HERE — a four-minute orientation and the colour rule.
· Setup — five input cells drive the whole file.
· Chart of Accounts — 53 preset accounts in four blocks, plus 27 spare slots for your own.
· Transactions (2,000 rows) — the ledger and your income and expense tracker: each entry picks up its type and tax category automatically, with a running bank balance.
· Invoices (500 rows) — money in: tax, total, balance, status and days late.
· Bills (500 rows) — the same engine on the supplier side.
· Recurring (40 items) — regular costs at any frequency, converted to weekly and yearly run-rates.
· Profit & Loss — 12 months by account, with gross and net margin.
· Cash Flow Forecast — the 13-week forward view.
· Tax Summary — 16 categories by quarter and year, with the net-profit cross-check.
· Bank Reconciliation — statement vs books, RECONCILED or OUT BY.
· Dashboard — 16 KPI tiles and 3 charts, all calculated for you.
A hidden LISTS tab powers the dropdowns.

CAPACITY
2,000 transactions · 500 invoices · 500 bills · 40 recurring items · 80 accounts — a full year of records, engineered to stay fast in Google Sheets.

WHAT YOU RECEIVE (one ZIP, instant download)
· SmallBusinessBookkeeping-CashFlow.xlsx — the full system
· A filled sample workbook — fictional Bramble & Co.: 176 transactions, 8 invoices, 6 bills and 8 recurring items to explore first
· User Guide (PDF, 7 pages) — plain English, no jargon
· Google Sheets Instructions (PDF) — a 30-second import, step by step
· Licence (PDF) — single-business licence in plain language
· Setup Tutorial (MP4) — a 4.5-minute silent screen walkthrough
· START-HERE.txt — open this first

COMPATIBILITY
Microsoft Excel 2016 or newer and Microsoft 365, on Mac and PC, and Google Sheets — a 30-second import; the included instructions PDF shows every step. No macros, so nothing to enable and no security warnings.

THE COLOUR RULE
Light blue = you type here. Grey = calculated for you, leave it alone. Yellow = optional override. Sheets are protected with a blank password so a stray click cannot wipe a formula — unprotect any tab in one click to customise.

PAIRS WITH
Sell online? The Reseller Spreadsheet in this shop tracks inventory and true per-item profit before it lands in your books. Landlords pair these books with the Rental Property Tracker Spreadsheet.

FAQ
Q: Do I need Excel or bookkeeping experience?
A: Neither. If you can pick an account from a dropdown and type an amount, the file does the rest — and it works in free Google Sheets too, import guide included.
Q: Will it replace my accountant?
A: No — it keeps your records clean and organised so year-end handoff is fast. It does not give advice or file anything for you.
Q: Can I add my own account names?
A: Yes — the Chart of Accounts has 27 spare slots across its four blocks. Keep each account inside its block (income with income, overheads with overheads) and the P&L maps it automatically; the guide shows exactly where.
Q: Does it handle sales tax?
A: Invoices and bills calculate tax, and the Tax Summary shows sales tax collected vs paid for the year and by quarter — a tax spreadsheet your accountant can work from.
Q: What about recurring costs on odd schedules?
A: The Recurring tab takes any frequency and converts it to a weekly run-rate for the forecast — a deliberate, documented simplification that keeps the 13-week shape true.
Q: Is the sample data real?
A: No — Bramble & Co. and every figure in it are fictional, included so nothing looks empty while you learn the file.

SUPPORT
If a file won't open or a formula misbehaves, message me here on Etsy and I'll fix it or replace the file. I read and answer every message myself.

GOOD TO KNOW
This spreadsheet is a record-keeping and planning tool. It does not provide financial, tax, legal or investment advice.
All numbers shown in the images are from a fictional sample business used for demonstration.
Designed and built by me with AI assistance, then tested against independently computed check-numbers before listing.

Microsoft, Excel and Microsoft 365 are trademarks of Microsoft Corporation. Google Sheets is a trademark of Google LLC. This product is an independent template and is not affiliated with, endorsed by, or sponsored by these companies.