How to make a simple profit and loss statement?

How To Create a Profit and Loss Statement Track Operating Revenue. ... Record Cost of Sales. ... Calculate Gross Profit. ... Determine Overhead. ... Add Up Operating Income. ... Consider Other Income and Expenses. ... Finally Arrive at Your Net Profit. Jan 25, 2023

What is the basic formula for a profit and loss statement?

How do you calculate P&L? Your P&L statement will draw on the following data points and calculations: Net Sales (or revenue) – Cost of Sales (or Cost of Goods Sold) = Gross Profit (or Gross Margin) Gross Profit – Operating Expenses = Net Operating Profit.

What is the basic P&L statement?

A profit and loss statement includes a business's total revenue, expenses, gains, and losses, arriving at net income for a specific accounting period. Management analyzes a P&L to determine how to increase profitability by increasing revenue, lowering costs or both.

What is an example of a profit and loss?

If a shopkeeper brings a cloth for Rs.100 and sells it for Rs.120, he has made a profit of Rs.20/-. If a salesperson has bought a textile material for Rs.300 and has to sell it for Rs.250/-, he has gone through a loss of Rs.50/-.

What is a profit and loss account with an example?

What is a profit and loss account? A profit and loss account shows a company's revenue and expenses over a particular period of time, typically either one month or consolidated months over a year. These figures show whether your business has made a profit or a loss over that time period.

What does a P&L sheet look like?

A P&L statement shows a company's revenues and expenses related to running the business, such as rent, cost of goods sold, freight, and payroll. Each entry on a P&L statement provides insight into how much money a company made and spent.

What are the three most important parts of a P&L?

The main categories that can be found on the P&L include: Revenue (or Sales) Cost of Goods Sold (or Cost of Sales) Selling, General & Administrative (SG&A) Expenses.

How do you write profit and loss in a business plan?

The simplest formula is this one: 'total revenue – total expenses = profit (or loss)'. Details of your turnover form the basis of the P&L calculations.

What is a profit and loss statement for self employed?

What should go into a P&L statement? A profit and loss statement (sometimes referred to as an income statement) summarizes income and expenses for a given time period. There are common elements to include to make it useful. The most common approach is to list all revenues at the top and then all the expenses afterward.

What is a 12 month profit and loss statement?

Also known as a profit and loss statement (P&L), the income statement records a business's income and expenses over a specific reporting period, typically a month, quarter, or year. There are two main parts to an income statement: Revenues and Expenses.

What is the formula for profit statement?

The basic formula that is used to calculate the profit in a business or a financial transaction, is: Profit = Selling Price - Cost Price.

How to Create a Profit and Loss Statement: Step-By-Step (2024)

A profit and loss statement provides businesses with a view of revenue, expenses, and income over a specified time frame. This step-by-step guide explains how to create a profit and loss statement.

Designed to provide business owners with revenue and expense details, the profit and loss statement, or P&L statement, is a must for business owners, whether you’re a small business bookkeeper, or the head of a global conglomerate.

Overview: What is a profit and loss statement?

Like a cash flow statement, a profit and loss statement provides you with detailed information regarding both revenues and expenses for your business.

Also known in accounting terms as an income statement, even a basic profit and loss statement can provide you with a convenient window through which you can view your company’s revenue and expenses.

In addition, profit and loss statements can also be a useful tool for creating a budget or calculating your working capital.

How to write a profit and loss statement

It’s up to you how frequently you wish to run a profit and loss statement. Some companies choose to run one monthly, while others prefer quarterly profit and loss statements.

Example profit and loss report comparing a company's P&L in four regions. Image source: Author

Whatever your preference, the best way to create a profit and loss statement is by using accounting software, which will take care of the entire process for you. If you currently do not use accounting software, you can use a template to create a profit and loss statement.

Here are the steps to take in order to create a profit and loss statement for your business.

Step 1: Calculate revenue

The first step in creating a profit and loss statement is to calculate all the revenue your business has received. You can obtain current account balances from your general ledger such as cash and current accounts receivable balances.

If you’re creating a monthly profit and loss statement, you’ll include all of the revenue received in that time frame, whether your business has collected that revenue or not. If you’ve chosen to run a quarterly statement, just add up the revenue received in that three-month time frame.

When calculating revenue, be sure to include all revenue received, whether it’s from selling products and services or from selling your old printer to the business next door.

Step 2: Calculate cost of goods sold

Your cost of goods sold is an important part of any profit and loss statement. If you’re selling wallets, you’ll have to include the cost of purchasing the wallets from the manufacturer.

If you’re making the wallets, you’ll have to include the materials and supplies needed to make them. If you’re selling services, you need to include the cost of your time or your employee’s time that provided the service.

Step 3: Subtract cost of goods sold from revenue to determine gross profit

Once you have calculated your revenue and your cost of goods sold, you’ll just need to subtract the cost of goods sold to arrive at your gross profit number. Gross profit is the profit your business has earned from selling your products and/or services.

Revenue - Cost of Goods Sold = Gross Profit/Loss

Step 4: Calculate operating expenses

The next thing you need to do is calculate all of your operating expenses. Operating expenses include rent, travel, payroll, equipment, utilities, and postage.

Step 5: Subtract operating expenses from gross profit to obtain operating profit

Once your operating expenses have been calculated, you’ll want to subtract that total to obtain your total operating profit. This will give you your total operating profit or loss.

Gross Profit - Operating Expenses = Operating Profit/Loss

Step 6: Add additional income to your operating profit

