For UK businesses changing accounting software

How to switch accounting software

Switching accounting software comes down to one clean cut-off date. Finish the old books to that date, carry the balances across, keep the old records readable and check the first month.

  • One cut-off date, opening balances from your trial balance
  • Old records kept readable for as long as HMRC requires
  • Free 30-day beta to set up before the switch date

To switch accounting software, you do not move your history: you pick a cut-off date, finish the old books up to that date, and start the new system with the closing balances as its opening position. Everything before the date stays in exports from the old system; everything after it is recorded in the new one. Done that way, most small businesses can make the change in a few evenings.

The switch in eight steps

Step What you do Result
1 Choose the switch date One date that both systems agree on
2 Bring the old books up to date and reconcile them Figures you can trust
3 Export reports, lists and documents Your records, independent of the old supplier
4 Set up the company in the new software Bank accounts, customers and suppliers ready
5 Enter opening balances from the trial balance The new ledger starts where the old one stopped
6 Enter unpaid customer and supplier invoices Payments after the switch have something to match
7 Run both side by side for a short overlap Confidence before you cancel anything
8 Check the first month end Bank, debtors, creditors and VAT agree

1. Choose the switch date

The best dates, in order:

  1. The first day of a new financial year. The old system holds complete years and your accountant prepares the year end from one set of records.
  2. The first day of a VAT period. Each VAT return then comes from a single system.
  3. The first day of any month, if you are not VAT registered.

Avoid switching in the middle of a VAT period. If the year end is a long way off, a quarter end is a perfectly good compromise.

2. Finish the old books

Before taking any figures out, in the old system:

3. Export what you will need

Export Format Used for
Trial balance at the cut-off date PDF and spreadsheet Opening balances
Aged debtors and aged creditors PDF and spreadsheet Open invoices to re-enter
Customer and supplier lists Spreadsheet Setting up contacts
General ledger for each year PDF or spreadsheet Your statutory record of past entries
Profit and loss and balance sheet for each year PDF Comparatives and lender questions
VAT returns and their detail reports PDF Evidence for each return submitted
Sales invoices, receipts and other attachments Original files The documents behind the entries
Fixed asset register Spreadsheet Cost and depreciation to date

File names that start with the date and say what the report is will save you time when someone asks for it in three years.

4 to 6. Set up and enter the opening position

Create the company in the new software, then:

  1. Add each bank account as it stands on the cut-off date.
  2. Enter the opening balances line by line from the trial balance. Debits must equal credits; if they do not, a line is missing. The guide to opening balances when changing software covers the awkward lines, such as VAT owed and retained earnings.
  3. Enter each unpaid customer invoice and supplier bill individually, so the totals equal the debtor and creditor balances you brought across. Do not let them count as new sales or costs.
  4. Set up the customers, suppliers and items you still trade with. Leave dormant ones behind.
  5. Carry on your invoice number sequence from the next unused number.

You can set up the company in the Nexbal beta ahead of the date; it is free for 30 days. Start before your switch date.

7 and 8. Overlap, then check the first month

Keep access to the old system for a month or two. In the first month in the new software:

In Nexbal you upload the month’s statement PDF; lines the AI can match are posted and the rest are listed for review, and you then agree the ledger balance to the statement. See bank statement upload in Nexbal.

VAT and Making Tax Digital when you switch

Records you must keep from the old system

Changing software does not shorten how long records must be kept:

Business Keep records for Source
Limited company 6 years from the end of the last company financial year they relate to Company and accounting records
Self-employed At least 5 years after the 31 January submission deadline of the tax year How long to keep your records
VAT-registered business VAT records for at least 6 years VAT record keeping

So before the old subscription ends, make sure the exports in step 3 are complete, readable without the old software and backed up. Some suppliers offer a cheap read-only plan, which is worth a few months’ fee during the first year end after the switch.

Mistakes that cause most of the trouble

Guides for specific moves

Pick the date, then set up the new books ahead of it. Join the Nexbal beta.

From document to posting, without the typing

Nexbal reads each document and suggests the entry. You check, approve and move on.

01

AI that does the bookkeeping

Forward or upload receipts and supplier invoices. AI reads them and fills in the entry, and you approve it.

Receipt

£42.00

£27.60

£14.90

Total£84.50

AI suggestion

Account
Office supplies
Amount
£84.50
Approve

02

Bank statements read by AI

Upload your bank statement as a PDF and Nexbal suggests a posting for every line.

PDFBank statement

  • −£126.80Posted
  • +£950.00Posted
  • −£39.90Posted
  • −£212.45To review
  • +£480.00Posted

03

Invoices in minutes

Send invoices, credit notes, reminders and quotes as PDF by email, and follow every invoice until it is paid.

Invoice1042

£600.00

£350.00

Total£950.00

  1. Sent by email
  2. Reminder sent

Nexbal is launching in the UK · beta open

Join the Nexbal beta

Early access, 30 days free, and your feedback shapes the product.