Why is there a variance in Outstanding Check Report & Bank Reconciliation Summary if there are no voids or other issues?
Occasionally, different sets of records based on certain dates, are compared during reconciliation.
Easy e-Bank Rec pulls records based on GL Posting Date and Microsoft Dynamics GP will pull records based on Document date. For example: GL date is 11/30 but the Document date is 12/1, any items outside these dates will be left off the Back Rec summary .
To identify if GL date & Doc dates are causing variance go to: Maint – Check List where GLPOSTDT <>TRX date.
If there is sufficient variance in dates, click on Update Transaction date with GL Posted date to fix this variance in Outstanding Checks list & Bank Rec Summary.