Before importing a trial balance: a director's checklist

In short: Before importing a trial balance, check five things: the company and accounting period, that year-end adjustments are posted, that debits equal credits, that bank and other control accounts agree to their reconciliations, and that opening balances match last year's final accounts. After importing, key totals must arrive unchanged: if the source shows £80,000 of sales, so should the import. A successful import proves only that a file was processed; the company still needs adequate underlying records (Companies Act 2006, section 386).

Before relying on the result, check the period, the meaning of the columns, the account mapping and the balances that should reconcile to independent records.

This checklist is a suggested review method for directors and bookkeepers. It is not a claim that every software product uses the same file format.

What is the file supposed to contain?

A trial balance lists ledger-account balances at a particular point in the accounting process, and its debits and credits should reconcile under the export's stated convention. Your import tool may expect separate debit and credit columns, signed balances or another defined layout, so match the export to the destination's template.

How do you import a trial balance, step by step?

Get the destination's template, preserve the source export, run the pre-import checks, map each account, import once with a log, then check the imported totals against the source. A successful import proves only that the file was processed; the checks before and after it are what show the figures are right.

Step 1: Get the destination's import template

Get the destination's actual template before exporting anything. Confirm whether it expects closing balances, movements for a period, comparative figures or a combination, and whether it wants separate debit and credit columns or signed balances. A correctly formatted export can still be the wrong type of report, so match the report to the template, not just the column layout.

Step 2: Export and preserve the source file

Name the source export clearly, including the company, period end and export date. Preserve it unchanged. Put any mapping work into a separate working version so you can explain what changed between the source and what you import. If the accountant later posts late adjustments, you will need to tell the two exports apart.

Step 3: Check the company, dates and year-end adjustments

Confirm the legal entity and accounting period match the intended filing. Check that the expected year-end adjustments have been posted, or that the outstanding ones are documented. An export for the wrong company or period can import perfectly and still be useless, so settle these before looking at any balances. The figures must support a balance sheet showing everything the company owns, owes and is owed on the last day of its financial year (GOV.UK: Prepare annual accounts for a private limited company).

Step 4: Check the balances reconcile

Confirm debits and credits reconcile under the export's stated convention. Agree bank, receivables, payables and relevant tax balances to their reconciliations, and brought-forward balances to the prior final accounts and any documented subsequent adjustments. Agreement of the debit and credit totals is necessary but not sufficient: a cost in the wrong account can leave both totals perfectly balanced.

Step 5: Map each account to the destination

Decide where each source account belongs. This is an accounting decision: similar labels do not guarantee equivalent meanings. A "director account" could be money owed by the company or to it; "tax" might be Corporation Tax, VAT or payroll. Do not map every tax-labelled account into Corporation Tax payable, resolve unmapped accounts before relying on totals, and flag costs needing tax adjustments.

Step 6: Import once and keep an import log

Before importing, check whether the product replaces or adds data: an unplanned second import can duplicate information. Then import the working version and keep a short import log: source file, destination, import date, mapping version, exceptions and who reviewed them. The log is particularly useful if a second export is imported after the accountant posts late adjustments.

Step 7: Check the imported totals match the source

Compare the imported report with the source, including zero, negative and unmapped balances, and confirm that key totals arrive unchanged. If the source has sales of £80,000 and operating costs of £55,000, the mapped totals should remain £80,000 and £55,000. Investigate any difference instead of adjusting a miscellaneous account to force agreement. The import has worked when every key total agrees and no balance is left unmapped.

What should you check before importing a trial balance?

Check five things before pressing import: the company and dates, completion of year-end adjustments, that debits and credits balance, control-account reconciliations, and opening balances against the prior final accounts. Balanced totals alone are not enough, because a cost in the wrong account can leave both totals perfectly balanced. In detail:

1. Company and dates: the legal entity and accounting period match the intended filing.
2. Completion: expected year-end adjustments have been posted, or the outstanding ones are documented.
3. Balance: debits and credits reconcile under the export's stated convention.
4. Control accounts: bank, receivables, payables and relevant tax balances agree to their reconciliations.
5. Opening position: brought-forward balances agree to the prior final accounts and any documented subsequent adjustments.

What does mapping a trial balance mean?

Mapping means deciding where each source account belongs in the destination, and it is an accounting decision: similar labels do not guarantee equivalent meanings. For example, "director account" could represent money owed by the company, money owed to it or a ledger requiring further analysis.

"Tax" might refer to Corporation Tax, VAT, payroll liabilities or a mixture. Do not map every tax-labelled account into Corporation Tax payable.

This is also a good point to flag costs requiring tax adjustments. Account mapping and tax deductibility are related tasks, but they are not the same task.

Is a trial balance enough evidence on its own?

No: the company still needs its underlying accounting records, and a CSV is not a replacement for invoices, contracts, bank statements or the calculations supporting the accounts. GOV.UK: Running a limited company: company and accounting records describes the records companies must retain. Before preparing an import, you can take the 30-second check to see whether Taxley fits your company.

Next step: ask Taxley about its current import requirements before preparing your file. Describe the report format without sending confidential accounting data in an initial enquiry.

Frequently asked questions

How do you check a trial balance import worked?

Compare the imported report with the source, including zero, negative and unmapped balances, and confirm that key totals such as sales and costs arrive unchanged. A difference between two totals, such as sales less costs, is not necessarily the final accounting or taxable profit.

Should I import the same file again to fix an error?

Not before checking whether the product replaces or adds data. An unplanned second import can duplicate information, so fix the mapping in your working version, confirm how a re-import behaves, and record each import in the log with its date and mapping version.

Does a balanced trial balance mean the tax is correct?

No. Balanced debit and credit totals show only that the file is internally consistent. Classification, completeness and tax adjustments need their own review: a cost in the wrong account can leave both totals balanced, and mapping is not the same task as deciding tax deductibility.

Can I map a "tax" account straight to Corporation Tax payable?

Not without checking. "Tax" might refer to Corporation Tax, VAT, payroll liabilities or a mixture, so look at the ledger detail before mapping. Do not map every tax-labelled account into Corporation Tax payable, and split an account that contains different items where appropriate.

General information, not personalised tax or accounting advice.