Skip to main content
Early accessBeta, invite only since 1 Nov 2026. A person reads every application.Apply for an invite
Demystify OS

Why does my payment gateway settlement not match my bank statement?

A settlement is the orders paid, less fees, taxes on fees, refunds, chargebacks and any amount held back, credited in batches on later days. To match it, take the settlement report, rebuild the gross orders it covers, subtract each deduction, and compare the result with one bank credit.

Who asks this: An online seller, trainer or service business in India who sells through a payment gateway or marketplace, sees fewer rupees in the bank than the sales dashboard shows, and cannot say where the difference went.

The steps

  1. 1. Download the settlement report, not only the sales report

    The sales dashboard shows what customers paid. The settlement report shows what the provider sent to you, with a line for each deduction. Download the report for the period and note the settlement batch number and the credit date. Without it, you are guessing.

  2. 2. Find the one bank credit for each settlement

    Match each settlement to a single credit in the bank statement using the amount, the date and the reference. Settlements are paid in batches on the cycle agreed with your provider, so the credit date follows its schedule and the banking calendar, and instant options may differ. Check the settlement report and your account settings. Write the reference of each batch next to the credit.

  3. 3. Rebuild gross sales for the batch

    Add the orders in the settlement and compare with your own order or invoice list for the same dates. A difference here usually means an order was cancelled, counted twice or paid on another channel, or that it fell on the other side of the batch cut-off and belongs to the neighbouring batch (see the timing step). Fix this before looking at fees.

  4. 4. List each deduction separately

    Write the provider's fee, the tax charged on the fee, refunds, chargebacks, dispute amounts and any reserve or hold on the report. Each should have its own line. Record the fees as an expense through your accountant, not by netting them against sales.

  5. 5. Account for timing

    An order paid on the last day of the month may settle in the next. List the orders paid but not yet settled at month end. This is money owed to you by the provider, and it should show as such, not as a missing amount.

  6. 6. Handle refunds and disputes by order

    For each refund or dispute, find the order and the customer, and check that your records show the same. A chargeback for an order you already delivered needs your evidence to the provider, within their time window.

  7. 7. Prove the match and file it

    For each batch, write: gross orders, less deductions by type, equals bank credit. Keep one line per batch in a sheet. If a batch does not match, ask the provider's support with the batch number, and note the date you asked.

A worked example

illustrative

A yoga-class business in Bengaluru sells online passes. For one batch the dashboard shows ninety-two thousand rupees of orders over three days. The bank credit is eighty-nine thousand one hundred rupees. The settlement report shows gross orders of ninety-two thousand, a provider fee of one thousand eight hundred and forty, tax on the fee of three hundred and thirty-two, and a refund of seven hundred and twenty-eight. Gross less these three deductions equals the credit exactly. The accountant records the fee and the tax separately, and the refund against the right customer.

What goes wrong

  • Only the sales dashboard is used, and the fees and refunds look like missing money.
  • Fees are netted against sales, so revenue and costs are both understated.
  • Orders paid at month end are not tracked as owed by the provider, and the books look short.
  • A chargeback arrives and nobody answers in time, so the money is lost.
  • Several batches are credited on the same day and are matched as one, hiding an error in one of them.
  • A reserve held back by the provider is never followed up and the money sits for months.

How Demystify OS helps

  • Close the counter honestlyAvailable

    Shows a close report that separates the day's takings by cash, UPI and other tenders, which is the same idea of keeping each channel's money separate until it reaches the bank.

  • Weekly summaryEarly access

    A weekly summary of results and open items gives a fixed place to list settlements that have not arrived or do not match.

  • Mysty WorkersEarly access

    Mysty Workers can be set up with you to read a settlement report and a bank statement you share, match each batch to a credit, list the deductions and ask a question for each mismatch. A settlement-matching routine is not yet a standard catalogue entry.

What it does not do. Demystify OS does not connect to a payment gateway or your bank, raise disputes on your behalf or move money; it works from the reports you share, and a person decides each exception.

Questions people ask

Why is the money credited later than the sale?

Timing follows the settlement cycle agreed with your provider and the banking calendar, and some providers offer instant options that differ. Check your settlement report and account settings. A gap is normal. What matters is that you can list orders paid but not yet settled at the end of each month, so the amount is accounted for.

Where do I record the gateway fee?

As an expense, through your accountant, with the tax on the fee shown as the accountant advises. Do not subtract it from sales. Keeping sales at the full order value gives you a true picture of revenue and of what the channel costs you.

What is a held-back amount or reserve?

Some providers keep part of the money for a period to cover refunds or disputes. It should appear on the settlement report with a release date. Note it, and ask the provider if it does not come back when promised.

A customer says they paid but I have no order. What now?

Ask for the transaction reference or a screenshot, then look in the settlement report and in the provider's dashboard. A payment that was taken but not linked to an order is common when a page closes early. The provider can usually trace it, and you can refund or fulfil.

How often should I reconcile a gateway?

Weekly if you have many orders, otherwise at least monthly before the books close. A short match each week keeps each batch small and the cause of any difference fresh.

Apply for the beta.

Demystify OS is invite only, and a person reads every application.

Apply for the beta