Skip to content
Digitizing E-commerce Operations· Part 4 of 7

E-commerce Payment Reconciliation: Did Every Riyal Arrive?

Short answer

A paid order in your online store is not money in the bank yet, and reconciliation shows where every riyal stands. Part four of Digitizing E-commerce Operations explains gateway settlements, cash on delivery and refunds, how to match every line to an order and give every difference an owner, with an exercise to reconcile one week.

Origami Team

Editorial Team · · 7 min read

Share on WhatsApp
Like what we publish? Pin Origami as a preferred source on Google.Add as a preferred source on Google
E-commerce Payment Reconciliation: Did Every Riyal Arrive?

A paid order in your online store is not money in your bank yet. Payment gateway settlements arrive grouped and net of fees, cash on delivery comes back through the carrier, and refunds and chargebacks reverse money you already received. Reconciling store payments comes down to 3 things: match every settlement line to an order, flag every difference, and give every open item a named owner. Start this week by reconciling one week of settlements against that week's orders. This is part 4 of a 7-part series.

In part three we took the order from the shelf to the customer's door. Now we follow the money: did the price of every order that left arrive, and where is what has not?

Why a paid order is not money in the bank

The store dashboard marks an order paid the moment payment succeeds, but the money takes a longer road. Usually the price of your orders arrives by 4 routes, each with its own shape:

  • The payment gateway. Cards, mada and Apple Pay go through the payment gateway, the service that accepts electronic payment on your behalf. The gateway does not transfer each order on its own; it sends a settlement: one amount that groups the transactions of a period, net of its fees. How your store or app connects to the gateway is covered in Integrating Payment Methods (Mada, Apple Pay, STC Pay) into Your App.
  • Cash on delivery. The courier collects from the customer, then the carrier remits the amounts later in one transfer with a statement of shipments. Between collection and transfer, the money sits with someone else.
  • Refunds. When you refund an order, the amount goes out or is deducted from an upcoming settlement, so the settlement is lower than the order total without anything being wrong.
  • Chargebacks. The cardholder disputes a transaction with their bank, and the amount is pulled back from you until the dispute is settled.

As a result, the sales figure in the store and the deposit in the bank never match on any given day, and that is normal. The problem is not the difference; it is the difference nobody can explain.

Reconciliation in plain words: match, flag, owner

Reconciliation means putting two lists side by side and making sure every line in one has its counterpart in the other. In a store the two lists are your orders on one side and the settlement reports and bank statement on the other. The work is 3 steps:

  • Match every settlement line to an order. Each transaction in the gateway report carries a reference number, and each shipment in the carrier's statement carries a tracking number. That number is the bridge to the order number in your store.
  • Flag every difference. A paid order with no settlement line, a settlement line with no order, or an amount that differs from the order value by more than the expected fees.
  • Give every open item an owner. A person's name and a follow-up date, not a note in a sheet that everyone sees and nobody acts on.

It is the same logic we use to reconcile supplier statements, as explained in Paying Suppliers on Schedule and Reconciling Statements, except that here the other side is the payment gateway and the carrier.

The differences you will usually find

The first time you reconcile, differences will appear, and most have familiar causes:

  • Timing. An order paid late in the day lands in the next day's settlement, so it looks missing while it is on its way.
  • Fees. The amount received is lower than the orders by the gateway's fees. That is not an error, but it should be recorded as fees, not left as an unexplained gap.
  • Cash on delivery not yet remitted. The parcel was delivered and paid for, but it has not yet appeared in the carrier's remittance statement.
  • Order cancelled after payment. The money arrived, the order was cancelled in the store, and the amount has not been refunded yet, or was refunded and not recorded.
  • Duplicate payment or payment with no order. A customer paid twice, or the payment succeeded and the order failed to be created in the store.

We will not tell you how many differences are normal, or what the gateway or carrier charges; that depends on your contract. Read your gateway's fees and settlement period in your own agreement.

What changes when the systems are connected

