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


                                                                                                      ご検討中の方