Home / Blog / QuickBooks Export to Excel
How-to · 2026

QuickBooks Export to Excel: Stop Rebuilding the Client Workbook by Hand

The export takes ten seconds. The next two hours go on deleting subtotal rows, fixing numbers stored as text and pasting the result into the workbook you built last month, for every client, every month.

By · Published November 17, 2026 · 7 min read

The QuickBooks export is quick. The part that costs time is everything after it: delete the title rows, remove the subtotals, convert the text to numbers, then paste it into the workbook you built last month and fix whatever shifted. Do that for each client and the close becomes a day of copying. Below is what goes wrong in the export and how to stop rebuilding the file every month.

What the export brings with it

An exported report keeps its print layout, not a data layout. An illustrative profit and loss export looks like this:

Acme Ltd
Profit and Loss
January - June 2026

                          Jan 2026    Feb 2026
Income
  Services                  42,000      44,500
  Product sales             11,200      10,800
Total Income                53,200      55,300
Expenses
  Payroll                   31,000      31,000
  Software                   2,100       2,250
Total Expenses              33,100      33,250
Net Income                  20,100      22,050

Sum that column and you add the totals on top of the accounts they total. Three of the first four rows are not data at all, and the section names sit in the account column with no amounts.

Cleaning it into a table

  1. Delete the title block and any rows above the column headers.
  2. Remove the rows that start with "Total" and the section headings, or add a column that marks them so you can filter them out.
  3. Convert the amounts to numbers. Select the column and use Text to Columns, or multiply by 1 in a helper column, and check a negative.
  4. Add the client and the period as columns, so rows from several clients can live in one table.

Do it once with Power Query and the steps are recorded, so next month you refresh instead of repeating them. That works well when the report layout never changes. It breaks when someone adds an account, because a new row shifts what the steps expect.

The workbook that does not move

The goal is a workbook whose formulas read from one named table and never from pasted ranges. When the table is replaced each month, the summary tab, the charts and the commentary update without you touching them. Keep the report settings the same every month: same basis, same columns, same grouping. If they change, the layout changes, and so does everything that read from it.

Skipping the export

For a client deliverable you produce every month, the export-clean-paste cycle is the part to remove. Quiriz connects QuickBooks directly, so the Excel add-in can ask the books for the table instead of receiving a pasted export. The connector brings in [QuickBooks] Profit and loss as a dataset. With the Excel add-in:

=QUIRIZ.ASK("profit and loss by month for this client, income and expenses by account", "table")

Check that the table has one row per account and no subtotal lines mixed in, so formulas that read from it do not double-count. See QuickBooks profit and loss analysis for what to ask once the table is in place.

What it does not replace. Check the first month against your usual export, line by line, and confirm the report basis matches. If your client workbook has custom groupings, the mapping from account to group still has to be written down once, in Company Context or in the sheet.

Skip the export and the cleanup

Try a profit and loss question on sample books with no signup, then connect QuickBooks and ask for it as a table.

Try Quiriz free →

Frequently asked questions

How do I export a QuickBooks Online report to Excel?
Open the report, set the period and options, then use the export icon at the top right of the report and choose Export to Excel. The exact menu can differ by report and by QuickBooks version, so check the report page if you do not see it.
Why do my QuickBooks export totals double-count?
The export includes subtotal rows as well as account rows. If you sum the whole column, the subtotals are added on top of the accounts they summarize. Remove the subtotal lines or sum only the account rows.
Why are my exported numbers not adding up in Excel?
The amounts are probably stored as text, or negatives are shown in brackets or with a trailing minus. Convert the column to numbers and check one total by hand against the report.
Can the workbook update itself each month?
With a stable table and the same report settings, you can paste the new export over the old rows and let the formulas read from the table. Connecting the books directly removes the export step as well.
Should I export from QuickBooks or connect it?
An export is fine for a one-off. For a monthly deliverable per client, a connection saves the repeated export and paste, as long as it reads the same report basis and period you use today.