In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Import Bank Transactions
Good day Everyone
Just with this topic, am wondering if anyone here has successfully imported their bank files (in csv/excel format) , created bank rules for matching and upon, processing the bank transactions (CA306000), the system automatically creates the cash book transaction entries when the results from the csv file matches that of bank transaction rules. We have created dozens of Bank Transaction Rules and even though, the description(with wildcards) and amount (on the csv file) matches what's on the bank transaction rules, the system doesn't automatically creates the CA entry. Upon clicking 'auto match' , none of the transactions on the csv file matches (except for 1) which showed there was an Applied rule.
So, just wondering if anyone has successfully done up their bank transaction rules(other than creating document for bank interest), and have them all match up successfully and system was able to create those CA documents based on the rules setup. I will get back with some samples later.
Thank you and have a nice weekend
I haven't done it personally. I haven't come across a client yet where the volume justified the time to setup the import.
Thanks for your reply. The client has huge volume of bank transactions and at this moment, they are unable to use the bank feeds. Thus, it's justifiable for them to use the 'import bank transation' features , if it works as it is 'expected'. Here are some relevant examples:
1. Setup bank rules. (just showing 2 examples here)
(i) Super - auto matched
(ii) HENGRA - NOT auto matched
Not really what this Discussion Topic is about, but it's related so I thought I would mention it. In Acumatica 2020 R2 they now do electronic bank feeds. Companies that are coming off of Quickbooks will like this:
Does anybody have experience integrating realtime Bank Feed Integration with Corporate Credit Cards? We consulted our bank for Visa credit card, it seems that they do not use Plaid and also apparently since Acumatica is not PCI compliant so they will send out VIDS files.