Small Business Bookkeeping Spreadsheet

Simple books for a small business, sole trader or freelancer. Log income and expenses as they happen; the profit and loss, dashboard and year-end summary build themselves.

9 connected tabs

• Setup: business name, financial year start, income and about 20 expense categories with tax-deductible flags, payment terms, tax set-aside %
• Income Log: 1,000 rows with paid, unpaid and overdue status
• Expenses Log: 1,500 rows with receipt tracking
• Mileage Log: trips, distance and your rate per km or mile
• Invoices: unpaid invoices with days outstanding and ageing
• Monthly P&L: 12 months by category, profit and margin
• Dashboard: year-to-date totals and 2 charts
• Year-end Summary: totals plus a checklist for your accountant

You get

The blank workbook, a filled example business to explore, and a Start Here guide (PDF).

Please note: this is a record-keeping tool, not tax or accounting advice. The tax set-aside is a reminder amount at the percentage you choose.