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.