#Simple CompanyTax
FeaturesWho we supportPricingFor accountants
Create account / Sign inStart free preview →
← Back to help centre

How to export a trial balance, profit and loss or balance sheet from QuickBooks

Last updated: 10 October 2026

Short version. Open Reports in QuickBooks Online, run the Trial Balance for the accounting period you are filing and export it to Excel. You can also import a separate Profit and Loss followed by a Balance Sheet into the same #Simple CompanyTax draft.

Go to the steps and entry details ↓

On this page
  • 1. Before you export
  • 2. Export from QuickBooks
  • 3. Import and review
  • 4. Check the result
  • Import last year's figures
  • Official sources

SimpleCompanyTax#Simple CompanyTax supports QuickBooks Online 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

Complete your bookkeeping and reconciliation. Check the report dates against the accounting period in your filing. Use the full accounts period even when it is longer than 12 months. The wizard asks you to allocate relevant figures between both Corporation Tax returns.

2. Export from QuickBooks

  1. Open Reports and search for Trial Balance.
  2. Set the report period to the exact accounting period and select Run report.
  3. Open the export menu and choose Export to Excel.
  4. If you use separate statements, run the Profit and Loss for the full period and the Balance Sheet at the end date. Export each to Excel.

3. Import and review

When Where are your figures from? appears, choose QuickBooks 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.

  1. Open Financial data and select Import profit and loss or Import balance sheet in the relevant section header.
  2. Upload the Excel file and check the selected sheet, report type, heading row and amount columns.
  3. QuickBooks account numbers are optional, so review the account name, type and suggested filing line together.
  4. Resolve every account that needs attention, check the resulting totals and apply the figures.

4. Check the result

Check that Profit and Loss totals are not duplicated by QuickBooks subtotal rows. Confirm the balance sheet has a zero difference, then inspect the generated annual accounts and Corporation Tax computation before filing.

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Official sources

  • QuickBooks: Export your data from QuickBooks
Read our reviews on Trustpilot

Ready to file with SimpleCompanyTax?

File with SimpleCompanyTax#Simple CompanyTax from £10 +VAT per company, per year. £10 +VAT for dormant companies. £25 +VAT for eligible micro-entities. Annual subscription. Compare plans and what's included.

Start filing →See pricing
SimpleCompanyTax#Simple CompanyTax

Affordable UK corporation tax filing for micro-entities.

✓ HMRC-compatible✓ IRmark signed✓ FRC taxonomy validated

Product

  • Features
  • CT600 software
  • Who we support
  • Pricing

Guides

  • Help centre
  • FAQ
  • How to file company tax
  • What is a CT600?

Company

  • About
  • Security
  • Support
  • Contact

Legal

  • Terms
  • Privacy
  • Cookies
© 2026 #Simple CompanyTax, a trading name of Infuzest Ltd (registered in England & Wales).
Read our reviews on Trustpilot