Every worked example in this module used someone else's numbers. This one uses yours. Five figures — revenue, cost of goods sold, operating expenses, net profit, and net margin — answer how to calculate my business profit, and they're the same five figures every single period, which is exactly what makes them worth tracking consistently instead of estimating from memory.
Key takeaways
- Five numbers are all you need: revenue, COGS, operating expenses, net profit, and net margin.
- Pick one normal, representative period — not your best month, not your worst, not a holiday season.
- Gather source numbers first (a sales total, purchase and stock records, a list of monthly bills), then do the arithmetic — mixing the two steps is where errors creep in.
- The formulas never change between periods, which is what makes the result genuinely comparable month to month.
- A single pass through this worksheet takes most small business owners under an hour once the source numbers are in hand.
The five numbers, defined once
Before filling anything in, know what each line means and where it comes from:
- Revenue — total value of everything sold in the period, before any deduction. Your sales total for the week or month.
- Cost of goods sold (COGS) — opening inventory plus purchases minus closing inventory: what it cost to produce or acquire whatever was actually sold. See how to calculate COGS if you're unsure where to start.
- Operating expenses — everything else it costs to run the business day to day: rent, wages (including your own, if you work in the business), utilities, marketing, subscriptions.
- Net profit — revenue minus COGS minus operating expenses minus interest and tax. What's actually left.
- Net margin — net profit ÷ revenue × 100. What percentage of every sales dollar you actually kept.
To calculate my business profit: add up total revenue for the period, subtract cost of goods sold for gross profit, subtract operating expenses for net profit, then divide net profit by revenue for net margin. Repeat with the same five numbers each week or month to track whether profit is genuinely improving.
Step 1: Choose your period
Pick one calendar month, or one representative week if your business is new or highly seasonal. Choose a period that reflects normal trading — not your single best week, not a slow week affected by weather or a holiday closure, and not the very first partial month of a new business. Write the exact start and end date down before you start pulling numbers; a vague period produces a number nobody can double-check later.
Step 2: Gather your revenue
Add up every sale made in the period, whether the customer paid cash on the spot or is still owed on an invoice — revenue counts the moment it's earned, not the moment cash lands. Pull this from your sales records, register tape totals, invoice list, or bank deposits plus any unpaid invoices from the period.
Your revenue for the period: $____
Step 3: Calculate your cost of goods sold
You need three figures: the value of stock on hand at the start of the period (opening inventory), everything you bought into stock during the period (purchases, plus any freight to get it to you), and the value of stock still unsold at the end (closing inventory).
COGS = Opening Inventory + Purchases − Closing Inventory
| Component | Your figure |
|---|---|
| Opening inventory | $____ |
| + Purchases (incl. freight-in) | $____ |
| − Closing inventory | $____ |
| = COGS | $____ |
If you run a service business with no physical stock, use your direct cost of service instead — labor, subcontractors, and materials tied directly to delivering the service — in place of COGS.
Step 4: Total your operating expenses
List every cost of running the business that isn't COGS: rent, wages (including a real figure for your own labor if you work in the business full-time — leaving this out is one of the most common mistakes that inflate reported profit), utilities, marketing, insurance, software subscriptions, and any other recurring bill.
| Expense category | Your figure |
|---|---|
| Rent / premises | $____ |
| Wages (including your own, if applicable) | $____ |
| Utilities | $____ |
| Marketing | $____ |
| Other operating costs | $____ |
| Total operating expenses | $____ |
Step 5: Calculate gross profit, operating profit, and net profit
Now the arithmetic — three subtractions, each one narrower than the last:
Gross profit = Revenue − COGS Operating profit = Gross profit − Operating expenses Net profit = Operating profit − Interest − Tax
Your profit, three layers
| Line | Formula | Your figure |
|---|---|---|
| Revenue | (from Step 2) | $____ |
| − COGS | (from Step 3) | $____ |
| = Gross profit | $____ | |
| − Operating expenses | (from Step 4) | $____ |
| = Operating profit | $____ | |
| − Interest expense | (interest portion of loan payments only) | $____ |
| − Tax | $____ | |
| = Net profit | $____ |
If you have no loan or don't yet know your tax liability for the period, operating profit is still a genuinely useful stopping point — just be clear with yourself that it isn't the final number. If you'd rather see this same structure filled in with someone else's numbers first, the full worked income statement example walks through exactly these steps line by line.
Step 6: Calculate your margins
Gross margin = Gross profit ÷ Revenue × 100 Net margin = Net profit ÷ Revenue × 100
Margin
| Margin | Formula | Your result |
|---|---|---|
| Gross margin | Gross profit ÷ Revenue × 100 | ______% |
| Net margin | Net profit ÷ Revenue × 100 | ______% |
Once you have both percentages, compare them against typical ranges for your type of business — a retailer, a service business, and a restaurant have very different normal margins, so measuring yourself against the wrong benchmark tells you nothing useful. See gross margin vs net margin for typical ranges by business type, and the full formula reference if any of the formulas above need a refresher.
Worked example, filled in
Here's the worksheet completed for a small trading business, so you can see the shape of a finished result before doing your own:
| Line | Amount |
|---|---|
| Revenue | $28,000 |
| COGS ($6,000 opening + $15,000 purchases − $5,000 closing) | $16,000 |
| Gross profit | $12,000 |
| Operating expenses (rent $2,000, wages $5,500, other $1,500) | $9,000 |
| Operating profit | $3,000 |
| Interest expense | $300 |
| Net profit | $2,700 |
| Gross margin | 42.9% |
| Net margin | 9.6% |
Every figure ties to the one above it: $28,000 − $16,000 = $12,000; $12,000 − $9,000 = $3,000; $3,000 − $300 = $2,700; $2,700 ÷ $28,000 = 9.6%. That's the entire test of whether your own worksheet is correct — each subtraction should account for the full gap to the line before it, with nothing missing.
If your own net margin looks suspiciously high, check first whether your own labor, loan interest, or a recent inventory count are actually reflected in the numbers above. An inflated result is far more often a missing cost than an error in the math itself.
Repeat it, don't just do it once
A single pass through this worksheet tells you one period's story. Doing it the same way every month is what turns it into a trend you can act on — a slipping gross margin over three consecutive months points at pricing or supplier cost; a slipping net margin with gross margin steady points at growing overhead instead. Track the same five numbers on a simple running log:
| Month | Revenue | COGS | Gross profit | Op. expenses | Net profit | Net margin |
|---|---|---|---|---|---|---|
| Jan | ||||||
| Feb | ||||||
| Mar |
How often should I actually do this?
Most small businesses get real value from running this worksheet monthly, with a lighter weekly check on just revenue and COGS if margins are tight or cash feels unpredictable. Catching a slipping number in week two of a bad month is far cheaper to fix than discovering it three months later, once several periods have compounded the same underlying problem.
Reyuko's Income Statement report produces these exact five numbers — revenue, gross profit (via COGS), operating profit, net profit, and the margins that follow from them — generated live from the ledger rather than filled in by hand each month. Because every Invoice posts revenue and cost of goods sold together, and operating expenses post through the General Journal into their own accounts under the Chart of Accounts, this worksheet's Steps 2 through 5 are already done the moment transactions are recorded — the report just needs to be opened, not rebuilt.
This report is part of Reyuko's free plan, so running it monthly costs nothing beyond keeping transactions recorded as they happen.
Reyuko