Payout reconciliation

Every payout, matched to your bank

RAMZA reads your store orders, payout files and bank statement, matches every transaction, and posts payments, gateway fees and VAT to books. No more month-end spreadsheets.

Reconciled and postedAED
Gross invoiced
413,466.00
Gateway fees
−24,107.63
Exchange differences
−3,100.66
Received in bank386,257.71
  • VAT on fees reclaimedAED 763.62
  • Clearing balance0.00

324 orders · 5 gateways · 214 settled in SAR, QAR, KWD or OMR

Tabby and Tamara pay you net of fees, so the amount in the bank never matches the invoice.

A refund or chargeback next month reopens a payout you already reconciled.

Five gateways, two currencies, one bank account, and someone matching it by hand every month.

The difference

Dashboards show you the gap.
RAMZA closes it.

Reporting tells you the number is wrong. Reconciliation makes it right, line by line, until the bank, the gateway and the books agree.

Walkthrough

See a month close in under a minute

Not a demo reel. The same month, three times: before RAMZA, while it runs, and after the books are closed.

18 unexplained

AED 1,571,770.40 sitting in the bank, unattributed

Eighteen payouts. Nothing ties out.

Five gateways paid you net of their fees, so not one deposit equals an invoice. The bank shows eighteen credits and no way to tell which orders they settle. Somebody opens a spreadsheet.

We will run this against one real month of your own payouts, free, before you decide anything.

How it works

  1. 1

    Connect your stores.

    Shopify and WooCommerce orders sync automatically.

  2. 2

    Send your payout files.

    Upload them, or we pull them for you.

  3. 3

    Match to the bank.

    Every payout is tied to a bank credit, including FX differences between AED and SAR.

  4. 4

    Close in Zoho.

    Payments are posted at invoice total, fees go to bank charges, VAT on fees is recorded. Invoices flip to Paid.

  1. Order
  2. Gateway
  3. Payout
  4. Bank
  5. Books

One orchestrator, four specialists

RAMZA is not one model doing everything. An orchestrator reads your payout file, bank statement and orders, then hands each job to the specialist that owns it.

  1. Orchestrator

    Reads the payout file, the bank statement and your orders. Splits the work and routes it.

  2. Reconciler

    Ties every payout to a bank credit, including the FX difference between AED and SAR.

  3. Bill handler

    Posts each gateway fee to bank charges and records the VAT on the fee.

  4. Consolidator

    Closes invoices in Zoho at invoice total and rolls up the AED and SAR ledgers.

  5. Reporter

    Writes the 48-hour payout audit and the monthly reports, with every exception listed.

The screen

The month, on one screen

Every gateway payout lined up against the bank credit that paid it. Matched rows settle green. A variance is the gap RAMZA is still chasing, not a number you have to go find.

Illustrative figures. Five gateways, one bank account, one month.

ReconciliationMarch 2026

Matched (AED)

1,486,220.40

16 of 18 payouts

Awaiting bank

84,310.00

1 payout in transit

Gateway fees

41,905.62

incl. VAT on fees

Open variance

1,240.00

1 payout to review

  • Tabby

    28 Mar · TBY-0318994

    Matched
    Bank credit
    312,480.20
    Payout net
    312,480.20
    Variance
    0.00
  • Tamara

    27 Mar · TMR-772140

    Matched
    Bank credit
    268,905.00
    Payout net
    268,905.00
    Variance
    0.00
  • Telr (SAR)

    26 Mar · TLR-2240871

    FX variance
    Bank credit
    195,332.40
    Payout net
    194,092.40
    Variance
    1,240.00
  • Stripe

    25 Mar · po_1Qx8mLB

    Matched
    Bank credit
    148,770.60
    Payout net
    148,770.60
    Variance
    0.00
  • COD, Aramex

    24 Mar · ARX-CO-44182

    Matched
    Bank credit
    96,214.00
    Payout net
    96,214.00
    Variance
    0.00

18 payouts · 1,204 orders · AED 1,486,220.40 matched to the bank

What your accountant sees

Payments are recorded the way your accountant would do it by hand: full invoice amount, fee split out, VAT captured. Nothing is left hanging as a residual.

Illustrative figures. One invoice, one Tabby settlement.

Invoice

Tabby settlement, March 2026

Paid
Invoice total
AED 1,250.00
Gateway fee, TabbyBank charges
− AED 38.45
VAT on feeInput VAT
− AED 1.92
Received in bank
AED 1,209.63

The invoice closes at its full total. The fee and its VAT are posted to their own accounts, so nothing is left as a residual.

Every line gets an account and a date

