Jet Reports

Aged Account Receivables

"Aged accounts receivable refers to the outstanding or unpaid invoices owed to a company by its customers or clients. It represents the amounts that are due to the company for goods sold or services rendered but have not yet been received.

The aged accounts receivable report organizes the outstanding receivables based on the length of time they have been outstanding. It typically categorizes the receivables into different age groups or "buckets" such as 30 days, 60 days, 90 days, and so on. This provides an overview of the company's outstanding receivables and helps in assessing the collection status.

Join On Point Academy to view all content

Join the academy →

By analyzing the aged accounts receivable report, businesses can track their outstanding receivables, identify overdue invoices, and prioritize collection efforts. It enables them to monitor cash flow, assess the effectiveness of their credit policies, and take appropriate actions to ensure timely payments.

In this article, I’ll show you how to create an aged account receivables which will include the overdue amount and also the not yet due amount.

To create this report, we need information from 2 different tables…

Customer
Cust. ledger entries

Procedure

Step 1 know where to pull your data from

Step 3 Creating Report Options and date range

a) Click on the report options tab and fill in as shown.

we only apply look up function for Customer posting group and vendor no.

Lookup function for Customer Posting Group

Lookup function for Customer no

Go to cell C4 and reference to report options in cell C2 as shown. you can give it the name “As at filter“

Go to D4 and fill in with NP function as shown below

C) Not due

Got to cell G7 and fill as shown

then use NP function in cell G8

D) 30 days due

Go to cell H7 and fill as shown

Then use NP function in cell H8

E) 60 days

Go to cell I7 and fill as shown

Then use the NP function in cell I8

F) 90 days

Go to cell J7 and fill as shown

Then go to Cell J8 and use the NP function

G) Over 90 days

Go to cell K7 and fill as shown

Then use NP function in cell K8

Step 3 Creating the report

The report will be grouped by vendor posting group. The vendor posting group is typically used in financial and accounting systems to determine the default general ledger accounts and posting rules for vendor transactions. It helps streamline the process of recording vendor-related transactions and ensures consistency in accounting practices.

vendor posting group can vary depending on the organization's requirements and industry. Common criteria may include vendor types, payment terms, tax rules, purchasing policies, or other relevant factors.

a. Filling in the formulas

go to cell D14 and fill in for the vendor posting group.