Today someone on the team collects the gateway report, the carrier's statement and the bank statement, and matches them by hand in a sheet. When the systems are connected through an API, the interface one system uses to talk to another, and through a webhook, the instant notice the gateway sends the moment a payment or refund succeeds:

  • The payment status on the order updates from the gateway itself, not from a screenshot the customer sends.
  • Settlement reports and the carrier's remittance statements are imported automatically instead of downloaded and copied.
  • Lines are matched by reference number and tracking number automatically, and the team is left with only the differences.
  • Differences show up in one list, each with an owner, a date and an alert if it runs late.
  • The reconciled figure reaches the accounting system without being entered twice.

If you are still choosing a payment gateway or connecting it to your software, we compared the options in How to Connect Your Software to a Payment Gateway in Saudi Arabia, and we will not repeat the comparison or the fees here. Because settlement reports carry customer names and transaction details, they are personal data covered by the Personal Data Protection Law, so limit who can see them to the people who need them.

Exercise: reconcile one week

You do not need a new system to know whether your money arrived. You need a sheet and one week of 7 days:

  • Export the week's paid orders from the store: order number, date, amount and payment method.
  • Export the gateway's settlement reports for the same week and a few days after, and the carrier's cash on delivery remittance statement.
  • Match every line to an order by reference or tracking number, and mark it with one of 3 labels: matched, known difference, or unknown difference.
  • Collect the unknown differences and write an owner and a follow-up date for each.
  • Record how many hours the exercise took and who did it. That is what you pay every week today to know where your money is.

Repeat the exercise two weeks later. The number that matters is your own count of unknown differences, and then the same count after you close their causes.

Refunds and the law

Some differences come from refunds, and a refund is not only a financial decision but an obligation to the customer. Today it is governed by the E-commerce Law and its Implementing Regulation, published with the store compliance list on the Ministry of Commerce e-commerce page. In its official announcement, the Ministry said the Council of Ministers approved the Consumer Protection Law of 10 chapters and 76 articles, which takes effect 180 days after publication in the Official Gazette and then replaces 3 laws, including the E-commerce Law. We cover the returns and refunds process in the next part; confirm your obligations with the Ministry of Commerce or a lawyer, as this is not legal advice.

The Origami view

When we work on store payments, we start with the same exercise: where the money comes from, which number links it to the order, and who reconciles what today. Then we connect the store to the payment gateway, the carrier and the accounting system so the payment status updates on its own, settlements are imported and matched automatically, and the team is left with one list of differences where every item has an owner.

The person reconciling statements today knows the causes of the differences before any system does, so we build on their knowledge, not over it. That is what we offer through our services.

In the next part

Some of the differences you found today come from returns. The next part turns returns and refunds into a clear process: a request with a reason, an approval rule, receiving and inspection, then back into stock and a refund through the same payment method.

Sources

  • #Make the Most of Tech
  • #Digitizing E-commerce Operations: From Order to Delivery
  • #E-commerce
  • #Order Management

Frequently asked questions

Why does the payment gateway settlement not equal my order total?

Because the gateway sends one amount that groups the transactions of a period net of its fees, refunds or chargebacks may be deducted from it, and orders paid late in the day may land in the next day's settlement.

What does e-commerce payment reconciliation mean?

Matching every line in the settlement report or carrier statement to an order in your store by reference or tracking number, then flagging every difference and giving each open item an owner and a follow-up date.

How do I make sure my cash on delivery money arrived?

Compare the delivered shipments in your store with the carrier's remittance statement by tracking number. Every delivered parcel missing from the statement is an open item to follow up with the carrier.

Can reconciliation be done automatically?

Yes, when the store is connected to the payment gateway and the carrier through an API. Settlements are imported and matched by reference number automatically, and the team is left with only the list of differences.

Software for stores, real estate and services

Online stores with Saudi payment gateways, plus property and booking systems, built around how you work.

Newsletter

New articles and series, in your inbox.

Follow Origami in Google

Pin Origami as a preferred source and our articles will surface first for you in Google Search and Top Stories.

Add as a preferred source on Google