How this instrument works
A business budget, in its plainest form, is two subtractions run back to back rather than one. First the direct cost of what was sold — materials, inventory, a subcontractor's invoice — comes off revenue to leave gross profit. Then everything it costs simply to keep the business open — rent, payroll, software, insurance — comes off that gross figure to leave net profit, and dividing net profit by revenue turns the result into a margin that reads the same whether the business is small or ten times the size.
The two-step shape exists because the two cost layers behave differently. Cost of goods sold rises and falls with sales volume — sell nothing, and there's little to buy or make. Operating expenses mostly don't; the office rent is due whether the month was busy or slow. Keeping them apart is what lets a sole proprietor, an e-commerce seller, or a small contractor see which layer is actually squeezing the number: a pricing problem shows up between revenue and gross profit, while a cost-structure problem shows up between gross profit and net profit.
Net margin, % leaves several things out on purpose. Income tax, loan interest, depreciation, and money the owner draws out of the business all sit outside this arithmetic and get handled separately on a return or a set of books. The period is also treated as a clean snapshot: a slow month carrying a large one-off inventory purchase will post a worse margin than a typical month, even when the business is healthy across a full quarter.
- Enter Revenue, $ — total sales the business booked for the period being budgeted, before any cost is taken out.
- Enter Cost of goods sold, $ — the direct cost tied to what was sold: materials, inventory, or subcontractor cost for that same period.
- Enter Operating expenses, $ — everything else it costs to run the business: rent, payroll, software, insurance, marketing.
- Read Gross profit and Net profit — the instrument subtracts cost of goods sold first, then operating expenses, so each layer's effect is visible on its own.
- Check Net margin, % — the share of revenue the business keeps once both cost layers are paid, worth comparing period over period rather than reading alone.
Worked example — $50,000 revenue, $20,000 COGS, $15,000 opex
Take the default sheet: $50,000 of revenue, $20,000 of cost of goods sold, and $15,000 of operating expenses. The instrument subtracts cost of goods sold from revenue first — 50,000 minus 20,000 leaves a Gross profit of $30,000 — then subtracts Operating expenses, $ from that figure: 30,000 minus 15,000 gives a Net profit of $15,000. Net profit over revenue, expressed as a percentage, lands Net margin, % at exactly 30 — the figure that reflects what the business keeps once every cost, direct and indirect, has been paid.
Gross profit alone would have shown $30,000 and stopped there, which is where a quick read goes wrong: raise Operating expenses, $ to $35,000 on the same revenue and cost of goods sold, and Net profit flips to a $5,000 loss — a −10% Net margin — even though Gross profit stays at a healthy $30,000. A business watching only the gross figure can miss that rent, payroll, and software bills are the ones actually deciding whether the period ends in the black.
Questions
Why does this calculator separate cost of goods sold from operating expenses?
Because they answer different questions. Cost of goods sold tracks only what was spent to produce or acquire the units that sold — materials, inventory, subcontractor fees — so subtracting it from revenue isolates Gross profit. Operating expenses keep running whether sales are strong or slow — rent, payroll, software, insurance — so subtracting those from gross profit is what finally shows Net profit, what the business actually keeps.
Can Net profit be negative even with strong Gross profit?
Yes, and it is a common trap. Gross profit only accounts for the direct cost of what was sold; if Operating expenses, $ climb high enough, they erase gross profit entirely and push Net profit below zero. On the $50,000-revenue sheet, raising opex from $15,000 to $35,000 turns a $15,000 net profit into a $5,000 loss without Gross profit changing at all.
What should go in Cost of goods sold, $ versus Operating expenses, $?
Cost of goods sold covers costs that scale directly with what was sold — raw materials, inventory bought for resale, a contractor paid per job. Operating expenses cover costs that continue whether or not a sale happens — office rent, salaried payroll, insurance premiums, software subscriptions. Splitting them this way is what lets Gross profit and Net profit answer separate questions about the same business.
Does Net margin, % account for taxes or owner draws?
No. This budget stops at operating net profit — revenue minus cost of goods sold minus operating expenses — before income tax, loan interest, or any amount the owner takes out of the business. Those are handled afterward and are not part of this arithmetic; a business or its accountant tracks them on a separate line.
Does this replace a household budget calculator?
No. A household budget subtracts total expenses from total income in one step, because a paycheck has no cost-of-goods-sold layer. This instrument is built for a business that buys or makes what it sells, so it separates the cost of that inventory or material (Cost of goods sold, $) from the cost of simply operating (Operating expenses, $) before arriving at Net profit.
How often should a small business run this budget?
Monthly is common for a business watching cash closely, while a seasonal operation might run it quarterly against the same period a year earlier. Revenue and both expense lines shift with volume, pricing, and headcount, so a single figure means far more sitting next to the same calculation from a prior period than it does on its own.
References
- U.S. Small Business Administration — manage your business finances
- IRS — Publication 334, Tax Guide for Small Business
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.