Profit & Loss Statement (Monthly)
Track revenue, expenses, and net profit with auto-calculating formulas. Full 12-month view.
Published by Blueprint Dynamics. Planning tools, not professional advice. Read the formula, assumptions, and examples below before relying on a result. Independent professional review is not claimed. Learn more about our methodology →
AllTemplates • Blueprint Dynamics • hello@bpdynamics.io. Educational worksheet; entries and assumptions are not independently verified. This document is not tax, legal, medical, investment or engineering approval. Review current official rules and seek a qualified specialist where appropriate.
Specialist review required for real decisions
Simplified management models, not GAAP statements, audited accounts, investment advice or a financing forecast. An accountant must check classifications, periods and reconciliation for formal use.
Primary reading context, not an endorsement or evidence that the linked organization reviewed this tool. No independent professional sign-off is claimed.
About the Profit & Loss Statement (Monthly)
A monthly profit and loss statement is the single report most small-business owners look at first, because it answers one blunt question: after everything came in and everything went out, did the month make money? This worksheet lays out all twelve months side by side so seasonal swings, one-off costs, and slow-building expense creep are impossible to hide. Instead of waiting for a year-end accountant summary, you see the shape of the business as it happens.
The statement follows the standard accounting order: revenue at the top, cost of goods sold (COGS) directly beneath it, then operating expenses, with gross profit and net income calculated in between. Keeping COGS separate from overhead matters because they behave differently — COGS rises and falls with sales volume, while rent and salaries stay flat whether you sell ten units or ten thousand. Reading the two layers separately tells you whether a bad month came from pricing or from bloated overhead.
Because every category runs across a full year, this format doubles as a budgeting and pattern-spotting tool. You can spot the month marketing spend jumped without a matching revenue lift, or the quarter where materials costs quietly ate your margin.
Before you enter your numbers
- Choose one accounting period and a consistent cash or accrual basis. Separate refunds from expenses and avoid counting sales tax collected as revenue.
- Classify direct production costs as COGS and overhead as operating expense without putting the same cost in both sections.
Assumptions and limits
- This planning statement is not a filed return or a GAAP certification. It does not automatically record assets, loan principal, accruals, or depreciation schedules.
Check your result
$20,000 revenue − $8,000 COGS = $12,000 gross profit, or 60% of revenue. Subtract $5,000 operating costs to obtain $7,000 operating profit before other modeled adjustments. Cash in the bank can still differ.
How the Profit & Loss Statement (Monthly) works
The worksheet groups line items into three sections — Revenue, Cost of Goods Sold, and Operating Expenses — each with rows you can rename (the defaults are Product Sales and Services for revenue, Materials and Direct Labor for COGS, and Rent and Marketing for expenses). Every row holds twelve monthly cells plus a row total, and each section shows a monthly column total at the bottom.
The math is deliberately transparent. For each month, Gross Profit = total Revenue minus total COGS, and Net Income = Gross Profit minus total Operating Expenses. There is no tax, depreciation, or interest layer here, so Net Income on this sheet is closer to operating profit than to the after-tax bottom line on a filed return. That keeps the operating picture clean and comparable month to month.
Gross margin is the ratio worth watching even though it is not printed as a separate row: divide gross profit by revenue. On the default numbers a healthy, stable margin signals your pricing and production costs are in balance; a shrinking margin over the year is an early warning long before net income turns negative.
Worked example
Take the default entries. Revenue is Product Sales at $1,000 per month plus Services at $500, so total monthly revenue is $1,500, or $18,000 across the year. COGS is Materials at $300 plus Direct Labor at $200, totaling $500 a month ($6,000 annually). That leaves Gross Profit of $1,000 per month — a 66.7% gross margin.
Operating expenses are Rent at $500 and Marketing at $100, or $600 a month. Subtracting that from the $1,000 gross profit gives Net Income of $400 per month, which compounds to $4,800 for the year on $18,000 of revenue — a 26.7% net margin. If you then bump Marketing to $400 in a single month to test a promotion, that month's net income drops to $100 and you can see immediately whether the extra revenue it drove was worth the spend.
Tips & common mistakes
- Put anything that scales with each sale — raw materials, packaging, payment processing fees, freight-in — under COGS, and keep fixed overhead like rent, insurance, and salaries in Operating Expenses. Misclassifying one for the other distorts your gross margin.
- Record revenue in the month you earned it and expenses in the month you incurred them, not the month cash actually moved. This accrual view stops a single large supplier payment from making one month look catastrophic.
- Add a row for owner's pay or contractor labor if you currently work for free — a P&L that ignores your own labor overstates how profitable the business really is.
- Compare gross margin month over month rather than just watching net income. A falling margin points to a pricing or cost problem you can fix before it reaches the bottom line.
- Reconcile the totals against your bank statements each quarter so a forgotten expense category does not silently inflate your reported profit.
Profit & Loss Statement (Monthly): frequently asked questions
What is the difference between gross profit and net income on this statement?
Gross profit is revenue minus cost of goods sold — the money left after covering what it costs to produce or deliver what you sold. Net income is gross profit minus your operating expenses like rent and marketing. Gross profit measures product-level efficiency; net income measures whether the whole business is profitable after overhead.
Does this include taxes, interest, and depreciation?
No. This worksheet stops at operating profit, so the Net Income figure is before income tax, loan interest, and depreciation. For a formal filed statement you would subtract those below net income. Keeping them off keeps month-to-month operating comparisons clean.
Should I use cash or accrual accounting to fill it in?
Accrual gives a truer monthly picture because it matches revenue to the month it was earned and expenses to the month they were incurred. If you run purely on cash basis, just be consistent so the trend line stays meaningful.
Where do I put payment processing or merchant fees?
Because those fees rise directly with each sale, they belong in cost of goods sold, not operating expenses. Grouping them with COGS gives you an accurate gross margin per dollar of revenue.
How do I handle a month with no sales in a category?
Enter zero rather than leaving the cell blank. A zero keeps the column totals accurate and makes the seasonal gap visible when you scan across the twelve months.
Use the result in your next decision
- Cash Flow Forecast: Explain differences between recognized profit and actual cash.
- Balance Sheet: Check assets and liabilities that do not belong on the P&L.
Sources and further reading
These references explain the specified topic; they are not endorsements or evidence that a professional has reviewed this tool.
- SEC: Financial statements — Defines income statements and their relationship to other financial statements.