· Reduce Aging by 3rd party amounts
· Sort By
o Name
· Group By
|
The summary of your totals is based upon how you group the accounts. |
o Preview
Use this window to generate the Aging Report, which prints a list of accounts showing the age of the debit transactions. Using the subtotals on the Aging Report, you can analyze your outstanding balances. To age the Accounts Receivable transactions, the report first adds the debits into the appropriate columns based on date. Then the program processes the credits for each account, subtracting them from the oldest aging column first. Finally, if you choose to age credit balance accounts, the surplus credit transactions are aged based on date.
You can control the headings on the report by specifying up to six aging range categories, such as 0 - 60 days, 61 - 120 days, etc. Set up these aging ranges using the Subsidiary Control window.
Select the subsidiary group for which the Aging Report is to be run.
|
A subsidiary group is simply a list of subsidiary control accounts consisting of as few as one or as many as all of your control accounts. |
Update the date if needed. The default is today's date.
|
The transactions are aged from this date. |
Select this checkbox to include student accounts with a credit balance on the report. The surplus credit transactions are totaled to the appropriate column based on the date.
Do not select this checkbox if you want to exclude credit balance accounts from the report.
· Reduce Aging by 3rd party amounts
|
If the Process Third Party as Subsidiary checkbox on the A/R Configuration window is active (selected), then this column will be disabled. |
Select this checkbox if you want to include transactions where a third party ID number is assigned.
Do not select this checkbox if you want to exclude transactions where a third party ID number is assigned.
Enter a title for the report, which will appear under the standard report heading.
· Sort By
Select this radio button to print the report sorted by ID Number.
o Name
Select this radio button to print the report sorted alphabetically by last name, first name, and middle name.
· Group By
|
The summary of your totals is based upon how you group the accounts. |
Select this radio button to group the report first by the subsidiary type, then by ID number or name (last, first, middle).
Select this radio button to group the report first by year and term, then by ID number or name (last, first, middle).
Select this radio button to group the report first by billing period, then by ID number or name (last, first, middle).
Select this radio button to generate and immediately print the report after you click OK.
|
You can also print the report from the Print Preview window, which displays with the Preview option. |
o Preview
Select this radio button to generate the report and display it in the Print Preview window after you click OK.
|
To print the report from the Print Preview window, click the Print icon, make your selections, and click the Print button. |
This sample report shows charges that are 0-30, 31-60, 61-90, etc., days old.
Name |
0-30 |
31-60 |
61-90 |
91-120 |
121-190 |
191 & Over |
Tom Wise |
16.25 |
1,625.00 |
.00 |
.00 |
.00 |
.00 |
Amy Jones |
200.00 |
.00 |
.00 |
.00 |
.00 |
.00 |
Jim Thompson |
12.63 |
12.50 |
1250.00 |
.00 |
.00 |
.00 |
Mary Nafziger |
.00 |
.00 |
.00 |
.00 |
.00 |
.00 |
The six aging periods limit and description columns should be filled in as follows on the Subsidiary Control window to create the report shown.
Aging Period # |
Number of Days Limit |
Column Description |
1 |
30 |
0-30 Days |
2 |
60 |
31-60 Days |
3 |
90 |
61-90 Days |
4 |
120 |
91-120 Days |
5 |
190 |
121-190 Days |
6 |
999 |
191 & Over |
Each line represents a Subsidiary Master table row. The information is grouped and sub-totaled by either subsidiary type, year/term, or billing period. The following example report is grouped by subsidiary type and sorted by ID number.
Subsidiary Type Code - CS |
|
|
|
|
|
|
||
|
|
|
0-30 |
31-60 |
61-90 |
91-120 |
121-190 |
191+ |
000000101 |
AC |
Absher, Jennifer M. |
1000.00 |
.00 |
.00 |
.00 |
.00 |
.00 |
000000101 |
BK |
Absher, Jennifer M. |
125.00 |
.00 |
.00 |
.00 |
.00 |
.00 |
000000201 |
AC |
Harton Adams, Holly |
500.00 |
.00 |
.00 |
.00 |
.00 |
.00 |
000000450 |
AC |
Jones, Teresa A. |
.00 |
.00 |
200.00 |
.00 |
.00 |
1200.00 |
000000430 |
AC |
Woods, Larry Scott |
100.00 |
.00 |
.00 |
.00 |
.00 |
400.00 |
Totals for Type Code - CS |
1725.00 |
.00 |
200.00 |
.00 |
.00 |
1600.00 |
||
|
|
|
|
|
|
|
||
Subsidiary Type Code - FA |
|
|
|
|
|
|
||
000000002 |
AC |
Allen, Laura Dianna |
.00 |
250.00 |
100.00 |
.00 |
.00 |
.00 |
000000303 |
AC |
Anthony, Michael L. |
750.00 |
.00 |
.00 |
.00 |
.00 |
.00 |
Totals for Type Code - FA |
750.00 |
250.00 |
100.00 |
.00 |
.00 |
.00 |
||
Using the subtotals on the Aging Report, you can analyze your outstanding balances and compare the totals to your General Ledger receivable balances.
1. Open the A/R Aging Report window.
2. From the Subsidiary Group drop-down list, select the subsidiary group for which the aging report is to be run.
3. The A/R Aging Date column defaults to today's date. Change the date if needed.
|
The transactions are aged from this date. |
4. To include students with a credit balance, select the Include Credit Balances checkbox. To exclude students with a credit balance, do not select the Include Credit Balances checkbox.
5. If you are configured to process third parties as subsidiaries, the Reduce Aging by 3rd party amounts checkbox is available:
a. To include transactions flagged with a third party ID number, select the Reduce Aging by 3rd party amounts checkbox.
b. To exclude transactions flagged with a third party ID number, do not select the Reduce Aging by 3rd party amounts checkbox.
|
If the Process Third Party as Subsidiary checkbox on the A/R Configuration window is active (selected), then this column will be disabled. |
6. In the Report Title column, enter a name for the A/R Aging Report, which will appear under the standard report heading.
7. From the Sort By options, select ID Number or Name to determine how the report will be sorted.
8. From the Group By options, select Subsidiary Type, Year/Term, or Billing Period to determine how the report will be grouped.
|
This selection determines how the report is grouped and sub-totaled. |
9. From the Print options, select Immediate or Preview to determine if you will preview the report before printing it or print the report immediately.
|
You can print the report from the Print Preview window, which displays with the Preview option. |
10. Click the OK button. The A/R Aging Report is generated.
|
To print the report from the Print Preview window, click the Print icon, make your selections, and click the Print button. |
Set Up Aging Ranges for the A/R Aging Report
1. Open the Subsidiary Control window.
2. In the Aging group box, enter the six aging ranges for the report in Period columns 1 through 6. The number you enter will be the upper limit of the range.
|
If you want the first aging period to age transactions from 0-30 days, then enter 30 in the Period 1 column since that is the upper limit of the first range. |
3. Enter a description for each Period entry in the Column Description columns. The descriptions appear as the column headings on the report.
4. Click the Save icon to save your entries.
|
|
