Profit and Loss Account Format (Free Template)

The format of a P&L determines whether anyone learns anything from it. The same underlying data, arranged badly, produces a statement people glance at and file.

The standard structure

• Revenue, split by the categories you actually manage
• Cost of sales, mirroring those revenue categories where possible
• Gross profit, with margin percentage shown
• Operating expenses, grouped logically
• Operating profit
• Other income and expenses, including interest
• Net profit

The gross profit line is the one most commonly missing from small business P&Ls, usually because cost of sales was never separated from overhead. Without it the statement cannot tell you whether a pricing problem or an overhead problem is causing poor results.

Add comparison columns

A single column of figures tells you almost nothing. The columns worth having:

• Current month, and the same month last year
• Year to date, and prior year to date
• Percentage of revenue for each line, which normalises for volume
• Variance against budget or forecast, if you maintain one

The percentage-of-revenue column is the most underused and among the most useful. It shows whether a cost is growing faster than the business, which absolute figures obscure.

How much detail

Enough to act on. A statement with four expense lines hides what changed. One with eighty is not read. The practical guide is to split by things you would make a decision about, and group everything else.

Where you need more detail occasionally, keep the summary statement clean and produce a supporting schedule. Do not degrade the main report to accommodate an annual question.

Grouping expenses usefully

Alphabetical order is the default in most software and it is close to useless. Group by function instead: people costs, premises, vehicles and equipment, sales and marketing, professional and administrative. Related costs sit together and a change in one area becomes visible.

Departmental or segment columns

If you run distinct service lines, locations, or crews, a P&L with a column per segment is substantially more useful than a consolidated one. It requires the transactions to carry a segment dimension, which is a setup decision rather than a reporting one.

What to check before circulating it

• Is the period complete? Unrecorded bills and unbilled work both distort it
• Have accruals and prepayments been recorded?
• Does anything sit in a suspense or uncategorised account?
• Do the balance sheet accounts reconcile? If not, the P&L is not reliable either

A practical profit and loss account format

• Revenue
• Less returns, discounts, and allowances
• Net revenue
• Less direct costs or cost of sales
• Gross profit
• Less operating expenses
• Operating profit or loss
• Add or subtract other income and expense
• Profit or loss before tax
• Less applicable income tax
• Net profit or loss

Use monthly columns, a year-to-date total, budget, variance, and prior-year comparison only when each view supports a decision. Keep the chart of accounts behind the report so a reader can trace every subtotal.

Match the format to the business model

A service company may group delivery labor and subcontractors as direct costs when its policy supports that classification. A retailer may show inventory cost of sales. A software company may separate hosting and customer-support costs for management analysis. Define categories consistently and avoid moving costs merely to improve a margin.

Build formulas that can be checked

Gross profit equals net revenue less direct costs. Operating profit equals gross profit less operating expenses. Net profit then reflects other items and tax according to the chosen presentation. Keep inputs separate from formulas, prevent hard-coded totals, and add checks that all accounts are included once.

Reconcile before interpreting

Confirm that revenue, payroll, bank and card activity, payables, accruals, depreciation, and other closing entries are complete. Compare the report total with the general ledger and preserve the reporting date, accounting basis, entity scope, currency, preparer, and reviewer.

Read the result in layers

Analyze price, volume, mix, labor, materials, utilization, overhead, and one-time items. Profit does not equal cash because receivables, payables, inventory, asset purchases, debt, owner activity, and other balance-sheet movements affect liquidity.

Template review checklist

• Reporting period and accounting basis are labeled
• Revenue and contra-revenue are separated
• Direct-cost policy is documented
• Subtotals contain every account once
• Comparisons use the same classification
• Unusual items are explained, not hidden
• The final result ties to the ledger

For management reporting, define every subtotal in a short data dictionary. State which accounts constitute net revenue, direct cost, gross profit, payroll, overhead, operating profit, and other items. When an account is reclassified, update comparative periods or explain the loss of comparability. Protect formula cells, validate signs and periods, and retain a clean blank version separately from completed reports. A template helps organize information, but it cannot determine the correct accounting policy for an unfamiliar transaction.

Use notes for material judgments and exceptions.