Why Your Spreadsheets Are a Problem Now

If your agency is still running on spreadsheets, you are not alone. Many agency founders I meet in Soho and Manchester's Northern Quarter are running 12-person digital agencies on a combination of Google Sheets, Excel, and memory. It worked fine when you were turning over £80k as a freelancer. It becomes a liability at £400k.

Making Tax Digital for Income Tax Self Assessment (MTD for ITSA) is coming. From April 2026, if your self-employed or property income is over £50k, you must keep digital records and submit quarterly updates using MTD-compatible software. From April 2027, the threshold drops to £30k. If your agency is structured as a limited company, the corporation tax version (MTD for CT) is expected to follow within a few years.

Spreadsheets are not MTD-compliant. Not the ones you built yourself, not the templates from your accountant, not the beautifully formatted colour-coded version your operations manager spent three weekends on. HMRC requires software that connects directly to their API. That means a proper accounting package.

This MTD agency founder guide is not a software comparison. It is a practical walkthrough of the migration itself: how to move your historical data from spreadsheets into Xero, QuickBooks, FreeAgent, or whatever you choose, without losing information, creating reconciliation nightmares, or missing tax deadlines.

Step One: Decide What Stays and What Goes

Before you touch a single import template, you need to decide how much history you actually need in your new system. This is where most agency founders get it wrong. They try to bring everything across.

Here is the rule of thumb: you need the current financial year in full, plus the previous year's year-end balances. That is it.

If your year-end is 31 March 2025 and you are migrating in November 2025, you bring in:

  • All transactions from 1 April 2025 to today (current year)
  • The closing trial balance as at 31 March 2025 (prior year)

You do not need every invoice from 2022. You do not need the bank statement lines from three years ago. Those records stay in your spreadsheet archive or PDF folder. HMRC only cares about the current and most recent completed year for MTD purposes.

If your accountant prepared your last set of filed accounts from your spreadsheets, those figures are already agreed with HMRC. You are not reopening them. You are setting a starting point.

Step Two: Clean Your Chart of Accounts

Your chart of accounts is the list of categories you use to classify income and expenditure. In a spreadsheet, you probably have something like:

  • "Sales - Retainers"
  • "Sales - Projects"
  • "Expenses - Software"
  • "Expenses - Travel"

That is fine for a small agency. But when you move to proper software, you need to think about what your accountant needs to file your CT600 (corporation tax return) and what you need to run the business.

Here is what a typical agency chart of accounts should include:

Income: Retainer income, project income, pass-through costs (ad spend, print, media buying), interest income.

Direct costs: Freelancer fees, contractor payments, software subscriptions billed to clients, third-party production costs.

Overheads: Rent, utilities, salaries, employer NI, pension contributions, accountancy fees, legal fees, marketing (your own), training, travel, equipment.

Map your current spreadsheet categories to these new accounts before you start importing. If you have a category called "Misc" that holds 15% of your spending, fix that now. Your new software will not fix bad data. It will just make bad data easier to report to HMRC.

Step Three: Standardise Your Data Format

Accounting software imports work on rigid rules. A date column must contain dates. An amount column must contain numbers without currency symbols or commas. A description column must be text.

Open your spreadsheet. Look at the columns. If you see anything like this, fix it before import:

  • "£1,234.56" (remove the £ sign and comma)
  • "01/04/24" (standardise to YYYY-MM-DD or DD/MM/YYYY consistently)
  • "Client - Project - Invoice 123" (split into separate columns if possible)
  • Blank rows (delete them)
  • Merged cells (unmerge them)

Every accounting package has a sample import template. Download it. Copy your data into that template column by column. Do not try to map your spreadsheet directly. Use their format. It saves hours of error-checking later.

Step Four: The Bank Statement Reconciliation

This is the critical step. Most migration errors happen because the opening bank balance in your new software does not match the real bank balance.

Here is the process:

  1. Download your bank statements for the last 12 months in CSV format.
  2. Import the most recent 3-6 months into your new software. Do not try to import 12 months at once. The error logs become unmanageable.
  3. Match each imported transaction against your spreadsheet records. In Xero or QuickBooks, this is the "reconciliation" screen.
  4. If a transaction exists in the bank but not in your spreadsheet, it is either an error in your spreadsheet or a transaction you missed. Investigate it now.
  5. If a transaction exists in your spreadsheet but not in the bank, it is either an invoice you raised that has not been paid, or a bill you entered that has not cleared.

Do not move on until the opening balance on day one of your new software matches the bank statement on that date. If it does not, everything downstream will be wrong.

Step Five: Bring Across Your Customers and Suppliers

Your contact list is straightforward. Export your customer and supplier names, addresses, and VAT numbers from your spreadsheet. Import them into your new software. Most packages accept a simple CSV for this.

The tricky part is opening balances. If a customer owes you £4,200 for an invoice you raised in February, you need to record that as an outstanding debtor. If you owe a freelancer £1,800 for work done in March, that is an outstanding creditor.

Create a list of all open invoices and unpaid bills as at your migration date. Import these as opening balances, not as new transactions. In Xero, you use the "Opening Balances" function. In QuickBooks, you enter them as outstanding transactions dated on or before your start date.

