Disclaimer: The information provided in this blog is for general informational purposes only and does not constitute legal, tax, or accounting advice. Nothing on this site should be relied upon as a substitute for professional advice from a licensed attorney, CPA, or financial advisor. Please consult a qualified professional before making any financial or legal decisions.
By the end of this guide, you'll know how to fill out a profit and loss statement template correctly and read the results to understand whether your business is actually profitable. You'll need your sales records, expense receipts or bank statements, and a spreadsheet program or downloadable template before you start.
Step 1: Choose or Download a P&L Statement Template
Not every template is built the same way, and picking the wrong one can leave you missing information you'll need later. Look for a template with clearly separated sections for revenue, cost of goods sold (COGS), operating expenses, and net income. These four sections form the backbone of any profit and loss statement, and if a template lumps them together or skips one, you'll have a harder time spotting where money is actually going.
As of 2026, most small business owners build their P&L in Excel or Google Sheets, either from a free downloadable template or one built into accounting software like QuickBooks or Wave. Spreadsheet-based templates have a real advantage over paper or PDF versions: they let you write formulas that automatically total each section and calculate gross profit and net income for you. This cuts down on manual math errors, which is one of the more common reasons a P&L doesn't match what's actually in the bank.
Before you commit to a template, decide how often you plan to review your finances. A monthly template makes sense if you want to catch problems early or you're managing tight cash flow. A quarterly or annual template works better if you're using the P&L mainly for tax prep or big-picture planning. Match the template's time period to that habit rather than picking one arbitrarily, since reformatting a template halfway through the year to change its period is more work than setting it up correctly from the start. If you're not sure which cadence fits your business, a monthly template is usually the safer default because you can always roll several months together into a quarterly or annual view later.
Step 2: Gather Your Income Records
With the template in place, pull together every source of income for the period you're covering. This usually means exporting sales data from your point-of-sale system, invoicing software, or simply reviewing bank deposits if you don't use dedicated sales tools. The goal is to capture every dollar that came in from your actual business activity during that window, not just the transactions that happen to be top of mind.
If your template supports it, break revenue into categories rather than entering one lump sum. A retail shop might separate in-store sales from online orders; a consultant might separate one-time project fees from retainer income. This separation matters because it shows you which revenue streams are actually carrying the business. It's common to discover that a product line or service you assumed was a moneymaker contributes a small fraction of total revenue once it's broken out on its own line.
The most common mistake at this stage is treating sales tax collected from customers as part of your revenue. That money passes through your business on its way to the state or local tax authority, it was never yours to keep, and including it inflates your revenue figure in a way that throws off every calculation downstream. Before entering a sales total, confirm whether the figure from your POS or invoicing system is gross (including tax) or net (excluding tax), and use the net figure. If you're not sure which your system reports by default, check a single transaction against the receipt to verify before you enter a whole period's worth of numbers.
Step 3: Enter Cost of Goods Sold
Cost of goods sold, or COGS, covers the direct costs tied to producing or delivering what you sold: raw materials, inventory purchased for resale, and production labor directly involved in making the product. It does not include general business costs like office rent or marketing, those come later as operating expenses. The distinction matters because COGS is what you subtract from revenue to get gross profit, one of the most useful numbers on the whole statement.
Most templates calculate gross profit automatically once you've entered revenue and COGS, using a simple formula: revenue minus COGS equals gross profit. Gross profit tells you how much money is left after covering the direct cost of what you sold, before you account for rent, payroll, software, or any other overhead. A shrinking gross profit margin over time, even with steady revenue, often means your material costs are rising or you're discounting too aggressively.
If you run a service-based business with little or no physical product, you may find you have very little to enter here. A freelance writer or a consultant, for example, might have no COGS at all, since their main cost is their own time, which typically shows up as an operating expense or simply isn't tracked as a direct cost. In that case, leave the COGS field at zero rather than forcing a number into it just to fill the space. Entering an inflated or invented COGS figure to make the template feel complete will only distort your gross profit and make later comparisons meaningless.
Step 4: List Your Operating Expenses
Operating expenses cover everything it costs to keep the business running that isn't directly tied to producing what you sell. Break these into clear categories rather than one general "expenses" line. Common categories include:
- Rent or lease payments for office, retail, or warehouse space
- Utilities, including electricity, internet, and phone service
- Payroll for administrative or sales staff not directly tied to production
- Marketing and advertising costs
- Software subscriptions and other recurring tools
Use the same categories every period, even if some months have a zero balance in a given line. Consistency is what makes a P&L useful for spotting trends: if you rename or reorganize categories every few months, you lose the ability to compare February to March or this year to last year with any confidence. Set your category list once, ideally when you first build the template, and resist the urge to tweak it unless a genuinely new type of expense shows up.
A frequent error at this stage is mixing one-time capital purchases into recurring operating expenses. Buying a new delivery van, a commercial oven, or a batch of laptops is a capital expenditure, not a regular monthly cost, and dropping it into your operating expenses for that period will make your P&L show a loss that doesn't reflect your normal operations. Capital purchases are typically depreciated over time and tracked separately on your balance sheet rather than expensed all at once on the P&L. If you're not sure whether a purchase counts as a capital expense or a regular operating cost, that's a good question to bring to a CPA rather than guess, since the treatment affects both your P&L and your tax return.
Step 5: Calculate Net Income
Once revenue, COGS, and operating expenses are entered, most templates walk you through a straightforward sequence: subtract COGS from revenue to get gross profit, then subtract total operating expenses from gross profit to get operating income. From operating income, you adjust for anything not yet accounted for, such as interest paid on loans or taxes owed, to arrive at net income, the true bottom line of the statement.
Net income is the figure most people mean when they ask whether a business is profitable. A positive net income means revenue covered every cost for the period, direct and indirect, with money left over. A negative net income, often shown in parentheses or in red depending on the template, means the business spent more than it brought in and needs a closer look. One negative month isn't necessarily alarming, especially for seasonal businesses, but a negative net income that repeats for several periods in a row is worth investigating before it becomes a cash problem.
Before you trust the final number, check the formulas themselves, particularly if you've added or removed rows since setting up the template. Spreadsheet formulas that sum a range of cells don't always automatically adjust when you insert a new expense line above or below the original range, which means a new category can get silently excluded from the total. Click on the cell containing your net income figure and verify that the formula still references every row it should. This kind of check takes thirty seconds and catches an error that could otherwise go unnoticed for months.
Step 6: Compare Against Prior Periods
A single P&L tells you where things stand right now, but it doesn't tell you much about direction. Place the current period's statement side by side with last month's or last year's version of the same period to see whether revenue is climbing or slipping, and whether expenses are moving in step with it or outpacing it.
Pay particular attention to expense categories that grew faster than revenue. If payroll rose 15% but revenue only rose 5%, that gap is worth understanding before it repeats for another few periods. Sometimes there's a good reason, like an investment in a new hire who hasn't ramped up yet, but sometimes it points to a cost that's crept up without anyone noticing, like a software subscription that auto-upgraded to a pricier tier.
Comparing raw dollar amounts gets harder as your business grows or shrinks, since a busier month naturally has bigger numbers across the board. Percentage-of-revenue analysis solves this: express each expense line as a percentage of total revenue for that period, so rent might be 8% of revenue in a slow month and 5% in a strong one, even though the dollar amount didn't change. Tracking these percentages over time makes it much easier to see whether a cost is genuinely growing out of proportion or just looks bigger because of a slow sales period.
Step 7: Share the Statement or Prepare It for Your Accountant
Once the numbers are entered and checked, the P&L often needs to go somewhere: to a lender evaluating a loan application, to a business partner reviewing performance, or to your accountant for tax preparation. Export the completed template as a PDF or a clean spreadsheet copy rather than sending your working file directly. This keeps your formulas and notes intact on your end while giving the recipient a polished, easy-to-read version.
Alongside the statement, keep your supporting documents organized: receipts, invoices, bank statements, and anything else you used to build the numbers. If a lender, auditor, or tax authority ever asks how a particular figure was calculated, having the backup ready saves time and reduces stress. A simple folder system organized by month or category, whether physical or digital, is usually enough.
Before using your P&L for tax filings or a loan application, have your accountant verify how expenses and revenue are categorized. Misclassified expenses, such as a capital purchase entered as an operating expense or personal spending mixed into business costs, can affect which deductions you're entitled to and may raise questions during a tax filing or audit. A CPA can also confirm that your COGS and operating expense categories align with how your industry and tax situation typically report them, which is a detail that's easy to get wrong without professional guidance.
A profit and loss statement is only as useful as the habit behind it. Revisit yours on a regular schedule, whether that's monthly or quarterly, and have a qualified accountant review your categories periodically so misclassifications don't quietly pile up over a year. Numbers that stay consistent and accurate now save real headaches when tax season or a loan application arrives.
Schedule a call and discover how we can help your business grow.