Business, Accounting & Investing
Profit and Loss Statement Cheat Sheet and Template
A practical P&L structure, formulas and a copyable tab-separated template for a defined reporting period.
- Jurisdiction
- General business accounting; tax classification varies by jurisdiction
- Applies to
- Checked 16 November 2026
- Last verified
- 16 November 2026
At a glance
- A P&L measures revenue, expenses and profit or loss over a defined period.
- Gross profit separates direct cost of sales from operating expenses.
- A P&L is not a cash-flow statement: non-cash items and timing differences matter.
Core formulas
Gross profit = Net revenue − Cost of goods sold
Operating profit = Gross profit − Operating expenses
Net profit = Operating profit + Other income − Other expenses − TaxCopyable P&L template
Paste this tab-separated template into Excel or Google Sheets, then replace the blank amounts. Keep one consistent period and accounting basis.
PROFIT AND LOSS STATEMENT AMOUNT
Business name
Period
Accounting basis (cash/accrual)
REVENUE
Sales / service revenue
Less returns and allowances
Other operating revenue
NET REVENUE
COST OF GOODS SOLD
Beginning inventory
Purchases and direct materials
Direct labour
Other direct costs
Less ending inventory
TOTAL COGS
GROSS PROFIT
OPERATING EXPENSES
Payroll and contractor costs
Rent and utilities
Marketing
Insurance
Software and office
Professional fees
Depreciation
Other operating expenses
TOTAL OPERATING EXPENSES
OPERATING PROFIT
Interest and other income
Interest and other expenses
Income tax
NET PROFIT / (LOSS) Monthly review checks
- Reconcile revenue to the sales system and bank/receivable records.
- Use a consistent COGS method and period cut-off.
- Investigate material changes against budget and the previous period.
- Keep owner draws and balance-sheet movements out of operating expenses unless accounting rules require otherwise.
Practical answers
Frequently asked questions
Use these answers with the dated scope and authoritative sources shown on this page.
What is Profit and Loss Statement?
A practical P&L structure, formulas and a copyable tab-separated template for a defined reporting period.
What are the most important points about Profit and Loss Statement?
A P&L measures revenue, expenses and profit or loss over a defined period. Gross profit separates direct cost of sales from operating expenses. A P&L is not a cash-flow statement: non-cash items and timing differences matter.
How should I use this profit and loss statement cheat sheet and template?
Read the sections on Core formulas, Copyable P&L template, Monthly review checks, then use the Copy P&L formulas and Copy P&L template block where it fits your situation. Keep the inputs and assumptions with the copied result so somebody else can review it.
Which jurisdiction and effective date does this page cover?
It covers General business accounting; tax classification varies by jurisdiction and is labelled for Checked 16 November 2026. Rules from another jurisdiction, tax year, product version or contract may produce a different answer.
What should I verify before acting on it?
Confirm exceptions and later changes in the linked material from U.S. Small Business Administration. The page was last verified 16 November 2026; provider terms, forms, thresholds, software features and local rules can change after that date.
Authoritative sources
Use the linked source for current instructions and exceptions before acting.
- Glossary of business financial termsU.S. Small Business Administration
Educational reference only. It is not legal, tax, accounting, lending, insurance or investment advice.
