Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 daily issue with balances being overwritten

edited Jun 16, 2020 10:02AM in Account Reconciliation 9 comments

Summary

Daily bank statement file (csv) does not have all the bank accounts listed on Saturdays therefore previously loaded balances are getting removed and replaced.

Content

Customer receives bank files (CSV format) daily which contain all bank accounts for the region. They will receive files on Saturday for the accounts that had activity which will be for a handful of accounts only. Once this file is processed any balances for the bank accounts processed on Friday will be removed if the bank account is not in the Saturday file.

Has anyone faced a similar issue?

I have tried creating two locations and only mapping one bank account to a profile in each location and ignoring the res. When I then process the same file for both locations data is still being blanked out. Using snapshot mode for the loading. A merge option would resolve this is there anything like this in ARCS?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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