How to monitor aged receivables?

← Accounting Support FAQ

CFOs or accountants need continuous reporting about outstanding receivables. They use aging reports to determine which customers have open invoices for longer times.

JustOn Billing & Invoice Management provides a business report that delivers this data: Aging report per debtor. Before you can make use of this report, however, you must create a number of formula fields on the Invoice object, which provide the necessary data.

To enable the aging report:

1. Create the required formula fields on the invoice.

   1. Click to enter Setup, then navigate to the fields list of the Invoice object (ONB2__Invoice__c).

   2. Create the following new fields:

      Field Label	API Name	Data Type	Formula
      Aged 0-30	Aged0_30__c	Formula (Currency)	IF(AND(ONB2__DaysOverdue__c>=0,ONB2__DaysOverdue__c<30),ONB2__Balance__c,null)
      Aged 31-60	Aged31_60__c	Formula (Currency)	IF(AND(ONB2__DaysOverdue__c>=31,ONB2__DaysOverdue__c<60),ONB2__Balance__c,null)
      Aged +60	Aged_60__c	Formula (Currency)	IF(ONB2__DaysOverdue__c>=60,ONB2__Balance__c,null)

2. Add the provided aging report to your org.

   1. Log in to your Salesforce org.
   2. Open the report overview.
   3. Scroll down the list until Aging report per debtor.

   4. Click Get it now.

      This adds the report to your Salesforce org and redirects you to the report result page.