To reconcile a commission statement with your bank credit, list each line of the statement, add them up to the statement's net, then check that the bank credit equals that net. Any lines that were not paid, or deductions shown at the bottom, explain the gap. Unpaid lines go on a carry-forward list for the next statement.
What does a statement usually contain?
Layouts differ by company, so rely on your own. Expect lines for each sale or policy, perhaps adjustments for returns or cancellations, and a total or net payable at the end. Check whether the statement shows what period it covers and which payout it belongs to.
How do I match line by line?
- Copy each statement line into your sheet with the order, customer code or reference and the amount.
- Add any adjustments, with negative amounts for reversals.
- Total the lines and compare with the statement's own net figure. If they differ, the problem is in the statement, so query it.
- Find the bank credit and compare it with the net.
- Mark each line as Paid, Held or Deducted, and carry forward anything unpaid.
What does a worked example look like?
| Line | Statement amount in ₹ | Result |
|---|---|---|
| Sale A | 1,200 | Paid |
| Sale B | 850 | Paid |
| Sale C | 2,400 | Paid |
| Adjustment for a return | -500 | Deducted |
| Sale D | 1,500 | Paid |
| Sale E | 300 | Held to next statement |
Hypothetical figures. The lines add to 1,200 + 850 + 2,400 − 500 + 1,500 + 300 = ₹5,750. The bank credit is ₹5,200. The difference is ₹550.
Looking back at the statement, Sale E for ₹300 is marked held, and at the foot there is a deduction of ₹250 for a charge the company applies. So 5,750 − 300 − 250 = 5,200, and the credit is fully explained. Sale E for ₹300 goes on the carry-forward list.
How do I keep a carry-forward list?
Create a second tab or a block with Statement month, Line, Amount and Date cleared. Whenever a held line is paid, fill in the date. If it has not appeared after two statements, send a written query. A formula for the open total, with Date cleared in column D and Amount in C, is =SUMIFS($C$2:$C$200, $D$2:$D$200, "="). The "=" criterion matches cells that are completely empty, so keep the date cell empty until the line is paid. A space or text there would stop it counting as open.
What if the credit is higher than the statement?
That is worth checking too. It might include an earlier held line, a bonus from another statement or an error. Do not assume it is a gift. Note it, confirm with the company, and keep the explanation.
Where does the bank statement come in?
The credit is on your bank statement, along with every other credit and debit. In SpendixAI, you pick the account, upload the statement, review the rows and save. That gives you one list of credits to tick against your statements. The company's line-by-line detail stays in your sheet.
How should I treat adjustments for returns or cancellations?
Adjustments are negative lines, and they are easy to miss because the statement may show them in a different section. Enter each one with the sale it relates to, even if that sale was in an earlier month. Then your total for the original sale and the reversal together show what you really kept. If an adjustment relates to a sale you do not recognise, ask for the reference before accepting it.
Each payout cycle
- Copy the statement lines in a day or two after receiving them
- Check the arithmetic of the statement itself
- Match the bank credit
- Update the carry-forward list
- Raise a query for anything older than two statements
Useful ideas start with a clearer picture of your own spending.
Explore your reports

