Automatic reconciliation between payments made on an ecommerce site and transfers from payment platforms.
Objective
Need to connect your e-commerce site?
Need to connect your e-commerce site? Data exchange in csv format, connection with your CRM, synchronization with your ERP, interface with a business application, … We model a connector specific to your needs on our HUB
Related issues
Bank transfer, making it difficult to identify individual payments. Variable processing times between order validation and the actual transfer complicate temporal matching. Transaction fees deducted by the payment platform create discrepancies between the amounts displayed on the site and the sums actually transferred. Cancellations, refunds, and chargebacks may be processed in separate transfers or deducted from future transfers, making tracking more complex. Currency differences and exchange rate fluctuations between the time of transaction and the time of transfer generate amount variations. The lack of standardized transaction references between systems makes reconciliation automation difficult. Finally, the absence of robust APIs to access bank transfer details often requires time-consuming manual checks, which is especially problematic with high transaction volumes.
Case studies
An IT services company sells fixed-price services on its website. Some of these services are recurring and sold in the form of subscriptions.
A portion of payments are made via bank transfers to the company’s Qonto account. Smaller payments are processed through Stripe as card payments. Subscriptions are automatically charged via Stripe, either as SEPA direct debits or recurring card payments.
The website generates approximately 500 invoices per year for a customer base of around 300 active clients. These clients consist exclusively of small businesses and non-profit organizations, mainly based in France, Belgium, Luxembourg, and Switzerland.
A web interface has been provided to the company’s accounting firm, allowing the accountants to independently download the bank journal.
The format of the bank journal was custom-designed in collaboration with the IT company’s accounting firm, with the goal of making the file directly usable in the firm’s accounting software.
Thus, the accounting firm can retrieve an up-to-date bank journal whenever needed, ready for immediate import into their accounting system.
Data is available on demand — a valuable time-saver.
No additional handling is required for processing payments from the website — saving time and improving reliability.
The integration was developed with the IT company’s chart of accounts in mind.
Payment information is collected from WooCommerce, the Stripe API, and the Qonto API.
Invoice-to-payment reconciliation is therefore automated, resulting in significant time savings.
A mapping is automatically applied with the correct accounting codes: Stripe clearing account code, bank account code, Stripe fee account code, and so on.
Linked connectors
Pas de connecteurs disponibles
