Our client is really struggling with bank rec. they are over a year behind due to the tangled mess of CC/cash/checks/returns for 65 stores with different rates of deposit. They've tried using Nolan Advanced Bank Rec and couldn't get it to help solve the problem. Ideas?
*This post is locked for comments
Only suggestion I have is to start from scratch. Basically, think of it this way, reconciling 1 year of bank rec is going to be a time consuming process. Cut your losses. Clear all the CM Transaction tables then run a blind reconcile as of the last bank statement cut off date and adjust any difference as an in/out to your cash account. Then adjust the cash account to reflect the bank statement plus any outstanding checks or deposits as of that date. Then start from there.
Ah !
At second reading, I realize that .. Though it says "They tried to use ABR, but struggled to make it work".. Maybe it's a training issue?
Beat,
Alas, that's the product the OP said the client is struggling with :-)
Id' suggest to look in a tool like Advance Bank Reconciliation from Nolan Computer Solutions.. Their product is great in matching various source of bank data to match straight with your GL accounts..
How many bank accounts do they have?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156