A profit and loss statement, or P&L, summarizes revenue, costs
and expenses over a defined period and calculates the resulting profit
or loss. The downloadable spreadsheet includes monthly columns, annual
totals and formulas for gross profit, operating profit and profit before
tax.
It is a management template, not a substitute for the accounting
records or statutory format required in a specific jurisdiction.
What is included in the
P&L template?
The worksheet contains sections for revenue, cost of goods sold,
operating expenses and other income or expense. Formula rows
calculate:
- total revenue;
- total cost of goods sold;
- gross profit;
- total operating expenses;
- operating profit;
- profit before tax.
Input cells are visually distinct from formula cells. Enter amounts
consistently as positive values in the appropriate section; the formulas
subtract cost and expense groups. Do not overwrite total rows.
How do you
make a simple profit and loss statement?
Choose a period and an accounting basis first. Cash-basis reporting
generally recognizes money when received or paid, while accrual
reporting recognizes revenue when earned and expenses when incurred.
Mixing the two can make one month look artificially strong and another
weak.
Enter operating revenue without sales tax collected on behalf of an
authority. Record refunds, discounts and returns consistently, either as
reductions of revenue or in clearly labeled contra-revenue rows.
Then enter direct costs. For a product business, cost of goods sold
may include inventory consumed, direct production labor and certain
freight or manufacturing costs. For a service business, direct delivery
costs may be presented separately when that produces useful gross-margin
information.
Finally, add operating expenses such as payroll, rent, software,
marketing, insurance, professional fees and depreciation. Keep owner
distributions and loan principal out of operating expenses; their
accounting treatment differs from ordinary business costs.
What is the P&L formula?
The central formulas are:
Gross profit = revenue − cost of goods sold
Operating profit = gross profit − operating
expenses
Profit before tax = operating profit + other income − other
expenses
Suppose revenue is $100,000, cost of goods sold is $42,000 and
operating expenses are $45,000. Gross profit is $58,000 and operating
profit is $13,000. If interest expense is $2,000 and there is no other
income, profit before tax is $11,000.
Can you prepare your own
P&L?
A small owner can use a template for internal tracking when
transactions are complete and classifications are understood. Reconcile
revenue with sales systems and bank deposits, and reconcile expenses
with bills, payroll and card statements. Investigate differences rather
than inserting a balancing amount.
Professional review may be needed for tax filings, lending,
investors, inventory accounting, depreciation, foreign currency, revenue
recognition or statutory accounts. A clean-looking spreadsheet is not
evidence that classifications comply with applicable standards.
Monthly versus
year-to-date reporting
Monthly columns reveal seasonality, price changes and cost drift. The
annual total shows cumulative performance. Compare both actual results
and the relevant budget or prior period.
Do not judge performance from net profit alone. Track gross margin,
operating margin and material cost categories. A growing revenue line
can coexist with falling profit if discounts, direct costs or overhead
rise faster.
Common P&L mistakes
Avoid counting loan proceeds as revenue, loan principal as an
expense, sales tax as earned revenue or owner withdrawals as payroll
without the correct legal treatment. Do not omit unpaid customer
invoices under accrual accounting or record the same cost from both a
bill and a card transaction.
Close each period with a repeatable checklist: reconcile accounts,
review unusual balances, confirm cut-off, document adjustments and lock
the approved version. Update the template’s account rows to match the
business, but preserve clear subtotals so a reader can trace how profit
was calculated.
