clock, money, growth, grow, time, time management, financial management, concept, idea, finance, business, success, financial, cash, currency, investment, banking, wealth, coins, economy, loan, profit, salary, credit, payment, savings, save, deposit, stack, symbol, income, accounting, clock, clock, clock, clock, money, money, money, money, time, time, time, time, time, time management. Profit and loss statements framework: tags and tie-backs
Photo by nattanan23 on Pixabay

Reviews

Part of Reading a profit and loss statement: gross profit, operating profit, and below operating profit

Profit and loss statements framework: tags and tie-backs

A profit and loss statements framework for the ledger: tag every account, group costs with one test, and tie each line back to the balance sheet.

A profit and loss statement is only as right as the ledger beneath it. The framework here works from the bottom up: tag every account, group the costs with one test, and tie each line back to the balance sheet. Done in that order, the statement checks itself.

Every line has a matching consequence somewhere on the balance sheet. See that link, and the two statements stop being separate documents. They become two views of the same entries. Every figure below is invented to make the arithmetic visible.

What to take away

  • Each ledger account carries one of five tags. That tag alone decides which report a coded transaction appears on.
  • Cost of sales and overhead are separated by one testdoes the cost move when you sell one more unit?
  • Every profit and loss line lands on the balance sheet too. A sale creates a receivable; a cost creates a payable, reduces cash, or reduces stock.
  • A wrong grouping does not change profit. It changes gross margin, the number you were going to decide with.

Tag every account

The mechanics are unglamorous. Each account in the ledger is tagged as one of five types: asset, liability, equity, income, expense. Income and expense accounts are the profit and loss. Assets, liabilities and equity are the balance sheet.

That tag is a chart of accounts decision, made once. It alone decides which report a coded transaction appears on, so a mistake in the tag moves a figure from one statement to the other without anyone typing a wrong amount.

Within the expense accounts, the split between cost of sales and overhead is a grouping applied on top of the tags. The grouping is where most of the judgment sits, and the next section gives it a test.

Group costs with one behavioral test

Ask what happens to the cost if you sell one more of the thing you sell, and one fewer. The test is behavioral, not moral, and it is the same for every business.

Cost of sales or overhead?

If you sell one more, does the cost move?

Yes

cost of sales

No

overhead

A joinery business buys timber. Sell one more kitchen, buy more timber. Timber is cost of sales. The workshop rent does not move whether the business fits ten kitchens this month or fourteen; rent is overhead. The bookkeeper's wages do not move either.

The awkward cases are the useful ones, and by that test a salaried fitter is overhead because the wage is paid whether or not work exists. The same fitter paid per job is a cost of sale. Nothing about the work changed; the commitment did, and the statement should show that.

Where a cost genuinely splits, split it. A van used for deliveries and for the owner's site visits can be allocated on a basis you write down once and apply consistently.

A mixed cost of that kind also raises what part of it is a business cost at all. The IRS publishes a guide to business expense resources that maps each topic to its major resources, and it notes that Publication 535 has been discontinued.

The precision of the split matters less than using the same rule every month. Then a change in gross margin means something changed in the business rather than in the coding.

Let the grouping feed the ladder

Once costs are grouped, the statement is a ladder of subtractions: revenue, cost of sales, gross profit, overheads, operating profit, then the items below the line. Each rung answers one question and only one.

The P&L ladder

  1. Revenuewhat we earned
  2. Less cost of salescost of the work
  3. Gross profitis the thing profitable
  4. Less overheadscost of existing
  5. Operating profitdoes operation make money
  6. Less interest, one-offs, taxleft for owners

Read from the top, each rung narrows the question. Read from the bottom, you only ever learn whether the answer was yes. That is why the grouping in the previous section has to be settled before anyone reads the statement: it decides which costs sit above the gross profit line and which below.

Operating profit is gross profit less overheads, and it answers whether the whole operation makes money. Below it come interest, one-off items and tax, which leave what is left for the owners.

The ordering is not a house style. It is how the statement is taught in a first course in financial accounting, and every published set of accounts uses some version of it.

