Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Bank does not reconcile with GL

Bank does not reconcile with GL

Bank does not reconcile with GL


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?

RE: Bank does not reconcile with GL

Did you upgrade from an old version?

RE: Bank does not reconcile with GL

I did indeed. Upgraded from 5.6 two weeks ago.

RE: Bank does not reconcile with GL

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.

RE: Bank does not reconcile with GL

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?

RE: Bank does not reconcile with GL

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.

RE: Bank does not reconcile with GL

Thank you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close