The P&L, structured to be read
A P&L template is mostly discipline: the right subtotals in the right order, so the statement answers questions instead of just totalling.
What it must contain
- Revenue by stream
- Cost of goods sold
- GROSS PROFIT subtotal
- Operating expenses, grouped
- OPERATING INCOME subtotal
- Other income/expense, then NET INCOME
Or skip the spreadsheet: SeroBooks produces six P&L views live from the ledger.
The mistakes that cost money
Sales tax counted as income. Tax you collect is money held for a government and belongs on the balance sheet as a liability — including it in revenue inflates the top line and every ratio derived from it.
The second is blending cost of goods with operating expenses. Keeping them separate is what produces gross profit, and gross profit is the number that says whether the core trade works before rent and wages enter the argument.
When a template stops being enough
A profit and loss is not a document you write; it is a summary of a ledger. Building it in a spreadsheet means the figures are only as good as the last time someone updated the inputs, and there is no way to drill from a suspicious total to the transactions behind it.
The specific tell is a gross profit that looks too good. In a spreadsheet you cannot investigate it; in a ledger you check whether cost of goods is posting at all, which is the usual answer.
Templates are training wheels. The software is the bicycle.
Free to start, on Windows, Mac, iPad and Android. No credit card.