Tie every line back to the balance sheet

Every entry has two sides, and the profit and loss only ever shows one of them. The other side sits on the balance sheet, and naming it is the quickest test that a line is right.

P&L line and balance sheet side

P&L line

Sale on terms
Revenue 1,000
Supplier invoice
Cost 400
Buying stock
No P&L entry
Prepaid insurance
Monthly overhead share
Loan repayment
Interest only
Profit for period
Profit

Balance sheet side

Sale on terms
Receivables 1,000
Supplier invoice
Payables 400
Buying stock
Cash to stock
Prepaid insurance
Asset released
Loan repayment
Principal cuts liability
Profit for period
Retained earnings

Profit and loss line / What it does on the balance sheet

A sale of 1,000 on terms
1,000 into receivables; no cash moved
A supplier invoice of 400 for work already done
400 into payables
Buying stock
Nothing on the profit and loss; cash moves into stock
An insurance premium paid a year ahead
An asset, released into overheads month by month
Repaying a loan
Interest is a cost; principal reduces a liability
Profit for the period, once closed
Added to retained earnings

The supplier invoice row is the other side described in the accounts payable guide. Stock is the row that surprises people: the cost appears only when the stock is sold, which is why buying it does not touch the profit and loss at all.

If you can name the balance sheet consequence of every line in your own statement, the statement is almost certainly right. Where you cannot, that line is where to look first.

See what a wrong grouping does

A wrong grouping leaves profit alone and moves gross margin. Gross profit divided by revenue is gross margin. Suppose revenue of 200 and cost of sales of 130. Gross profit is 70 and gross margin is 35%.

Same profit, falling margin

  • 35%Period 1 gross margin
  • 29%Period 2 gross margin
  • 70Period 1 gross profit
  • 70Period 2 gross profit

Now suppose the next period brings revenue of 240 and cost of sales of 170. Gross profit is 70 again. The business is busier, earning more, and taking home exactly the same. Margin has fallen from 35% to 29%, and the profit line at the bottom will not tell you that. It shows the same 70.

That is the whole argument for the ladder. A single profit figure hides which rung moved, and a cost parked on the wrong rung moves the margin without moving the profit.

Run two checks before believing the statement

Two checks apply to any statement, whoever produced it.

Before believing the statement

  • Does the period contain the costs of its revenue?
  • Does retained earnings movement equal profit?
  • Is each ledger account tagged one of five types?
  • Is the cost of sales and overhead split consistent?
  • Does the period contain the costs of the work it contains the revenue for? The IRS says the purpose of an accrual method of accounting is to match income and expenses in the correct year.
  • Does the movement in retained earnings on the balance sheet equal the profit shown here?
  • Can every line be tied to a balance sheet consequence from the table above?

The cut-off question is covered in the expense recording guide. If the retained earnings check fails, something was posted to a profit and loss account by a route that bypassed the ledger.

What the tie-back cannot tell you

It cannot tell you whether you have money. Profit is what was earned, not what was collected, and the difference lives in the cash flow statement.

It cannot tell you whether a customer is worth having, because it aggregates. It cannot tell you whether a price is right, only what a price produced last period. And it cannot be compared with another business's statement unless you know how they drew the same line between cost of sales and overhead, which you almost never do.

Common questions

Should the owner's own pay appear on the statement?
Yes, in some form, or the profit figure describes a business that runs on free labor. The legal form of the business decides how it is recorded, so ask your accountant.
Where do one-off items go?
Below operating profit, and named. A large legal cost or an insurance recovery inside overheads makes the period look like a trend when it was an event.
Is a monthly statement worth producing for a very small business?
Yes, if the cut-off is done. A monthly statement built from the bank feed alone is a cash summary with a misleading title, and it will show a bad month whenever a big payment happens to land.
Why does my accountant's version differ from mine?
Usually because of adjustments made at the year end: accruals, prepayments, stock counts, and the treatment of things bought to keep. Ask for the list of adjusting entries rather than the finished statement. That list is the most useful teaching document your books will ever produce.

More in Reviews

Latest from Trade Desk