Aged Trial Balance by Fund Report
  • 19 Sep 2023
  • Contributors
  • Dark
    Light
  • PDF

Aged Trial Balance by Fund Report

  • Dark
    Light
  • PDF

Article summary


Aged Trial Balance by Fund Report

This report lists Pledge receivables for the first, second, and third month after a user defined aging date. The report is sorted based on the Funds that will be receiving Pledges.

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.

NOTE: You can access this report from anywhere in FIMS by selecting Reports > Pledges > Aged Trial Balance by Fund.


Aged Trial Balance Fields

NOTE: The Aged Trial Balance by Donor report contains the same fields as this report.

Field

Description

Doc. No. / Line

The Pledge number and line number. This information is only available if you run a detailed report.

Apply No. / Line

The Pledge number and line number that the payment will be applied to. This information is only available if you run a detailed report.

Date

The due date for the Pledge (line item) payment.

Type

The type code associated with the Pledge payment.

Future

Pledge receivable amounts that are due at a future date.

0 - 30

Pledge receivable amounts that are between zero and thirty days past the aging date.

31 – 60

Pledge receivable amounts that are between thirty-one and sixty days past the aging date.

61 +

Pledge receivable amounts that are more than sixty days past the aging date.

Running the Aged Trial Balance by Fund Report

NOTE: The Aged Trial Balance by Donor report is run in exactly the same way as this report.

1. In the Pledge Management module, select Reports > Aged Trial Balance by Fund. The Selection and Formatting window opens.
Selection and Formatting Window

2. Select the Aging Date that you want to use as the basis for your report.

3. In the From and Through 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).

4. In the Report Formatting Options section, select the radio button that corresponds with the report format you want to use (Detail or Summary).

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

6. Click OK.


Was this article helpful?