# How to Calculate Small Business Profit and Loss

- Link: https://simplyvora.com/how-to-calculate-profit-and-loss-small-business/
- Published: 2026-10-14T16:45:37+00:00
- Author: SimplyVora Editorial Team

When you run a small business, it is easy to focus on sales and forget to calculate
what you actually keep. A simple profit-and-loss (P&L) tracker helps you see income,
expenses, and the result for a week or month. You can start with a spreadsheet before
investing in complicated software.

**Quick answer:** Net profit or loss = total business income − total business expenses.
A positive result means income exceeded the expenses included in your calculation;
a negative result means expenses were higher. The result is only as accurate as 
the records and categories you include.

## What Is a Profit-and-Loss Tracker?

A P&L tracker summarizes revenue earned and costs incurred over a defined period.
It can help freelancers, online sellers, consultants, and small-business owners 
spot rising costs and compare performance month to month. It is a planning tool,
not a substitute for required accounting records or professional tax advice.

## The Simple Profit-and-Loss Formula

**Net profit or loss = total income − total expenses**

For example, suppose a digital-product shop records $1,200 in sales during one month.
Its listed costs are $180 for software, $90 for marketing, $60 for payment and platform
fees, and $270 in other operating costs. Those costs total $600, leaving $600 before
taxes and any costs not included in the example.

  |  Monthly example |  Amount |  
   |  Total income |  $1,200 |  
 |  Software and tools |  $180 |  
 |  Marketing |  $90 |  
 |  Payment and platform fees |  $60 |  
 |  Other costs |  $270 |  
 |  Total expenses |  $600 |  
 |  **Profit before taxes and excluded costs** |  **$600** |

This is an illustration, not a prediction. Your own result depends on your actual
records, refunds, fees, and applicable costs.

## What Should You Record?

### 1. Record income clearly

For each sale or payment, note the date, description, sales channel, amount, and
whether the money has been received. Keep refunds, discounts, and cancelled orders
visible so that the report reflects what really happened.

### 2. Group expenses into consistent categories

 * Software and subscriptions
 * Marketing and advertising
 * Payment processing and marketplace fees
 * Supplies, packaging, or delivery, if relevant
 * Contractors, professional services, and other operating costs

Choose categories that make sense for your business and use them consistently. Separate
personal purchases from business spending as far as practical, and keep receipts
or invoices.

### 3. Track refunds, fees, and unpaid invoices

Gross sales are not always the amount you keep. Refunds, discounts, chargebacks,
and platform fees affect the result. Also distinguish money already received from
invoices customers still owe you. A positive P&L does not automatically mean the
same amount is available in your bank account today.

## A Simple Spreadsheet Layout

Create a Transactions sheet with these columns: **Date, Type, Category, Description,
Amount, Payment Status, Notes.** Use “Income” or “Expense” in the Type column and
keep amounts in a consistent currency.

  |  Date |  Type |  Category |  Description |  Amount |  
   |  Oct 2 |  Income |  Product sales |  Planner bundle |  150.00 |  
 |  Oct 3 |  Expense |  Software |  Monthly tool |  25.00 |  
 |  Oct 4 |  Expense |  Payment fees |  Processing fee |  6.00 |

In Excel or Google Sheets, if Type is column B and Amount is column E, the total
income formula is `=SUMIF(B:B,"Income",E:E)` and total expenses can use `=SUMIF(
B:B,"Expense",E:E)`. Subtract expenses from income to calculate the net result. 
Adjust column letters to match your sheet and test formulas with sample entries 
first.

## Three Useful Numbers to Review

 * **Net profit or loss:** income minus expenses for the same period.
 * **Profit margin:** net profit divided by revenue, multiplied by 100. Do not calculate
   a percentage when revenue is zero.
 * **Largest expense categories:** identify costs that are increasing faster than
   sales.

Depending on your business, you may also need a separate cash-flow view for money
owed, upcoming bills, loan repayments, and taxes. Accounting treatment can vary 
by location and business structure.

## Common Mistakes to Avoid

 * Mixing personal and business spending without labeling it.
 * Forgetting refunds, platform fees, or recurring subscriptions.
 * Counting unpaid invoices as cash already received.
 * Changing categories every month so comparisons become difficult.
 * Assuming the remaining amount is automatically take-home income after taxes.

## Make the Template Easy to Maintain

Use dropdowns for transaction type and category, automatic totals, a monthly summary,
and a notes field for unusual entries. Protect formula cells from accidental edits
and keep a clean blank copy for each new period. A useful tracker is one you can
update consistently in a few minutes.

Pair your money review with a short weekly planning session: choose one financial
task, one customer or sales task, and one improvement to test next week. You can
explore practical resources in the [SimplyVora shop](https://simplyvora.com/shop/)
as our digital planning collection grows. For your weekly workflow, see our [weekly business planner guide](https://simplyvora.com/weekly-business-planner-freelancers-small-business/).

## Final Thoughts

You do not need to be a finance expert to start understanding your numbers. Record
income, record expenses, use consistent categories, and review the difference regularly.
Small, reliable habits help you make decisions from your records rather than guesswork.

_This article is for general educational purposes and does not replace advice from
a qualified accountant or tax professional._