Export Profit and Loss from QuickBooks Online
QuickBooks Online lets you export your Profit and Loss statement as an Excel or CSV file from the Reports menu. The export includes your income and expense accounts with their balances, but the formatting often requires cleanup before you can analyze it in a spreadsheet.
Upload your QuickBooks P&L export and get back a clean table where every row is an account, every column is a number you can calculate with, and the structure stays consistent no matter which classes or periods you included.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountSee 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.
What this export contains
| Account |
| Total |
| Jan - Dec 2023 |
| Class |
| Type |
| Balance |
| Current Month |
| Year-to-Date |
| % of Income |
| Debit |
| Credit |
| Net Income |
Common questions
How do I export profit and loss from QuickBooks Online?
Go to Reports, search for Profit and Loss, open the report, set your date range and filters, then click Export and choose Excel or PDF. The Excel option gives you a .xlsx file you can open in any spreadsheet program.
Why are there extra rows in my exported P&L?
QuickBooks includes section headers like 'Income' and 'Expenses', subtotal rows like 'Total Income', and a final 'Net Income' row. These formatting rows help readability in the report but interfere with formulas when you treat the export as a data table.
How do I compare multiple months in one export?
In the report settings, change the display columns to Months or Quarters before exporting. QuickBooks will create a separate column for each period. You can also select 'Previous Period' or 'Previous Year' comparison to get side-by-side columns.
What does the class tracking column do?
If you use class tracking in QuickBooks, you can run the P&L by class to see income and expenses broken out by department, location, or project. The export adds columns for each class, but this makes the file structure different from a standard P&L export.
Can I export only certain accounts?
You can filter the report before exporting by clicking Customize, then using the Filter section to select specific accounts or account types. The export will include only the accounts that appear in the filtered report.
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