Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

johnhugh (TechnicalUser) (OP)
2 Jul 12 10:58

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 (TechnicalUser)
2 Jul 12 11:05
Did you upgrade from an old version?
johnhugh (TechnicalUser) (OP)
2 Jul 12 11:12
I did indeed. Upgraded from 5.6 two weeks ago.
ettienne (TechnicalUser)
2 Jul 12 11:20
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 (TechnicalUser) (OP)
2 Jul 12 11:26
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?

Helpful Member!  ettienne (TechnicalUser)
2 Jul 12 11:50
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 (TechnicalUser) (OP)
2 Jul 12 12:01
Thank you.

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!

Back To Forum

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