How to Calculate Profit Margin from a PDF Bank Statement

You have your bank statement as a PDF. Your accountant is busy. You need to know if the business is actually making money. Here is exactly how to do it.

---

What Is Profit Margin (and Why It Matters More Than Revenue)

Revenue tells you how much money came in. Profit margin tells you how much you kept.

There are two numbers every business owner should know:

Gross Profit Margin $$\text{Gross Profit Margin} = \frac{\text{Revenue} - \text{Cost of Goods Sold}}{\text{Revenue}} \times 100$$

Net Profit Margin $$\text{Net Profit Margin} = \frac{\text{Net Income}}{\text{Revenue}} \times 100$$

A restaurant with 40 % gross margin but 3 % net margin is paying almost everything back out in rent, wages, and overhead. Knowing both numbers tells you where the leak is.

---

Step 1 – Extract the Numbers from Your PDF Bank Statement

This is where most people get stuck. PDF bank statements are structured for humans to read, not for businesses to calculate from.

You have three options:

Option A: Manual extraction (slow)

Open the PDF. Manually total all inbound transactions (your revenue) and all outbound transactions (your costs). This works for simple statements but easily takes 60–90 minutes for a monthly statement with hundreds of transactions.

Option B: Copy-paste into Excel (medium effort)

Some PDFs allow you to select text. Try selecting a column of transaction amounts, pasting into Excel, then using =SUM(). Warning: formatting often breaks and you spend as much time cleaning as calculating.

Option C: Use AI to extract and analyse automatically (fastest)

Tools like Raavue accept PDFs directly, extract all transaction data automatically, and calculate profitability metrics for you in under two minutes — including trends across multiple months.

---

Step 2 – Categorise Income vs. Expenses

Bank statements list every transaction chronologically. Profit margin requires you to separate:

• Revenue / income: customer payments, transfers in, sales deposits
• Cost of goods sold (COGS): supplier payments, raw materials, direct labour
• Operating expenses: rent, utilities, insurance, software subscriptions
• One-off items: equipment purchases, loan repayments — these should be excluded from margin calculations

If your bank statement mixes these together (they all do), you need to assign a category to each line.

Practical shortcut: sort transactions by description. Recurring vendor payments are likely COGS. Payroll is an operating expense. Transfers from payment processors (Stripe, Square, etc.) are revenue.

---

Step 3 – Calculate Gross Profit Margin

Once you have total revenue and COGS:

| | Amount | |---|---| | Total inbound (revenue) | £ 48,500 | | Supplier costs (COGS) | £ 19,200 | | Gross Profit | £ 29,300 | | Gross Profit Margin | 60.4 % |

A 60 % gross margin is healthy for most product businesses. Service businesses often target 70–80 %.

---

Step 4 – Calculate Net Profit Margin

Now deduct all operating expenses:

| | Amount | |---|---| | Gross Profit | £ 29,300 | | Rent | £ 4,200 | | Payroll | £ 14,500 | | Software & subscriptions | £ 800 | | Utilities | £ 600 | | Net Profit | £ 9,200 | | Net Profit Margin | 19.0 % |

19 % net margin is good for a small business. Anything above 10 % is generally considered healthy; below 5 % means your cost structure needs attention.

---

Step 5 – Compare Month Over Month

A single month's profit margin is a snapshot. What you really want is a trend.

• Is your margin improving or shrinking each month?
• Did a particular month spike in costs? Why?
• Is revenue growing faster than expenses, or the other way around?

Manually doing this for 12 months of PDF statements is a full day's work for most business owners. This is exactly the problem Raavue was built to solve — upload three to twelve months of statements and get a trend chart automatically.

---

Common Mistakes to Avoid

1. Confusing cash flow with profit Your account balance went up this month. That does not mean you made a profit. Outstanding invoices, loan drawdowns, and pre-paid expenses all affect the bank balance without affecting profit.

2. Including VAT in revenue If you are VAT-registered, your inbound payments include tax that is not yours. Strip VAT out before calculating margin.

3. Ignoring owner salary If you pay yourself from the business account, that outgoing is an expense. Leaving it out makes profit margin look artificially high.

4. One-off vs. recurring costs A £8,000 equipment purchase will crater your net margin for the month you paid it. Separate one-off capital costs from recurring operating expenses for a fair picture.

---

The Fast Route: Let AI Do It

Calculating profit margin from a PDF bank statement is doable manually — but it is tedious, error-prone, and takes time you probably do not have.

Raavue lets you upload your PDF bank statement and receive a complete financial report including:

• Gross and net profit margin
• Month-over-month trend charts
• Expense breakdown by category
• Anomalies and unusual transactions flagged automatically

Start your free 7-day trial → No credit card required. Your first report is ready in under two minutes.