How do I export a trial balance from Pandle?
In Pandle, click Reports in the navigation menu and choose Trial Balance from the list. Select the date range for the report, refresh it, and check that debits equal credits. Click the Excel icon to download a CSV file, or View PDF for a PDF, and check that the balance sheet categories show their closing balances.
Key facts
| Where | Reports (navigation menu) > Trial Balance |
|---|---|
| Period | Select the date range, then click the refresh icon |
| What it shows | Your category balances for the date range |
| Downloads | Excel icon (downloads a .CSV file); View PDF icon |
| Updates | Reports update automatically as transactions are entered or amended |
As at 28 October 2026.
Export the trial balance
- Open the report. Click Reports in the navigation menu and choose Trial Balance.
- Set the dates. Select the date range of the financial year, ending on the year end, and click the refresh icon.
- Check the totals. Confirm that debits equal credits, and compare the bank and VAT balances with your statements and returns.
- Download. Click the Excel icon to download a CSV file, or View PDF for a PDF.
- Repeat for last year. Run the previous financial year for the comparatives.
Check before you upload
| Check | Why |
|---|---|
| The report date is the last day of the financial year | The accounts are made up to the accounting reference date, or a date up to 7 days either side of it |
| Year-end journals are posted | Depreciation, accruals, prepayments, stock and the tax charge belong in the trial balance you export |
| Debits equal credits | If the totals differ, something is wrong in the books; the accounts cannot balance |
| Last year's closing balances are the opening balances | The comparatives must agree with last year's accounts |
| The director's loan account is right | An amount a director owes the company is disclosed in the notes and may lead to s455 tax |
| VAT and PAYE accounts agree to the returns | They are creditors for taxation and social security, which the balance sheet formats show separately |
| Suspense and clearing accounts are empty | A balance there is an unexplained item that has to be cleared before the accounts are prepared |
Pandle's help describes the trial balance as the category balances for a date range. Before uploading, check that the balance sheet categories (bank, debtors, creditors, the director's loan account, share capital) show their full balances at the year end and not only the movements in the year; compare them with your bank statements and last year's accounts.
Work out any s455 tax on a director's loan with the s455 calculator, and the filing date with the filing deadline calculator.
Pandle specifics
- Categories. Pandle calls its nominal accounts categories; each becomes one row of the trial balance to map.
- Live figures. Reports update as you enter or amend transactions, so post the year-end adjustments first and export afterwards.
- The CSV. The icon is labelled Excel, but the file it downloads is a CSV, which opens in a spreadsheet and imports into accounts software.
Using the export with StatutoryAccounts.io
StatutoryAccounts.io is built to read a trial balance export as Excel, CSV or PDF, suggest the Companies Act line item for each nominal account with AI and let you confirm the mapping. The file to use is the CSV download. Keep last year's trial balance as well, unless the comparatives come from the accounts filed at Companies House.
Frequently asked questions
Where is the trial balance in Pandle?
Click Reports in the navigation menu and select Trial Balance from the list of reports.
What format does Pandle export the trial balance in?
The Excel icon downloads a CSV file, and View PDF creates a PDF.
Do Pandle reports update after I post adjustments?
Yes. Pandle's reports update automatically as transactions are entered or amended, so export after the year-end journals.
Sources
Prepare your statutory accounts
Create an account and set up your company from the Companies House register; your first set of accounts is free. The trial balance import and the CT600 are in preparation.
Join the waitlistGeneral information about UK company law and tax, not legal or tax advice. The directors remain responsible for the accounts and returns they approve and file.