How to Get Profit and Loss from QuickBooks

QuickBooks exports profit and loss reports as Excel or PDF files, but the formatting often breaks spreadsheet analysis. The export includes merged cells, subtotal rows mixed with data rows, and date ranges in headers rather than columns.

Upload your QuickBooks P&L export and get back a clean dataset ready for pivot tables, formulas, and multi-period analysis.

Drop your file in and ask a question — no account needed.

Upload your spreadsheet.xlsx .xls .csv — free to try, no account

Or start with

How do I export a profit and loss statement from QuickBooks?Why does my QuickBooks P&L have blank rows in Excel?How do I remove subtotals from a QuickBooks profit and loss export?Can I get QuickBooks to export P&L by month in separate columns?How do I compare profit and loss across multiple periods in QuickBooks?

See it on a sample file

What DataMimi shows for a QuickBooks transaction detail

1,118 rows, Jul 2025 – Aug 2026. Computed by DataMimi from a sample export with the same columns as yours — the data is invented, the figures are exactly what the app produces from it.

Open this sample in DataMimi

Ask the sample — no account

Income versus expenses, month by month Which expense accounts grew the most this year?Who are our biggest vendors?Which customers paid us the most?

What this export contains

Account

Account Type

Total

Jan 2024

Feb 2024

Mar 2024

Q1 2024

Income

Cost of Goods Sold

Gross Profit

Expenses

Net Income

Common questions

How do I get profit and loss from QuickBooks into Excel?

In QuickBooks, go to Reports, select Profit and Loss, set your date range, then click Export and choose Excel. The file opens in Excel but contains merged cells and subtotal rows that interfere with formulas.

Why does my exported P&L have merged cells?

QuickBooks formats section headers like Income and Expenses as merged cells spanning all columns. Excel requires you to unmerge these before you can sort, filter, or use the data in a pivot table.

How do I remove Gross Profit and Net Income rows from the export?

These calculated rows appear in the same Account column as your actual accounts. You must manually delete them or filter them out, because they will cause double-counting if you sum the Total column.

Can I export multiple months as rows instead of columns?

QuickBooks exports each month as a separate column by default. To get months as rows, you must export each month individually and stack the files, adding a period column to each before combining them.

How do I handle sub-account indentation in the export?

QuickBooks indents sub-accounts with spaces. To use these in formulas, either trim the spaces with TRIM() or create a separate column that identifies the account hierarchy level.

Try it with your own file

DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.

Ask about your file