← All prebuilt solutions
Bookkeeping & Compliance

Bookkeeping Workbook

A complete, integrated set of books for a small business

£20

Secure checkout. Your download link is sent as soon as payment clears.

Bookkeeping Workbook

Overview

This workbook is a complete, simple set of books for a small business. You record three things – the invoices you send, the bills you receive and every line on your bank statement – and everything else is produced for you: a monthly Profit & Loss, a Balance Sheet that checks itself, the nine VAT return boxes, aged debtors and creditors, and a dashboard. Invoices and bills mark themselves paid when the bank line quotes their number, so you always know who owes you what. The Start Here sheet holds your settings, opening balances and the weekly, monthly and quarterly routine; this manual explains every sheet and column in detail.

Price
£20
Who it’s for
Bookkeeping & Compliance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Start Here

Settings, opening balances, how the workbook fits together, the routine and links to every sheet. What you do: fill in sections 1 and 2 once a year.

Start Here
Sales Invoices

Step 2

Sales Invoices

One row per invoice or credit note, with VAT, due date, amount paid and status. What you do: enter the yellow columns.

Step 3

Purchase Bills

One row per supplier bill, with the same automatic columns. What you do: enter the yellow columns.

Purchase Bills
Bank

Step 4

Bank

Your cash book – every line from the bank statement, with a running balance. What you do: enter the yellow columns and tick Reconciled.

Who it is for

Made for people like you

  • Example – text
  • Small limited companies – Accruals-basis books with a Balance Sheet, ready to hand to your accountant at the year end.
  • Sole traders and partnerships – Cash or accruals basis, with the Profit & Loss your tax return needs.
  • VAT-registered businesses – Boxes 1–9 for each quarter on invoice basis or cash accounting, to enter in your MTD software.
  • Bookkeepers – A tidy, consistent set of records that can be reviewed and reconciled quickly.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings and opening balances – On Start Here fill in section 1 (your business) and section 2 (opening balances). The opening capital figure balances automatically.
  2. Categories – Check the Categories sheet and rename, add or remove categories so they suit your business.
  3. Customers and suppliers – List your customers and suppliers with their payment terms in days.
  4. Record sales and bills – Add each invoice to Sales Invoices and each supplier bill to Purchase Bills.
  5. Enter the bank – Copy every bank statement line onto the Bank sheet, choose its Type and, for receipts and payments of invoices and bills, quote the invoice or bill number as the Reference.
  6. Fix, reconcile and review – Clear any 'Check:' messages in the Match? column, tick Reconciled when the balance agrees to the statement, then pick the month on the Dashboard to see the year to date.

Key features

  • Sales invoices, purchase bills and bank transactions feed every report automatically.
  • Profit & loss, balance sheet and VAT return built from your entries.
  • Aged debtors and creditors so you know who owes what.
  • A dashboard with the key numbers and charts.

What’s included

  • Start Here – Settings and step-by-step setup
  • User Manual – Full user manual
  • Dashboard – Key numbers and charts
  • Sales Invoices – Money in
  • Purchase Bills – Money out
  • Bank – Bank transactions
  • Profit & Loss – Monthly P&L
  • Balance Sheet – Year-end position
  • VAT Return – VAT boxes
  • Aged Debtors – Who owes you
  • Aged Creditors – Who you owe

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions