How to Create a Profit and Loss Report

How to Do a Profit and Loss Report

Business owners often make business decisions based on three reports: a cashflow statement, a balance sheet, and an income statement or profit and loss report. These three reports tell the business owner nearly everything they need to know about the state of their finances. Perhaps the most important of these statements is the profit and loss report.

The profit and loss report shows the business’ revenues gained and expenses incurred and the profit or loss that results from those expenditures. These records are created for a given time period, usually a month or a quarter.

What do you need for a Profit & Loss Report?

To complete a profit and loss report, you will need a few basic financial records.

  1. List of all transactions during the given period

This includes transactions in the business’ checking account and any purchases made on business credit cards. This list should also include the production or purchasing cost of goods sold.

  1. List of all sources of income

Sources of income include checks, credit card payments, profits from sales and more. These credits are most likely readily available on your bank statement.

  1. Any reductions to sales

This includes any discounts, refunds or returns that were issued in the reporting period.

How do I complete a Profit & Loss Report?

Step 1: Calculate Revenue

Include any income you have brought in during the set period of the report.

Step 2: Calculate Cost of Goods Sold

This is the direct cost of producing the goods your company sells.

Step 3: Revenue – Cost of Goods Sold = Gross Profit (or Loss)

Subtract the cost of goods sold from the income you have brought in to derive your gross profits.

Step 4: Calculate Operating Expenses

You consider operating expenses as the cost running a business. This includes rent, utilities, payroll, marketing, insurance, etc.

Step 5: Gross Profit (or Loss) – Operating Expenses = Operating Profit (or Loss)

Subtract your operating expenses from your gross profit to get your operating profit.

Step 6: Operating Profit (or Loss) + (Interest Income + Dividends Earned) = EBITDA

Add any income from interest payments or earned dividends to derive your EBITDA (earnings before interest, taxes, depreciation and amortization).

Step 7: Calculate Interest, Taxes, Depreciation and Amortization

Next, calculate any interest, taxes, depreciation and amortization you owe for the duration of the set period.

Step 8: EBITDA – (Interest + Taxes + Depreciation + Amortization) = Net Profit (or Loss)

Subtract the number from step 7 from your EBITDA to get your net profit. Hopefully, by this point, your business is not operating at a net loss.

What does a Profit & Loss Report tell you?

A profit and loss report tells you three main things:

  1. Whether your business model or product line is profitable
  2. Whether your business’ profits are trending in the right direction
  3. The overall financial health of your business

This report, in conjunction with the other three main financial statements, serve as a barometer of how your business is doing. That is why running this report in set intervals is crucial to keeping your business on the right track.

What else do you need to know?

Pro Forma P&L vs. Periodic P&L

A pro forma profit and loss report is typically completed at startup. This report projects your profits and losses based on industry data before they happen. A pro forma profit and loss report can also be completed before applying for funding for a new business venture or project.

A periodic profit and loss report is one that is created at a set interval based on new information. For example, you might complete one before you file your taxes to project how much income tax you will have to pay for the year. These can also be done after monthly or quarterly bank statements as a form of bank statement reconciliation.

Accounting Software

Creating a profit and loss report is hard work. To take some of the pressure off, you can use an accounting software like QuickBooks. The software will compile the report. Then, you or an accountant will need to reconcile the transactions and results. Software is great, but it is not infallible.

A profit and loss report can give you vital insight into the way your business is operating financially. You should complete a P&L at least once per quarter to make sure your business is on the right track.

Share this post

A CONTINUING EDUCATION

Unlocking Financial Mastery: The Dynamic Duel Between Forecasting and Budgeting 

Unlocking Financial Mastery: The Dynamic Duel Between Forecasting and Budgeting 

In the quest for financial mastery, the art and science of forecasting and budgeting stand as critical pillars. Mastering these tools is essential for anyone looking to navigate the tumultuous waters of personal finance or steer a business toward prosperity.

READ MORE »
Navigating the Audit Maze: Smart Strategies for Business Preparedness 

Navigating the Audit Maze: Smart Strategies for Business Preparedness 

In the complex world of business operations, one term can often bring a mix of anxiety and necessity to the forefront: audit. Navigating the audit maze requires more than just a reactive stance; it demands proactive preparedness and a deep understanding of what audits entail, their types, purposes, and the strategic approaches businesses can adopt to survive and thrive through them.

READ MORE »
Financial KPIs to Keep Track of in 2024 

Financial KPIs to Keep Track of in 2024 

In the ever-evolving landscape of business and finance, staying ahead involves understanding the current trends and predicting future changes. As we enter 2024, it is increasingly critical for businesses to monitor certain Financial KPIs (Key Performance Indicators) to ensure they are on the right track towards fiscal health and prosperity.

READ MORE »

Contact Us

    1000 character limit