Ledgers do not agree with Trial Balance

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

Reply to
stubass
Loading thread data ...

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!!!

Reply to
Laura

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

Reply to
stubass

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

Reply to
Laura

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

Stubass

Reply to
stubass

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

Reply to
Laura

Thanks. That seems to have done rthe job

Stubass

Reply to
stubass

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.