If you run a small company and someone has asked you for a "trial balance", it can feel like being handed a foreign language dictionary. The good news: a trial balance is much simpler than it sounds, and once you have one, preparing your statutory accounts and Corporation Tax return becomes a quick job rather than a long weekend.
Here is what a trial balance is, why it matters, and how to get one out of your accounting system in a few clicks.
What is a trial balance, in plain English?
A trial balance is a list. That is really all it is. It shows every account your bookkeeping uses - things like sales, rent, wages, the bank account, money owed to you, money you owe - and the total balance sitting in each one at a particular date.
Each line has either a debit or a credit value. You do not need to worry about which is which. The important point is that, when the bookkeeping has been done properly, the debits and the credits add up to the same total. That is why it is called a trial balance - the two sides should balance.
Think of it as a snapshot of your business on a single day, usually your year end. Every pound that has moved through the business is summarised on one page.
A trial balance is just an organised list of every account in your bookkeeping, with the balance in each one on a chosen date.
Why does a trial balance matter to you?
You need a trial balance because it is the raw material for two very important documents:
- Your statutory accounts, which go to Companies House.
- Your Corporation Tax return (CT600), which goes to HMRC along with a tax computation.
The profit and loss account, the balance sheet and the notes in your accounts are all built by taking the numbers from the trial balance and grouping them in the way the rules require. No trial balance, no accounts. A messy trial balance, messy accounts.
So getting a clean, accurate trial balance is the single most useful thing you can do before filing season.
Where does a trial balance come from?
If you use accounting software, you already have one - the software builds it for you in the background every time you record a transaction. You just need to know where to find it.
From cloud accounting software
Most cloud bookkeeping tools have a report called "Trial Balance" tucked away in the reports menu. You set the date (usually your accounting year end) and export it. We support exports from Xero, QuickBooks, Sage and many other systems.
From a spreadsheet
If you keep your books in Excel, Google Sheets or a smaller system, you can still produce a trial balance. It is just a list of account names with a debit or credit balance against each one. As long as the totals balance, you are good to go.
From your accountant
If an accountant or bookkeeper looks after your records, they will be able to send you a trial balance in seconds. Ask for it as a PDF or a spreadsheet.
Heads up - Always run your trial balance after you have finished tidying up the year - bank reconciliations done, invoices entered, year-end journals posted. A trial balance is only as good as the bookkeeping behind it.
What does a typical trial balance look like?
A trial balance usually has three columns:
- The account name - for example, Sales, Office Rent, Bank Current Account, Trade Debtors, Director's Loan.
- The debit column.
- The credit column.
Broadly speaking, things you own and money you have spent sit as debits. Things you owe, your share capital and your income sit as credits. You do not need to memorise that. Your software handles it. What you do need to do is glance down the list and check the balances look sensible.
How Tax Optimiser turns your trial balance into accounts
This is the part that used to take hours and now takes minutes. Once you have your trial balance, Tax Optimiser does the heavy lifting.
1. Get the trial balance in
You have three options:
- Connect your accounting system and we pull the trial balance straight out of Xero, QuickBooks or whichever tool you use.
- Upload a spreadsheet - we accept exports from Sage, Xero and many other systems, as well as plain Excel or CSV files.
- Key it in manually if your records live somewhere else. You just type the account names and balances into a simple grid.
2. Map it to the accounts
Each line on your trial balance needs to be matched to the right place in your statutory accounts - for example, "Office Rent" might belong under administrative expenses, while "Trade Debtors" belongs under current assets on the balance sheet.
You can let our AI suggest the mapping for you, or you can map each line yourself with a couple of clicks. Once a line is mapped, we remember it for next year, so the second set of accounts is even quicker than the first.
3. Review and file
We build the full set of accounts and the Corporation Tax computation from the mapped trial balance. You review the figures, make any tweaks, and file straight through to Companies House and HMRC.
The slow part of preparing accounts has always been mapping the bookkeeping to the right disclosures. AI mapping turns a half-day job into a coffee break.
Common questions from business owners
Do I need a trial balance if I am a sole trader or landlord?
You do not file company accounts, so a formal trial balance is not required. But the same idea applies - you still need a clean list of income, expenses, assets and liabilities to prepare your Self Assessment (the annual tax return individuals file with HMRC) and, in time, your Making Tax Digital (MTD) submissions.
What if my trial balance does not balance?
That usually means a transaction has been entered incorrectly or a journal is missing. Do not panic - your accounting system or accountant can track it down. You should not try to force the accounts through with an unbalanced trial balance.
Can I use last year's trial balance as a starting point?
Yes, and you should. The closing balances from last year become the opening balances for this year. TaxOptimiser pulls these through automatically when you connect your software or upload a comparative trial balance.
Heads up - The trial balance is the foundation. If something is wrong on it, the error flows through into your accounts and your tax return. Take ten minutes to sense-check the big numbers before you map.
The bottom line
A trial balance is not a piece of accounting wizardry. It is a tidy list of what your business owns, owes, earns and spends, as at a point in time. Once you have one, the rest of your year-end is mostly a matter of presentation - and that is exactly the bit we automate.
If you can export a trial balance, drop a spreadsheet into a browser, or type a handful of numbers, you can produce your company accounts and Corporation Tax return with TaxOptimiser in minutes.