Every template £4.99 · Instant download · Commercial licence on every file
Home / Business & Finance / Bookkeeping Tracker (Self-Employed)
Bookkeeping Tracker (Self-Employed) preview
Business & Finance

Bookkeeping Tracker (Self-Employed)

Simple bookkeeping for the self-employed. Track income, expenses and VAT in one ledger, with a dashboard that shows your profit and VAT position — ready for your return.

£4.99£14.99Save 67%
Instant downloadInstant download on Etsy
Excel · Google SheetsEditable formats
Commercial licencePersonal & business use
Free updatesForever, at no cost

What's inside

  • One ledger for income and expenses with categories
  • VAT and gross totals calculated automatically
  • Dashboard: income, expenses, net profit and VAT due
  • Expenses-by-category donut
  • Colour-coded entries; sample data included
  • Works in Excel and Google Sheets, on any device

About the Bookkeeping Tracker (Self-Employed)

You do not need complicated accounting software to keep clean books — you need one simple, organised ledger. This Bookkeeping Tracker lets self-employed people and small businesses record every bit of income and every expense in one place, with VAT and gross totals worked out automatically, and a dashboard that shows your profit and VAT position at a glance.

Log a transaction as income or expense, tag its category, and the tracker keeps a running total of your total income, total expenses, net profit, VAT collected, VAT paid and VAT due — plus an expenses-by-category breakdown so you can see where the money goes. It is everything you need to stay on top of your numbers through the year and hand clean figures to your accountant or self-assessment.

Built in Excel and Google Sheets with clearly marked input cells and sample entries, it works on any device. Please note it is a bookkeeping tool to organise your figures, not tax advice — always confirm with your accountant. For deeper VAT-by-quarter tracking, see our [VAT & Tax-Prep Tracker](#/product/vat-tax-prep-tracker).

Who it's for

Self-employed & sole tradersKeep clean books without expensive software.
Small businessesHand your accountant organised figures at year end.

What's included

  • One ledger for income and expenses with categories
  • VAT and gross totals calculated automatically
  • Dashboard: income, expenses, net profit and VAT due
  • Expenses-by-category donut
  • Colour-coded entries; sample data included
  • Works in Excel and Google Sheets, on any device

How to download & use it

  1. Check your email. The moment your payment goes through, we email your files to the address you enter at checkout. They usually arrive within a minute or two — if not, check your spam or promotions folder.
  2. Download your files. Open the email and click the download button. Your files save straight to your device — nothing is posted, it is all instant and digital. Keep the email so you can re-download any time.
  3. Open it. Open the file in Microsoft Excel, or upload it to Google Sheets (in Google Drive: New → File upload, then open with Google Sheets). It works on desktop, tablet and mobile.
  4. Make it yours. Type into the highlighted input cells — everything else calculates automatically. Most files include a "Start Here" tab and sample data to guide you.

Need a hand? Every purchase includes free email support and free updates for life. If a file ever will not open, reply to your receipt and we will sort it.

Frequently asked questions

Do I need accounting knowledge?

No — just log income and expenses; the tracker does the totals and VAT.

Is it a replacement for an accountant?

No — it organises your figures ready for your return. Always confirm with a qualified accountant.

Related searches

bookkeeping spreadsheetself employed accounts templateincome and expense trackersmall business bookkeepingVAT tracker spreadsheetsole trader accountsGoogle Sheets bookkeepingaccounting spreadsheet UK

Instant digital download. Nothing is shipped. Files are delivered to your email the moment you buy, and you can re-download them any time. Single-business licence.

You might also like

More in Business & Finance
SheetFreelancer Income & Tax TrackerTemplate Collective
Business & Finance

Freelancer Income & Tax Tracker

£14.99£4.99
SheetSide Hustle Profit TrackerTemplate Collective
Business & Finance

Side Hustle Profit Tracker

£14.99£4.99
New
SheetAirbnb & Rental Income TrackerTemplate Collective
Business & Finance

Airbnb & Rental Income Tracker

£14.99£4.99
SheetWedding Budget TrackerTemplate Collective
Business & Finance

Wedding Budget Tracker

£14.99£4.99
✓
Secure checkout
Live previewPreview
This is an interactive sample. The file you download is fully editable in Excel, Google Sheets or Word.