Home » How to Prepare a Profit & Loss Report (A Simple, No-BS Guide for Business Owners)

How to Prepare a Profit & Loss Report (A Simple, No-BS Guide for Business Owners)

Let’s be honest — most business owners avoid financial reports like the plague. They feel boring, complicated, and honestly a bit intimidating. But here’s the truth: A Profit & Loss (P&L) report is one of the most powerful tools you’ll ever use in your business. It answers the only question that actually matters: “Am I really making money… or just staying busy?” Whether you run a small shop, freelance, or sell online, knowing how to read (and prepare) your own P&L gives you clarity, control, and confidence. You’ll know where your money comes from, where it disappears, and whether your business is actually worth continuing. No jargon. No fluff. Let’s break it down.

What Is a Profit & Loss Statement?

A P&L statement is simply a summary of:

  • Revenue (money coming in)
  • Expenses (money going out)
  • And the final result: profit or loss

In plain English: You earn money → you spend money → what’s left is your reality.

It answers 3 brutal questions:

  1. Am I actually making money?
  2. Where is my money going?
  3. Is my business even worth continuing?

You can prepare a P&L using:

  • Cash basis – record when money actually moves (simple, good for small businesses)
  • Accrual basis – record when income/expenses are earned or incurred (more accurate, more complex)

Most small businesses start with cash basis. Keep it simple.

Key Components of a P&L Report.

1. Revenue (Sales / Top Line)

This is all the money you earned from selling stuff or services. Sales, service fees, subscriptions — everything. If customers returned something or got discounts, subtract that to get Net Revenue.

2. Cost of Goods Sold (COGS)

These are direct costs to deliver what you sell. Examples:

  • Products you bought to resell
  • Raw materials
  • Direct labor
  • Shipping for products

Not included:

  • Rent
  • Internet
  • Office snacks
  • Your Spotify subscription 😅

Those are operating expenses.

3. Gross Profit

This shows how good your core business actually is. Formula: Gross Profit = Revenue – COGS If this number is weak, you have a pricing problem or a sourcing problem. No amount of “motivation” can fix bad margins.

4. Operating Expenses

These are your day-to-day survival costs:

  • Rent
  • Salaries
  • Marketing
  • Electricity
  • Internet
  • Software
  • Transport

Basically: what it costs just to keep the lights on.

5. Operating Profit (EBIT)

This is profit from real business operations. Formula: Operating Profit = Gross Profit – Operating Expenses. This tells you if the business itself works — without loans, taxes, or random events.

6. Other Income & Expenses

Stuff that’s not part of daily operations:

  • Bank interest
  • Loan interest
  • Selling old equipment
  • One-time gains/losses

7. Net Profit (The Only Number That Matters)

This is your bottom line. Formula: Net Profit = Profit Before Tax – Taxes This is:

  • Not your bank balance
  • Not your cash in hand
  • Not your “feeling”

This is the truth.

Step-by-Step: How to Prepare Your Own P&L

You can do this in Excel, Google Sheets, or in ZUPO.

Step 1: Pick a Time Period

Start with one month. Monthly P&L is the sweet spot.

Step 2: Gather Your Data

Collect:

  • Bank statements
  • Sales invoices
  • Receipts
  • Credit card bills
  • Payroll
  • Inventory records

If data is messy, your P&L will lie.

Step 3: List Your Revenue

Add up all income sources.

Step 4: Calculate COGS (if you sell products)

Formula: Opening Inventory + Purchases – Closing Inventory

Step 5: Calculate Gross Profit

Revenue – COGS

Step 6: List All Expenses

Go through every receipt. Categorize everything. Yes, even that “small” expense. Small leaks sink big ships.

Step 7: Get Operating Profit

Gross Profit – Expenses

Step 8: Add Other Income/Expenses

Step 9: Subtract Taxes

Step 10: Format It Nicely – That’s your P&L.

Real Example: Sarah’s Stationery Business

Sarah runs a small online stationery shop. Here’s her P&L for January 2026: In one month: You sold goods worth: NPR 200,000, You bought those goods for: NPR 120,000. Your monthly expenses: Rent: 15,000, Salary: 20,000, Electricity: 3,000, Internet: 2,000, Transport: 5,000 Total Expenses = 45,000

Step 1: Revenue (Income)

This is all the money you earned from your business. Example: Sales = NPR 200,000 This is your top line.

Step 2: Cost of Goods Sold (COGS)

These are direct costs to sell your product. For example: Purchase of stationery = NPR 120,000 This is not rent, not salary, not electricity. Only the cost of the goods you sold.

Step 3: Gross Profit

Formula: Gross Profit = Revenue – COGS So: 200,000 – 120,000 = NPR 80,000 This tells you: “After buying goods, how much did I actually make?” If this number is weak, your pricing or sourcing is wrong.

Step 4: Expenses

These are your operating costs:

Expense TypeAmount (NPR)
Rent15,000
Salary20,000
Electricity3,000
Internet2,000
Transport5,000
Total45,000

Step 5: Net Profit (Final Answer)

Formula: Net Profit = Gross Profit – Expenses : 80,000 – 45,000 = NPR 35,000 This is your real business result. Not your bank balance. Not your cash in hand. This is the actual profit.

How to Analyze Your P&L (Quick Tips)

  • Compare Periods — Is revenue growing? Are expenses rising faster?
  • Track Margins — Aim to improve gross margin over time.
  • Spot Red Flags — Sudden expense spikes or shrinking profits.
  • Use Percentages — Show each line as % of revenue (e.g., “Marketing = 8% of sales”).

Common Mistakes to Avoid

  • Mixing personal and business expenses (big tax headache!)
  • Forgetting to include all costs (especially small ones that add up)
  • Using inconsistent accounting methods month-to-month
  • Ignoring depreciation or amortization
  • Not updating regularly—do it at least monthly
  • Misclassifying expenses (e.g., putting loan interest in COGS)

The Smart Way: Automate It

Manually preparing P&L is fine when:

  • You’re tiny
  • You have 10–20 transactions/month

After that? It’s just self-torture. With accounting software like ZUPO, your P&L is:

  • Auto-generated
  • Real-time
  • Always accurate
  • Filterable by month, year, branch, project

You just enter:

  • Sales
  • Expenses
  • Purchases

The system does the rest. No Excel formulas. No missed entries. No “I’ll do it later”.

Reality Check (Blunt)

If you don’t look at your P&L:

  • You are not running a business
  • You are just staying busy

Busy ≠ profitable, Effort ≠ success. Only numbers tell the truth. And P&L is the first truth you should face every month.

Happy calculating!