Automatic Matching from Bank Statements / Feeds

Automatic Matching from Bank Statements / Feeds

Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met?

My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these cases, there can be hundreds or thousands of transactions. However, if the payment transactions are recorded correctly, they should be fairly easy to recognize and match in an automated manner.

As an example, when an e-commerce order is received and fulfilled, this is automatically recorded in Zoho Books as a Sales Order, Package, Shipment Order, Invoice, and Payment. The Payment is deposited into the appropriate Clearing Account with the bank's transaction number.

When the statement is downloaded from the merchant services provider and imported to Zoho Books as a statement, it has all of that same data, including the date, total, and transaction number.

Given that all of the data is there for a match, is there any way to automate matching?

I realize that there is a need for human intervention from time to time, and that's fine. That's the point of doing reconciliations and the like. But when there's a transaction for $309.00 on 05/03/23 with ref# 8g9eb1ab in the register and a transaction for $309.00 on 05/03/23 with ref# 8g9eb1ab in the feed / imported statement, it would be really helpful if there were the option to allow for automatic matching under those (or similar) criteria.



This comes into play in any instance where there are high transaction levels. E-com can have hundreds or thousands of transactions to comb through. Manually matching a couple thousand transactions the way things currently are is a huge waste of time when it wouldn't be hard for an automation to do the stuff that doesn't require thinking. If an automation could do 90+% and just leave the stuff that requires a human intervention (i.e., stuff where there wasn't a perfect date-amount-reference match), that would be a major increase in efficiency for high-transaction businesses.

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources

                                                                                            Zoho Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方