Overview

The following guide details how to ensure the A/R Aging Report is in balance with General Ledger, as well as steps to take to fix the issue if it is indeed out of balance.  

Use Case(s)

Users should periodically (recommended Monthly) check their A/R Aging to the A/R General Ledger to ensure it is in balance. 

...

• Incorrect Journal Entries

• A Member payment being marked as Non-Member

• Member payment going to the incorrect A/R Account

Steps to Balance

Please Note: All Members should be in the Reporting Group.

1. Run report (Interactive Reports → Membership → AR Aging) and confirm the last date it was in balance and that it does go out of balance on the next date.

2. Then in General Ledger enter the start date the 1st day of the month and the End Date the AS Of date of the AR Aging Report. Put the AR Account number in the Search Field. Then click the Refresh Arrows.

3. The Ending Balance in the GL grid should match the AR Aging Report.

4. Go to General Ledger in the module settings row, then Ledger Periods. Find the last period that was closed and reopen it (double click on the period → uncheck Closed→ Save), then as soon as that completes, reclose it.

5. Go back and run the Aging Report again for the date it was out of balance and see if it now is in balance.

6. A/R Aging should be in balance now. 

Analyze Batches

If for any reason A/R Aging is not in balance after completing steps 1-6, then analyze the batches that were posted on that date—both the Member charges and the payment batches, by following the steps below. 

...

If all the above steps were completed and the batch is still out of balance, please reach out to your Clubessential Support team to help troubleshoot the issue.

Downloadable Guide

...