Aged Payables & Payable GL not balancing

[oldming]

the total amount in my report of aged payable is not equal to the amount of AP in my Balance Sheet...can i find out where is the difference ?!!

[LauraG]

Can you isolate the problem to a particular accounting period or vendor?

Do the vendor balances match the A/P report?

There is a problem with your company file (run Data Verification)

There could also be a journal entry coded to the A/P account. Run a g/l ledger report for the whole year and look for Jrnl type=GENJ. Or a transaction that was posted to A/P instead of an expense account.

[hannah]

I have same problem. My Balance sheet showing $6,693.36 but aged payable is showing $5,371.70.

Hannah

[LauraG]

Run the Aged Payables and Balance sheet for each month of 2006 until you find the month where the problem occurred. Then run a General ledger report on the A/P account and vendor ledger reports for that month looking for journal entries or incorrectly posted purchase journals. You should also be able to figure out which vendor is out of balance by comparing the vendor balances with the aging report as of the end of that month.

[Lisa_p]

I frequently see this when someone changes the AP account on purchases. Check the purchase journal and look for credits going to accounts other than AP. Sometimes it's like looking for a needle in a haystack and sometimes they pop right out.

I wish they would let you hide the AP account while still showing it in the detail lines.

This happens in AR too.

[LauraG]

I agree with Lisa_p that it is sometimes like looking for a needle in a haystack. That's why i suggested trying to isolate which accounting period the problem happened. Sometimes that helps make the haystack smaller.

[dstegman]

My problem is that my Trial Balance is "out of balance" as certain payables that were paid were not posted to the General Ledger. I have identified specific payments that were made and do not show on the Aged Payables but are still in the General Ledger Payables account!!!

Any suggestions?

I don't understand how only one-side of a payable payment could be posted.

After running the Data Verification checks which included the syncronization tests, I recieved errors one for each of the payment transactions that said:

An entry in the amount of X could not be posted to account #0. This entry was found in journal CDJ period X Trx Number X and the reference was (check number), line 0.

Is there any way to repair this as it appears the check did not fix these errors? When looking at accounting behind the scenes the correct payable account number is shown (not account 0), but it is not shown on the general ledger as an applied payment. The account number is blank on the CDJ.

[rick Prindivill]

Try running the INTERNAL ACCOUNTING REVIEW from the Reports Listing. This report will list potential or suspicious transactions related to incorrect postings. You can choose the date range for the review.

[lila.godel]

My problem is that my Trial Balance is "out of balance" as certain payables that were paid were not posted to the General Ledger. I have identified specific payments that were made and do not show on the Aged Payables but are still in the General Ledger Payables account!!!

Any suggestions?



You could try this. For each problem payment note the appied inovices, uncheck them and save the payment. Then reopen the payment recheck the applied inovices and save it. This should trigger a reposting to the payments to A/P and because you are fixing the payments rather than deleting them and reentering them you will not have a bank reconcilation issue.

[dstegman]

lila.godel

I don't understand your suggestion. Where would I uncheck the invoices? I currently have accounting period 11 opened and the unapplied invoice payments occurred in period 2.

dstegman

[lila.godel]

lila.godel

I don't understand your suggestion. Where would I uncheck the invoices? I currently have accounting period 11 opened and the unapplied invoice payments occurred in period 2.

dstegman

On the payments to which they were applied. These would be the payments that did not post to the G/L.