Monthly Profit Report Template for Small Business

Download the Free Monthly Profit Report Template

Start here. The blank template gives you the structure; the completed example shows exactly how a finished report looks. Both open in any spreadsheet program.

What a Monthly Profit Report Is

A monthly profit report — sometimes called a monthly profit and loss (P&L) statement or a monthly income and expense report — is a one-page summary of a single month of business activity. It answers one question: did the business make money last month, and how much?

It works by lining up two things: the money that came in (revenue) and the money that went out (expenses). Subtract expenses from revenue and you get net profit — your bottom line. That is the whole idea. Everything else on the report exists to help you understand why the number is what it is.

You do not need to be an accountant to build one. If you can write down what you charged and what you paid for, you can complete this template.

Why It Matters

A yearly review comes too late to fix a bad quarter. Checking your bank balance daily is too noisy to reveal a trend. A monthly report is the practical middle ground: frequent enough to catch problems early, spaced enough to show a real pattern.

• It shows real profit, not just cash. A full bank account can hide the fact that expenses are creeping up.
• It reveals trends. Three months of shrinking margin is a warning you can act on before it becomes a crisis.
• It makes tax time easier. Twelve clean monthly reports hand your accountant an organized year.
• It keeps you disciplined. Knowing you will review the numbers changes how you spend during the month.

What Numbers You Need

Before you fill in the template, gather these for the month you are reporting on. Most of it lives in your bank statement, your invoicing tool, and your receipts.

• Every payment you received from customers (your revenue).
• Direct costs tied to delivering the work — materials, supplies, per-job labor (your cost of goods sold).
• Running costs of the business — rent, insurance, software, fuel, marketing, fees (your operating expenses).
• Last month’s totals, so you can fill in the month-over-month comparison.

A quick note on terms so the rest of the guide is clear: revenue is money in, expenses is money out, gross profit is revenue minus direct costs, net profit is what remains after all expenses, and cash flow is the separate question of how much money is actually in your account. This report measures profit.

Every Line Explained

Here is what each row in the template means and how to fill it, assuming no accounting knowledge.

How to Complete It, Step by Step

1. Set the month. Fill in the business name and reporting month at the top.
2. Enter your income. Go through your deposits and invoices and total up what customers paid you, grouped by revenue type.
3. Enter direct costs (COGS). List materials, supplies, and per-job labor. Skip this if it does not apply to your business.
4. Calculate gross profit. Total revenue minus total COGS.
5. Enter operating expenses. Work through your bank and card statements and drop each cost into a category row.
6. Add up total expenses. COGS plus operating expenses.
7. Calculate net profit and margin. Revenue minus total expenses, then divide net profit by revenue for the margin.
8. Fill in the comparison and notes. Copy last month’s totals into the comparison block and jot down anything that explains the numbers.

Worked Example: A Small Cleaning Business

Meet Bright & Tidy Cleaning, a one-owner cleaning service with one part-time contract helper. Here is their completed report for April 2026. The completed-example download above contains these exact numbers.

Income

Cost of goods sold and gross profit

Operating expenses

The bottom line

Month-over-month

How to Interpret the Result

Bright & Tidy kept $6,500 of the $10,500 they billed — a 61.9% net margin. Both revenue and profit rose versus March, and the margin improved by about 3 points, which means the extra revenue did not come with proportionally higher costs. That is a healthy month.

When you read your own report, work top to bottom: is net profit positive, and up or down from last month? If it dropped, was it because revenue fell, expenses rose, or both? Then scan the expense rows for any category that jumped — a spike in marketing might be a planned campaign or it might be overspending. Finally, look at the trend across two or three months, because direction matters more than any single month.

Close by writing one or two action items in the notes, such as “renegotiate supply costs” or “follow up on two unpaid invoices.” That turns the report from a record into a decision.

Quick Profit Calculator

Not ready to fill in the whole template? Drop in three numbers to see your gross profit, net profit, and margin right away.

Common Mistakes to Avoid

• Mixing personal and business spending. If your personal coffee and your business software share one card, your expenses are wrong. Keep them separate, or at least tag them clearly.
• Confusing revenue with profit. A big sales month is not automatically a profitable one. Always run the numbers down to net profit.
• Confusing profit with cash. Money owed to you is revenue, but it is not cash until it lands. Do not assume a profitable month means a full bank account.
• Forgetting small recurring costs. A handful of $9–$30 subscriptions quietly add up. Include every one.
• Skipping months. The value is in the comparison. One missing month breaks the trend.
• Rounding away the detail. Enter real amounts. “About $500” across ten rows can hide a real problem.

Template vs. Automated Software

The spreadsheet template is free and flexible. Software costs money but removes the manual work. Here is how to choose.

Monthly Review Checklist

Run through this once a month, right after you complete the report. It takes about 15 minutes.

When to Let Software Do It

The template is a great start. But once you are re-typing the same transactions every month, or you have skipped a month because you were busy, that is the signal to automate. YourProfitBook builds the same monthly report from the income and expenses you log, calculates gross profit, net profit, and margin for you, tracks month-over-month automatically, and exports to PDF, Excel, or CSV.

Want to go deeper on the concepts first? Read how to calculate business profit or the full profit and loss tracking guide.

For definitions and record-keeping rules from primary sources, the U.S. Small Business Administration’s guide to managing your finances and the IRS page on business recordkeeping are reliable references.