Any luck reconciling payouts from Shopify with Invoices?

Any luck reconciling payouts from Shopify with Invoices?

We have Shopify integrated with Zoho Inventory and for the most part it works well.  Once we got a script going that automatically creates packages from Sales Orders that come in from Shopify.

But having to manually reconcile Shopify payouts in our bank account with the correct Invoices is TEDIOUS!

Firstly, the amounts aren't the same due to the processing fees they charge. So you have to kind of guess, or get your calculator out. Secondly there might be multiple orders in the one payout.

Just wondering if anyone has created a script or integration that would help with this process.  it seems to me that most of the relevant information to be able to calculate this is able to be scraped from either Shopify directly, or from Inventory.
    • Sticky Posts

    • Authtoken Deprecation for Zoho Inventory APIs

      UPDATE (7 July 2021): We've extended the deadline to 30 August 2021 for converting Authtokens to OAuth.  Hello everyone,   The usage of Authtokens to authenticate API calls is being deprecated on 30 August 2021 across Zoho's Finance suite of products,
    • ZOHO Inventory - Early Access

    Zoho Pagesense Resources

        Zoho SalesIQ Resources

              Zoho TeamInbox Resources

                Zoho DataPrep Resources

                    Zoho CRM Plus Resources

                      Zoho Books Resources

                        Zoho Subscriptions Resources

                          Zoho Desk Resources

                            Zoho Projects Resources

                              Zoho Sprints Resources

                                Qntrl Resources

                                  Zoho Creator Resources

                                    Zoho WorkDrive Resources

                                        Zoho Campaigns Resources

                                          Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now