Skip to Content
This question has been flagged
1 Respondre
398 Vistes
Avatar
lloyd@ariavetri.com

We use Shopify as our commerce site.  Customers enter orders in Shopify, which  creates a sales order, which is then imported to Odoo via the VentorTech connector with the same sales order as Shopify.  Odoo creates an invoice upon shipping, but that is not pushed back to Shopify.  So the Reference field in Shopify is the sales order and in Odoo it's the invoice.

The payment is made in Shopify and a Payment transaction is created in Odoo, which really doesn't seem to accomplish anything and the bank reconciliation process is still very manual.  

The Shopify Finance screen shows the amount transferred to our bank.  Clicking on this provides the detail of each sales order and the associated fee for the net remittance.

In Odoo, the deposit comes into the bank.  On the transaction screen for the Bank Journal, the references are the Odoo Invoice #, not the sales order number.  

I've solved this by creating an import file in Excel with a match to the Customer from the Odoo Sales Order file, which makes the match much easier.  When the invoices paid are all match the result is a JE to Dr- Bank, Dr- Shopify Fees and Cr- Accounts Receivable for each sales order/invoice paid with the deposit. 

However, it's still a multi-step manual process.  Does anyone have a connector to automate this reconciliation process?  Thanks.

Avatar
Descartar
Avatar
Sandeep Paulraj R
Best Answer

What you are describing is a common challenge with Shopify integrations. The key issue is that Shopify usually settles payments in batches (net of fees), while Odoo invoices are generated and reconciled individually.

In a fully automated setup, the connector should:

  1. Create and post customer payments in Odoo when Shopify captures the payment.

  2. Link those payments to the corresponding invoices.

  3. Create payout entries when Shopify transfers funds to the bank.

  4. Post Shopify fees to a dedicated expense account.

  5. Reconcile the payout against the customer payments and fees automatically.

If your current connector only creates payment.transaction records, but does not create/account for actual payments and payouts, then Odoo's reconciliation process will remain largely manual.

A common accounting flow is:

  • Customer payment → Outstanding Receipts / Shopify Clearing Account

  • Shopify fee → Shopify Fees Expense

  • Shopify payout → Bank Account

This allows the payout amount received in the bank statement to be reconciled automatically against the clearing account balance and fees.

Before looking for another connector, I would check whether the VentorTech connector supports:

  • Shopify Payout synchronization

  • Automatic payment creation

  • Payment-to-invoice reconciliation

  • Shopify fee import

Without payout synchronization, Odoo has no information about how Shopify grouped the transactions, which makes automatic bank reconciliation difficult.

From an accounting perspective, using a dedicated Shopify Clearing Account instead of posting directly to Accounts Receivable is generally the most scalable approach for high-volume Shopify stores.

Avatar
Descartar