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?
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.
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.