Moving from spreadsheets to accounting software
Last checked 18 November 2026
Spreadsheets work well at first, but they become harder to manage as a business grows.
Pick a clean start date
The start of a VAT period or financial year is usually easiest.
Gather your opening balances
You'll need bank balances, unpaid customer invoices, unpaid supplier bills and, ideally, a trial balance from your accountant.
Set up the basics
Add your VAT details, connect your bank and agree a chart of accounts with your accountant.
Keep your old records
Keep your spreadsheets and source documents for at least six years.
Official sources