top of page
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

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…

  1. Customer

  2. 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



b)

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.



b. Go to cell E15 and fill in for Vendor no as shown



c. Go to cell F15 and fill in for Vendor name as shown



d. Go to cell G15 and fill in for not due as shown



e. Go to cell H15 and fill in for 30 days as shown



f. Go to cell H15 and fill in for 60 days as shown



g. Go to cell I15 and fill in for 90 days as shown



h. Go to cell J15 and fill in for over 90 days+ as shown



Step 4 Creating balance and totals

a. Go to cell M15 and fill in as shown



b. To calculate the total for each grouping, go to cell d14 and fill in as shown




c. Grand total

Go to cell F19 and type in as shown below.




Step 5

Run your report

Get trained
the On Point way

From self paced online courses to private training sessions.
Become industry ready.
bottom of page