In a payment gateway report, a sale is what the customer paid, the fee is what the gateway deducts, and the settlement or payout is the net amount credited to your bank, usually a few days later. The settlement is almost never equal to your sales total, so you need to book each line separately instead of treating the bank credit as your income.
What do the terms mean?
- Sale or payment: an order the customer paid for, at the full amount.
- Fee: the charge the gateway deducts for processing, often shown with any tax on that fee.
- Refund: money returned to a customer, which reduces what you keep.
- Settlement or payout: the net transfer to your bank for a batch of payments, after fees and refunds. Different gateways use these two words differently, so read the glossary in your own report.
One batch of ten sales
Hypothetical example for a seller of handmade candles. Ten orders were paid on 10 and 11 November.
| Order | Amount |
|---|---|
| Order 1 | ₹1,200 |
| Order 2 | ₹850 |
| Order 3 | ₹2,400 |
| Order 4 | ₹640 |
| Order 5 | ₹1,500 |
| Order 6 | ₹990 |
| Order 7 | ₹3,200 |
| Order 8 | ₹450 |
| Order 9 | ₹1,100 |
| Order 10 | ₹1,670 |
| Total sales | ₹14,000 |
Check: 1,200 plus 850 plus 2,400 plus 640 plus 1,500 plus 990 plus 3,200 plus 450 plus 1,100 plus 1,670 is 14,000.
How does a settlement of ₹12,820 come out of ₹14,000?
Say the customer for Order 2 asked for a refund of ₹850, and the report shows a fee line of ₹330 for the batch, including any tax shown on the fee. The settlement is sales minus refund minus fee: 14,000 minus 850 is 13,150; minus 330 is 12,820. On, say, 14 November, ₹12,820 reaches the bank account, three or four days after the sales. These amounts are invented for illustration; your fee will appear as whatever your gateway charges.
| Line | Amount | How to book it |
|---|---|---|
| Sales | ₹14,000 | Income, on the date of each sale |
| Refund | ₹850 | Reduces sales, on the refund date |
| Gateway fee | ₹330 | Expense, such as Payment gateway fees |
| Settlement | ₹12,820 | Not income: the bank credit you tick against the three lines above |
Why not just record the ₹12,820 as sales?
Because your sales would be understated by ₹1,180, and your fees and refunds would vanish from view. You would also lose the link between each order and the customer. Record the gross sales, record the fee and the refund as their own lines, and use the settlement only to confirm the bank credit.
What if the settlement does not match?
- Check that every order in the batch is on your list and none is duplicated.
- Look for refunds or chargebacks dated after the sale but inside the batch.
- Confirm whether a reserve or held amount was kept back, as stated in the report.
- Compare the credit on your bank statement with the settlement figure; the date can differ from the report date.
Timing is the other trap. Orders paid on 31 March may settle on 2 or 3 April, which falls in the next financial year. Decide in advance whether you book by sale date or by settlement date, write the rule down, and your yearly totals will not shift depending on weekends and bank holidays in between.
Where does a tracker help?
The fee and the bank credit are what show on the bank side. If you import your statement into SpendixAI and keep a category for gateway fees, your running cost of collecting payments appears in the reports. Sales and refunds remain a matter for your own order list. Rates and tax treatment of gateway fees are for your CA to confirm.
Every settlement day
- Open the report and note the batch's sales, refunds, fees and settlement.
- Check that sales minus refunds minus fees equals the settlement.
- Find the bank credit and note its date.
- Book the fee and refund lines.
- Mark the batch as reconciled.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
