Small Business Bookkeeping (Cash Basis)

What you get

A single Excel workbook with six interconnected sheets covering everything from recording your first transaction to producing year-end reports a CPA can work from directly. All formulas are live and cross-referenced, so the Income Statement, Balance Sheet, and Cash Flow update automatically as you log transactions. Twelve months of sample data come pre-loaded so every formula is visible in action before you replace the numbers with your own.

Who it's for

Built for solo founders, freelancers, and micro-businesses who handle their own bookkeeping and want a clean, structured system instead of accounting software. The right moment to buy is when spreadsheet chaos is costing you time at tax season, or when you need to hand an accountant something organized rather than a folder of receipts and rough notes.

What's inside

• Chart of Accounts — a pre-built, editable account list organized by type, serving as the backbone that all other sheets reference
• Transaction Register — a monthly log where income and expenses are recorded on the cash method: income when received, expenses when paid
• Income Statement — auto-generated from logged transactions, showing revenue, expenses, and net income for any period
• Balance Sheet — a point-in-time snapshot of assets, liabilities, and equity that updates as your data changes
• Cash Flow Summary — a straightforward view of cash in and cash out, organized by operating activity
• Tax Prep Summary — an end-of-year sheet that consolidates figures by tax category, formatted for easy review by you or a CPA
• 12 months of sample data — realistic placeholder transactions that demonstrate every formula and layout before you enter your own numbers

How to use it

Open the file in Microsoft Excel or upload it to Google Sheets. Review the Chart of Accounts and adjust account names to match your business, then clear the sample transactions and start logging your own. The Income Statement, Balance Sheet, Cash Flow, and Tax Prep Summary update automatically and require no additional setup.