Why does your online store’s bank deposit differ from its sales?
A gateway payout may combine customer payments with refunds, fees, disputes and other adjustments. It may also cover a different period from your sales report. Match the payout’s supporting transactions to the bank deposit before treating the difference as missing money.
Your store dashboard shows AED 20,000 in sales, but a smaller amount reaches your bank. That difference needs an explanation, but it does not automatically mean a payment has disappeared.
A structured payment gateway settlement reconciliation UAE process helps you trace customer payments through the gateway and into your business bank account.
Understand the Three Figures You Are Comparing
Start by separating store sales, gateway activity and bank deposits.
Store sales reports describe activity recorded by your e-commerce platform. Check whether the selected report includes unpaid orders, cancellations, discounts, delivery charges or other components.
Gateway reports show payment activity and movements within the gateway account. These can include payments, refunds, fees and adjustments.
Bank statements show the money credited to your bank account.
These reports answer different questions. Comparing their totals without checking definitions and dates can create an apparent mismatch.
Stripe, for example, distinguishes payment exports from financial reports used to reconcile balance movements, including charges, payouts, refunds, fees and disputes. support.stripe.com
1. Collect the Gateway Report for the Payout
Begin with the deposit you want to investigate.
Record its amount, currency, bank reference and credit date. Then locate the corresponding payout or settlement in your gateway dashboard.
Download the available settlement statement and transaction breakdown. Also retain the relevant store export and bank statement.
Choose the report appropriate to your payout method. Stripe explains that its payout reconciliation report supports automatic payouts; it cannot directly associate individual transactions with manual payouts in the same way. support.stripe.com
For your broader monthly records, use KIF’s existing Monthly Bookkeeping Document Checklist in the UAE. The settlement review should sit alongside those records rather than replace them.
2. Match the Payout Batch to the Bank Deposit
Use the payout identifier and bank reference where available. Matching only by amount is less reliable when several deposits have identical values.
Check:
- Merchant account and receiving bank account.
- Payout identifier.
- Settlement currency.
- Reported payout amount.
- Payout status.
- Expected and actual arrival dates.
Keep the gateway’s settlement date separate from the bank’s credit date.
If you cannot locate the payout, review adjacent reporting dates and the report’s time zone. Checkout.com specifically advises checking dates on either side before concluding that a settlement is missing. Checkout.com
Do not assume every gateway follows the same settlement schedule.
3. Identify the Components Behind the Net Amount
Once you find the batch, examine its detailed movements.
Possible components include:
| Component | What to verify |
| Customer payments | Successful amounts included in this settlement |
| Refunds | Refund reference, amount and processing date |
| Processing fees | Supporting fee details and contractual basis |
| Disputes or chargebacks | Case reference, status and related deductions |
| Reserves or holds | Amount retained and supporting explanation |
| Reserve releases | Previously retained funds returned to the balance |
| Currency conversion | Original currency, settlement currency and conversion details |
| Other adjustments | Description and supporting evidence |
Treat these as investigation categories. Not every payout contains every item.
Also check how fees are collected. Checkout.com explains that it deducts fees from the available balance as they are charged, rather than only when a settlement is generated. Checkout.com
That makes the provider’s transaction breakdown more useful than estimating fees from the bank deposit alone.
4. Work Through a Hypothetical Settlement Example
The following figures are illustrative. They are not a gateway’s published pricing or a recommendation about accounting or VAT treatment.
Assume an online store reports AED 20,000 in successfully collected customer payments for a selected period. The supporting gateway records explain the movements as follows:
| Movement | Amount |
| Customer payments collected | AED 20,000 |
| Refunds processed | − AED 1,000 |
| Gateway fees | − AED 600 |
| Dispute deduction | − AED 400 |
| Amount retained as a reserve | − AED 500 |
| Amount remaining for a later payout | − AED 2,000 |
| Expected bank deposit | AED 15,500 |
The difference between collections and the deposit is AED 4,500. In this example, each part has a separate explanation.
The AED 2,000 awaiting payout is different from a fee. The reserve also needs separate tracking. Neither should be treated as an expense simply to make the bank reconciliation balance.
This simplified example assumes no opening gateway balance, currency conversion or other movements. Real reconciliations must include them where relevant.
5. Investigate Missing Evidence
An unexplained amount is an exception requiring follow-up.
If the report shows a refund, find its payment and refund references. If a deduction is labelled “adjustment,” request an explanation through the gateway’s official support channel.
Use specific questions:
“Please provide the transaction breakdown supporting payout [reference] and explain the adjustment of [amount].”
For an expected deposit that has not arrived, check the payout status and destination details. Ask the provider for any available transfer reference, then follow up with the bank where appropriate.
Do not create a balancing entry merely because supporting information is unavailable.
6. Send Exceptions for Accounting Review
Maintain a short exception register:
| Reference | Issue | Evidence needed | Owner | Status |
| ______ | Unexplained deduction | Adjustment breakdown | ______ | Open |
| ______ | Refund without order match | Original payment record | ______ | Open |
| ______ | Payout not received | Transfer reference | ______ | Open |
Send your accountant the register together with the original exports and supporting records.
Accounting review should determine the appropriate classification and period. A successful payout match does not, by itself, establish revenue recognition or VAT treatment.
Where fees, refunds or cross-border transactions raise tax questions, provide the underlying documents for separate assessment.
7. Review the Gateway Balance at Month-End
Matching bank deposits is only one part of the process. Also reconcile what remains with the gateway.
A useful starting relationship is:
Opening balance + credits − debits − payouts = closing balance
Check the provider’s definitions to avoid counting an item twice. Where reports separate pending, available and reserved balances, review those categories consistently.
This helps distinguish money still awaiting settlement from genuinely unexplained differences.
How KIF Consultancy Can Help
KIF Consultancy supports UAE businesses with accounting and bookkeeping. KIF Consultancy
For an online store, provide the gateway reports, store exports, bank statements and exception register when discussing reconciliation support. These records help focus the review on identifiable transactions and outstanding evidence.
FAQs
Should my bank deposit equal my store’s daily sales?
Not necessarily. Settlement periods, deductions and the store report’s definitions may differ.
Can I record the entire difference as gateway fees?
Only classify amounts when the evidence supports that treatment. Investigate timing differences, refunds and other adjustments separately.
What if a refund relates to an earlier sale?
Link it to the original payment and identify where it appears in the gateway records. Send the timing and classification question for accounting review.
Does reconciliation determine VAT treatment?
No. Matching cash movements is separate from assessing the underlying transaction and supporting tax documents.
What should I send my accountant?
Send the settlement breakdown, relevant store transactions, bank statement and a list of unresolved differences.
