How to Create a Profit and Loss Statement for Your Business

A profit and loss statement (also called a P&L or income statement) is one of the most important financial reports for any business. It shows whether your business is making money or losing money over a specific period. You’ll need it for tax filing, applying for loans, and making smart business decisions. This guide walks you through each step to create your own P&L statement.

What Is a Profit and Loss Statement?

A profit and loss statement summarizes your business revenue, costs, and expenses during a set time, like a month, quarter, or year. It follows a simple formula: Revenue – Expenses = Net Profit (or Loss). The statement helps you see where money comes from and where it goes.

Many small business owners use a P&L to track profitability, identify spending problems, and prepare for tax season. It’s also essential if you plan to seek funding or sell your business.

Step 1: Choose an Accounting Period

First, decide the time frame for your P&L. Common choices are monthly, quarterly, or annually. Monthly reports help you spot trends quickly. Annual reports are useful for taxes and year-end reviews.

Be consistent. If you compare month to month, always use the same length period. This makes it easier to see growth or problems.

Also consider your business cycle. A retail store might want monthly reports to track seasonal spikes. A contractor with long projects might prefer quarterly. The key is to pick a period that matches how you run your business. Once you choose, stick with it. Changing periods mid-year can confuse comparisons and make tax prep harder.

Step 2: Calculate Total Revenue

Revenue is all the money your business earned from sales, services, or other income before any expenses. Add up every sale, including cash, credit card, and online payments.

For example, if you sold 100 widgets at a certain price each, your total revenue is that amount. Include any other income like interest or rental income. List revenue at the top of your P&L.

Don’t forget about returns or discounts. If you gave a customer a refund or a discount, subtract that from your gross revenue. The result is your net revenue. Most P&Ls use net revenue because it reflects what you actually keep. Also include non-operating income like gains from selling equipment, but keep it separate if you can.

Step 3: Determine Cost of Goods Sold (COGS)

Cost of goods sold (COGS) are the direct costs of producing what you sell. For a product business, this includes materials, labor, and shipping. For a service business, COGS may include contractor payments or software directly tied to delivering the service.

Do not include indirect costs like rent or marketing here. Those come later. To calculate COGS, add up all direct costs for the period.

If you make products, you need to track inventory. COGS = Beginning Inventory + Purchases – Ending Inventory. For example, start the month with a certain amount in inventory, buy more, and end with some left. Your COGS is the difference. Service businesses can use simpler methods: just add up direct labor and materials for each job. Be careful with labor — only include wages for employees who directly work on your product or service, not administrative staff.

Step 4: Calculate Gross Profit

Gross profit is your revenue minus COGS. It shows how much money you have left to cover other expenses and still make a profit.

Formula: Gross Profit = Total Revenue – COGS. For instance, if revenue is a certain amount and COGS is another, your gross profit is the difference. This number is a key indicator of your pricing and production efficiency.

Compare gross profit across periods. If it drops, maybe your material costs rose or you’re discounting too much. If it rises, you might be pricing well or controlling direct costs. A healthy gross profit margin (gross profit divided by revenue) varies by industry, but tracking your own trend matters more than comparing to others.

Step 5: List Operating Expenses

Operating expenses are all costs not directly tied to making your product. They include rent, utilities, salaries, marketing, insurance, office supplies, and professional fees. List each expense as a line item.

Common categories are selling expenses (like advertising) and administrative expenses (like office rent). Use your accounting software or a spreadsheet to gather these numbers.

Example of Operating Expenses

• Rent: a certain amount
• Utilities: a certain amount
• Salaries: a certain amount
• Marketing: a certain amount
• Insurance: a certain amount

Add up all operating expenses to find your total. In this example, total operating expenses are a specific sum.

Be thorough. It’s easy to miss small expenses like bank fees, subscription services, or mileage. If you use your car for business, include mileage or actual vehicle costs. Also, separate one-time expenses from recurring ones. A large equipment purchase might need to be depreciated over time, not expensed all at once. Check with your tax professional on how to handle big purchases.

Step 6: Calculate Net Income

Net income (or net profit) is your gross profit minus all operating expenses. This is the bottom line. If the number is positive, you made a profit. If negative, you had a loss.

