Built for QuickBooks Online

QuickBooks consolidated reporting

Report Craft connects to your QuickBooks Online companies through Intuit's official OAuth connection and turns them into one consolidated Profit & Loss, Balance Sheet and Trial Balance — with intercompany eliminations and a bundled PDF — from $8 per ledger.

Start for free

Consolidate QuickBooks companies without the spreadsheet

QuickBooks Online handles a single company well, but groups with several company files have no native way to produce consolidated group accounts. The usual workaround — exporting each company's trial balance and merging it by hand — is slow and easy to get wrong. Report Craft automates the whole consolidation.

Connect each QuickBooks Online company through the official Intuit connection, map every company's chart of accounts to a single group chart, post your eliminations, and generate a complete consolidated report bundle — front cover, compilation report, P&L, balance sheet, trial balance and notes — as one print-ready PDF.

How the QuickBooks integration works

Report Craft is an authorised Intuit developer app. Here is exactly what happens when you connect a QuickBooks Online company.

  1. 1

    Authorise on Intuit's screen

    Click Connect to QuickBooks in Report Craft and Intuit's own authorisation screen opens. You sign in with your Intuit account, pick the QuickBooks Online company you want to share, and approve the connection. Report Craft never sees your QuickBooks user name or password.

  2. 2

    We import your accounts and balances

    Once you approve, Report Craft calls the QuickBooks Online Accounting API to read the company name, the chart of accounts (including sub-accounts and account types) and trial balance totals for up to five financial years. Nothing else is read — no invoices, customers, payroll or bank feeds.

  3. 3

    Add every company in the group

    Repeat the connection for each QuickBooks Online company. Every company file becomes a ledger in Report Craft, and their charts of accounts are mapped once to a single group chart that is remembered for next year.

  4. 4

    Produce the consolidated reports

    Post consolidation adjustments and intercompany elimination journals, then generate the consolidated Profit & Loss, Balance Sheet, Trial Balance and supporting schedules as one print-ready PDF. Adjustments live in Report Craft and are only written back to QuickBooks if you explicitly choose to post them.

  5. 5

    Stay in sync, or disconnect any time

    Refresh a ledger whenever the QuickBooks data changes and the reports update with it. Disconnect from inside Report Craft or from the Apps area of QuickBooks Online — the authorisation is revoked with Intuit straight away and we stop accessing that company file.

The connection uses Intuit's OAuth 2.0 accounting scope. Access tokens are stored encrypted, refreshed automatically, and destroyed when you disconnect. See our privacy policy for how your data is held.

What you get

Consolidate multiple QuickBooks Online companies into one group
Official Intuit OAuth connection — no credentials shared
Chart of accounts and five years of balances imported automatically
Unified group chart of accounts, mapped once and remembered
Intercompany elimination and consolidation adjustment journals
Consolidated P&L, balance sheet and trial balance in one PDF
Comparative periods with percentage analysis across the group
Australian financial year handled out of the box

Simple per-ledger pricing

Pricing starts at $8 per ledger per month. Each QuickBooks company is one ledger, and the more you connect the less you pay per ledger.

Client ledgers Price per ledger
1 – 10 $8.00
11 – 30 $4.50
31 – 75 $3.00
76 – 150 $2.00
151+ $1.00
All report types, PDF bundles and a 14-day free trial included.

QuickBooks consolidated reporting FAQ

Can I consolidate multiple QuickBooks Online companies?
Yes. QuickBooks Online has no native multi-company consolidation, so Report Craft connects each company file and combines them into one consolidated set of financial statements.
How many QuickBooks companies can I consolidate?
There is no limit. Connect as many QuickBooks Online companies as your group or your client base needs — each one is a ledger in Report Craft.
How does Report Craft connect to QuickBooks?
Through Intuit's official OAuth 2.0 connection. You choose the QuickBooks Online company and authorise Report Craft on Intuit's own screen, and Report Craft then imports the chart of accounts and up to five years of period data using the QuickBooks Online Accounting API. We never see or store your QuickBooks sign-in credentials.
What QuickBooks data does Report Craft read?
The company name, the chart of accounts, and trial balance totals for each financial year. That is everything the reports are built from — Report Craft doesn't read invoices, contacts, payroll or bank feeds.
Does Report Craft change anything in my QuickBooks company?
Not unless you ask it to. The connection is used to read your accounts and balances. Consolidation adjustments and elimination journals are held in Report Craft, and are only posted back to QuickBooks when you explicitly choose to.
How do I disconnect a QuickBooks company?
Disconnect from inside Report Craft, or from the Apps area of QuickBooks Online. Either way the authorisation is revoked with Intuit immediately and Report Craft stops accessing that company file. Reconnecting later takes one click.
Does it handle intercompany eliminations?
Yes. Post consolidation adjustments and elimination journals to remove intercompany loans, internal sales and investments so the consolidated result reflects only external activity.
What does QuickBooks consolidated reporting cost?
Report Craft is billed per client ledger, starting at $8 per ledger per month, with the rate per ledger falling as you connect more. Every plan includes all report types, PDF bundles and a 14-day free trial.

See also our guide to consolidating multiple QuickBooks companies.

Consolidate your QuickBooks clients today

Connect your first QuickBooks Online company and generate a consolidated report in minutes.

Start your free trial