Every payout line is proposed with an account and a date before anything is booked. You see the suggestion, then watch it post.

Proposed postingsMarch 2026
  • Tabby settlementPayments received04 MarAED 18,420.50
  • Gateway fee, TabbyBank charges04 MarAED 584.00
  • VAT on gateway feeInput VAT04 MarAED 29.20
  • FX on SAR settlementRealised FX loss06 MarAED 42.00
  • COD courier remittancePayments received09 MarAED 29,882.00
  • Refund, order SA-4471Refunds payable11 Mar−AED 150.85
6 lines posted to Zoho. You approve the batch, nothing books on its own.

RAMZA copilot

Ask why the money is short. The copilot traces a payout back through every order, fee and refund and tells you where the gap is.

    1. Payout SAR 24,180.00 covers 51 orders, gross SAR 25,090.00.
    2. Tamara fee SAR 723.00 and VAT on fee SAR 36.15 account for SAR 759.15.
    3. Two orders (SA-4471, SA-4488) were refunded after the cutoff: SAR 150.85 held back.
    4. 25,090.00 − 759.15 − 150.85 = 24,180.00.

    Nothing is missing. The SAR 300 you expected is a fee-plus-VAT line of SAR 759.15 offset by SAR 150.85 of post-cutoff refunds. RAMZA books the fee to bank charges and carries the two refunds to next month's payout.

Illustrative. The copilot works from your reconciled data, not a chatbot.

Reconciled books are the deliverable

Matching payouts is the work. These are the two things it buys you, and both of them have a deadline attached.

Tax ready

Tax-ready books

Every gateway fee is posted to bank charges with the VAT on the fee recorded as input tax, so the return is built from the ledger instead of reconstructed from statements the week it is due.

  • Gateway fees and the VAT on them split out per payout
  • AED and SAR held separately, FX difference booked
  • Nothing parked in a suspense or residual account
Investor ready

Investor-ready financials

Revenue is recognised against the order that earned it, not the day the gateway happened to settle, so a month closes once and stays closed when a payout lands late.

  • Revenue on order date, cash on payout date, both available
  • Cross-month payouts split rather than dropped
  • Every exception listed with the reason it was left open
Review

Software does the matching. Senior accountants check it.

Automation is right most of the time, and the month you need it is the month it isn't. Every close passes through a layered review before anyone relies on the numbers.

  1. Layer 1

    The engine matches

    Payouts tied to bank credits, fees and VAT split to their accounts, FX between AED and SAR resolved. Anything it cannot tie with confidence is held, not guessed.

  2. Layer 2

    Exceptions are worked

    Partial captures, post-cutoff refunds, invoices with no order behind them. Each one is resolved by hand and the reason is written next to it.

  3. Layer 3

    A senior accountant signs off

    Before the month is called closed, a qualified accountant reviews the postings, the fee and VAT treatment, and every exception left open, then tells you what needs a decision.

Works with what you already run

No gateway switch, no new store platform, no re-keying. RAMZA reads what these already produce and posts the result into your books.

Payments

Every payout file, including cash on delivery.

Stores

Orders sync on their own, no export step.

Books

Where the matched payment is posted.

What the current process costs you

Four numbers you already know. Everything below is arithmetic on them, not an industry average.

1,500
4
12 h
AED 120

Loaded cost of whoever does it. Your accountant's rate, or your own.

Every year, as things stand

AED 17,280

spent reconciling by hand

Lines to match
18,192
Hours
144
Working days
18
Per month
AED 1,440

1,500 orders plus 16 payout reconciliations is 1,516 lines a month, about 28.5 seconds each at your stated pace. Times twelve.

Your price is set on the free payout audit, against your real volume and gateway mix, and locked for 12 months. No card, no commitment to see it.

Founding partners

We're onboarding a small number of Gulf stores this quarter. Founding partners get setup done for them and pricing locked for 12 months.

Price lock
12 months
Setup
Done for you
Time to live
Under a week

One price by transaction volume. VAT on fees and multi-currency included.

Written up, in detail

28 pages on how payout reconciliation actually works, gateway by gateway and market by market. No sign-up, no gate.

By gateway

How each payout file actually settles, and what it takes to close it.

Compared

Where the alternatives hold up, and where they stop.

By market

VAT, currency and the rules that differ once you cross a border.

Questions

Free payout audit

Send us last month's payout files and bank statement. Within 48 hours you get a report of every unmatched payout, unbooked gateway fee, and invoice stuck on overdue. We sign an NDA before you send anything.

Gateways you use

We sign an NDA before you send any files.

RAMZA — Payout reconciliation for Gulf e-commerce