How to import Xero, QuickBooks, Sage Accounting or spreadsheet data for a CT600
Short version. Importing fills only the Financial Data figures you approve from a Xero, QuickBooks, Sage Accounting or spreadsheet report. It does not change your dates, submit anything or divide one-date amounts between two returns for you. SimpleCompanyTax can import Xero, QuickBooks, Sage Accounting or spreadsheet data into your CT600 and annual accounts filing. Upload a trial balance, profit and loss report or balance sheet as CSV or Excel, review the account mappings, then choose which figures to apply. You can import current-period figures and prior-year comparatives. Your existing figures change only when you apply the import.
On this page
Financial Data onlyCSV, TXT, XLS or XLSXAccounts periods over 12 monthsWhere you see it: Financial Data › Profit & loss or Balance sheet
Before entering figures, the filing setup questions can set the existing destination and CT600 route for an ordinary limited company. They keep the full accounts dates beside the CT600 dates. You can also continue with the controls below without opening the questions.
Importing fills only the Financial Data figures you approve from a Xero, QuickBooks, Sage Accounting or spreadsheet report. It does not change your dates, submit anything or divide one-date amounts between two returns for you.
- The importer opens from Import profit and loss or Import balance sheet on Financial Data. Both buttons open the same importer and both accept a trial balance.
- Nothing changes in your filing until you select Use these figures. Where a field already has a figure, you choose to keep, replace or clear it.
- The import does not change your accounting period, your CT600 dates or your answers on Company Profile & Period.
- For an accounts period that ends more than 12 months after it starts, even by one day, import the figures for the whole accounts period once. Amounts that belong to one date still need allocating between the two returns, and a notice lists them. Long accounting periods
- The import does not submit anything to HMRC or Companies House. You still review the figures, the accounts and the tax computation before you file.
Is this the right guide for you?
Use it if all of these are true
- You have a trial balance, profit and loss report or balance sheet for the accounts period you are filing.
- The report is a CSV, TXT, XLS or XLSX file of up to 1 MB, or rows you can copy from a spreadsheet.
- You are filing for a company on the ordinary company route, which has the import buttons on Financial Data.
Do not use it if
- You prepared your own spreadsheet rather than exporting from Xero, QuickBooks or Sage Accounting.Use instead: Import your own Excel or CSV spreadsheet
- You only have bank statements, invoices or a list of transactions.The importer reads prepared account balances, not transactions. Prepare a trial balance first, or type the totals into Financial Data.
- You are filing a charity CT600E or an unincorporated club return.Those routes do not have the import buttons. Enter the figures their screens ask for.
Common mistake: a report for the wrong dates
The importer reads whichever column you choose. It does not check that the report covers your accounting period, and it never changes the period to match the report. A report for one month, for the wrong year, or for only the first 12 months of a longer accounts period fills Financial Data with the wrong totals. For a long period, export one report for the whole accounts period and import it once. Do not import a separate report for each return's dates.
More help: The imported total is too high or too low · Accounts periods longer than 12 months
Worked example
- Company
- Aspen Example Ltd
- Accounts period
- 1 March 2025 to 31 May 2026 (15 months, two CT600s)
- Report
- A Xero trial balance for 1 March 2025 to 31 May 2026, exported as Excel
- What the import fills
- Profit and loss and balance sheet figures for the whole accounts period
- What stays with you
- The dates, the tax adjustments and how any one-date amount divides between the two returns
The company and all figures on this page are fictional.
Before you start
- Your report
- A trial balance, profit and loss report or balance sheet for the whole accounts period you are filing.
- The file
- CSV, TXT, XLS or XLSX, up to 1 MB, 2,000 rows and 200 columns per sheet. Or rows copied from a spreadsheet.
- Last year’s report
- Only if you want to import the comparatives as well. Not offered for a first accounting period.
- Your filing
- A saved filing with the period chosen on Company Profile & Period. Save and resume a filing
The company and all figures on this page are fictional.
Use a report for the accounts year you are importing. Current-period figures and prior-year comparatives use their respective accounts periods. The importer accepts:
- a trial balance with debit and credit columns
- a profit and loss report with one or more amount columns
- a balance sheet with one or more amount columns
- a generic CSV, XLS or XLSX spreadsheet with account names and financial amounts
Keep account names, account codes and account types in the export where your accounting software provides them. They improve the suggested mappings. A suggestion is never treated as an accounting judgement. You remain in control of the destination, sign and figure used for each account.
Step by step
Open the importer
- Import profit and loss
- Click it in the Profit & loss section headerOr click Import balance sheet in the Balance sheet header. With Enter figures separately, the profit and loss import is on the Accounts step and the balance sheet import on Shared details.
- Where are your figures from?
- Xero, QuickBooks, Sage Accounting or Another spreadsheet or CSV, then ContinueThe choice is asked again for every import.
- Import into
- This year, or Prior year for last year's comparativesShown only when the filing has a prior year.
- Your file
- Choose or drop the file. For copied rows, choose Another spreadsheet or CSV and then Paste rows instead
More help: Supported reports and file formats
Check the columns
A recognised Xero, QuickBooks or Sage Accounting report skips this step. Other files open the column grid.
- Which row has your column names?
- Click the row with your headings, or My file has no heading row
- Column roles
- Account name, plus one Amount column or both Debit and Credit columnsFor a comparative column, choose Prior year amount.
- Report type
- Trial balance, profit and loss or balance sheet
- How signs are shown
- How your report shows income, costs, debits and credits
Click Review mapping.
More help: What the column settings mean · Your own spreadsheet
Review the mapping
- Amber rows
- Confirm each proposal, or Confirm all when they all match your accountsSelect a line to read its description and choose a different one.
- Not used
- For a row that should not fill any figure
- Review changes
- Shown when fields already hold figures. Choose Keep current, Replace or Clear for each
Click Use these figures. The filled fields are highlighted and a notice says how many figures were filled.
More help: Choosing a filing line
After the import
- Accounts period over 12 months
- If the notice lists amounts that still need allocating, click Allocate beside each one and divide it between the two returnsThe list updates as you finish. A valid allocation you already made stays as it is.
- Check the figures
- Compare the Financial Data totals with your prepared accounts
- Save Progress
- Save, then complete the rest of the step
More help: Check the result · Long accounting periods
Sample outcome
Supported reports and file formats
You can import one trial balance covering both financial statements, or import a profit and loss report and balance sheet separately into the same draft.
- Xero
- Trial balance, profit and loss or balance sheetUse a CSV or Excel export. Follow the Xero export steps.
- QuickBooks Online
- Trial balance, profit and loss or balance sheetUse an Excel export. Account numbers are optional. Follow the QuickBooks export steps.
- Sage Accounting
- Trial balance, profit and loss or balance sheetUse a CSV export. Codes are optional. Follow the Sage Accounting export steps.
- Your spreadsheet or other software
- Prepared account balancesUse CSV, TXT, XLS or XLSX, or paste spreadsheet rows. Follow the generic CSV and Excel import steps if the columns are not recognised.
Files can be up to 1 MB, with up to 2,000 rows and 200 columns per sheet. You upload exported files. No sign-in to your accounting software is needed.
Export from Xero or QuickBooks
Xero
- In Xero, open the report for the required period.
- Use the report's export control and choose Excel or CSV.
- Leave the account code and account type columns in the export where they are available.
Xero recommends exporting a Balance Sheet and Profit and Loss for each year and a Trial Balance that includes past periods. See Xero's guide to exporting data and reports. Our Xero report export guide explains the dates and review steps for this filing.
QuickBooks Online
- Open Reports, then Standard reports.
- Search for and open Trial Balance, Profit and Loss or Balance Sheet.
- Set the report period to the accounting period you are filing.
- Choose Export or Export/Print, then Export to Excel.
QuickBooks also lets you export the three reports together from Settings, Export data. See QuickBooks' report export guide. Follow our QuickBooks report export guide for the filing workflow.
Import and review the figures
Each import asks Where are your figures from?. Choose Xero, QuickBooks, Sage Accounting or Another spreadsheet or CSV, then select Continue. When a file was chosen first, check the detected source before continuing. The choice is not remembered between imports.
Recognised vendor templates open Review directly. Generic files, pasted rows and edited exports open Which row has your column names?. Choose the heading row or My file has no heading row, then set the column roles and select Review mapping. If it is greyed out, the line above it says what to change. Use one Amount column or both Debit and Credit columns. For comparisons, choose Prior year amount. The labelled controls under Columns use the same selections. See the heading and column grid guide.
The first sheet with data opens first. Keep one report per sheet and use Workbook sheet to change reports. Bank statements and transaction lists cannot be imported. Use prepared account balances instead.
Using your own Excel file? You do not need Xero or QuickBooks. Follow how to prepare and import your own spreadsheet for example layouts, downloadable CSV examples that open in Excel, and the exact column settings. In the importer, choose My spreadsheet or other software under Exported from.
- Open your filing and go to Financial data.
- Select Import profit and loss in the Profit & loss section header, or Import balance sheet in the Balance sheet section header. Both buttons open the same importer and also accept a trial balance.
- Under Where are your figures from?, choose Xero, QuickBooks, Sage Accounting or Another spreadsheet or CSV, then select Continue.
- Choose the file from your device, or drop it onto the upload area in the import window. For copied spreadsheet rows, choose Another spreadsheet or CSV, then Paste rows instead. How to import your data in the window header opens these steps in a new tab.
- Check the detected source and period on the review screen. Select Change to inspect the report type, worksheet and columns. For a generic profit and loss report, also confirm whether expenses are shown as positive or negative amounts.
- Review all account mappings. Recognised bank overdrafts and VAT recoverable balances are placed automatically and remain editable. Accounts needing confirmation are highlighted in amber. Select Confirm on those proposals, or Confirm all when they all agree with your accounts. Select a line to open the chooser. Read its description and examples, select an alternative, then select Assign to keep it amber for later confirmation, or Apply change to assign and confirm it now. Cancel leaves the original mapping in place. Undo reverses your latest mapping change. Choose Not used when a row should not populate the filing.
- A retained earnings figure is selected when it reconciles to net assets. Open Retained earnings working to inspect it or choose another figure.
- If existing figures differ, select Review changes and choose Keep current, Replace or Clear for the affected filing fields. A fresh draft goes straight to Use these figures.
- Select Use these figures.
You can import a profit and loss report first and a balance sheet second. The second import leaves the first report's fields in place unless you explicitly replace or clear them. Re-importing a report also shows fields that existed in the previous import but are missing from the new file. Unchanged fields missing from the new file default to Clear. Fields you edited default to Keep current.
Import prior-year comparative figures
Where your filing needs comparatives, you can import prepared prior-year figures for that column in your annual accounts. Use reports for the prior accounts period and review their mappings and figures before applying them. Check any differences from prior-year figures already in your draft.
Keep the current-period and prior-year figures separate. A comparative figure describes the earlier accounts period. It is not an extra current-period income or expense. After applying the import, review both columns in the accounts preview.
What the column settings mean
Opening, movement and closing balances: when both closing debit and closing credit columns are present, the importer proposes that pair. Headings such as CBDEBIT and CBCREDIT or Closing Dr and Closing Cr are recognised. A single closing column is never mixed with an ordinary Debit or Credit column. Check the proposed pair and use Columns to change it.
Monthly reports with a Grand total: the total is proposed when the other amount headings are months and every row of amounts is readable and adds up. Overlapping subtotal columns with Total or Totals in their heading are excluded from the check. A comparison, budget or other heading, or an unreadable amount, leaves the Grand total unselected. An ordinary Total, Amount, Balance or Net heading can still be proposed. Choose the column covering the accounts period.
Income and costs both negative: for a profit and loss with at least two non-zero account amounts, all negative, How signs are shown proposes Income and costs are negative. The file cells keep their original signs. Review shows their contribution as income or cost. You can change the setting, and an explicit choice is kept when you change columns or the heading row.
These settings describe your spreadsheet. They do not ask you to create account types or change your bookkeeping. Open the help icon beside any setting for its meaning and an example. The preview marks the columns being used.
- Heading row
- Heading rowThe row containing column titles, not the company name or the first account. Choosing it tells us where the account rows begin. If your file has no column titles, choose No heading row (data starts on row 1).
- Account name
- Account nameChoose the column containing descriptions such as Sales or Bank fees. It may be called Account description. Do not choose the account number column.
- Account code
- Account codeThe optional reference your accounting software gives each account. Choose Not included if your file has no codes.
- Account type
- Account typeAn optional category supplied by your accounting software, such as Revenue, Expense or Bank. Choose the column containing those categories. You do not need to invent a type when your export has none.
- Amount layout
- Amount layoutChoose how the money columns are arranged. One amount column means each account has a single balance or total. Debit and credit columns means there are two separate columns labelled Debit and Credit.
- Amount
- AmountChoose the total for the accounting period you are importing. If there are monthly columns and a YTD or Total column, choose the whole-period total that matches your filing. We use this column, not the sum of every column.
- Debit
- DebitChoose the column labelled Debit or Dr in the exported trial balance. Use the labels in your file, not whether an amount looks like income or spending.
- Credit
- CreditChoose the column labelled Credit or Cr in the exported trial balance. Debit and Credit must refer to different columns.
- Exported from
- Exported fromFor a file you prepared in Excel, choose My spreadsheet or other software. Choose Sage Accounting for its cloud reports. For Sage 50 desktop or another accounting package, use My spreadsheet or other software and choose the columns.
- Report type
- Report typeTrial balance lists ledger account balances. Profit and loss lists income and costs for a period. Balance sheet lists assets, liabilities and equity at a date. Choose the report named in your file.
- Workbook sheet
- Workbook sheetAn Excel workbook can contain several sheets. Choose the sheet containing the report you want to import.
- How signs are shown
- How signs are shownMatch the numbers in your export. Some profit and loss reports show both income and costs as positive numbers. Others show costs as negative, or both income and costs as negative. The proposed setting is editable. A signed trial balance may instead use positive for debit and negative for credit. Separate Debit and Credit columns do not need this setting.
If your profit and loss has code and account names in column A, account amounts in B and calculated totals in B/C, see the settings for the supported CSV without column headings. Check that the first account is included before applying.
Fictional example. A spreadsheet has Account number in column 1, Account description in column 2, monthly figures in columns 3 to 14 and YTD in column 15. Select column 2 as Account name, column 1 as Account code and column 15 as Amount if its dates cover the filing period. Leave Account type as Not included if the file has no category column.
Choosing a filing line
For the difference between detailed ledger accounts and filing headings, read how a trial balance maps to micro-entity accounts.
When the balance sheet shows Corporation Tax payable, review any separate tax liability mapping. If your file has no separate tax liability, the payable keeps its current setting. After applying, check Total creditors: due within one year and Closing retained earnings against your accounts. If the creditors you imported already include the tax, enter 0 in the payable box or take the tax out of the other creditors. If imported retained earnings already include this period’s tax charge, add back the signed charge from the profit and loss. Subtract it instead if it is a tax credit.
A filing line is the place an account contributes to your prepared figures. Select the current or proposed line to explore descriptions and examples. Search by a name such as bank or an example such as wages. Selecting a line in the chooser does not move the account. Assign saves your choice in the amber section for later confirmation. Apply change assigns and confirms it immediately. Cancel discards the choice. The Undo button reverses your latest mapping change until you leave Review or change the report.
Use Split between two lines for an account containing two categories. Choose both lines and enter amounts that add up to the account balance. Use Not used only when the account should contribute nothing to your imported figures. The chooser also works for selected groups of accounts.
- Turnover
- Profit and lossSales of goods and services, excluding VAT. Example: Product sales, consulting income.
- Other trading income
- Profit and lossIncome of the trade that is not a sale. Example: Trading grants recognised as income.
- Cost of raw materials and consumables
- Profit and lossMaterials, stock and consumables used in what you sold. Example: Raw materials, packaging.
- Staff costs
- Profit and lossEmployee pay and the employer’s payroll costs. Example: Salaries, employer National Insurance, pensions.
- Depreciation and amounts written off assets
- Profit and lossThe period’s depreciation, amortisation and asset write-down charges. Example: Equipment depreciation, software amortisation.
- Other charges
- Profit and lossRunning costs that do not belong on another expense line. Example: Rent, insurance, bank fees, professional fees.
- Interest receivable and similar income
- Profit and lossInterest earned by the company. Example: Bank deposit interest.
- Interest payable and similar charges
- Profit and lossInterest and similar finance charges paid or payable. Example: Loan interest, finance charges.
- Dividends received
- Profit and lossDividends the company receives from investments. Example: Dividends from another company.
- Charitable donations
- Profit and lossCharitable donations shown separately from other running costs. Example: Donations recorded in your prepared accounts.
- Other income not elsewhere included
- Profit and lossIncome that belongs outside the other listed income categories. Example: Other non-trading receipts in your prepared working.
- Profit on disposal of fixed assets
- Profit and lossThe accounting profit on selling a tangible fixed asset. Example: Sale proceeds less the asset’s book value.
- Net property income
- Profit and lossProperty income after the related property costs. Example: Your prepared net rental profit or loss.
- Property rental income
- Profit and lossRental income before deducting property costs. Example: Rent earned from tenants.
- Property materials and consumables
- Profit and lossMaterials and consumables used by the property business. Example: Materials used in the letting activity.
- Property staff costs
- Profit and lossEmployee and payroll costs belonging to the property business. Example: Pay for employees in the letting business.
- Property other charges
- Profit and lossProperty running costs that do not belong on another property line. Example: Letting fees, insurance, repairs.
- Property depreciation
- Profit and lossDepreciation and asset write-down charges of the property business. Example: Depreciation of property-business equipment.
- Called up share capital not paid
- Balance sheetShare capital called up but still unpaid by shareholders. Example: An unpaid amount due on issued shares.
- Intangible assets
- Balance sheetNon-physical fixed assets at their carrying value. Example: Purchased software, patents, goodwill.
- Fixed assets (tangible)
- Balance sheetPhysical fixed assets at their carrying value. Example: Equipment and vehicles, less accumulated depreciation.
- Investments
- Balance sheetInvestments held as fixed assets. Example: Long-term shareholdings.
- Current assets
- Balance sheetShort-term assets and amounts owed to the company. Example: Bank balances, stock, debtors, VAT recoverable.
- Prepayments and accrued income
- Balance sheetCosts paid in advance and income earned but not yet received. Example: Prepaid insurance, accrued income.
- Creditors due within one year
- Balance sheetAmounts the company owes that fall due within one year. Example: Suppliers, bank overdrafts, VAT payable.
- Corporation Tax payable
- Balance sheetCorporation Tax owed at the end of the accounts period and due within one year. Example: Use the outstanding balance, including unpaid tax from earlier periods..
- Creditors due after more than one year
- Balance sheetAmounts the company owes that fall due after more than one year. Example: The long-term part of a loan.
- Provisions for liabilities
- Balance sheetLiabilities with uncertain timing or amount in your prepared accounts. Example: A provision recorded in your accounts.
- Accruals and deferred income
- Balance sheetCosts incurred but not yet paid and income received in advance. Example: Accrued fees, income relating to a later period.
- Share capital
- Balance sheetThe nominal value of shares issued by the company. Example: Issued ordinary share capital.
- Retained earnings
- Balance sheetAccumulated profits or losses and reserves carried in the equity working. Example: Retained profits, brought-forward losses, reserves.
Long accounting periods
Import the prepared accounts figures once for the full accounting period. If the period is longer than 12 months, the existing allocation panels remain available for amounts that must be assigned between the two Corporation Tax returns. Allocate the amounts you prepared. The import does not change the period dates or silently divide event-based amounts such as qualifying charitable donations.
If any allocations are missing or no longer match the imported totals, the message after import lists every amount still needing allocating. Select Allocate beside an amount to open its controls. Choose how much belongs to each return using the dates shown. The list updates as you finish. A valid existing allocation stays unchanged. If an imported donation or dividends received amount becomes zero, its allocation is removed without clearing unrelated allocations.
Check the result
Fictional example. An export has Sales of £12,000 and Other charges of £3,000. Confirm those lines to fill Turnover with £12,000 and Other charges with £3,000. The profit before tax is £9,000. Each statutory line is added in pence and those pence are kept in the accounts. Each profit and loss category is rounded once for Corporation Tax. Compare the totals with your report before continuing.
Calculated lines such as Net Assets and Net Current Assets, and totals that repeat accounts already imported, are left out of the figures. A summary-only Total for row can supply a figure when its section has no account detail. Open Headings, totals and percentage rows to inspect skipped rows. Choose Use this total only when the detailed rows are missing from the export, then check the resulting figures.
On a Xero balance sheet, section headings such as creditors due within one year guide the proposed filing line. A bank listed there with a positive balance is proposed as a current creditor. Review each proposal and change it when your prepared accounts use another line.
Some account names could be income or a cost, such as names containing services, consulting or advertising. Recognised headings and account types help the import propose a line for ambiguous names. For example, an Expenses heading can place Design services in Other charges, while an Advertising income heading can place Magazine advertising in Turnover. A line you confirmed in an earlier import is used again. Review each proposal and change it when your accounts use another line.
Before continuing, check that:
- the imported period agrees with the period shown in the filing
- the profit and loss total agrees with the source report
- assets, liabilities and equity agree with the source balance sheet
- accounts that needed a judgement use the destination you selected
- negative balances and retained earnings have the intended sign
- the Financial data summary agrees with your prepared accounts
The original CSV or Excel file is processed in your browser and is not uploaded or stored. The figures you apply and mapping choices are saved with the draft. Separately, private diagnostics record the parsed sheets, account names, codes, amounts, mapping changes and errors for up to 180 days to help us investigate problems. These financial details are not anonymised or sent to advertising providers. Keep the original export with your accounting records.
Common import questions
Do I need to connect my Xero or QuickBooks account?
No. Export the report from your accounting software and select Import profit and loss or Import balance sheet in Financial data. You do not connect your accounting account or share its password.
Will importing a balance sheet replace my profit and loss?
You can apply the profit and loss first and the balance sheet second. The second import keeps the first report's fields unless you explicitly choose to replace or clear them. Check the comparison before selecting Use these figures.
Does importing a trial balance complete my CT600?
The import fills the financial fields you approve. Complete the remaining filing questions and any tax adjustments or allocations that apply, then review the generated accounts and Corporation Tax computation before submitting.
Fix an import problem
My CSV or Excel file will not import
Use one of the supported file formats and stay within the size and sheet limits above. If the file cannot be read, export a fresh copy. For an unfamiliar layout, select Change, choose the report type and review Columns, which opens automatically. Use account descriptions as Account name and nominal numbers as Account code.
The imported total is too high or too low
Check the selected period and amount column. Choose the full-period total for the accounts year you are importing rather than one month or another year. Keep current-period and comparative amounts separate. Do not add monthly figures and a YTD total together. Review headings and subtotals so a total is not included alongside its detail, then check the account mappings and signs.
The Grand total does not match the monthly amounts
A Grand total that differs from the sum of the monthly columns by more than one penny stays unselected. If no other amount column is proposed, the importer shows a warning. Check the totals in your spreadsheet before choosing an amount column. You can correct the spreadsheet and import it again, or choose the full-period amount yourself. Choosing a column removes the warning. This check does not confirm that a total covers your accounts dates.
Rows say they have the opposite sign
This message can mean that a filing line total is below zero, or that an amount assigned through Split between two lines has the opposite sign to its account. Contra accounts such as accumulated depreciation are allowed when their combined filing line can be represented.
Pence are preserved, so even a small negative total can need correcting. An inconsistent split can still need correcting. Move the affected account to the correct line, mark it Not used, or correct its split amounts. Review the resulting totals before selecting Use these figures.
A spreadsheet cell says it could not be read
Inspect the named cell in your spreadsheet. Export the calculated values if the formula cannot be read, then import the corrected report. An unreadable balance needs resolving before it can contribute to your figures.
Can I upload a bank statement or PDF instead?
This importer reads prepared account balances rather than a list of bank transactions. Export a trial balance, profit and loss or balance sheet as CSV or Excel. PDF reports are not supported by this importer.
Not the right guide?
Open the guide that matches your report.
Looking for a different field or step? See all filing wizard guides →
Official sources
- Xero Central: About exporting data out of Xero
- QuickBooks: Export your reports to Excel
- Financial Reporting Council: FRS 105
Whether this route matches your filings is for you to decide, yourself or with your accountant.
Example companies and figures are fictional. Field names match the filing wizard as of 12 October 2026.
The import preview and resulting balance sheet show Net assets (liabilities). The caption is the same for a positive, zero or negative total.