The Elo Cloud family
EloERP Cloud
Start Free Trial
The compliance differentiator

FBR, ZATCA, MyInvois & UAE e-invoicing — built into every invoice, not a bolt-on. Sell compliantly from day one.

Compliance hub
Ecommerce › Financial reconciliation

Track every unit from booked to banked

A booked order is not revenue. Between the sale and the money hitting your bank sit courier COD remittances, gateway payouts, marketplace settlements, delivery and service fees, withholding tax, refunds, chargebacks and RTO reversals. EloERP follows each unit the whole way and posts every step to a balanced double-entry ledger — so “what was sold” and “what was banked” finally reconcile.

The cash-truth waterfall

Watch gross collapse into what you actually bank

Spreadsheets record the sale value and stop there. EloERP walks every order down the waterfall — from what the courier collected at the door to what clears in your account — and every deduction on the way down is a posted, balanced GL line, not a fudge factor. Amounts are shown in your own base currency.

COD collected by courier¤ 1,000,000
− Courier delivery fee−¤ 62,000
− COD service fee−¤ 18,000
− Withholding tax deducted−¤ 12,000
Net banked — the only number that’s real¤ 908,000

Every line above is a ledger entry. When the courier remits, EloERP posts DR Bank + DR Courier fees + DR WHT receivable, CR Courier COD clearing — the clearing account only zeroes out when the cash truly lands, so an unremitted parcel can never masquerade as banked revenue.

The COD funnel — verified → booked → shipped → delivered

See how many units and how much value survive each stage of the cash-on-delivery journey. Leakage between shipped and delivered is your RTO exposure; leakage between delivered and remitted is your collection risk — both quantified live.

The prepaid track — captured, MDR, refunds, chargebacks, net banked

Card and wallet orders run their own waterfall: gross captured, less the gateway’s merchant discount rate, less refunds and chargebacks, to net banked. Each deduction posts to the ledger so prepaid revenue reconciles to the payout, not to the order value.

A freshness meter on in-transit & clearing balances

Two floating pools never sit still: cash in transit with couriers, and captured payments still clearing at the gateway. A freshness meter flags how stale each balance is, so money that should have cleared days ago rises to the top before it turns into a loss.

Unexplained-variance detection

When a remittance total doesn’t equal expected COD minus known fees and tax, the gap is isolated, valued and queued for review — instead of being silently absorbed into “shrinkage.” Every currency unit is either accounted for or flagged.

A per-courier breakdown

The same waterfall, sliced by carrier: which courier collects fastest, which one charges the most in fees, and which is sitting on the largest unremitted balance right now — so you can steer volume to the partners who actually pay you.

Booked ≠ banked, made visible

One reconciliation dashboard shows total booked, total in flight, total banked and total written off — the four numbers that a founder actually needs, reconciled to the general ledger down to the last unit.

Import, match, post

Turn a courier statement or a gateway payout file into balanced journals

Drop in the file the carrier or processor sends you. EloERP auto-detects the columns, matches every line to a local invoice, and posts a double-entry voucher that can never leave your books unbalanced.

Courier COD remittances

Reconcile the money a carrier owes you against the parcels they actually delivered.

  • Per-item COD amount, delivery fee, COD fee, other deductions and withholding tax — reconciled line by line
  • A balanced GL journal on every remittance: DR Bank + DR Courier fees + DR WHT receivable, CR Courier COD clearing
  • CSV / Excel import with automatic column detection — no template wrangling per carrier
  • Auto-match to local invoices by tracking number, with a preview of matched / unmatched / variance counts before you commit
  • RTO items automatically trigger a sale-return reversal — stock back in, revenue backed out

Payment gateway payouts

Reconcile the deposit a processor sends against the transactions it settled.

  • Per-item gross, processing fee, refund and chargeback — each mapped to its originating order
  • A balanced GL journal on every payout: DR Bank + DR Gateway fees + DR Refunds, CR Gateway clearing
  • CSV / Excel import with auto-detect columns for any processor’s settlement export
  • Void a posted payout with a full, automatic GL reversal — no manual back-out entries
  • An unbalanced-voucher safety guard blocks any journal where debits don’t equal credits — the books cannot drift
