How to Audit Your MT4 Statement for Hidden Costs
Most traders check their profit and loss line and stop there — but if you want to know where your money is really going, you need to audit your MT4 statement for hidden costs like spread, swap, commission and slippage, not just the final balance. It takes about twenty minutes with a spreadsheet and it can permanently change how you pick brokers and instruments.
Why Your MT4 Statement Hides More Than It Shows
The default MT4 statement (Account History → Report) shows profit, but it buries the costs that produced that profit. Spread is baked invisibly into your entry price. Swap appears as a single "Swap" column that rarely gets summed. Commission, if charged separately, sits in its own column and is easy to skim past. Slippage — the gap between the price you clicked and the price you got — doesn't appear anywhere at all.
This matters because two accounts can show the same headline P&L while one is bleeding far more in costs than the other. A scalper running 40 trades a week on a 1.2-pip average spread pays a completely different bill to a swing trader holding three positions a month — yet both might glance at the same "net profit" figure and assume costs are irrelevant.
Auditing forces you to separate skill (was the trade idea right?) from cost drag (how much did the broker's pricing structure eat into that idea?). Without this split, you can't tell if a losing month was bad strategy or just an expensive account. This is exactly the gap PipTax's [cost audit tool](/audit.html) is built to close — but you can do a first-pass manual version yourself, and you should, because it teaches you what the numbers actually mean.
Step 1: Export the Right Report
Before you can analyse anything, get a clean, complete export:
- In MT4, go to Account History, right-click, and select Save as Report (HTML) or Save as Detailed Report if available.
- Set the date range to cover at least the last 3 months — one month is too small a sample, especially for swap and slippage patterns.
- If you trade multiple symbols, don't filter yet; you want the full picture first.
- Export as CSV instead of HTML if you're comfortable with a spreadsheet — it's far easier to sort and sum.
Do this for every live account you run, including any demo-to-live comparisons you're testing. If you trade with more than one broker (say Pepperstone for scalping and IG for longer-term positions), export both separately — cost profiles differ by broker and by account type, and averaging them together will just hide the story you're trying to find.
Step 2: Separate the Four Cost Categories
Once you have the raw data in a spreadsheet, add columns to isolate each cost type rather than looking at net profit alone:
1. Spread cost — estimate using (entry price − mid-market price at execution) × lot size. If you don't have tick data, approximate using your broker's typical spread for that symbol/session from the [rates page](/rates.html). 2. Commission — sum the commission column directly; MT4 usually reports this per trade already. 3. Swap/rollover — sum the swap column separately for long vs short positions; swap is often asymmetric and can quietly dominate costs on held positions. 4. Slippage — compare your requested price (if you logged it, or if using an EA with logging) against the actual fill price in the statement.
| Cost type | Where it hides | How to isolate it | |---|---|---| | Spread | Built into entry price | Compare fill vs mid-price | | Commission | Own column, often skipped | Sum per symbol/month | | Swap | Single column, rarely totalled | Sum by long/short direction | | Slippage | Not shown at all | Compare logged request vs fill |
Step 3: Total Costs by Symbol and Session
Raw totals tell you how much you paid; breaking it down by symbol and trading session tells you why. Build a pivot table with symbol as rows and cost type as columns, then add a session column (London, New York, Asia overlap) based on trade open time.
Patterns worth hunting for:
- A single symbol dominating your cost bill — often a pair with wider typical spreads (exotics, or majors traded outside their main session).
- Swap eating into "free" swing trades — a trade that looks profitable on price movement alone can be quietly negative after several days of adverse swap.
- Session-dependent slippage spikes — many traders unknowingly place trades right at rollover or during low-liquidity Asian hours, where spreads widen and fills slip more.
This is also where account type starts to matter. A standard account with no commission but a wider spread markup can cost more per lot on high-frequency strategies than a raw/ECN account with commission but tighter spread — the only way to know for your own trading is to run both totals side by side.
Step 4: Turn Cost-Per-Trade Into Cost-Per-Strategy
Once you have totals, convert them into a per-trade and per-lot average. This is the number that actually matters for decision-making:
- Cost per round-turn lot = total costs ÷ total lots traded.
- Cost as % of average trade risk — if you risk £50 per trade and average £6 in spread+commission+swap, that's 12% of your risk budget gone before the trade even needs to move in your favour.
- Cost-to-profit ratio — total costs ÷ gross profit (before costs). Above roughly 20-30% for an active strategy is usually worth investigating further.
Scalping and grid-style strategies are the most sensitive to this because trade frequency multiplies every small leak. A swing trader might comfortably absorb a 1-pip spread; a strategy taking 15 trades a day cannot.
Step 5: Cross-Check Against Your Broker's Published Rates
Your statement tells you what you actually paid — but you need a benchmark to know if that's reasonable. Compare your averaged costs against:
- Your broker's live spread and commission schedule (check the account type you're actually enrolled in, not the marketing headline rate).
- Typical swap tables for your traded pairs and direction.
- Comparable account types at other brokers, using PipTax's [broker pages](/brokers/index.html) and the [cost impact calculator](/cost-impact.html) to see how the same trading volume would cost elsewhere.
For example, Pepperstone and IG both publish account-type-specific spread and commission structures — the numbers differ between a standard and a raw/ECN tier, and change with symbol and session. Don't assume the figure quoted on a homepage applies to your exact setup; always check the specific account page or run your volume through the cost tool for a live comparison.
Building a Repeatable Monthly Habit
A one-off audit is useful, but the real value comes from repeating it every month so you can see trends, not snapshots. To make this sustainable:
- Save a template spreadsheet with the four cost columns pre-built, so each new export just needs pasting in.
- Track your cost-to-profit ratio over time — rising costs with flat profit is an early warning sign, not just a curiosity.
- Re-run the audit after any change: new broker, new account type, or new strategy that alters trade frequency.
- Cross-reference against PipTax's [methodology page](/methodology.html) if you want to understand exactly how we calculate comparable cost benchmarks, and browse the [trading school](/school/index.html) for background on spread, swap and slippage mechanics if any term above is unfamiliar.
Learning to audit your MT4 statement properly is a skill you only need to build once — after that, it's a five-minute monthly habit that keeps your broker and your strategy honest with each other. Trading always carries risk, and no amount of cost auditing changes that, but at least you'll know precisely which part of your results is strategy and which part is simply the bill.
Key takeaways
- Your MT4 statement's net profit figure hides spread, swap, commission and slippage — audit each separately to see true cost drag.
- Export at least 3 months of history and break costs down by symbol and trading session to spot patterns.
- Convert raw totals into cost-per-lot and cost-to-profit ratio so you can compare strategies and account types fairly.
- Benchmark your averaged costs against your broker's published rates and PipTax's cost tool, since account type and session both affect real pricing.
- Make auditing a monthly habit, not a one-off exercise, so rising costs get caught early.
- Trading remains risky regardless of cost efficiency — auditing separates strategy performance from account cost, it doesn't remove risk.
Frequently asked questions
- What's the fastest way to audit an MT4 statement without a spreadsheet?
- Export the Detailed Report as HTML and manually sum the Commission and Swap columns for a quick estimate. It's rougher than a spreadsheet breakdown but takes under five minutes and flags obvious problem symbols.
- Does MT4 show slippage anywhere in the statement?
- No. MT4's standard report only shows the final fill price, not your requested price. You'll need trade logs from an EA, a third-party plugin, or your broker's execution reports to measure slippage directly.
- How often should I audit my trading costs?
- Monthly is a good baseline for active traders, and after any change to your broker, account type, or strategy. Swing or position traders can often audit quarterly since trade frequency is lower.
- Is a commission-based account always cheaper than a spread-only account?
- Not always — it depends on your trade frequency and the specific spread markup versus commission rate. Run both scenarios through PipTax's cost tool with your real volume to see which suits your strategy.
- What cost-to-profit ratio should worry me?
- There's no universal number, but if total costs are eating more than roughly 20-30% of your gross profit on an active strategy, it's worth investigating whether your account type or trade frequency needs adjusting.