If you have any additional income not included in your revenue totals above, such as interest income or dividends from investments, you’ll want to include them here. Once added to your operating profit, the total is earnings before interest, taxes, depreciation, and amortization, otherwise known as EBITDA.

EBITDA = Operating Profit + (Interest Income + Dividends Earned)

Step 7: Calculate interest, taxes, depreciation and amortization

The next step is to calculate any interest payments, taxes due, as well as depreciation and amortization expenses.

Step 8: Subtract interest, taxes, depreciation, and amortization expenses from EBITDA to obtain net profit

Your final step is subtracting interest, taxes, depreciation, and amortization expenses to arrive at your net income, or net profit.

Net Profit/Loss = EBIDTA - (Interest + Taxes + Depreciation)

##promo-body-ecap##

What does a P&L statement tell you about your business?

A profit and loss statement lets you know exactly how your business is doing. Often used to determine both strengths and weaknesses in businesses, a profit and loss statement can also tell you the following:

Whether your products or services are profitable

We’re all in business to make a profit, so it’s no surprise that one of the most important markers for your business is your gross profit. Your gross profit is calculated by subtracting the cost of goods sold from revenue earned.

This number can tell you how well your products are performing or whether your services are profitable. If your gross profit is low, look to increasing sales.

Whether your business is trending in the right direction

When reviewing your profit and loss statement, it’s important to look at trends. Whether you calculate profit and loss on a monthly or quarterly basis, comparing reports can help you understand exactly how your business is trending.

For instance, if your net profit for January was $11,000, but dropped down below $5,000 in February, March, and April, you’ll need to do a deep dive into your business finances to determine what happened. You can do that by first examining gross profit. If gross profit is down, your course of action should be to increase sales.

However, if gross profit has remained consistent but net profit is down, that signifies an increase in operating expenses, so you’ll want to start looking at ways to cut expenses. While one profit and loss report is helpful, comparing them can be even more helpful.

How healthy your business is overall

The bottom line. When you hand over financial documents to investors or financial institutions, their eyes go to the bottom line: net profit. While having a loss isn’t the end of the world, it does signify that something is amiss, either as a one-time issue or across business operations.

Either way, the profit and loss statement lets you see exactly where your business stands in terms of profit, which in turn allows you to make better business decisions.

Best accounting software to create a profit and loss statement

It’s not difficult to find a profit and loss statement template that can be used to create a simple profit and loss statement, but the entire process is much easier if you use accounting software.

By tracking the information needed to create a profit and loss statement such as revenues and expenses using accounting software, you can have a current profit and loss statement in seconds.

1. QuickBooks Desktop

QuickBooks Desktop is one of the best accounting software options for small and growing businesses. Offering three plans, you can easily scale up to the next plan as your business grows. The latest version of QuickBooks Desktop offers enhanced system navigation and expanded help options.

QuickBooks Desktop offers a good selection of profit and loss statements for your business. Image source: Author

QuickBooks Desktop offers top-notch reporting capability, including several variations of the profit and loss statement. Reports can be easily customized and exported to Microsoft Excel for further customization if needed.

QuickBooks Desktop offers three plans:

Pro: The Pro plan is $299.95/year and supports up to three users.
Premier: The Premier plan also includes industry-specific reporting options. It’s priced at $499.95/year and supports up to five users.
Enterprise: Enterprise is the best plan for actively growing businesses. It costs $849.10/year and supports up to 30 users.

2. FreshBooks

FreshBooks is a small business accounting application that offers a long list of features geared toward sole proprietors and very small businesses. Offering online access as well as a mobile app for both iOS and Android devices, Freshbooks lets you collaborate with your employees, contractors, and accountants.

FreshBooks offers profit and loss statements by month or by quarter. Image source: Author

Even sole proprietors need to know how profitable their business is, and FreshBooks does a good job of providing business owners with the reports they need to make good management decisions.

FreshBooks offers four plans, all include product support and solid reporting capability:

Lite: The Lite plan is $15/month and supports up to 5 billable clients.
Plus: The Plus plan runs $25/month and supports up to 50 billable clients.
Premium: Premium is $50/month and supports up to 500 billable clients.
Select: The Select plan is custom-priced and supports more than 500 billable clients.

3. OneUp

OneUp is an affordable, easy to use accounting software application well suited for sole proprietors, freelancers, and small business owners. Offered on the cloud, OneUp works on desktop systems, laptops, and all mobile devices.

OneUp includes a profit and loss statement on their financial dashboard. Image source: Author

A OneUp feature that sets it apart from the competition is the option to enter transactions manually or connect to a bank for automatic transaction posting. Great for smaller businesses, OneUp includes a financial dashboard that provides you with a good view of business profit and cash flow.

OneUp’s pricing structure is also unique, with all features included in all plans, plan pricing based on the number of system users, with five options available:

Self: For single users, the Self plan is $9/month with no product support
Pro: Supports 2 users and runs $19/month with unlimited support
Plus: Supports up to 3 users and runs $29/month with unlimited support
Team: Supports up to 7 users and runs $69/month with unlimited support
Unlimited: For 8 or more users, Unlimited runs $169 per month with unlimited support

For a more complete list of accounting software applications, be sure to check out The Ascent’s accounting software reviews.

A final word about the profit and loss statement

Creating a profit and loss statement for your small business is vital since it’s one of the best reports to determine whether your business is profitable.

Required by lending institutions and investors alike, a profit and loss statement can also help you pinpoint areas of success as well as spots where your business may need additional help.