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
Didn't find your answer? Ask the community — no account required.
L
Laura
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!!!
S
stubass
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
L
Laura
What kind of entries were they? Were they customer/vendor specific or just year end adjustments that should be reversed?
S
stubass
Year end adjustments but i can't reverse them. When I enter Accounts receivable it says it must have an customers account name.
Stubass
L
Laura
Create a customer called CPA_adjustments and use that on both the original entry and the reversal.
S
stubass
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
Report Content
You are reporting this content to the moderators. They will look at it
ASAP.