Moving your books
off a spreadsheet.

When is the right moment?

The start of a period, always. A tax year is cleanest; a VAT quarter is nearly as good. Switching mid-period means one set of figures lives in two places, and the reconciliation at the end is worse than the migration you were trying to avoid.

The forcing deadline for most people is Making Tax Digital. Once your income brings you into scope, quarterly updates have to be filed from compatible software, and a spreadsheet on its own no longer clears the bar. The thresholds and start dates have been phased and rephased, so check gov.uk for where you actually sit rather than working from something you read a year ago.

The other honest trigger is simpler: when you no longer trust the sheet. A formula that broke in March and was noticed in September is not a tooling preference, it is a filed return based on numbers nobody can vouch for.

What do you actually move?

1. 1

   Pick the changeover date

   The first day of a tax year or VAT quarter. Everything before it stays in the spreadsheet; everything after it lives in the software.

2. 2

   Bring in opening balances, not history

   Bank balances, unpaid sales invoices, unpaid bills, VAT owed or reclaimable, and any loan or asset balances. You are not re-keying years of transactions — you are stating where the business stood on day one.

3. 3

   Connect the bank feed

   This is the single biggest change. Transactions arrive on their own and get matched, instead of being typed in from a statement weeks later.

4. 4

   Re-enter the open items individually

   Unpaid invoices and bills go in one by one so they can be matched off when they are paid. Only the open ones — settled items are history.

5. 5

   Run both for one month

   Keep the spreadsheet going alongside for a single period and compare the two at the end. If they agree, stop the spreadsheet. If they do not, you have found the problem now rather than at the year end.

6. 6

   Archive the spreadsheet

   Do not delete it. Records have to be kept for years after the deadline they relate to, and the sheet is the record for everything before the changeover.

What can a spreadsheet not do?

• —File anything. Every MTD submission has to come from compatible software, and a manual re-key into a portal is exactly the error path the rules were written to close.
• —Tell you what you are owed today without someone maintaining it by hand.
• —Chase an unpaid invoice on its own.
• —Match a bank transaction to an invoice, or notice that the same bill was paid twice.
• —Keep the receipt attached to the transaction, which is what an enquiry actually asks for.
• —Survive contact with a second person, or with the version of you that is tired on a Sunday night.

What people worry about, and what actually happens

The common fear is losing control — that the spreadsheet is understood and the software will not be. In practice the reverse is the risk: a spreadsheet's errors are silent, while software that reconciles to a bank feed tells you when something does not add up.

The second fear is time. Migration is a few hours if you move balances rather than history, and a few days if you insist on re-entering three years of transactions nobody will ever look at. Move balances.

The third is cost, which is worth comparing honestly: a monthly subscription against the hours a month you currently spend keeping the sheet alive, plus the accountant's time spent untangling it at the year end. For most people the second number is larger, and always was.