How to export a trial balance, profit and loss or balance sheet from Xero
Short version. Run the Xero Trial Balance for the accounting period you are filing, then export it as CSV or Excel. You can also export the Profit and Loss and Balance Sheet separately and import them one after the other in #Simple CompanyTax.
Go to the steps and entry details
On this page
SimpleCompanyTax supports Xero report file imports for a CT600 and annual accounts filing. After exporting, follow how to import your accounting data for the complete mapping and review steps.
1. Before you export
Finish your bookkeeping and reconciliation first. Check the start and end dates against the accounting period shown in your filing. If the accounts cover more than 12 months, export the full accounts period. The filing wizard will still ask you to confirm any figures that must be allocated between the two Corporation Tax returns.
2. Export from Xero
- In Xero, open Accounting, then Reports.
- Open Trial Balance. Set the date to the end of the accounting period and update the report.
- Choose Export, then download CSV or Excel. Keep the account codes and account types in the export where Xero offers them.
- If you cannot use the Trial Balance, export Profit and Loss for the full period and Balance Sheet at the period end. Import both files into the same draft.
3. Import and review
When Where are your figures from? appears, choose Xero and select Continue. Export guidance is linked beside the upload control. If you chose a file first, check the source guessed from that file before continuing.
An unedited export matching a recognised template goes straight to Review. A workbook with several sheets lets you choose the report first. An edited export opens Which row has your column names?. Click the heading row, or select My file has no heading row, and choose the account and amount roles above each column. Select Review mapping when the layout matches your report.
If your file clearly matches another supported software template, it is read using that template. Exported from shows the detected software and remains changeable. Edited exports use the source you chose and still need your review.
- Open Financial data and select Import profit and loss or Import balance sheet in the relevant section header.
- Drop the file into the upload area. Check that Xero, the report type, the heading row and the amount columns are correct.
- Review every non-zero account. Resolve each amber choice, including loans, other income, donations, property costs and equity.
- Choose Keep current, Replace or Clear for each filing field, then select Use these figures.
4. Check the result
Check the profit before tax and balance-sheet difference shown before you apply the figures. Then review the Financial data totals and generated annual accounts. A zero balance-sheet difference confirms that net assets equal equity. It does not confirm that every account has the right accounting or tax treatment.
Import last year's figures
You can import the comparatives from the same report or from a separate last-year file. Companies House figures still prefill as usual. Imported prior-year figures replace the supplied lines without another prompt. Lines missing from the import keep their existing figures.
- For a report with both years, keep Import into set to This year. Open Columns and select Prior year amount. Ordered year or full-date headings propose the latest column for this year and the immediately preceding annual column for prior year. Check both selections. Monthly columns are never selected as prior year automatically.
- For a separate file, choose Prior year under Import into, upload last year's report and review its mappings. For a trial balance with separate prior Debit and Credit columns, use a separate prior-year file.
- Review the prior-year amounts and destination totals before selecting Use these figures. If you split an account between lines in a two-year report, enter each year's split amounts separately.
- Check the comparative column and prior period dates in Financial data, then save progress. The import keeps those dates unchanged. Prior-year figures are for the accounts comparatives and do not change this year's tax or two-return allocations.
Prior-year import controls are hidden for a first accounting period or when you have selected that there is no prior year.