Expense categories

How to track payment gateway fees month by month

Track payment gateway fees each month by reconciling settlements, checking fee share of sales and spotting rate or mix changes. Worked month in rupees.

Editorial illustration for How to track payment gateway fees month by month

To track payment gateway fees, reconcile every settlement to your bank, record gross payments and fees as separate lines, and calculate total fees as a share of the month's online sales. The share is the number to watch. It can change when the mix of payment methods changes, or when a plan changes, even if sales stay level.

What do you record from each settlement?

  1. Settlement date and the period it covers.
  2. Gross amount collected from customers.
  3. Fees, with the tax charged on them shown separately.
  4. Refunds and chargebacks deducted.
  5. Net amount credited to the bank.

Do the reconciliation on the day the settlement lands. A gap you notice that week is easy to chase. One you notice after a quarter often needs a pile of reports.

How often does the cost arrive?

ItemRhythmWhat to track
Per-transaction feeWith each settlement, daily or weeklyFee as a share of gross
Refund and failure chargesIrregularCount and reason
Monthly planSame date each monthWhether you still need it
Tax on feesWith each settlementKeep it as its own column

A hypothetical month, with numbers

Say a shop has four weekly settlements. Gross collected: ₹40,000, ₹55,000, ₹35,000 and ₹70,000. Fees charged: ₹880, ₹1,210, ₹770 and ₹1,540.

Gross for the month is ₹2,00,000 (40,000 plus 55,000 plus 35,000 plus 70,000). Fees are ₹4,400 (880 plus 1,210 plus 770 plus 1,540). That is 2.2 percent of gross. Each week works out to the same 2.2 percent (880 divided by 40,000 is 0.022), so nothing changed.

Now say the next month shows ₹2,40,000 of gross and ₹5,760 in fees, which is 2.4 percent. The 0.2 point difference on ₹2,40,000 is ₹480. It is small, but it started somewhere: perhaps more payments through a method that costs more, a plan change or extra refund charges. Check the settlement report before you assume the provider raised its rate.

How do you spot a change?

  • Fee share moving week to week without a change in your sales channels.
  • A new line item, such as a refund handling fee, that was not on earlier reports.
  • A settlement that lands later than usual. Delays do not change the fee but they affect your cash.
  • A mismatch between the payout and the report, which you should raise with the provider promptly.

What does a sensible review look like?

Weekly: tick each settlement against your bank. Monthly: compute fee share and compare it with last month. Quarterly: read your plan terms again and decide whether another plan or provider would suit your payment mix better. Compare in writing, with the same assumptions, and give a test period before you move everything.

Keep a note of any day a settlement was held or delayed, and why. A delay by itself is not a cost, but if it happens often it affects how much cash you can count on to pay suppliers, and it may be a reason to ask the provider for faster settlement or to review your plan.

Round the process off with a quarterly look at the plan itself. If your volume has grown or shrunk a lot, the plan that suited you at the start may not suit you now, and any change should be made in writing with the provider, with a note in your records of the date it began.

Finally, keep a column for payment method if your report provides it. A month where one method dominated explains a fee share change on its own, and you will be able to explain the number to yourself, your partner or your accountant.

Where does an app help?

Import your bank statement into SpendixAI to capture each settlement deposit, then add the fee and tax from the report as manual expenses. Attach the report as a receipt. On Pro, a monthly budget for Gateway fees and the Report builder, filtering and grouping by month, make the trend easy to see.

Month-end checklist

  • Every settlement matched to the bank.
  • Fees and tax recorded separately.
  • Fee share computed.
  • Refund fees reviewed.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports