QuickBooks Profit and Loss by Month: How to Run and Read It

To run a QuickBooks profit and loss by month, open Reports, select Profit and Loss, set the date range to the full period you want (for example January 1 to December 31), then change the Display columns by setting from Total Only to Months. QuickBooks Online splits the P&L into one column per month across the range, with a total column on the right. It is the fastest way to see revenue and expense trends and to spot the month something changed.

The monthly view is one of the most useful reports in QuickBooks and one of the most misread. Below is how to run it, how to add and compare month columns, why the columns sometimes do not sum to the annual figure, and how to turn the report into a pack you can send. It is written for QuickBooks Online; QuickBooks Desktop has the same options under slightly different menus.

How do I run a monthly P&L in QuickBooks?

Open Reports from the left menu and choose Profit and Loss under Business overview, or type its name into the report search box. At the top, set the Report period to the span you want to see broken out, such as a full year or a single quarter. Then find Display columns by (in the customize panel or directly above the report) and switch it from Total Only to Months. Run the report and each month appears as its own column.

Two settings change every figure, so check them before you read anything. The accounting method toggle (Cash versus Accrual) shifts revenue and expenses between months depending on when cash moved versus when it was earned or incurred. And the date range has to cover complete months, or the first and last columns will be partial and look artificially low. Set both deliberately and the monthly trend becomes trustworthy.

How do I add month columns to the P&L?

The month columns come from the Display columns by setting, not from the date range alone. Setting the range to a year shows a single annual total until you also set Display columns by to Months; then the same range breaks into twelve columns. You can column by Days, Weeks, Quarters or Years the same way, but Months is the standard cadence for reviewing a business.

You can also add a percentage view. Turn on % of income in the customize panel to see each line as a share of revenue in every month, which makes margin drift obvious even when dollar amounts bounce around. Save the configured report as a custom report so you do not rebuild the settings each month, and QuickBooks will keep the monthly layout ready to run.

Why do my monthly P&L columns not add up to the year?

Usually the columns do add up, and a mismatch points to one of three things. First, the accounting method: if you glance at a cash-basis monthly report but compare it to an accrual annual figure, the totals will differ because the two methods place transactions in different months. Second, the date range: a range that starts or ends mid-month gives partial columns that will not tie to a full-year total. Third, transactions dated outside the visible columns but inside the total, which happens when the range and the columns do not perfectly align.

There is also the everyday cause: uncategorized or misdated transactions. A bill dated to the wrong month, or income sitting in an Uncategorized account, lands in a column you did not expect and quietly breaks the pattern you are trying to read. When a lot of a month's activity arrives as paper or PDF vendor bills that get keyed in by hand, the dating errors multiply; pulling that data in cleanly by extracting the invoices to a spreadsheet first cuts down the miscoding before it reaches the P&L.

Can I compare months in QuickBooks?

Yes, and there are two ways depending on what you want. The monthly columns described above are the simplest comparison: one period, broken into months you read side by side. For a direct two-period comparison, use the compare options in the customize panel to add a previous period or previous year column, plus dollar-change and percent-change columns, so QuickBooks does the variance math for you.

The percent-change column is the one to watch. A line that jumped 40 percent against the same month last year is either a real event worth explaining or a coding error worth fixing, and either way it is the first thing a reviewer will ask about. Reading months in isolation hides those swings; the comparison columns are what surface them.

Turning a monthly P&L into a pack you can send

A monthly P&L is great for spotting trends on screen, but a lender, investor or board usually wants the full pack: the P&L alongside a balance sheet and cash flow, formatted and explained. QuickBooks runs each report separately and leaves the assembly, the tie-out and the written commentary to you. Our guide to the QuickBooks profit and loss statement covers the single-period report in depth, and running all three QuickBooks financial statements together shows how they connect.

To skip the manual assembly, connect QuickBooks to the financial statement generator. It pulls the ledger and returns all three statements formatted, footed, tied and analyzed in plain English in about a minute, including the month-over-month trends worth flagging, so you review a finished document instead of stitching monthly columns into a report by hand.

One honest note: this is a how-to guide, not accounting or tax advice. For statements you file or hand to a lender, have a licensed professional review them.