Small Business Bookkeeping Template

Small Business Bookkeeping Template

A free, beginner-friendly Excel workbook for small business owners who want to track their money without hiring a bookkeeper or learning formal accounting. Everything is formula-driven; enter a transaction once, and every summary, balance, and total updates on its own.

What's inside (8 tabs):

• Start Here – a plain-language guide to the whole workbook: what each tab does, a 5-step setup checklist, and a color legend (blue = fill in, yellow = input cell, black = calculated)
• Daily Log – the core ledger. Every sale and expense gets one row, with dropdowns for Type, Category, Account, and Payment Status
• Cash & Accounts – real-time balance for each account (bank, mobile money), pulled automatically from the Daily Log
• Accounts Receivable / Accounts Payable – track who owes you and who you owe, including partial payments. Status moves from Outstanding → Partially Settled → Settled on its own
• Monthly Summary – income and expenses by category for any month you pick
• Category Guide – a reference for what belongs in each category
• Lists – customize your own categories and account names in one place; every dropdown and formula elsewhere updates automatically