Formula: Net Income = Gross Profit – Total Operating Expenses. Using the example above: gross profit minus expenses equals net loss. That means you lost money.

Sample Profit and Loss Statement

Item	Amount
Total Revenue	a certain amount
Cost of Goods Sold	a certain amount
Gross Profit	a certain amount
Operating Expenses	a certain amount
Net Income (Loss)	a certain amount

Common Mistakes to Avoid

Many small business owners make errors when creating a P&L. One common mistake is mixing personal and business expenses. Keep separate accounts. Another is forgetting to include all revenue, like cash sales. Always record every transaction.

Don’t guess numbers. Use actual data from bank statements, receipts, and invoices. Also, remember to account for non-cash expenses like depreciation. For tax purposes, follow IRS guidelines for reporting.

If your bookkeeping is messy, consider using accounting software or hiring a professional. A clean P&L makes tax filing much easier. For help setting up your bookkeeping, read our guide on how to set up a bookkeeping system for your small business.

Another common error is confusing cash basis with accrual basis. Cash basis records income when you receive money and expenses when you pay. Accrual basis records income when you earn it and expenses when you incur them, even if cash hasn’t changed hands. Most small businesses use cash basis for simplicity, but accrual gives a more accurate picture. Check which method you use and stick with it. Switching methods can cause reporting issues.

How to Use Your P&L for Tax Planning

Your profit and loss statement is essential for preparing tax returns. It shows the IRS your taxable income. You’ll use the net income figure to calculate how much tax you owe.

Regular P&L reports help you plan. If you see a big profit, you might want to buy equipment or prepay expenses to lower your tax bill. If you have a loss, you can carry it forward to offset future profits.

For example, if your P&L shows a high net income in Q3, you could purchase needed supplies before year-end to reduce taxable income. Or you might contribute to a retirement plan. Just make sure any expense is legitimate and properly documented. Also, use your P&L to estimate quarterly estimated tax payments. The IRS expects you to pay taxes throughout the year. Underpaying can lead to penalties. Your P&L helps you calculate a reasonable estimate.

Adjusting Entries: Why They Matter

An often-overlooked step is making adjusting entries. These are corrections or updates to your accounts at the end of a period. Common adjustments include recording depreciation, accruing unpaid expenses (like wages earned but not yet paid), and recognizing prepaid expenses (like insurance paid upfront).

Without adjusting entries, your P&L can be misleading. For instance, if you paid an insurance premium in January for the full year, you shouldn’t expense the whole amount in January. Instead, allocate a portion each month. This keeps your monthly net income accurate. Similarly, if you used office supplies from your inventory, record that as an expense. Missing these adjustments inflates profits in some months and deflates them in others.

Set a reminder to review and adjust entries each month. Your accounting software can automate some of this, but you still need to check it. If you’re unsure, ask an accountant. They can help set up recurring adjustments.

Final Tips for an Accurate P&L

Update your P&L regularly, at least quarterly. Compare it to previous periods to spot trends. Use accounting software to automate calculations and reduce errors. Review your P&L with a tax professional or accountant to ensure accuracy.

Remember, your P&L is a snapshot. It only shows a period of time. Combine it with a balance sheet and cash flow statement for a complete financial picture.

Frequently asked questions

What is the difference between a profit and loss statement and a balance sheet?

A profit and loss statement shows revenue, expenses, and net income over a period. A balance sheet shows assets, liabilities, and equity at a single point in time. The P&L covers performance; the balance sheet covers financial position.

Do I need to include taxes in my profit and loss statement?

Yes, income taxes are usually listed as an expense after net income before taxes. For small businesses, you may include estimated tax payments. Consult a tax professional for your specific situation.

How often should I prepare a profit and loss statement?

Many businesses prepare a P&L monthly, quarterly, and annually. Monthly reports help you catch problems early. Annual reports are required for tax filing. Choose a schedule that helps you manage your business.

Can I create a profit and loss statement in Excel?

Yes, you can create a P&L in Excel using a template. List revenue, COGS, and expenses in rows, then use formulas to calculate gross profit and net income. Many free templates are available online.

What if my profit and loss statement shows a loss?

A loss means your expenses exceeded revenue. Review your spending and look for ways to cut costs or increase sales. A loss can reduce your taxable income, but repeated losses may signal a business problem.