QuickBooks Profit and Loss Statement to a Board-Ready Income Statement in 60 Seconds

How to run the profit and loss statement in QuickBooks

In QuickBooks Online, open Reports in the left menu, find the Business overview group, and click Profit and Loss. Three controls do almost all the work. Report period sets the window, and the preset options (this month to date, last quarter, this fiscal year) are not always the window your reader wants, so type the dates yourself if the board expects a calendar quarter and your fiscal year starts in July. Display columns by is where a single flat total becomes something readable: switch it to Months or Quarters and you get a trend across the period instead of one number, which is the single most useful change most people never make (the settings and the column limits are covered in running a QuickBooks profit and loss by month). Accounting method is the cash versus accrual toggle. Hit Run report, then use the export icon at the top right for PDF or Excel. QuickBooks Desktop puts the same report under Reports, Company and Financial, Profit and Loss Standard.

Two variants are worth knowing. Profit and Loss Detail lists the individual transactions inside each account rather than the totals, which is what you actually need when a number looks wrong and you want to see the five entries behind it. Profit and Loss Comparison puts a prior period next to the current one. And yes, this answers the template question directly: QuickBooks does not hand you a blank fill-in template, it hands you a live report built from your chart of accounts, and the report layout is the template. If your books live somewhere else, or you keep them in a spreadsheet, our profit and loss statement generator builds the same statement from a CSV. If you need the full set (P&L, balance sheet, cash flow) out of one QuickBooks file, start at the QuickBooks financial statements hub.

What commonly goes wrong on a QuickBooks P&L

The report is only as honest as the categorization behind it, and bank feeds have made miscategorization easier than ever. The usual offenders: an Uncategorized Expense bucket holding four figures of transactions that nobody ever sorted, personal spending sitting inside cost of goods sold because a card got auto-matched, owner draws booked as an expense (they belong in equity, and expensing them understates your real profit), and deposits that are not revenue at all, loan proceeds, transfers between accounts, owner contributions, dropped into an income account and quietly inflating the top line. Duplicates are the other classic: a downloaded bank transaction gets added instead of matched to the invoice already in the books, and the same $12,000 hits income twice. Before you send anything, run the Detail version and read the Uncategorized rows and the largest five entries in every income account.

Then there is the cash versus accrual confusion, which produces the single most common support question about this report: I ran it twice and got two different numbers. Both are correct. Cash basis recognizes income when the money lands and expenses when they clear. Accrual recognizes income when you invoice and expenses when you are billed. A company that looks strong on accrual and thin on cash usually has a receivables problem, and that gap is a story worth telling rather than a bug to hide. We cover the mechanics in GAAP vs cash basis accounting. Two more silent distorters: a class, location or customer filter left on from a previous session, which excludes data without warning (running the report deliberately by class is a different exercise, covered in QuickBooks profit and loss by class), and inventory purchases expensed on purchase instead of moving to COGS on sale. Both of them survive the export, so they need catching in QuickBooks, not after.

What the QuickBooks P&L does not do

QuickBooks is genuinely fine at producing the raw report. That is the job it was built for, and it does it. The gap opens the moment that report has to be read by someone who did not build your chart of accounts. What comes out is an account dump: every account you have ever created, in chart of accounts order, at whatever level of granularity your bookkeeper chose. Six separate software subscription lines. Two overlapping contractor accounts. Marketing spend split across four names that no outsider can group. There is no percent-of-revenue column, no grouping into the categories a reader expects (revenue by stream, gross margin, then sales and marketing, then general and administrative), and no comparative context unless you remember to run the comparison variant. A lender or a board member does not want to do that grouping in their head, and the ones who try will get it wrong.

The bigger absence is analysis. QuickBooks will not tell you that gross margin slipped 4 points while revenue grew, that your largest expense line is growing faster than the revenue it supports, or that the trend across the last three months points somewhere uncomfortable. It prints numbers and stops. AIStatements takes the same export and adds the two layers on top: presentation (grouped, typeset, comparative, percent of revenue) and written commentary that cites your actual figures. The figures stay deterministic, computed from the ledger, and the AI writes only the narrative around them. Red flags get pinned to the exact statement line that triggered them: margin slips, expense lines outgrowing revenue, a trend that is bending the wrong way. That is what our AI financial analysis does with a P&L, and it is the layer QuickBooks was never built to provide.

From QuickBooks export to a finished income statement

The workflow is short. Connect QuickBooks directly, or export the Profit and Loss to Excel or CSV and upload the file. AIStatements maps your accounts to income statement categories, builds the statement with ruled subtotals, comparative columns and margin lines, and writes the commentary. Median generation time is 42 seconds, and a full pack lands in about a minute. Export PDF for the bank or the board, XLSX for anyone who wants to trace a figure back to the ledger. Because a P&L alone rarely satisfies a lender, the same upload also produces the QuickBooks balance sheet and a cash flow statement, and the three tie to each other: net income flows into retained earnings, and ending cash agrees across the pack. That consistency is most of what makes a pack read as credible, and it is exactly what breaks when three separate exports get pasted into one deck by hand.

To be plain about what we are and are not. We are not QuickBooks and we are not affiliated with Intuit; QuickBooks is their trademark, and we integrate with it. We do not replace your bookkeeping, and we cannot fix categorization that is wrong at the source: if owner draws are booked as an expense in your ledger, they will be an expense in what we build, which is why the categorization pass above matters. And one honest boundary: AIStatements is software that formats and analyzes your data. It is not accounting, audit, tax or investment advice, it is not a CPA, and it does not guarantee GAAP compliance. Have a licensed professional review anything you file or send to a lender.

Where is the income statement in QuickBooks, and which P&L variant do you actually need

There is no menu item called income statement in QuickBooks, which is why people look for one and conclude it is missing. Intuit names the report Profit and Loss, and it sits under Reports in the Business overview group in QuickBooks Online, or under Reports, Company & Financial in Desktop. The QuickBooks income statement and the QuickBooks profit and loss statement are the same report under two names, so if a lender, a board pack or an accountant has asked you for an income statement from QuickBooks, run Profit and Loss and you have it. What changes between them is only the label at the top, and that label is worth correcting before the file leaves your hands: send a document headed Profit and Loss to a credit analyst who asked for an income statement and somebody will spend a phone call establishing they are the same thing.

The variant matters more than the name. The plain report gives you one column for one period, which is almost never what a reader wants. Display columns by Months turns it into a month by month P&L, which is the version management actually reads, because a single annual column hides the month revenue fell over. Comparing to a prior period adds the previous year beside the current one plus the change in dollars and percent, and that is the version a lender or a buyer expects by default. If class tracking is switched on, the same report can be split by class, location or department, which is how firms report per property, per site or per service line. The step by step for each of those runs is in QuickBooks profit and loss by month, QuickBooks profit and loss by class and the comparative report settings.

Two traps come with the variants specifically. A P&L filtered by class will silently exclude any transaction that was never tagged with one, so the filtered columns can add up to less than the unfiltered total and nothing on the report says so; reconcile the two before presenting either. And a monthly P&L makes the accrual question unavoidable, because on a cash basis the month a bill was paid rather than incurred is the month that carries the expense, which produces month to month swings that look like a business problem and are actually a basis problem. Fix the basis once, state it on the statement, and keep it fixed across every period in the pack.

Common questions