Standard Report - AR Aging As Of

This report provides a detailed view of outstanding accounts receivable (AR) aging, allowing you to track and analyze unpaid invoices. It helps identify customers who owe money and those who are not paying promptly.

Monitoring AR aging is crucial for maintaining cash flow, identifying potential bad debts, and improving financial management.

Special logic

• If there is any Unapplied cash, then an additional Summary line is displayed which will show Actual Balance for the Customer. [See attached Snapshot: Customer: 1154 123 Technology]
• All Negative balances are taken as unapplied cash. If the client has overpaid any invoice, and has not created any UC, then that overpaid amount will be included under Unapplied Cash in AR Aging As Of report.
• Unapplied cash in the Detail section (data table) is denoted by brackets, also represents a negative amount. Unapplied cash can also be seen in Supplier Total Box and Report Total Box.

Report Description

View outstanding AR aging in detail. Quickly track and analyze your receivable dollars to know who owes and who is not paying in a timely manner.

Parameters

Parameter Name	Options	Explanation
Roll up to Parent Customer	True/False	Based on this parameter, the result will either displayed per individual customer department or rolled into Root Customer.
Customer Name		Filters results by Customer Name.
Aging Date Type	Accounting Period Date, Due Date, Invoice Date	Invoice Accounting Period Date, Due Date or Invoice Date
As of Date		Select Date on basis of which the data are obtained
Group By	Branch, None	Select to choose to Group Invoices by Branch or not.
Branch	All available branches
Age Group 1		Define the width of Age Bucket 1 [Age Bucket 1 = 1 to Age Group 1 Value]
Age Group 2		Define the width of Age Bucket 2 [Age Bucket 2 = Age Group 1 Value + 1 to Age Group 2 Value]
Age Group 3		Define the width of Age Bucket 3 [Age Bucket 3 = Age Group 2 Value + 1  to Age Group 3 Value]
Show Summary	True / False	View Customer level Summary or view Invoice Level Detail
Root Customer ID		Filters result by root customer ID

Report Fields

Field Name	Explanation
Affiliate	Invoice Supplier
Branch	Invoice Branch. Will be visible when Branch is selected under Group By Parameter.
Customer #	Customer ID [Customer who receives the Invoice] – This field will vary according to Roll Up To Parent Customer parameter
Customer Name	Customer Name from Invoice. [Invoice To Customer] – This field will vary according to Roll Up To Parent Customer parameter
Department	Customer Department
Payment Terms	Customer Payment Terms from Billing Setup
Credit Limit	Customer Credit Limit from Back Office Setup >> Credit
High Limit	Calculated as the highest amount, when the total of the outstanding amount for the invoice has been so far
Phone Number	Customer Primary Contact Method
Last Payment Date	Last Paid Date for Customer as per AsOfDate. There is another field with the same title [Last Payment Date] which is for Invoice.
Inv. #	Invoice Number
Inv. Date	Invoice Date
Date Due	Due Date from Invoice
Invoice Amount	Invoice Amount from Invoice
Finance Charge	Total Finance Charge accumulated to the Invoice as per AsOfDate
Payment/Credits	Total Amount paid by the client to the Invoice as per AsOfDate
Last Payment Date	Last Paid Date for Invoice as per AsOfDate. There is another field with the same title [Last Payment Date] which is for Customer.
GP Adj Cost	Sum of Item Cost for Transaction types that is nontaxable and has property GPCalculation set to True.
Balance	Total Balance Due of Invoice [Calculation: Invoice Amount – Payment Amount + Finance Charge]
DO	Days Outstanding (Age of Invoice). This field depends on the Aging Date Type parameter. If Aging Date Type = Invoice Date, DO = As Of Date – Invoice Date If Aging Date Type = Due Date, DO = As Of Date – Due Date If Aging Date Type = Accounting Period Date, DO = As Of Date – Accounting Period Date
Current	Balance Due of Invoice for which DO < 0
1 – Age Group 1 days (Eg. 1-30 days)	Column title is dynamic, which depends upon the Age Group 1 Parameter value. This Column shows the Balance Due of Invoice whose DO is between 1 and Age Group 1 Value
(Age Group 1 Value + 1)  –( Age Group 2) days (Eg. 31-60 days)	Column title is dynamic, which depends upon Age Group 1 Parameter value and Age Group 2 value. This Column shows the Balance Due of Invoice whose DO is between (Age Group 1 Value + 1)  and Age Group 2 Value
(Age Group2 Value + 1)  – (Age Group 3) days (Eg. 61-90 days)	Column title is dynamic, which depends upon Age Group 2 Parameter value and Age Group 3 Value. This Column shows the Balance Due of Invoice whose DO is between (Age Group2 Value + 1)   and Age Group 3 Value
Over (Age Group 3) days (Eg. Over 90 days)	Column title is dynamic, which depends upon the Age Group 3 Parameter value. This Column shows the Balance Due of Invoice whose DO is over Age Group 3 Value

Efficiency Drivers:

• Unapplied Cash Tracking: Negative balances are flagged as unapplied cash, allowing for easy identification of overpayments or adjustments needed.
• Dynamic Grouping Options: Customize report views by branch, customer, or aging date type to streamline analysis.
• Age Group Buckets: Define custom aging periods to pinpoint overdue invoices and prioritize collection efforts.

Actionable Insights:

• Review Unapplied Cash Regularly: Ensure any overpayments are accurately accounted for and adjust customer balances as needed.
• Customize Aging Buckets: Adjust aging parameters to better reflect your business’s credit terms and collection strategies.
• Monitor High-Risk Accounts: Focus on customers with significant overdue balances to mitigate financial risk.

By leveraging the AR Aging As Of Report, businesses can effectively manage their receivables, improve cash flow, and enhance customer credit management practices.