Skip to content

Profit and loss templates

3 templates

All templates

Compare profit and loss versions

Profit and Loss StatementRental Property Income TrackerSmall Business Bookkeeping
FormatSpreadsheetSpreadsheetSpreadsheet
Works inGoogle Sheets and ExcelGoogle Sheets and ExcelGoogle Sheets and Excel
Length4 slides5 slides4 slides
StyleCorporateEditorialMinimal

How to choose a profit and loss template

A profit and loss statement shows a business's income, costs and resulting profit or loss over a period. Owners, lenders and accountants use it to judge how the business is performing.

Read more

Cover revenue by source, cost of sales, operating expenses, gross profit, net profit or loss, and comparison with last period.

Compare each month with the same month last year, since seasonal ups and downs can hide a real trend in a single month.

Compare Profit and Loss Statement, Rental Property Income Tracker, and Small Business Bookkeeping, all 4 to 5 pages long, then pick the closest match and replace the sample text with your own.

Questions

What is a profit and loss statement?

A profit and loss statement shows a business's income, costs and resulting profit or loss over a period. Owners, lenders and accountants use it to judge how the business is performing.

What should a profit and loss statement include?

Include revenue by source, cost of sales, operating expenses, gross profit, net profit or loss, and comparison with last period. Compare each month with the same month last year, since seasonal ups and downs can hide a real trend in a single month.

What is the difference between profit and cash flow?

Profit counts income and costs when they are earned or incurred, while cash flow tracks when money actually arrives and leaves. A profitable business can still run short of cash if customers pay late.

How do you calculate gross profit?

Subtract the cost of the goods or services sold from revenue. The result is gross profit, which shows what is left to cover running costs.

How do I track rental property income?

Record each rent payment with its date and unit, and list every repair and running cost against the property. Keep receipts, since they support your tax return.

Which profit and loss template should I start with?

Start with Profit and Loss Statement: Track revenue, costs and profit for a small business, month by month, with a dashboard. If that is not the right fit, compare it with Rental Property Income Tracker.

How long is a profit and loss statement?

The templates here are 4 to 5 pages long. Cut any section you do not need; each template explains what its sections are for.

Which apps can I use for a profit and loss statement?

Yes. These profit and loss templates work in Google Sheets and Microsoft Excel. All 3 templates are free, with no account or email needed.

Preparing your template…