TL;DR — Rebate tracking means keeping a simple monthly spreadsheet of your traded volume, the cashback you receive, and your net cost after rebates. It takes about ten minutes a month and turns a vague sense of "cashback helps" into a clear number you can act on. If you trade forex or gold regularly, that number is often the difference between a strategy that works and one that quietly bleeds.
Why Rebate Tracking Beats Checking Your Balance
Most traders only look at their account balance. That tells you the outcome, not the cause. A balance can rise while your trading costs quietly eat into every winner, or fall while your cost per lot is actually improving.
Rebate tracking separates three things that normally blur together: how much you traded, how much you paid in spread and commission, and how much came back to you as cashback. Once those are separate columns, you can see whether a bad month was bad trading or just expensive trading.
It also protects you from a common trap: assuming a rebate is working without ever verifying it. Brokers and rebate providers both report numbers, and occasionally they do not match. A spreadsheet is how you catch that early, while it is still a small discrepancy rather than six months of missing payments.
What to Log Each Month
You do not need accounting software. A single sheet with one row per month and a handful of columns is enough. Here is a practical starting set:
- Month — one row per calendar month, kept in order.
- Lots traded — total standard lots, taken from your broker's statement.
- Gold lots vs forex lots — split them if you trade both, because rebate rates per lot usually differ.
- Gross cost — spread plus commission, in your account currency, as reported by the broker.
- Rebate received — the cashback actually credited to you that month, not what you expected.
- Net cost — gross cost minus rebate.
- Net cost per lot — net cost divided by lots traded. This is the number that matters most.
If your broker reports costs in pips rather than currency, convert them using your average position size. It is a rough conversion, but consistency matters more than precision here.
Building the Sheet in Ten Minutes
Open any spreadsheet tool and set up the columns above as headers in row one. Leave a few blank rows at the bottom for future months. Then add three simple formulas:
- Net cost = gross cost minus rebate received.
- Net cost per lot = net cost divided by lots traded.
- Rebate coverage = rebate received divided by gross cost, shown as a percentage.
That third figure is quietly the most useful. It tells you what share of your trading cost is being returned. If it drifts downward month after month, something changed — a broker adjusted spreads, your instrument mix shifted toward higher-cost pairs, or your rebate is not being credited correctly.
Keep a second small sheet for notes: broker name, account type, and the date you last checked your rebate rate. Rates move, and a note stops you from comparing months that were priced differently.
In our view — the traders who get the most from cashback are rarely the ones chasing the highest advertised rate. They are the ones who know their own net cost per lot to the decimal, because that number tells them when to negotiate, when to switch, and when to leave things alone.
A Hypothetical Month, Worked Through
Suppose, for example, you trade 40 standard lots in a month, split evenly between gold and major forex pairs. Say your gross cost averages out to a modest figure per lot, and your rebate returns a meaningful portion of it. The exact numbers will differ for you, but the structure is what matters:
| Line | Example figure | What it tells you |
|---|---|---|
| Lots traded | 40 | Your activity level for the month |
| Gross cost | Hypothetical total | What the broker charged you |
| Rebate received | Hypothetical total | What came back to you |
| Net cost | Gross minus rebate | Your true trading bill |
| Net cost per lot | Net cost ÷ 40 | The number to compare across months |
Run this for three months and you will see a pattern. Most traders discover that one instrument or one strategy is responsible for a disproportionate share of their costs. That is actionable information.
Reconciling Your Rebate Against the Broker Statement
Once a month, put your broker statement and your rebate record side by side. Check three things:
- Does the lot count on your rebate record match the lot count on the statement?
- Did the rebate arrive in the expected timeframe, or was it delayed?
- Is the rebate calculated on the same instruments you actually traded?
Small mismatches are common and usually harmless — a trade closed just after midnight, a swap-adjusted lot, a currency conversion. Large or repeated mismatches are worth raising with your rebate provider. Having the spreadsheet means you can raise it with dates and figures rather than a general complaint.
It also helps to understand the mechanics before you reconcile. If you are new to this, our guide on how forex cashback works explains where the money comes from and why it is paid per lot rather than per trade.
Using the Numbers to Make Decisions
A completed spreadsheet answers questions that are otherwise guesswork. Should you switch brokers? Compare your net cost per lot against what is available on the rate board before deciding. If you are already on a competitive rate, switching may not be worth the disruption; if you are not, the gap will be obvious in the numbers.
Should you change your instrument mix? If gold lots are consistently cheaper per lot after rebate than your forex pairs, that is a fact worth knowing, not a reason to abandon your strategy. Cost is one input among several.
Are you leaving money on the table? The switch calculator estimates how much cashback a trader with your volume might be missing on a different arrangement. Feed it the lot numbers from your spreadsheet rather than a rough guess.
Finally, remember that a per-lot rebate lowers your real cost on every lot, win or lose. That is the whole point of tracking it: not to celebrate the cashback, but to know your true cost of doing business.
Where to go next
Build the sheet this week, even with rough numbers, and fill in your first row at the end of the month. If you want a head start, check current per-lot rates on the rate board, estimate your monthly cashback with the rebate calculator, and read how cashback works so your spreadsheet reflects reality. You can also browse the full guide library for more on keeping trading costs under control.