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

Feature to upload back after doing Manual Reconciliation in Excel.

edited May 27, 2020 12:12PM in Payables, Payments & Cash Management 1 comment

Summary

Feature to upload back after doing Manual Reconciliation in Excel.

Content

Business case:

User requirement to do manual reconciliation for few banks so they would like to export both Statement lines and System transaction lines in Excel and import to application after reconcile

Do we have mechanism to upload all un-reconcile items again to get it reconcile automatically?

Business has complex scenarios so business would like to do manual reconcile even though we have Automatic reconciliation.

We have option to download Bank Statement Lines & System Transactions separately in excel but don't have option to reconcile from excel.

Manual Bank reconciliation screen also not flexible to see the full transaction details, each and every time user need to scroll left/right to see the full transaction information or need to download the transaction in excel. Lot of manual work is involved to scroll right to left for every transaction.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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