Integrating E-Commerce, POS and Accounting for a Growing Retailer
An online store, six tills and an accounting system that do not talk to each other will produce overselling, manual journals and stock nobody trusts. Connecting them starts with deciding where each piece of data lives.

A fashion retailer with six stores across Amman and a growing online shop has three systems: the point of sale (POS) system in the stores, an e-commerce platform for the website, and an accounting package used by finance. Every evening a staff member exports online orders to Excel and keys them into the accounting system. Every few days, a customer buys an item online that sold out in a store that morning. At month-end, finance spends a week matching card settlements, cash deposits and courier collections to sales.
None of these systems is bad. The problem is that each one holds part of the truth and nobody designed how they share it.
Start with what has to flow, not with connectors
Integration discussions often start with “does system A have a plug-in for system B?”. That question comes later. First, decide which system owns each type of data and where it needs to go. For a typical retailer selling both in stores and online, the picture looks something like this:
| Data | System of record | Needs to reach | How often |
|---|---|---|---|
| Products, prices, barcodes | POS or ERP (enterprise resource planning) item master | Online store, accounting | On change |
| Stock on hand by location | POS or inventory system | Online store | Every few minutes or on each sale |
| Online orders | Online store | Inventory, accounting, delivery | As they happen |
| Store sales | POS | Accounting | Daily summary |
| Returns and refunds | Whichever channel received them | Inventory, accounting | As they happen |
| Payments and settlements | Bank, card processor, payment gateway, courier | Accounting | Daily |
The single most important decision is where the item master and stock live. If products are created in two places, you will spend years fixing mismatched codes and prices. Pick one home and make every other system read from it.
Three ways to connect the systems
Native connectors
Many POS, e-commerce and accounting products offer ready-made connectors to each other. They are quick to set up and usually cheap. Their limits are flexibility and visibility: they move data in a fixed way, and when something fails, it may fail silently. Check whether the connector handles your real cases, such as multiple warehouses, bundles, gift cards and partial refunds, before relying on it.
Integration or workflow platforms
A middle layer such as an integration platform, or a workflow tool like n8n or Power Automate for simpler flows, sits between the systems and moves data according to rules you define. This gives you control over mapping, error handling and logging. It is a good fit when you have three or more systems, or when connectors do not cover your needs.
Moving to a unified platform
Some retailers solve the problem by moving POS, inventory, online store and accounting onto one platform, for example an ERP with retail and e-commerce modules such as Odoo or Microsoft Dynamics. This removes many integrations but is a larger project, and it only makes sense if the platform fits your store operations well. It is a business decision as much as a technical one.
The details that cause most of the trouble
- Stock buffers. Stock sync is never truly instant. Many retailers show online only a portion of store stock, or hold back a safety buffer on fast-moving items, to avoid selling something that has just left the shelf.
- Which stock is sellable online. Decide whether online orders are fulfilled from a central warehouse, from stores, or both. The answer changes what stock the website should see.
- Returns across channels. A customer who buys online and returns in a store must be handled correctly in stock and in accounting. Design this flow explicitly; connectors often handle it poorly.
- Payment settlements. Card processors (the banks that handle your card payments), payment gateways and cash-on-delivery couriers pay you net of fees, often in batches several days later. Accounting needs to match these to orders, which is a reconciliation job in its own right.
- Tax treatment. Make sure sales tax is calculated consistently in every channel and posts to the right accounts. Where e-invoicing applies to your sales, check with your adviser how it affects POS and online invoices.
- Summary or detail. Accounting rarely needs every till transaction. A daily summary per store, per payment method, is usually enough and keeps the ledger clean. Detailed sales stay in the POS for analysis.
A sensible order of work
- Clean the item master. One code per product variant, consistent across channels, with correct barcodes and prices.
- Connect stock and products to the online store first. This stops overselling, which is the problem customers feel.
- Automate online orders into inventory and accounting. Remove the evening re-keying job.
- Post daily POS summaries to accounting. Replace manual journals with an automatic posting per store and payment method.
- Automate settlement reconciliation. Match card, gateway and courier settlements to sales, with exceptions listed for finance.
- Build reporting on top. Sales by channel, margin by product and stock by location, from one consistent set of data, so buying and markdown decisions use the same figures finance reports.
Working in this order means each step delivers something useful on its own, and you can pause between steps without leaving the business worse off.
One retailer, one set of numbers
For the fashion retailer in our example, the first three steps would end most overselling and remove the evening re-keying job, and those visible results usually make the case for the rest. The settlement reconciliation step tends to be the one finance values most, because it turns a week of month-end matching into a short daily review of exceptions.
Most of the work in retail systems integration is agreeing where each piece of data lives and how it moves. Once that is settled, the connections themselves can stay simple and be monitored every day. Our Enterprise Systems service handles the system design, data architecture and legacy integration behind this, while our Intelligent Automation work covers the reconciliation and reporting that sit on top.



