Excel spreadsheet

Limited Company Accounts Spreadsheet

Bookkeeping for your limited company, in one spreadsheet

Log sales and purchases with VAT, and the spreadsheet builds your profit and loss, VAT return boxes, a Corporation Tax estimate, the director's loan account and the profit available for dividends.

£8.99one-off · no VAT · instant download
Buy & download

Secure card checkout on our client portal (Stripe). Your download is ready the moment payment goes through. How it works

  • Excel .xlsx
  • Google Sheets
  • Numbers
  • LibreOffice

In the download (110 KB zip)

  • Daedalus-Design-Limited-Company-Accounts-UK.xlsx
  • Daedalus-Design-Limited-Company-Accounts-UK-EXAMPLE.xlsx

What's included

  • Sales and purchases logs with VAT at 20%, 5%, 0%, exempt and no VAT
  • Profit & loss — month by month, by cost category
  • VAT return boxes 1 to 9 for each quarter, with the filing date
  • Corporation Tax estimate — 19% / 25% with marginal relief, add-backs and AIA
  • Director's loan account — overdrawn balance and s455 warning
  • Dividends log with vouchers, checked against profits available
  • Summary page, blank file plus a filled-in example company

Perfect for

  • Directors of small limited companies
  • Contractors and consultants
  • Newly incorporated businesses
  • VAT-registered companies
  • Getting records ready for your accountant
  • Planning dividends and tax

UK Rules

Corporation Tax rates and VAT boxes for UK companies.

Totals Itself

P&L, VAT and tax estimate update as you add rows.

Dividend Check

See what's available before you declare a dividend.

Your Data Stays Yours

A file on your own computer — no app, no bank login.

Questions

Does it file my VAT or tax returns?

No — it gives you the figures to copy into your Making Tax Digital software or hand to your accountant. It isn't tax advice.

I'm not VAT registered. Does it still work?

Yes. Set VAT registered to No; costs then count at their full amount and the VAT sheet is switched off.

Does it work in Google Sheets?

Yes. Upload it to Google Drive and open it with Google Sheets. It also opens in Numbers and LibreOffice.

How do I get the files?

Press Buy, sign in or create an account on our client portal and pay by card. Your download appears under My downloads as soon as payment goes through, and you can download it again at any time.

Something not right?

Email hello@daedalusdesign.co.uk and we'll put it right: a corrected file, a different format or a refund. See refunds and faulty files.

Buy Limited Company Accounts Spreadsheet · £8.99

You might also like

Excel spreadsheet

Monthly Budget Planner & Dashboard

Set a budget, log what comes in and goes out, and the dashboard shows income, spending, savings and what's left, with every category checked against…

£11.99 DetailsBuy
Excel spreadsheetNew

Sales, Expense & Stock Tracker

Log sales, stock and expenses and the dashboard shows your sales, discounts, fees, cost of goods and real profit month by month, by channel and by…

£9.99 DetailsBuy
Excel workbook

Project Management Toolkit

A Gantt chart that draws itself, a Kanban board that sorts your tasks, a RAID log with a risk heat map, a budget with cost variance and a one-page…

£15.99 DetailsBuy