A/P subledger does not tie to the G/L
Kevin
what could be cause this problem?
Thanks
Richard Whaley -- MVP 2006-2008
1. The AP GL account is a control account and should only receive postings
from software generated transactions. Turn off posting to that account in
the Account setup. This stops people from entering the account number on
forms but lets the software generate and post transactions. Check the trial
balance for any postings that seem to come from the wrong source (GL
adjustments, ect)
2. Are you using PO? Most PO receipts post to the proper expense/inventory
account and offset to a Receiving Accrual Account. The Matching invoice then
relieves the Receiving Accrual Account and offsets to Accounts Payable. Some
firms force the receipt to hit AP and then the Match also hits AP...BIG
problem.
3. Are you posting through from AP to GL? If not, there should be GL
batches that need to be posted from the AP transactions. If these got
deleted, you are out of balance.
4. Are you generating checks by selecting invoices from AP? Or do you
enter data and tie to expenses and AP? Opps, you should have hit cash and
expense. But this does not relieve AP either. You need to generate checks
paying AP by selecting AP invoices and hitting cash and AP.
I will let someone else through more ideas at you...hope these help.
--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com
Janakiram M.P.
Did You run Reconcile to GL for Payables? This should help you
identifying the Unmatched transactions. I always use this report for
tie-out with GL. To do this, Go to Routines>Financial>Reconcile and
select Payables management.
Thanks
Janakiram M.P.
MCP-GP
On May 7, 7:52 pm, Richard Whaley -- MVP 2006-2008
> Get our Free Tips and Tricks Newsletter and check out our books athttp://www.AccoladePublications.com
>
>
>
> "Kevin" wrote:
> > We are using GP 9.0. The A/P subledger does not tie to ou G/L. Do anyone know
> > what could be cause this problem?
>
> > Thanks- Hide quoted text -
>
> - Show quoted text -
Kevin D
was new in GP 10. I have limited experience with GP 9 though.
Richard Whaley -- MVP 2006-2008
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com
Frank Hamelly, MCP-GP, MCT, MVP
Two of the most frequent reasons for this are -
1. Posting general journal entries to the AP control account
2. Posting AP transactions that should be hitting the AP control
account to some other account
The easiest way to spot the first one is to run an Account
Transactions SmartList and review the Transaction Source field to spot
any transactions other than POP or AP. Any other transaction source
should be treated as suspect. There should never be any transactions
in this account that don't originate from these two sources. If there
are, you need to review how and why they were posted and prevent
posting to the AP account in the future. The second one is tougher to
spot and will likely be spotted as a result of analyzing the account
transactions.
The other potential issue is Void transactions, where the GL posting
date is different from the original document date. When this occurs,
the GL transaction usually is posted in the current period and the
Void transaction posted in a prior period.
Hope this helps. For more information on keeping this account (and
the Purchases Accrual account, if you use one) please see my blogs on
this subject here http://gp2themax.blogspot.com/search/label/Purchase%20Accrual.
Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com
Kevin
on my out come.
jhum...@gmail.com
> I working on this now. Thanks everyone for your help. I will keep you posted
> on my out come.
>
> "Frank Hamelly, MCP-GP, MCT, MVP" wrote:
>
>
>
> > Kevin,
>
> > Two of the most frequent reasons for this are -
>
> > 1. Posting general journal entries to the AP control account
> > 2. Posting AP transactions that should be hitting the AP control
> > account to some other account
>
> > The easiest way to spot the first one is to run an Account
> > Transactions SmartList and review the Transaction Source field to spot
> > any transactions other than POP or AP. Any other transaction source
> > should be treated as suspect. There should never be any transactions
> > in this account that don't originate from these two sources. If there
> > are, you need to review how and why they were posted and prevent
> > posting to the AP account in the future. The second one is tougher to
> > spot and will likely be spotted as a result of analyzing the account
> > transactions.
>
> > The other potential issue is Void transactions, where the GL posting
> > date is different from the original document date. When this occurs,
> > the GL transaction usually is posted in the current period and the
> > Void transaction posted in a prior period.
>
> > Hope this helps. For more information on keeping this account (and
> > the Purchases Accrual account, if you use one) please see my blogs on
>
> - Show quoted text -
Couple more
Voids with different dates
Default in AP has an inactive account and you are set to Post To.
Then the account is changed when it is posted.
You can go to http://www.onestopreporting.com/ where there are AP to
GL Excel Templates to help you with this. We also do a lot of work
with this issue using XL Reporter.
Jim