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 − Tax

Copyable 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.

Educational reference only. It is not legal, tax, accounting, lending, insurance or investment advice.