Ours is a Service organization with no inventory. We have customers set up with unique A/R codes. Each customer is identified not only as A/R but by fund source, cost center, and program. This is problematic as there many accounts that are funded by state and local governments. This being said we usually receive a large payment that needs to be applied to several customer accounts.
We currently have accounts with credit balances that need to be offset against those with debit balances. We also have cash receipts applied to A/R that should have gone to another G/L account all together. This is a result of the retirement of a very seasoned GP User.
How best can I clean up the A/R and transfer the payments to the correct accounts. National Accounts don't help as management wants a detailed aging for banking purposes.
Thank You
*This post is locked for comments