QuickBooks Profit and Loss export (Excel / CSV)
A rendered P&L report dumped to a spreadsheet, which people treat as a flat table of accounts and amounts when it is actually a formatted, indented report with derived subtotal rows baked into the same column as the leaf data.
The shape, how the file is really laid out
The first three to five rows are a preamble, not data: company name, the
literal title "Profit and Loss", the period ("January 1 - December 31, 2025"),
and often a basis line ("Accrual Basis"). The real header row sits below that,
and the account column is usually unlabeled or blank. Accounts are an indented
tree, parent accounts, sub-accounts, then a "Total <Account>" row, under
section banners Income, Cost of Goods Sold, Gross Profit, Expenses, Net
Operating Income, Other Income/Expense, Net Income. Amounts show negatives in
parentheses, e.g. (1,240.00); blank spacer rows separate sections. A multi-
period run adds monthly columns plus a right-hand Total column.
The traps
Header is not row 1, a naive read grabs "Profit and Loss" as a column name.
- Every trap in this export, worked through
- The reconciliation anchor, the total the file asserts about itself
- The refusal cases, when to stop and ask instead of guess
Reference: Intuit QuickBooks Online Help, "Run a Profit and Loss report" and report export/basis settings · QuickBooks Desktop report export documentation (reference only)