Import Bank Transactions - Everything Else

RE: Import Bank Transactions

Evida Suntoyo — Wed, 01 Sep 2021 14:21:16 +0000

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.

RE: Import Bank Transactions

matthewjames — Tue, 06 Oct 2020 07:06:14 +0000

@timrodman unfortunately not supported in the UK or ROTW at the moment but they're working on it and we're part of a UK localisation group with other UK VARs

RE: Import Bank Transactions

Tim Rodman — Tue, 06 Oct 2020 03:42:59 +0000

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:

RE: Import Bank Transactions

matthewjames — Thu, 27 Aug 2020 16:01:32 +0000

@pamela-poh-chuen-ong Hi Ong, i hope you are well, did you ever find a solution to this issue? we're based in the UK and a customer is coming from Quickbooks where they have bank feeds and want to import transactions directly to the "Import Bank Transcations" form but only have CSV files as an export from their banking software.

i've tried creating the import scenario to speed things up but getting the message "View name: Header" but nothing else for import errors.

I have logged a case but wondering if this was something you came across when setting up?

Thanks in advance

RE: Import Bank Transactions

Ong — Tue, 17 Sep 2019 01:05:03 +0000

Hi Tim,

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

RE: Import Bank Transactions

Tim Rodman — Mon, 16 Sep 2019 19:06:01 +0000

I haven't done it personally. I haven't come across a client yet where the volume justified the time to setup the import.

Import Bank Transactions

Ong — Fri, 16 Aug 2019 07:51:41 +0000

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