What is the best way to "reconcile" a CM bank account that is CLOSED and zero balance in GL but Bank Register shows balance on account? Just want to change status of entries to "Reconciled" so they will no longer appear in reports.
What is the best way to "reconcile" a CM bank account that is CLOSED and zero balance in GL but Bank Register shows balance on account? Just want to change status of entries to "Reconciled" so they will no longer appear in reports.
Thank you for your post John M Jankowski!
What version and update of Sage 300 CRE are you currently using? The version will reference 9.8 or 13.1 in your Help, About in the software. (example 13.1 Rev 7 Acc Update 6)
9.8
John,
One way to do this is to turn on a setting in Cash Management under File, Company Settings, CM Settings, "Override opening Balance in Reconcile." From there you can go to Tasks, Reconcile, enter a statement ending balance of 0.00, and reconcile all of the transactions. After everything is checked off, click the Statement button and make the opening balance the opposite of the Difference amount shown at the bottom of the reconcile. This should allow you to finish the reconcile with a 0 balance.
Let me know how it goes!
*Community Hub is the new name for Sage City