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.