Just imagine: It's November 25, Black Friday, and your online store is running at full speed. Thousands of orders are coming in, the cash registers are ringing - at least virtually. But while your sales team is rejoicing, youraccounting department isin sheer horror. Because behind every sale lurks a question that will come back to haunt you later: Is the money really where it should be?
The truth is: for most e-commerce companies, payment reconciliation is a mess. Partial deliveries, returns and lost transaction IDs turn what should be a simple accounting task into a months-long battle against discrepancies that no one can explain. And on days like Black Friday, Cyber Monday or Christmas sales? That's when a problem turns into a disaster.
In this article, I'll show you why the classic accounts receivable model is reaching its limits with modern online stores, the fatal consequences of lost references - and how you can finally regain control with the right strategies.
Traditionally, many companies post aseparate accounts receivable account for each customer.The idea behind this is simple and logical:
This model has proven itself over decades - in industries with few, manageable transactions and clear payment terms. But modern web stores play by completely different rules.
The following happens in the world of digital commerce:
Unlike traditional B2B transactions with invoices and payment terms, customers in e-commerce pay directly at checkout. The money flows via payment service providers (PSPs) such as Stripe, Adyen or PayPal - but these payment service providers do not transfer the amounts individually, but in aggregated collective transfers.
This means that a sum of, for example, EUR 47,382.15 ends up in your bank account. Which of the day's 2,847 individual transactions are included? The bank won't tell you. The information is somewhere in the billing files of your PSP - if at all.
Things get really complicated with partial deliveries:
The crux of the matter: Your POS system has recorded the original order, your PSP has collected the money in full, your merchandise management system shows a partial delivery, and your accounting department has to bring it all together somehow - across multiple systems that all use different reference numbers.
And with returns? Then the game starts all over again, only backwards.
Here comes the real killer: the transaction ID gets lost.
WS-2025-103847TRX-998273645SETTLE-20251030The result? You sit there with three different data sets and try to find out manually which payment belongs to which order. With 50 transactions a day, that's annoying. With 5,000 transactions on Black Friday? Impossible.
On normal days, manual reconciliations can still be handled reasonably well. But then come the high-volume days of e-commerce, which push every system to its limits. Black Friday on the last Friday in November traditionally kicks off the hot phase, followed by Cyber Monday on the following Monday. Singles Day on November 11 also plays an increasingly important role in many markets, and of course Christmas sales throughout December should not be forgotten.
On these special days, the transaction volume really explodes. Suddenly, 10 to 20 times more orders come in than on normal days. At the same time, customer expectations rise: Delivery times become shorter, impatience greater. But it is precisely at these peak times that stocks run low, leading to significantly more partial deliveries. And as if that wasn't enough, two to three weeks later comes the inevitable wave of returns as customers rethink their impulse purchases or exchange gifts.
The result: thousands of open itemsthat cannot be allocated. Differences in the five- to six-figure range are not uncommon. Unresolved balances of up to EUR 400,000 have already been identified for ReconHub customers.
These differences are not just an accounting nuisance - they have massive financial and operational consequences:
If you don't know exactly what payments have been received, you can't plan with certainty. Liquidity bottlenecks arise even though the money is actually there - you just can't find it.
Auditors don't like unresolved differences. The more open items, the more intensive the audit - and the more expensive the bill.
Incomplete or incorrect reconciliations can violate commercial and tax regulations. In the worst case, sanctions may be imposed.
At some point, unresolved differences must be corrected. This is often done by means of lump-sum write-offs - money that is actually there is booked as a loss. Or vice versa: sales are reported too early and have to be corrected later.
Your accounting department spends hours, sometimes days, reconciling Excel lists, exchanging emails with PSPs and clarifying discrepancies. Time that is lacking for value-adding activities.
Here comes the crucial point: not all payment reconciliation systems are the same. Most solutions on the market can only work with the reference numbers that PSPs provide - and that's where the problem lies. Because if the transaction ID is lost during the transition from one system to another, even the best software won't help you.
ReconHub takes a different approach: the system can perform the reconciliation using the OrderID - the original order number from your webshop. This reference is retained throughout the entire process, from the first order to the final payment.
ReconHub integrates with all relevant data sources:
The OrderID is used as a consistent identifier so that each transaction can be uniquely assigned - even if the PSP reference is missing or several transactions have been aggregated.
Instead of comparing totals (which does not localize any source of error in case of differences), ReconHub works at the individual transaction level:
ReconHub relies on an intelligent, tiered system:
This means that even on a Black Friday with 10,000 transactions, only 500-1,500 cases are checked manually - instead of all 10,000.
With ReconHub, you can always see exactly
This not only creates security in accounting, but also confidence during audits - because every single transaction is fully traceable.
What you should do:
Why this is important:
In e-commerce reality, you otherwise pay the price in the form of unresolved differences that accumulate over months. Transaction-based systems give you back control.
What you should do:
Why this is important:
Manual Excel reconciliations don't scale. From a certain size (1,000+ transactions/month at the latest) you need automation - but the right one.
What you should do:
Why this is important:
On normal days, many things work
"somehow". On Black Friday, "somehow " collapses immediately. Preparation is everything.
What you should do:
Why this is important:
You can only improve what you can measure. Transparency prevents small problems from growing into big differences.
What you should do:
Why this is important:
Technology alone does not solve problems. It needs people who know how to use it correctly - and processes that ensure that the technology is also used.
The reality is brutal: most e-commerce companies have no idea how much money is really in their account. They work with estimates, balances and the hope that at the end of the month the differences won't get too big.
This works - until it doesn't. Until an auditor asks. Until a CFO has to explain why there are EUR 400,000 in open items. Until a write-down becomes necessary that ruins the annual result.
The good news is that there is a solution. Systems such as ReconHub show that transaction-specific payment reconciliation is possible - even with thousands of transactions every day, even with complex partial deliveries and returns, even on Black Friday.
The first step? Recognize the problem. The second? Take action.
Because one thing is certain: the next peak season is sure to come. And the question is not whether there will be differences - but whether you will find them in time.
Do you recognize your company in this article? Then now is the right time to make a change.
3 concrete next steps:
Share this article with your CFO, your accounting team or anyone who can't sleep at night because the numbers don't add up. Because only those who know the problem can solve it.