Your POS says you took 47,320 dirhams yesterday. Your bank shows something else. Your payment gateway dashboard shows a third number. Nobody has stolen anything and nothing is broken, but somebody now has to spend an hour working out which figure is real.
This is the most common frustration retailers hit after adding an online channel, and it is rarely a sign of a problem. It is usually the predictable result of three systems measuring different things at different moments.
This is the seventh post in our WooCommerce series, following integration basics, inventory sync, click and collect, pricing, returns, and the single customer view. Stock and customers are covered. This one is about the money.
A Sale and a Settlement Are Not the Same Event
At the counter, a sale and its money arrive together. The customer taps, the terminal approves, the drawer closes. Sale and cash are effectively simultaneous.
Online, they separate. The order is placed on Tuesday, the gateway authorises it immediately, but the funds land in your bank days later, net of fees, usually batched with dozens of other orders. Your POS records a sale on Tuesday. Your bank records a deposit on Friday for a different amount. Both are correct.
Once you accept that these are two different events rather than one number that should match, reconciliation stops being confusing and becomes a process. The rule is that you reconcile sales to sales and settlements to settlements, never a sales figure directly against a bank balance.
The principle: your POS answers what you sold. Your bank answers what you have been paid. A healthy business needs both, and they will never be the same number on the same day.
Where the Gaps Come From
Most differences trace to a small number of causes, and knowing them turns an hour of investigation into a few minutes of checking.
| Cause | What You See |
|---|---|
| Settlement delay | Sales recorded today, funds arriving days later |
| Gateway fees | Deposit lower than the sales total it relates to |
| Batching | One deposit covering several days of orders |
| Refunds | Deducted from a later payout, not the original one |
| Failed or pending orders | Counted as sales before payment actually cleared |
| Cash on delivery | Recorded at order, collected at handover, banked later |
The failed-order row is worth attention because it inflates your revenue figures rather than reducing them. An order that sits in a pending state, or one where the payment was declined after the order was created, can look like a sale in your reporting while no money exists behind it. Deciding which order statuses count as revenue is a decision worth making explicitly rather than inheriting from a default setting.
Cash on Delivery Deserves Its Own Handling
Cash on delivery remains common across the UAE, and it complicates reconciliation more than card payments do because the money passes through people rather than systems.
The order is created at checkout, the cash is collected at the door or the counter, and it reaches your bank whenever it is banked. Between collection and banking, that money is a receivable sitting with a driver or in a till, and it is genuinely at risk in a way card revenue is not.
The practical answer is to treat collection as its own recorded step rather than assuming it happened. A driver or branch reconciles what they collected against the orders assigned to them, and any shortfall surfaces the same day rather than at month end when nobody remembers the details.
Worth confirming: which WooCommerce order statuses your POS counts as revenue. If pending or failed orders are included, your sales figures are overstated and no amount of reconciliation will fix that.
A Daily Close That Actually Works
The daily close should confirm that what happened today is recorded correctly. It should not attempt to prove that money has arrived, because for online orders it has not yet.
In practice that means counting the physical cash drawer against recorded cash sales, checking the card terminal batch total against recorded card sales, and confirming that online orders for the day are present with the right statuses. Three quick checks, each comparing like with like.
Settlement reconciliation is a separate exercise, done when payouts arrive rather than daily. You take each deposit, match it to the orders it covers, and confirm that the difference is accounted for by fees and refunds. Doing this weekly is usually enough, and it is far less painful than attempting it once a quarter.
Every Sale Still Needs a Compliant Invoice
Reconciliation is an internal exercise, but the records underneath it are not. Whether a sale happens at your counter or on your website, it produces a tax invoice, and the Federal Tax Authority sets out what those must contain and when they are required on its tax invoices page.
The practical risk with two channels is divergence. In-store invoices come from the POS and are usually compliant because that is what the system was built for. Online invoices sometimes come from WooCommerce, generated by a plugin configured by whoever built the site, and nobody checks whether they carry the same required detail. Worth verifying that both produce the same standard, including sequential numbering that does not collide between channels. Anything specific to your registration or category is a question for your accountant rather than a blog post.
Check Who Is Actually Handling Your Money
One more thing worth knowing as a merchant. Payment service providers operating in the UAE fall under the Central Bank’s Retail Payment Services and Card Schemes Regulation, which sets licensing requirements and supervisory expectations for firms providing retail payment services and operating card schemes.
If you are choosing a gateway, or adding a buy-now-pay-later option because a competitor has one, it is reasonable to ask whether that provider is licensed by the Central Bank. It is a fair question and any legitimate provider will answer it readily. Settlement terms are worth asking about at the same time, since payout timing affects your cash flow more than a small difference in transaction fees usually does.
Getting the Habit Right
None of this is difficult, but it does need to be routine. Retailers who reconcile daily and settle weekly spend a few minutes at a time and catch problems while the details are still fresh. Retailers who leave it until the accountant asks spend days reconstructing months of activity from bank statements.
The other benefit is that a clean reconciliation habit makes genuine problems visible. When your numbers usually agree, an unexplained gap stands out immediately instead of disappearing into the noise of differences you were expecting anyway.
MultiTech POS records online and in-store sales in one ledger inside the same retail POS software that runs your counter, connected through the WooCommerce POS integration, with paperless invoicing applying the same standard to both channels.
Spending too long on the daily close?
Book a demo and we will walk through how your online and counter payments could reconcile in one place.
Frequently Asked Questions
1. Why does my bank deposit not match my sales total? Because they measure different things. Deposits arrive after a settlement delay, net of gateway fees, and are often batched across several days of orders.
2. Should online and in-store sales sit in the same report? Yes. Total revenue is far more useful when both channels are in one ledger, with payment method recorded so you can still separate them when needed.
3. How should cash on delivery be handled? Record collection as its own step, separate from the order and from banking. That way a shortfall surfaces the same day rather than at month end.
4. Do pending online orders count as revenue? They should not. Decide explicitly which order statuses count as a sale, because including pending or failed orders overstates your figures.
5. How often should we reconcile settlements? Weekly works for most retailers. Daily is unnecessary given settlement delays, and quarterly turns a small task into a long reconstruction exercise.