Bank does not reconcile with GL 1

[johnhugh]

Hello,

I'm using Accpac 6.
My Bank does not reconcile with GL.
I have been through every transaction for the month in GL and ticket off against the bank and it all matches.
No unposted batches. Hit calculate button a number of times.

What else could it be?

 

[ettienne]

Did you upgrade from an old version?

 

[johnhugh]

I did indeed. Upgraded from 5.6 two weeks ago.

 

[ettienne]

There were specific updates to install for the upgrade to 6.0, if you missed those then your bank rec can be out.
Run a data integrity check on BK with the fix option, then check it again.
If it is still out check for JE to the bank account in the GL - the #1 reason for it not balancing.

 

[johnhugh]

Thanks.
Just ran data integrity with fix option but GL and bank still does not balance.
There were no JE to GL.
I installed Accpac 6 and PU1 together. Activated Accpac 6 PU1, so would think that PU1 had all updates included that it needed?

What is the best way to reconcile Bank with GL?
In GL I have the Transactions Listing report. Where do I get previously posted Bank reconcilliation reports from?
Reconcilliation Posting Journal?

 

[ettienne]

Yes, the reconciliation posting journal - the ones you printed and cleared before the 6.0 upgrade.
Look for something silly like an erroneous posting to the bank GL account, people do strange things sometimes. I've also seen people use the bank GL account in Banks for the Write-Off Account and Credit Cards Charges Account - then wonder why their bank does not agree with the GL.
Also look for checks return in the future and deposits done in future periods.

 

[johnhugh]

Thank you.