Ledgers do not agree with Trial Balance

Jan 17, 2011 6 Replies

I have just taken over the book-keeping of a company using Quickbooks.



The balances shown in the Trial Balance for Accounts Receivable & Accounts Payable do not agree with the figures shown in the actual ledgers. How can I correct this situation?



TIA,



Stubass


This can be caused by a journal entry or other Non A/R or A/P transaction hitting that account without a customer/vendor name.

Run transaction reports on the A/R account to see if you can see any journal entries or other odd transactions. Do the same thing with the a/p account. I usually run the TB & ledger reports by year then by quarter until I can pin point a time frame to help me find the transaction(s).

I would also run a Verify on the file to rule out file corruption but do some investigation of the transactions posted to the account. DO NOT RUN THIS TOOL IF YOU ARE RUNNING 2011 R4!!!

I've found the offending entries but how do I correct them? Any posting to the Accounts Receivable file needs a customer reference so that the individual balances are adjusted but so is the figure in the Trial Balance. I need the figure adjusted in the TB to agree with the A/R report.

Stubass

What kind of entries were they? Were they customer/vendor specific or just year end adjustments that should be reversed?

Year end adjustments but i can't reverse them. When I enter Accounts receivable it says it must have an customers account name.

Stubass

Create a customer called CPA_adjustments and use that on both the original entry and the reversal.

Thanks. That seems to have done rthe job

Stubass

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required