Limited Company Bookkeeping, Dividend & Corporation Tax Tracker
Sales, expenses, dividends and a corporation tax estimate for a small limited company.
Price: £12.00 was £15.00 Launch offer: 20% off
Price in GBP. Digital download; no VAT is charged unless shown at checkout.
Secure card payment by Stripe. Download links on screen and by email straight after payment. Prefer Etsy? Also on Etsy (opens in a new tab).
- Instant download after payment
- Built for the 2026/27 UK tax year
- Personal or single-business licence (details)
What is included
- Sales log (400 rows) with net, VAT and gross, paid tracking
- Expenses log (600 rows) with company P&L categories
- Dividends log with up to 4 shareholders and cumulative totals
- Printable A4 dividend voucher driven by a voucher number
- Corporation tax estimate with marginal relief
- Distributable reserves check with dividend warning
- Director's dividend tax illustration
- Monthly P&L summary with VAT due
- Director's loan account with running balance (200 rows)
- Settings sheet with every rate and threshold
- Quick-start PDF guide
- Formats
- Excel and Google Sheets
- Made for
- Small Ltd directors
- Version
- v1.0
- Delivery
- ZIP download, on screen and by email, instantly
About this template
Built for directors of small limited companies who do their own day-to-day bookkeeping and want to know, at any moment, how much profit is left after corporation tax and whether the next dividend is safe to pay.
Log sales and expenses with net, VAT and gross columns, record dividends against a shareholder list and print a dividend voucher for each one. The corporation tax estimate applies the small profits rate, main rate and marginal relief for you, then shows distributable reserves after dividends with a warning if you have paid out more than the company has earned. A director's loan account keeps a running balance and flags when it is overdrawn.
Every rate and threshold lives on one Settings sheet so an April update takes seconds. Works in Excel 2016 or later and Google Sheets. Not tax or accounting advice.
Who it's for
UK sole traders, small limited companies and side hustles who want admin done properly without paying for software. If you can type into a spreadsheet or document, you can use it.
- Small Ltd directors
Frequently asked questions
How do I get the files after paying?
Download links appear on screen as soon as payment goes through and are emailed to you as well. The ZIP includes a quick-start guide; links stay valid for 7 days and the order page issues fresh ones any time.
Do I need Microsoft Excel?
No. The spreadsheets work in Excel 2016 or later and in Google Sheets, which is free. Upload the .xlsx to Google Drive and open it with Sheets; the formulas carry over. There are no macros or add-ins.
Is it up to date for this tax year?
It is built for the 2026/27 UK tax year (6 April to 5 April). Every rate and threshold sits on one Settings sheet, so you can see and change them, and we rebuild the template each April.
Can I use it for more than one business?
The licence covers you or one business you own or run, with unlimited documents. Bookkeepers and agencies working for several clients need a multi-business licence; just ask.
What if something does not work?
Email support@hnjuk.co.uk with your order reference and a screenshot. Faulty files are always fixed or refunded; because these are digital downloads there is no cooling-off refund once downloaded.
Guides to go with it
Sole trader vs limited company: a plain-English comparison
The real differences between trading as a sole trader and running a limited company in the UK — liability, admin, tax, privacy — and how to decide.
What a limited company must show on its letterhead and invoices
The UK trading disclosure rules in plain English: what a limited company must show on letterheads, emails, websites and invoices, plus VAT invoices.
How to make a 12-month cash flow forecast for a bank loan
Build a 12-month cash flow forecast a UK lender will take seriously: assumptions, payment timing, VAT and tax bills, and the checks to run first.
You might also like
BusinessSole Trader Bookkeeping & Self-Assessment Tracker
Log income, expenses and mileage; get an SA103-ready summary and a tax estimate.
Price: £9.60
was £12.00Launch offer: 20% offExcel · Google Sheets
Business12-Month Cash-Flow Forecast
A bank-ready 12-month cash-flow forecast with VAT, actuals and variance built in.
Price: £7.20
was £9.00Launch offer: 20% offExcel · Google Sheets
BusinessInvoice & Quote Template Pack
10 UK invoice templates and 3 quote designs for Excel, Word and Google Sheets that add themselves up.
Price: £4.80
was £6.00Launch offer: 20% offExcel · Google Sheets · Word






