A simple, no-software bookkeeping system for sole traders, side businesses and small shops: record what comes in and goes out, see who still owes you money, and get a monthly profit & loss statement automatically.

What you get

• Income log (customer, category, payment method) and expense log with editable categories.

• Invoice tracker: due dates from your payment terms, paid-to-date, balance due, status (Open / Partially paid / Overdue / Paid) and days overdue.

• Receivables summary: total outstanding, overdue amount and ageing buckets (not yet due, 1-30, 31-60, 61-90, 90+ days).

• Monthly P&L for 12 months + total: revenue by category, cost of goods sold, gross profit, operating expenses by category, net profit, gross and net margin, and a cash balance line.

• Blank template + a fictional EXAMPLE file. 1,000 income rows, 1,000 expense rows, 500 invoices.

Good to know

• Cash-basis record keeping: income and expenses are counted on the date money is received or paid. Invoices are tracked separately for what is still owed.

• Works in Microsoft Excel, LibreOffice and Google Sheets. No macros, no add-ins, no logins.

• Contains no tax rates or country-specific rules. Record-keeping tool only; not accounting, tax, financial or legal advice. Check your local requirements with a qualified professional.

Template created with the assistance of automated tools and checked with test data.