Profit and Loss Calculator

How the figure is built

A profit and loss statement runs downward through defined subtotals. Revenue, less returns and discounts, gives net revenue. Less cost of goods sold gives gross profit. Less operating expenses gives operating profit. Less interest and tax gives net profit.

The subtotals are the point. Each one isolates a different question: the product, the operation, the financing, the tax position, and a business that only looks at the bottom line cannot tell which of the four moved.

How that looks in practice

Revenue $960,000. Returns and discounts $115,200, giving net revenue $844,800. Cost of goods $337,920, so gross profit $506,880 at 60%. Operating expenses: advertising $168,960, fulfilment $118,272, salaries $144,000, overheads $57,600, total $488,832. Operating profit $18,048, at 2.1%.

Interest $9,600 and tax $1,690 leave net profit of $6,758, a 0.8% net margin.

The structure shows immediately where the business is. A 60% gross margin is healthy; the problem is that operating expenses consume 57.9% of net revenue. No amount of sourcing improvement fixes that, and the diagnosis is only visible because the subtotals exist.

Where the figure deceives

A profit and loss statement is not a cash flow statement. Stock bought and not yet sold sits on the balance sheet rather than in cost of goods, so a business can show profit while its bank balance falls, and it commonly does during growth.

Timing also distorts. An annual insurance premium paid in one month belongs across twelve, and a business that expenses it as paid will show one terrible month and eleven flattering ones.

Acting on it

Read it as percentages of net revenue rather than as absolute numbers, and compare the percentages against the previous period. Absolute figures move with volume and tell you little; percentages isolate what actually changed.

Then work down the statement to find the first line that moved materially. That line is the diagnosis, and everything below it is consequence rather than cause.

Producing one monthly without an accountant

The barrier is usually not the accounting but the categorisation. A profit and loss statement that lumps everything into a few buckets cannot diagnose anything, and one with forty categories takes too long to produce monthly.

Ten to fifteen lines is the practical range for a small ecommerce business: revenue, returns, cost of goods, advertising, fulfilment, shipping, platform fees, payment fees, salaries, contractors, software, rent, insurance, other. Anything smaller hides the diagnosis; anything larger stops getting done.

The other requirement is consistency. A category that means one thing in January and another in June makes the comparison worthless, and comparison is the entire value of producing the statement regularly. Writing down what belongs in each category once, and keeping to it, matters more than choosing the categories perfectly.

The other habit worth building is a short written note against any line that moved more than a couple of points. Six months later, a statement showing advertising jumping from 17% to 22% is a mystery; the same statement with "launched two new products, front-loaded spend" beside it is a record. Management accounts are only useful if you can still interpret them after you have forgotten the month.

For a business heading towards a sale, that discipline pays twice. A buyer's first request is three years of monthly figures, and a set that reconciles cleanly with explanations for the anomalies is worth a meaningful part of a multiple against one that needs reconstructing under scrutiny.