To make sure your accounts receivable (A/R) accounts balance in CivicRec all of the following should match exactly.
- The balance of the General Ledger (GL) Summary, the Long-Term GL Summary, or the General Ledger Detail run from the 1st day of setup to the date you consider the end of the period you are checking should match.
- The balance of the Accounts Receivable with Aging total minus the Account Credits with Aging total, or the total of the Consolidated A/R Report.
Manual User Credits
If you are not balancing either within CivicRec or with your formal accounting software one place to look is Manual User Credits. As these do not create GL entries (the first side of our balancing equation) but do reflect in the A/R aging reports (the second side of our balancing equation) they can cause you to be off.
Run a report showing the total of Manual User Credits (which can then be either added to side 1 or subtracted from side 2).
CommentsLet us know what was helpful or not helpful about the article.
Please sign in to leave a comment.