Small Business Bookkeeping Spreadsheet, Excel and Google Sheets, Income Expense Profit Tracker

You type in one sheet. Everything else fills itself in.

Most bookkeeping templates fail the same two ways: they’re so elaborate you need a tutorial to start, or one stray keystroke wipes a formula and you don’t notice for three months. This one is built against both. Every formula cell is locked, so the only cells you can type in are the ones you’re supposed to. Log a transaction — date, description, category, income or expense, amount — and your profit and loss statement, quarterly tax estimates, and dashboard update on their own.

What’s inside

• Transactions — the only tab you type in. 500 formatted rows, category and type dropdowns.
• P&L — month-by-month income and expenses by category, with a year total column.
• Quarterly Tax — Q1–Q4 summaries plus a set-aside calculator (enter your own rate).
• Dashboard — this month, year to date, and your top five expense categories.
• READ ME FIRST — 60-second setup, and where to edit your categories.

Built for real use: works in Excel and Google Sheets (no Excel subscription needed), opens on Mac, iPad and phone, and the categories are yours to rename — the dropdowns and every total follow automatically.

Includes a one-page quickstart PDF that walks you from download to first entry, because “where did my file go” shouldn’t be the hard part.

A cash-planning tool, not tax advice — your accountant’s numbers win.

How this was made: the spreadsheet’s formulas, layout and documentation were built with the help of AI tools, then tested by hand before release. Every formula in this file has been verified to calculate correctly.