Monthly Profit and Loss Statement: How to Run a Monthly Income Statement and QuickBooks P&L by Month

A monthly profit and loss statement reports revenue, cost of goods sold and operating expenses for a single month, ending in net profit or loss for that month. It is the same statement as a monthly income statement, which is the more formal name for it, and it is normally presented beside the prior month and the same month last year so the reader can see direction rather than a single isolated figure. In QuickBooks, you produce it by setting Display columns by to Months on the Profit and Loss report.

The monthly view is one of the most useful reports a business produces and one of the most misread. Below: what belongs on a monthly income statement, how to read the month-over-month columns without chasing noise, how to run and compare month columns in QuickBooks, why the columns sometimes do not sum to the annual figure, and how to turn the report into a pack you can send.

What is a monthly profit and loss statement?

It is an income statement covering one calendar month. The structure is identical to an annual P&L: revenue at the top, cost of goods sold subtracted to give gross profit, operating expenses subtracted to give operating income, then other income and expense and tax to arrive at net income. Only the period changes.

What makes the monthly version different in practice is that a month is short enough for timing to distort it. An annual statement absorbs a quarterly insurance premium or a semi-annual property tax bill without anyone noticing. A single month does not: whichever month the invoice lands in shows a spike, and the eleven months around it look artificially good. This is why a monthly P&L built straight from cash movements misleads, and why accrual basis matters more at monthly granularity than at annual.

Three conventions make a monthly statement readable. Present at least two comparative columns, normally the prior month and the same month in the prior year, since a month in isolation says almost nothing. Show each expense line as a percentage of revenue, because absolute dollar changes are hard to judge when revenue itself is moving. And spread costs that genuinely relate to the whole year across the months they benefit rather than leaving them where the invoice happened to fall, which is the same integral-view logic that applies to interim financial statements generally.

What should be on a monthly income statement?

Enough detail to act on and not so much that nobody reads it. A monthly statement running to 140 account lines is a bookkeeping report, not a management report. Group into subtotals and keep the detail available underneath.

A monthly profit and loss statement, with the comparative columns that make it readable

Line	This month	Prior month	Same month last year	% of revenue
Revenue	$418,000	$392,000	$356,000	100.0%
Cost of goods sold	$171,400	$156,800	$142,400	41.0%
Gross profit	$246,600	$235,200	$213,600	59.0%
Payroll and benefits	$139,000	$137,500	$121,000	33.3%
Occupancy	$22,000	$22,000	$21,000	5.3%
Sales and marketing	$31,400	$24,900	$19,600	7.5%
General and administrative	$28,800	$27,200	$26,400	6.9%
Depreciation	$6,200	$6,200	$5,800	1.5%
Operating income	$19,200	$17,400	$19,800	4.6%

Read that example and the story is in the percentage column, not the dollar column. Revenue grew 17 percent year over year and operating income went slightly backwards, because marketing spend grew 60 percent and payroll grew faster than revenue. A statement showing only this month's dollars would have looked like a good month.

How to read the month-over-month columns

The trap with monthly reporting is treating every movement as a signal. Most month-to-month variation is timing: an extra payroll date in a five-Friday month, a vendor who invoiced late, a customer whose order slipped a week. Chasing those wastes the meeting.

Three filters make the review useful. Start with percentage of revenue rather than dollars, so lines are judged against activity. Set a materiality threshold and only discuss variances above it, for example anything moving more than 10 percent and more than $5,000, which typically reduces forty lines to five. And distinguish timing from trend by looking at three consecutive months rather than two, since a genuine trend persists and a timing artifact reverses in the following month.

Then check the tie-outs before believing any of it. The monthly columns should sum to the year-to-date total, the net income for the month should agree with the movement in equity, and cash on the balance sheet should reconcile. A monthly package that has not been tied out produces confident conversations about numbers that are wrong. The sequence for that is in our month end close checklist, and the assembled version is our monthly financial reporting package. If the reason you are running the report is that somebody outside the business asked for it, what they expect on a YTD profit and loss statement is a narrower question than the monthly view answers.

How do I run a QuickBooks profit and loss by month?

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.

Month is only one of the ways to column this report. If the question is which part of the business earned the money rather than when, the same P&L columned by segment is the better view, and running a QuickBooks profit and loss by class covers the setup, the unclassified column and how classes differ from locations and projects.

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. Catching those strays before they harden into a reported month is what a repeatable close is for; our QuickBooks month end close checklist covers the review steps that keep monthly columns comparable.

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. That percent-change reading is horizontal analysis, and pairing it with each line as a percent of revenue tells you whether a 40 percent jump actually matters; both are worked through in vertical and horizontal analysis.

QuickBooks monthly P&L: settings that change what you see

Setting	Where	What it controls
Display columns by: Months	Above the report	Splits the period into month columns
Accounting method	Customize panel	Cash vs accrual placement of each transaction
Report period	Top of report	Must cover whole months to tie out
% of income	Customize panel	Shows each line as a share of revenue
Compare (prior period/year)	Customize panel	Adds change and percent-change columns

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.

If you are at the point of comparing tools rather than doing it by hand, the field that reads a QuickBooks file, with current prices, is set out in financial reporting software for QuickBooks.

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.