Aged Trial Balance w/ As Of Date Report

Aged Trial Balance w/ As Of Date Report

This report lists Pledge receivables for the selected number of days after a user defined aging date. The report is based on the As of Date you select when you run the report.

You can either run this report as a summary or detailed report. The summary displays the Fund name, Donor name and total Pledge information. The detailed report includes information about each line item in a Pledge.

This report is identical to the Aged Trial Balance by Fund report, except that you can base the report on any date, not just the current date (the As Of Date).

The first column in this report displays pledges that are due on a future date (after the specified As Of Date). Subsequent columns display pledges that are past due in relation to the selected As Of Date.

NOTE: You can access this report from anywhere in FIMS by selecting Reports > Pledges > Aged Trial Balance w/ As Of Date.

Running the Aged Trial Balance w/ As of Date Report

1. In the Pledge Management module, select Reports > Aged Trial Balance w/ As Of Date. The Aged Trial Balance Selections window opens.
Aged Trial Balance Selections Window

2. Enter the As of Date and Aging Date that you want to use as the basis for your report.

3. In the Pledge Dates fields, enter the range of Pledge Dates that you want to include on the report. The default value for both fields is today’s date.

4. In the Fund ID and Donor ID fields, enter the range of Fund ID codes and / or Donor ID codes that you want to include in the report. If you want to include all Funds and Donors, leave the From fields blank and enter ZZZZZZ in the Through fields (this is the default setting).

5. In the Define Your Day Ranges for Aging Columns section, enter the number of days that you want to include in each range (1 through 5). Each range appears in a separate column in the report.

NOTE: FIMS automatically calculates the number of days in the From field for each day range based on the number in the Through field for the previous range.

NOTE: FIMS automatically calculates Range # 6 based on your previous ranges. You cannot edit this range.

6. Select the radio button that corresponds with the Report Type you want to run (Detail or Summary).

7. Select the radio button that corresponds with the Aging Period you want to use for the report (30 Day, 90 Day, Yearly, or Custom). The fields in the Day Ranges for Aging Columns section automatically update based on your selection.

NOTE: If you select a Custom Aging Period, enter the desired ranges in each of the Day Ranges for Aging Columns fields.

8. If you want each Fund to print on a separate page, select the Form Feed After Each Fund checkbox.

9. Click OK.