Small Business Bookkeeping Spreadsheet

One row per invoice in Income, one per receipt in Expenses, your trips in Mileage and your hours in Hours. Everything else calculates itself.

At filing time, open the VAT summary: sales per rate, input VAT and the amount due, per quarter, in filing order. Copy it into your return. VAT rates are fully editable, so it works in any VAT country.

Forget a category or a VAT rate somewhere? The dashboard counts those rows and warns you — revenue never silently disappears.

1. Start on the Settings tab: business details, financial year and your VAT rates.
2. Put every invoice or sale on one row in Income.
3. Put every receipt or bill in Expenses, and log business trips in Mileage.
4. The dashboard, VAT summary and profit and loss fill themselves in.

• Small_Business_Bookkeeping.xlsx — the empty working file, no macros
• Small_Business_Bookkeeping_EXAMPLE.xlsx — filled with a full year
• Dashboard: profit, unpaid invoices, VAT set-aside, tax buffer, chart
• Quarterly VAT summary in filing order, rates fully editable
• Income (500 rows) and Expenses (800 rows) with dropdown categories
• Mileage log with deduction and an hours tracker with target
• Monthly profit and loss by category
• Invoice template that does the math and prints on one page

• Works in Microsoft Excel, and in Google Sheets by uploading the file
• No macros and nothing to enable. Yellow cells are the ones you type in
• No currency symbol anywhere, so it works in any currency
• Every formula was checked to the cent before this went on sale
• A bookkeeping aid, not tax or legal advice