Skip to main content
HelloBooks.ai home

How to Reconcile Payment Gateway Payouts in the UAE | HelloBooks Gateway payouts arrive net of fees, refunds and chargebacks. How UAE businesses reconcile them to sales, record fees with VAT and keep a clearing account.

Blog · Payroll, expenses and banking

How to reconcile payment gateway payouts in the UAE without losing fees or VAT

An online shop in Dubai takes 600 card payments a month through a payment gateway. The bank receives eight payouts, each a different amount, none matching any single order. Somewhere between the orders and the payouts sit gateway fees, VAT on those fees, refunds, chargebacks and rolling reserves. If you book payouts straight to sales, revenue is understated, fees disappear and input VAT goes unclaimed. This post shows how to reconcile gateway settlements properly using a clearing account, with a worked AED example.

Free Plan with invoices within 200 transactions, bills & quotes — no credit card.

Why payouts never match orders

A gateway collects card payments, waits a settlement period, deducts its fees and any refunds or chargebacks, and pays the net amount to your bank. One payout can cover hundreds of orders across several days. The bank statement shows only the net figure.

The settlement report from the gateway is the bridge. It lists each transaction included in a payout, the gross amount, the fee, any VAT on the fee and the net. Download it for every payout; it is your source document.

Use a gateway clearing account

Treat the gateway like a bank account that holds your money for a few days. Record each sale as normal, with the customer receipt going to a “gateway clearing” account instead of the bank. When the payout lands, move the net amount from clearing to the bank, and post fees, VAT on fees and refunds from clearing as separate lines. If everything is recorded, the clearing account returns to zero, or to the amount of sales not yet paid out.

Our view: any business with more than a handful of card or online payments a week should run a clearing account per gateway. It is the only reliable way to know the fees you actually pay.

Worked example: one weekly payout

Orders paid by card from 1 to 7 October: AED 48,300 including VAT. One refund: AED 1,050. Gateway fees on the gross: AED 1,352.40, plus VAT on the fees of AED 67.62. Net payout on 10 October: 48,300 − 1,050 − 1,352.40 − 67.62 = AED 45,829.98.

Sales are recorded as orders occur, AED 48,300 into gateway clearing. On payout: debit bank AED 45,829.98; debit payment processing fees AED 1,352.40; debit VAT input AED 67.62; debit refunds (or the credit note against the customer) AED 1,050; credit gateway clearing AED 48,300. Clearing returns to zero for that week.

  • Gross sales from your store or invoices, not from the payout
  • Fees and VAT on fees from the settlement report
  • Refunds matched to credit notes
  • Chargebacks recorded as a receivable or loss, with the dispute evidence attached

VAT on gateway fees

Gateway charges are explicit fees for a payment service. Under Article 42 of the VAT Executive Regulation, financial services charged through an explicit fee or commission are generally taxable, so UAE gateways commonly charge 5% VAT on their fees. Collect the gateway’s monthly tax invoice; without it, the input VAT on fees cannot be recovered.

Gateways based outside the UAE may not charge UAE VAT, in which case the reverse charge may apply to the fees you pay. Check each provider’s invoices with your accountant, because the treatment changes the VAT return.

Rolling reserves and chargebacks

Some gateways hold back a percentage of payouts as a rolling reserve, released months later. That money is still yours: move it to a “gateway reserve” receivable rather than treating it as a fee. Chargebacks, where a cardholder disputes a payment, reduce a payout and may come with a fee. Record the disputed amount as a receivable while you contest it, and write it off only if you lose.

Letting the AI do the heavy lifting

HelloBooks has no direct integration with UAE payment gateways or POS systems, so the reconciliation uses general tools: a clearing account per gateway, the bank statement upload and the gateway’s settlement report as an attachment. The AI agent reads the report, proposes the payout entry with fees, VAT and refunds split out, and matches the net amount on the bank statement.

You approve the entry. Ask “what did gateway fees cost us as a percentage of card sales last quarter?” and the agent answers from the fee and sales accounts. If you need a custom clearing report or AI categorisation rules for your gateway’s report format, contact the team at hello@hellobooks.ai.

FAQ

Frequently asked questions

Should I record sales gross or net of gateway fees?
Gross. The customer paid the full price and VAT is due on that. Gateway fees are a separate expense. Recording net understates revenue and loses input VAT on the fees.
What if the clearing account does not return to zero?
Look for payouts not yet received, refunds not recorded as credit notes, chargebacks, or reserves. Investigate any balance older than the gateway’s normal settlement period.
Do cash-on-delivery couriers work the same way?
Yes. Courier COD remittances arrive net of courier charges. Use a clearing account per courier and reconcile each remittance to its delivery report.
How often should I reconcile gateway settlements?
Weekly for busy stores, monthly at minimum. Gateways sometimes make errors, and disputing them is easier when the period is recent.

Start automating your books today

Free Plan with full access to the AI accountant — no credit card, no time limit.

Subscribe to our newsletter

Stay up to date with the latest news and announcements. No credit card required.

By subscribing, you agree to our Privacy Policy.