← All articles

How to Create a Simple Profit and Loss Statement

How to create a simple profit and loss statement for a small business — BudgetSheets PH

A profit and loss statement (P&L) tells you, in black and white, whether your business actually made money last month — not just whether your bank balance looks healthy. This guide walks you through the structure, a full worked example in pesos, and the mistakes that trip up most small business owners in the Philippines.

What a profit and loss statement actually shows

A P&L (also called an income statement) is a summary of everything your business earned and spent over a specific period — usually a month, a quarter, or a year. Unlike your bank balance, which can be thrown off by loan proceeds, owner withdrawals, or unpaid customer balances, a P&L focuses purely on income and expenses tied to running the business. That is why it is the single most useful report for deciding whether to raise prices, cut costs, or expand.

For sari-sari stores, online shops, carinderias, and small service businesses, the P&L answers one blunt question every month: did we actually profit, or were we just moving money around?

The basic structure: three lines that matter

Every P&L, no matter how simple, follows the same logic. You only need three levels:

  • Revenue — total sales for the period, before any deductions.
  • Cost of Goods Sold (COGS) — what it cost you to produce or buy what you sold (ingredients, inventory, direct labor tied to production).
  • Gross Profit — Revenue minus COGS. This tells you how healthy your core product margin is.

From there, you subtract everything else it costs to keep the business running:

  • Operating Expenses — rent, salaries, utilities, marketing, transportation, supplies, loan interest, and other overhead not directly tied to making the product.
  • Net Profit — Gross Profit minus Operating Expenses. This is your real bottom line.

If you are unsure what belongs in COGS versus operating expenses, our guide on how to compute COGS breaks it down item by item, which matters because misclassifying expenses is one of the most common ways owners misread their own numbers.

A worked example: Aling Nena’s Carinderia

Here is a simple monthly P&L for a carinderia to show the structure in action.

Revenue
Total food sales for the month: ₱185,000

Cost of Goods Sold
Meat, vegetables, rice, cooking oil, and other ingredients: ₱74,000

Gross Profit
₱185,000 − ₱74,000 = ₱111,000

That is a gross margin of about 60 percent — a healthy range for a food business, though it will vary by menu.

Now list operating expenses for the same month:

  • Stall rent: ₱15,000
  • Helper’s wage: ₱12,000
  • LPG and cooking gas: ₱4,500
  • Electricity: ₱3,800
  • Market transportation: ₱2,200
  • Disposable containers and cleaning supplies: ₱1,500

Total Operating Expenses: ₱15,000 + ₱12,000 + ₱4,500 + ₱3,800 + ₱2,200 + ₱1,500 = ₱39,000

Net Profit
₱111,000 − ₱39,000 = ₱72,000

So even though Aling Nena rang up ₱185,000 in sales, her actual take-home profit for the month is ₱72,000 — a net margin of roughly 39 percent. Without a P&L, she would only see the sales figure and might overestimate how much cash she can safely pull out of the business. This is also where a P&L works hand in hand with a cash flow tracker, since profit on paper does not always mean cash in the drawer — especially if suppliers are paid on terms or customers owe her on utang.

The exact same structure applies to an online shop (revenue from orders, COGS from product cost and shipping, operating expenses from platform fees, packaging, and ads) or a small lending business, where COGS is closer to the cost of funds and bad debt provisions — something covered in more detail in our piece on how to run a lending business.

How often should you make a P&L?

For most small businesses in the Philippines, monthly is the sweet spot. It is frequent enough to catch problems early, but not so frequent that it eats up time you could spend running the business. A practical rhythm looks like this:

  • Monthly: Prepare a full P&L. This is your main decision-making report.
  • Quarterly: Compare three months side by side to spot trends — rising costs, slowing sales, seasonal dips.
  • Annually: Consolidate into a yearly P&L for tax filing, loan applications, and setting next year’s targets.

If your business is seasonal (school supplies, holiday items, tourism-related services), a weekly quick P&L during peak season can help you catch cost overruns before they eat into your busiest month’s earnings.

Common mistakes small business owners make

  • Mixing personal and business expenses. If your grocery run and your ingredient run go through the same wallet without separation, your P&L will lie to you.
  • Confusing revenue with cash received. If a customer owes you ₱10,000 on credit, that is revenue once the sale happens, not when they finally pay — treat it consistently based on the accounting method you choose.
  • Lumping COGS and operating expenses together. This hides your true gross margin and makes it hard to tell if a pricing problem or an overhead problem is eating your profit.
  • Forgetting small recurring costs. Delivery app commissions, bank transfer fees, and small supply purchases add up and are often left out entirely.
  • Only checking the bank balance. A growing bank balance can hide a shrinking margin if you took out a loan or delayed paying suppliers. The P&L, not the balance, tells you if the business itself is profitable.
  • Not reviewing it at all. A P&L sitting unopened in a folder is useless. The value comes from comparing month to month and asking why numbers moved.

Frequently asked questions

Do I need accounting software to make a P&L?

No. A well-organized spreadsheet with clear categories for revenue, COGS, and operating expenses is enough for most small businesses, especially in the early stages. What matters more than the tool is being consistent about what goes in each category every month.

What is the difference between gross profit and net profit?

Gross profit is what is left after subtracting the direct cost of what you sold (COGS) from revenue — it shows how efficient your core product or service is. Net profit goes one step further, subtracting all operating expenses like rent, wages, and utilities, giving you the true bottom line after everything is paid for.

Can a business have high revenue but still show a loss on its P&L?

Yes, and it happens often. High revenue with thin margins, expensive COGS, or bloated operating expenses can still result in a net loss. This is exactly why sales figures alone are misleading and a full P&L, run regularly, is necessary to see the real picture.

Skip the blank spreadsheet

Get a ready-to-use profit and loss template built for Philippine small businesses, with COGS and operating expenses already structured for you. Works in Excel and Google Sheets, and you can pay easily via GCash, Maya, or Maribank.

Browse business templates →