Free profit and loss statement template

A profit and loss (P&L) statement is a summary of your business income and expenses during a given time period. This P&L template makes it easy to create a profit and loss statement for small businesses. Simply plug your numbers into the template and you're ready to go.

Profit and loss template with blank fields for users to fill out.

Monitor your business income and expenses

Record revenue, COGS and indirect expenses to calculate your net profit or loss before taxes.

Receive an easy-to-use format

Just put in your numbers and the calculations are done for you in the simple profit and loss template.

Save and keep to use again

Compare with previous statements to see how your business is tracking.

Download the free profit and loss template

Fill in the form to get a profit and loss template as an editable PDF. We’ll throw in a guide to help you use it.

Understanding your business’s profit and loss statement

A profit and loss statement is a financial report that shows a business's profits or losses over a set period of time. It summarises the business's income and expenses, and typically, it shows profits both before and after taxes. Monthly, quarterly or yearly are the most common periods to do a P&L statement.

Learn more about Xero financial reporting

A profit and loss statement is a financial report that shows a business's profits or losses over a set period of time. It summarises the business's income and expenses, and typically, it shows profits both before and after taxes. Monthly, quarterly or yearly are the most common periods to do a P&L statement.

Learn more about Xero financial reporting

A P&L statement often doesn’t report income tax. Instead, it reports profit or loss before tax. This profit or loss – which is on the final row of this free P&L template – is used to help calculate taxes. A business will generally be taxed on its profits. If you find a P&L statement showing income taxes, that amount will then be subtracted to give a final figure that is net profit after tax.

Learn more about income tax

A P&L statement often doesn’t report income tax. Instead, it reports profit or loss before tax. This profit or loss – which is on the final row of this free P&L template – is used to help calculate taxes. A business will generally be taxed on its profits. If you find a P&L statement showing income taxes, that amount will then be subtracted to give a final figure that is net profit after tax.

Learn more about income tax

The most important part of a profit and loss statement is the bottom line. It shows how much your business earned or lost during the time period used. If you have a profit, your business strategy is working. If you have a loss, you may need to take a closer look to see where the problem lies. Pay attention to your revenue, cost of goods sold, operating expenses, and taxes as they have a direct impact on the bottom line and should be considered when making investments or budget planning.

Learn how to calculate net income (with examples).

The most important part of a profit and loss statement is the bottom line. It shows how much your business earned or lost during the time period used. If you have a profit, your business strategy is working. If you have a loss, you may need to take a closer look to see where the problem lies. Pay attention to your revenue, cost of goods sold, operating expenses, and taxes as they have a direct impact on the bottom line and should be considered when making investments or budget planning.

Learn how to calculate net income (with examples).

Yes, you can make a profit and loss statement with Excel or Google Sheets, but our simple profit and loss template is easier to complete and can be used over and over again. An even easier option is to use accounting software to generate your profit and loss reports. With cloud-based software, you can access accurate, up-to-date numbers and financial reports from anywhere.

Learn how to move from Excel to accounting software.

Yes, you can make a profit and loss statement with Excel or Google Sheets, but our simple profit and loss template is easier to complete and can be used over and over again. An even easier option is to use accounting software to generate your profit and loss reports. With cloud-based software, you can access accurate, up-to-date numbers and financial reports from anywhere.

Learn how to move from Excel to accounting software.

Why use our profit and loss statement template?

  • Included
    Accurate financial tracking with fields for common business income and expense categories.
  • Included
    Time-saving, reusable template that lets you plug in numbers quickly.
  • Included
    Features the most important details about your business's profitability.
  • Included
    Lets you identify where expenses can be reduced.

Our free profit and loss template is reusable and simple to use. You can create a statement for internal decision-making or to show lender

Check out Xero reporting
A woman using a laptop at her desk.

How to prepare your profit and loss sheet

Go to the download section on this page, fill in your details and we’ll send you an email with the template as a downloadable PDF. We’ll also send a guide on how to use it with a sample P&L statement. You’ll need to have a PDF reader installed to use the template.

Check out the template now.

