You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Loading bank balances using MT940 file

Question
13
Views
0
Comments
edited Aug 17, 2021 10:22AM in Account Reconciliation

Content

We are using MT940 adapter for bank files to load Bank Statement balances to ARCS. We are trying to get these statement files loaded daily to ARCS.

Scenario - there are chances that if on Day 1 we processed 10 bank accounts to ARCS from MT940 file and on Day 2, the file has only 8 bank accounts; the 2 additional bank account balances that were loaded on Day 1 are being vanished from ARCS.

Is there a smart way to handle this without letting ARCS clear the balances if the latest files didn't have data for the previously processed accounts?
 
Importing using Append mode also doesn't work in this case as it duplicates data

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!