If you have 40 outstanding invoices, this takes an afternoon. If you have 200, you should consider whether your credit control needs fixing before you migrate. An agency with 200 overdue invoices is an agency with a cash flow problem, not a software problem.

Step Six: VAT Setup

If your agency is VAT-registered, your new software must handle VAT correctly from day one. This means:

  • Setting your VAT scheme (standard accounting, flat rate, annual accounting)
  • Setting your VAT return period (quarterly or monthly)
  • Entering your VAT registration number
  • Checking that your opening VAT balance matches your last submitted return

If you use flat rate VAT, make sure your software supports it. Xero and FreeAgent do. Some cheaper packages do not, or handle it poorly.

If you are a limited cost trader (spending less than 2% of your VAT-inclusive turnover on relevant goods, or less than £1,000 per year), you cannot use flat rate. You must use standard accounting. Many agency founders I meet in Bristol Harbourside do not realise they stopped qualifying when their contractor spend dropped. Check this before you migrate.

Step Seven: The First Month in Your New System

You will not get everything right on day one. Plan for a parallel run of 4-6 weeks. Keep your spreadsheets updated alongside the new software. At the end of each month, compare the two sets of numbers.

Check these specific items:

  • Bank balance (should match exactly)
  • Total sales (should match your invoice list)
  • Total expenses (should match your bill list and bank outgoings)
  • VAT liability (should match your manual calculation)
  • Debtors and creditors (should match your open items list)

When the two systems agree for two consecutive months, you can retire the spreadsheets. Keep the archive file. Do not delete it. You may need to refer back to it during your first year-end under the new system.

Common Errors and How to Avoid Them

Error 1: Duplicate transactions. You import bank statements and then manually enter the same invoices. The result is double-counted income and a reconciliation that never balances. Solution: use the bank feed import as your primary source. Enter invoices separately only if you need to track unpaid items.

Error 2: Wrong opening balances. You enter the bank balance as at 1 April but forget to include uncleared cheques or pending card payments. Solution: reconcile your bank statement to the penny before you set the opening balance.

Error 3: VAT coding mistakes. You code a supplier invoice as 20% VAT when it should be reverse-charged, or you miss the VAT on an EU purchase. Solution: run a VAT return draft in your new software before you submit it. Compare it to your manual calculation. If they differ by more than £50, find out why.

Error 4: Missing historical payroll data. Your software may not import RTI (Real Time Information) submissions from your previous payroll provider. Solution: keep your old payroll records accessible. Your new software will handle go-forward payroll, but HMRC already has your historical submissions.

When to Get Your Accountant Involved

You can handle steps one through three yourself. Steps four through seven are where most agency founders call us. As ICAEW qualified accountants, we see the same patterns repeatedly: a founder spends 30 hours migrating data, gets 95% of the way there, and cannot find the missing £2,300 that makes the balance sheet disagree with the bank.

If your agency has more than 500 transactions per month, or if you have multiple bank accounts, or if you use foreign currency accounts, get your accountant involved before you start the import. The cost of fixing a corrupted migration is higher than the cost of doing it right the first time.

If your contractor mix has changed in the last 12 months, or if you are unsure whether your agency qualifies for R&D tax credits on software development work, ask your accountant before year-end. The data structure you choose now affects what you can claim later.

For more on how we support agency founders through this process, see our services page.

Software Recommendations for Agency Founders

I am not going to recommend one package over another without knowing your agency. But here is what I see working in practice:

  • Xero: Best for agencies with complex project tracking, multiple currencies, and a need for add-on apps like Dext (receipt capture) and Float (cash flow forecasting). Most agency accountants prefer Xero.
  • QuickBooks Online: Good for smaller agencies (under £500k turnover) who want a lower monthly cost and simpler setup. The project costing features are weaker than Xero.
  • FreeAgent: Excellent for sole traders and micro-agencies. Built-in MTD compliance, simple bank feeds, and a clean interface. Less suitable for agencies with multiple directors or complex group structures.
  • Sage: Still used by some larger agencies, but the cloud version lags behind Xero and QuickBooks in ease of use.

Whichever you choose, make sure it is on HMRC's recognised software list for MTD. If it is not, you are not compliant.

What Happens If You Get It Wrong

HMRC is not going to fine you for a migration error in month one. But if your MTD submissions are consistently wrong because your opening balances were incorrect, you will eventually get a compliance check. That means time, stress, and potentially penalties.

More immediately, bad data means you cannot trust your management accounts. You make decisions on cash flow, pricing, and hiring based on numbers that are wrong. That is the real cost of a poor migration.

If you are reading this and thinking "my spreadsheets are fine, I will deal with MTD later", consider this: the first MTD for ITSA quarterly update is due in 2026. If you start the migration process in January 2026, you will be doing it under time pressure, with your accountant's busiest season already underway. Start now. The work is the same either way. The stress is not.

For agency-specific advice on MTD compliance, visit our agency services page.

And if you are a digital agency or creative agency founder who has been putting this off, book a call. We will walk through your specific spreadsheet setup and tell you exactly what needs to change.