Go to the download section on this page, fill in your details and we’ll send you an email with the template as a downloadable PDF. We’ll also send a guide on how to use it with a sample P&L statement. You’ll need to have a PDF reader installed to use the template.

Check out the template now.

Record your income and expenses in line with your chosen accounting method. With the accrual method, you record revenue or expenses when you earn the money or incur the expense, but with the cash basis method, you don't record anything until the cash actually exchanges hands. You must be consistent about using one or the other if you want to create accurate reports.

To learn more, check out cash vs accrual accounting explained.

Record your income and expenses in line with your chosen accounting method. With the accrual method, you record revenue or expenses when you earn the money or incur the expense, but with the cash basis method, you don't record anything until the cash actually exchanges hands. You must be consistent about using one or the other if you want to create accurate reports.

To learn more, check out cash vs accrual accounting explained.

Profit and loss statements cover specific periods of time such as weeks, months, quarters, or years. Consider looking at a variety of time periods to see how your business does during different intervals – for example, an annual report will show how your business did over a year, while quarterly and monthly reports help to track seasonal trends. When comparing different time periods, make sure to use consistent date ranges.

Profit and loss statements cover specific periods of time such as weeks, months, quarters, or years. Consider looking at a variety of time periods to see how your business does during different intervals – for example, an annual report will show how your business did over a year, while quarterly and monthly reports help to track seasonal trends. When comparing different time periods, make sure to use consistent date ranges.

List all of your business's revenue from different sources in the designated fields, and the template will automatically calculate a total. Next, list your cost of sales and all of your fixed and variable expenses in their designated fields. Once you've entered everything, the template will subtract expenses from revenue to calculate your net profit before tax.

List all of your business's revenue from different sources in the designated fields, and the template will automatically calculate a total. Next, list your cost of sales and all of your fixed and variable expenses in their designated fields. Once you've entered everything, the template will subtract expenses from revenue to calculate your net profit before tax.

Your net profit before tax will be displayed at the bottom of the template. Use this number and the other details on your report to make informed decisions for your business. Understanding the profitability of your business at different time periods can help you create budgets and make smart financial decisions.

Your net profit before tax will be displayed at the bottom of the template. Use this number and the other details on your report to make informed decisions for your business. Understanding the profitability of your business at different time periods can help you create budgets and make smart financial decisions.

The final row of this free P&L template will display the net profit before tax, which can be used to help calculate a business’s tax bill. This assumes that all the expenses listed on the P&L are deductible. Reasonable or ordinary expenses generally are, but there are exceptions and nuanced rules in certain cases. Your tax office has details to help you understand what qualifies.

The final row of this free P&L template will display the net profit before tax, which can be used to help calculate a business’s tax bill. This assumes that all the expenses listed on the P&L are deductible. Reasonable or ordinary expenses generally are, but there are exceptions and nuanced rules in certain cases. Your tax office has details to help you understand what qualifies.

Once you’ve created the statement, it's time to print and/or save it. You can use past P&L statements to track the history of your business's finances and compare with new reports to see how your business is improving.

Once you’ve created the statement, it's time to print and/or save it. You can use past P&L statements to track the history of your business's finances and compare with new reports to see how your business is improving.

Want to learn more about how to understand your profit and loss statement or check you're in line with local regulations? An accountant or bookkeeper can help you complete your profit and loss statement template and avoid mistakes.

Find an advisor

Want to learn more about how to understand your profit and loss statement or check you're in line with local regulations? An accountant or bookkeeper can help you complete your profit and loss statement template and avoid mistakes.

Find an advisor

Make profit and loss statements better

Software can crank out P&Ls painlessly. Set up Xero to capture your financial data and it will create a report whenever you need one.

  • Included
    Create up-to-date reports at the press of a button
  • Included
    Format them the way you like
  • Included
    Share them online with your accountant, bookkeeper, and business partners
Check out Xero reporting
Table shows Xero gives push-button reporting, customisable formats, online sharing, and can visualise results.

Disclaimer

Xero does not provide accounting, tax, business or legal advice. This template has been provided for information purposes only. You should consult your own professional advisors for advice directly relating to your business.

Start using Xero for free

Access Xero features for 30 days, then decide which plan best suits your business.