In easyacct the general ledger does not match my aged receivable listing when I run it with all cutomers including those with zero blances...I have tried
several different things and nothing seems to tell me why they don't match. The detailed distribution report even matches the GL!
Hi Jamie,
Thanks for your question. The A/R account balance on the General Ledger typically does not match the Aged Receivables Listing. This is especially true if printing the listing for a month in the past or for multiple months. The reason they do not match is because the Aged Receivables Listing does report does not reflect closed transactions. Although, the report should match the general ledger account balance if you are printing it for the current month.
The detailed distribution report, on the other hand, will always match the general ledger account balance because it shows a detailed break down of what comprises the AR Journal Entry. Click here to view our online support article on the topic.
I am also having this problem....I recently came to this company and they have a customer whose activity is showing up on the aging, but his account shows zero. In the "receive payments" screen, he shows a credit, but nothing to apply it to. The aging is off from the GL by this amount.
This flies in the face of common sense. A listing of outstanding customer balances MUST agree to the general ledger account for accounts receivable at any given date.
That DOES fly in the face of common sense, if the "given date" is "today." It may be, though, that whatever your receivables were on, say, September 30th, might somehow differ from one of the reports that comes out automatically, that always gives you today's figures regardless (i.e., whatever you collected between 9/30 and now, won't show up on an aged report about who owes you how much right now, and how late they are).
If you ran both the reports using today's date as the date you needed, do you still get a mis-match? That would be bad!
Yes, that is the problem.
The customer listing of outstanding balances due must equal the general ledger accounts receivable balance and it doesn't, by the same amount, no matter what date I use, whether today or 12/31/09.
I think the client ran into this problem in 2009 because of NSF checks that were sent back to him from the bank. How the general ledger could change, and the individual outstanding balances did not change is a mystery to us. No matter what we do, we can not create a journal entry to accounts receivable without affecting a customer's account balance. How can we make that one sided entry to NOT affect the aging summary list of outstanding balances. We've tried the opening balance item too, and that doesn't work either.
