How do I run an Aged Receivables Report?

Charlotte Boatner-Doane - Forum Moderator
Charlotte Boatner-Doane - Forum Moderator
  • Updated

To help you keep track of unpaid balances across your organization, an Aged Receivables report is available through Accounting Exports to run for certain Funders (Client Individual, Funder Individual, Funder Batched, and Electronic Billing types only). This report provides an overview of all unpaid balances for Clients and Funders over a set period of time and groups overdue payments according to how many days have passed since the invoice Posting Date. 

To run an Aged Receivables Report, go to Accounting>Accounting Exports. Click +Add Accounting Export and select the type you need.

Screen Shot 2023-08-21 at 10.29.27 PM.png

In the resulting dialogue, select Aged Receivables as the Type. By default CSV will be selected as the Format

Screen Shot 2023-08-21 at 10.31.05 PM.png

Enter an End Date for the report. The report will take into account only transactions that occur on or before this End Date

Click to add the Clients and/or Funders you wish to include in the report. Only Funders of Type Client Individual, Funder Individual, and Funder Batched will be available to include in an Aged Receivables export. 

Click Save to generate the report. 

The Aged Receivables Report will now appear in your list of Accounting Exports. Click the AR Report button in the Download column to open the report. 

The report contains the following fields in CSV Format

  • Funder Name
  • Billing Contact (if the Funder is Type Client Individual)
  • Client First Name
  • Client Last Name
  • Client Status
  • Current: the amount owed based on invoices with unpaid balances posted in the 30 days prior to the End Date
  • 31-60: the amount owed from invoices with unpaid balances posted more than 30 but less than 60 days before the End Date.
  • 61-90: the amount owed from invoices with unpaid balances posted more than 60 but less than 90 days before the End Date
  • 91-120:  the amount owed from invoices with unpaid balances posted more than 90 but less than 120 days before the End Date
  • 120+: the amount owed from invoices with unpaid balances posted more than 120 days before the End Date
  • Unallocated Credits: the sum of all Unallocated Credits for the Client and Funder.
  • Balance: the total amount owed as of the End Date by the Client and Funder.

Learn More

Was this article helpful?

1 out of 2 found this helpful

Comments

0 comments

Article is closed for comments.