Marketplaces & tax

Settlements and withholding, resolved to the ledger

Marketplaces net their cut before they pay you, and couriers withhold tax on your behalf. Both are money that’s yours but isn’t in your account yet — EloERP tracks the difference and posts it, so nothing quietly disappears.

  • Marketplace settlements: gross revenue − platform fees − cost of goods = contribution, per settlement
  • A per-platform breakdown so you know which channel truly contributes after its take rate
  • Settlement posting with a balanced GL voucher — platform fees expensed, contribution recognised
  • Tax & withholding: expected vs deducted WHT per courier, so under- and over-deductions surface
  • Income-WHT and sales-WHT rates with automatic doubling for non-filer / non-listed parties
  • A running WHT Receivable ledger balance with a by-period breakdown for your tax filing
settlement & wht ledger
Gross (platform A)
¤ 640k
1,204 orders settled
Platform fees
¤ 96k
15% take rate
Contribution
¤ 191k
after fees & COGS
WHT receivable balance¤ 148,300
Expected WHT this period¤ 41,000
Deducted vs expectedmatched — 0 variance
claims recovery desk
Open claims
23
¤ 214,600 at stake
Deadline soon
4
< 48h to file
Recovered YTD
¤ 1.1M
credited back
Recovery scoreboard
Courier North: 92% recovered · Marketplace B: 61% recovered — ranked so you chase the worst offender first.
Claims management

Chase every lost, damaged and short-paid unit until it’s recovered

Couriers lose parcels; marketplaces short-pay settlements. Left to a spreadsheet, those claims quietly expire. EloERP files them, counts down their deadlines, and posts the credit to your ledger the moment it lands.

  • Six courier claim types and six marketplace claim types — lost, damaged, short-paid, wrong deduction and more
  • Per-party deadline countdown with urgency levels, so a filing window never closes on you
  • A recovery scoreboard per courier and per marketplace — recovery rate, amount at stake, amount won back
  • A credited claim posts a balanced GL entry against the right clearing account — recovery reconciles automatically
1Draft 2Filed 3In review 4Approved 5Credited ×Rejected

Every claim carries the tracking number, the originating invoice and the disputed amount — so when a courier asks for proof, it’s one click, not an afternoon of digging.

Aging reports

Know exactly how old your uncollected money is

Two pools of your cash sit outside your bank at any moment: COD delivered but not yet remitted, and prepaid orders captured but not yet paid out. Aging buckets show how long each has been outstanding — and per courier, who is sitting on it.

COD aging — unremitted, by courier

Delivered invoices whose cash the courier still owes you, bucketed by how long they’ve been outstanding.

Courier0–7d8–15d16–30d30d+
Courier North¤ 84k¤ 31k¤ 12k¤ 4k
Courier West¤ 52k¤ 40k¤ 22k¤ 18k
Courier East¤ 66k¤ 19k¤ 7k¤ 2k

Anything in the 30d+ column is cash a courier should have remitted a month ago — the first place to open a claim.

Gateway aging — captured, not paid out

Prepaid invoices captured at the gateway but not yet settled to your bank, bucketed by clearing age.

Gateway0–3d4–7d8–14d14d+
Gateway One¤ 120k¤ 34k¤ 6k¤ 0
Gateway Two¤ 78k¤ 41k¤ 15k¤ 9k
Wallet Pay¤ 44k¤ 12k¤ 3k¤ 1k

A balance drifting into 14d+ means a payout stalled — the freshness meter flags it before it becomes a support ticket.

Explore the suite

Reconciliation closes the loop the rest of the module opens

← Back to the Ecommerce overview

Booked, then banked

Reconcile every unit to your real books

COD remittances, gateway payouts, marketplace settlements, withholding tax and courier claims — each posting a balanced double-entry journal, so what you sold and what you banked finally agree. Start free for 14 days.

Start 14-Day Free Trial Book a demo
Schedule a demo