Module 04 · Profit & Profitability

Calculate Your Own Profit This Week: A Step-by-Step Worksheet

A small business profit worksheet with five numbers: revenue, COGS, operating expenses, net profit and net margin. Repeat it each period to track your trend.

7 min readLesson 14 of 14 in this moduleUpdated 2026-08-25

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:

  1. Revenue — total value of everything sold in the period, before any deduction. Your sales total for the week or month.
  2. 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.
  3. 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.
  4. Net profit — revenue minus COGS minus operating expenses minus interest and tax. What's actually left.
  5. 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.

A number that doesn't tie out means something was missed, not that the formula is wrong

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.

Doing this in Reyuko

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.

Frequently asked questions

How do I work out my business profit from start to finish?

Start with total revenue for one fixed period. Subtract cost of goods sold to get gross profit, then subtract operating expenses to get operating profit. Subtract interest and tax to reach net profit, and divide net profit by revenue for your margin. Use the same period and the same steps every time so the results can be compared.

How often should I calculate profit?

Monthly works well for most small businesses, using the same worksheet each time. If margins are tight or cash feels unpredictable, add a lighter weekly check on revenue and cost of goods sold. Catching a slipping number in week two is far cheaper to fix than finding the same problem three months later.

Should I include my own salary as an owner?

Yes, if you work in the business. Enter a realistic wage for your own time under operating expenses. Leaving it out does not make the business more profitable; it hides a real cost. That cost shows up the moment you hire someone to do the same work and have to pay them.

What if I do not track inventory and just buy supplies as I need them?

You can still complete the worksheet. Treat what you spent directly buying the goods you sold in the period as your cost of goods sold, even without an opening and closing stock count. Once volume makes stock tracking worthwhile, switch to the full opening plus purchases minus closing formula for more accurate figures.

Does Reyuko calculate these five profit numbers for me?

Yes. Reyuko's Income Statement report is generated live from your ledger and lays out revenue, gross profit, operating profit, net profit and the margins. Sales invoices post revenue and cost of goods sold together, and operating expenses post through the General Journal, so the report only needs to be opened. It is part of the free plan.

Skip the worksheet next month

Reyuko's Income Statement report produces these same five numbers automatically from your ledger, so this worksheet becomes a one-time exercise instead of a monthly chore.

Download Reyuko freeSee what's included