Small Business Financial Tracker — Free P&L Calculator Online
Track revenue, COGS, expenses, and profit with a free P&L layout. Runs in your browser — no account, no upload.
Summary
Total Revenue
$55,000
Total Expenses
$44,800
Expense Ratio: 81.5%
Gross Profit
$32,000
Margin: 58.2%
● HealthyOperating Profit
$13,500
Margin: 24.5%
● HealthyNet Profit
$10,200
Margin: 18.5%
● HealthyFormula Breakdown
| Metric | Formula | Value | Margin % |
|---|---|---|---|
| Total Revenue | Sum of all revenue lines | $55,000 | — |
| Total COGS | Sum of cost of goods sold | $23,000 | — |
| Gross Profit | Revenue − COGS | $32,000 | 58.2% |
| Operating Expenses | Sum of operating expense lines | $18,500 | — |
| Operating Profit | Gross Profit − Operating Expenses | $13,500 | 24.5% |
| Taxes & Interest | Sum of taxes & interest lines | $3,300 | — |
| Net Profit | Operating Profit − Taxes & Interest | $10,200 | 18.5% |
| Total Expenses | COGS + Operating Expenses + Taxes & Interest | $44,800 | 81.5% |
Revenue Allocation
How your $55,000 revenue is distributed across cost categories.
How to Use This Tracker
- 1Enter your revenue — Add every income stream under Revenue — product sales, service fees, retainers, licensing, anything that brings money in.
- 2Enter your cost of goods sold (COGS) — Add the direct costs of delivering your product or service: raw materials, inventory, direct labor, merchant fees. Do not include rent or salaries here unless those workers only do production.
- 3Enter operating expenses — Add all recurring business overhead that isn't tied to a specific unit of output: rent, admin salaries, marketing spend, software subscriptions, insurance.
- 4Enter taxes & interest — Add estimated income taxes for the period and any interest payments on business loans or credit lines.
- 5Read the summary cards — Each profit card shows the dollar amount, the margin as a % of revenue, and a color-coded health badge based on industry benchmarks.
- 6Export or reset — Download a CSV with all inputs and results for your accountant or records. Use Reset to start a fresh period.
What Each Metric Means
Revenue − COGSWhat's left after paying the direct cost of producing what you sell. A high gross profit funds all of your overhead and growth.
(Gross Profit ÷ Revenue) × 100How many cents of every dollar of revenue survive after covering production costs. A 60% gross margin means $0.60 of each $1.00 earned is available to pay for operations.
Gross Profit − Operating ExpensesWhat's left after paying both production costs and overhead. This is earnings before interest and taxes — a clean measure of core business performance.
(Operating Profit ÷ Revenue) × 100Shows how efficiently the business converts revenue into operating profit. Investors and lenders watch this closely when evaluating a business.
Operating Profit − Taxes & InterestThe true bottom line — what the business actually keeps after all obligations. This is the number that flows into retained earnings or owner distributions.
(Net Profit ÷ Revenue) × 100The most important single number for business health. A net margin below 3% leaves almost no buffer for a slow month, an unexpected repair, or a market downturn.
(Total Expenses ÷ Revenue) × 100The share of revenue consumed by all costs combined. The lower this number, the more revenue converts to profit. An expense ratio above 90% means the business is running on very thin margins.
Health Badge Thresholds
The color badges on each profit card compare your margins against broad industry benchmarks for small businesses. They are a quick signal, not a verdict — a restaurant with a 12% gross margin can be perfectly healthy while a software company with the same margin is in serious trouble.
| Metric | ● Healthy | ● Tight | ● Danger |
|---|---|---|---|
| Gross Margin | ≥ 40% | 20 – 39% | < 20% |
| Operating Margin | ≥ 15% | 5 – 14% | < 5% |
| Net Margin | ≥ 10% | 3 – 9% | < 3% |
Typical Net Margins by Industry
Net margin varies enormously by industry. Use these ranges to calibrate whether your numbers are competitive — or to spot where costs may be out of line.
Ranges are approximate averages for small-to-mid-size businesses. Individual results vary by scale, geography, and business model.
Related: Profit Margin Calculator for quick unit-level margin analysis, or Break-even Calculator to find the minimum sales volume your business needs.
Frequently Asked Questions
Is the Small Business Financial Tracker free?
Yes — completely free. No account, no subscription, and no data is sent to a server.
Does it upload my financial data anywhere?
No. All data is stored in your browser's local storage. Nothing is transmitted to any server. Use the Export CSV button to keep a local backup.
Do I need an account?
No account, no login, and no signup required.
What is the difference between gross profit and net profit?
Gross profit subtracts only the direct cost of producing your goods or services (COGS) from revenue. Net profit goes further and subtracts all remaining costs — operating expenses like rent, salaries, and marketing, plus taxes and loan interest. Gross profit shows production efficiency; net profit shows the true bottom line.
What counts as COGS vs. an operating expense?
COGS are costs directly tied to each unit of output: raw materials, inventory purchased for resale, direct labor (workers who build or deliver the product), and merchant or payment processing fees. Operating expenses are the overhead costs that exist regardless of how many units you sell: office rent, admin salaries, software subscriptions, marketing, and insurance.
Why is my gross margin healthy but my net margin in the red?
This usually means operating expenses or taxes are consuming most of the gross profit. Look at your OpEx rows — high fixed costs like salaries, rent, or software can wipe out a healthy production margin. The fix is either to grow revenue faster than overhead, or to reduce fixed costs.
How often should I update this tracker?
Most small businesses run a P&L monthly or quarterly. Monthly tracking catches problems early — a single bad month is fixable, but three bad months in a row can threaten cash flow. Export a CSV at the end of each period and rename it with the date so you build a historical record.
Does this tracker store my data anywhere?
No. All data lives exclusively in your browser's localStorage. Nothing is sent to a server or third party. Clearing your browser data will erase your entries — use Export CSV to keep a copy.
What is a good net profit margin for a small business?
A net margin of 10% or above is considered healthy for most small businesses. Margins between 3–9% are workable but leave little cushion for downturns. Below 3% means a single slow month or unexpected expense can push the business into loss. Benchmarks vary widely by industry — a grocery store at 2% can be thriving while a consulting firm at 2% has a serious problem.