AR Aging Summary by Due Date Report
Last updated
Last updated
This report provides a summary of accounts receivable balances categorized by different aging periods based on the due dates of invoices. It typically includes columns such as "Current," "1-30 Days," "31-60 Days," "61-90 Days," and "Over 90 Days," which represent different payment timeframes. By reviewing these aging periods, businesses can identify overdue invoices, assess payment patterns, and take appropriate actions to ensure timely collections.
The A/R Aging Summary by Due Date report enables organizations to gauge the overall health of their accounts receivable portfolio. It helps in identifying potential cash flow issues, forecasting future revenues, and mitigating the risk of bad debt. By monitoring the aging of receivables, businesses can proactively follow up with customers, implement effective collection strategies, and maintain healthy cash flow.
Step 1: Filtering options to customize the report's parameters.
Company Code From: This option allows you to enter a specific range of company code to filter the data or leave it blank
As of GL Date: By selecting a date using the calendar picker, the report will show the aging information based on the outstanding balances as of that particular GL date.
Customer Number: By entering a customer name or selecting it from a dropdown menu
Group By Days: Define the time intervals for grouping, which can range from a few days to larger timeframes, depending on your preference
Report Format: Choose between PDF or Excel format for the report output.
Step 2: Click the "Run Report" button
Locate the "Run Report" button and click on it.
This triggers the system to process and generate the report based on the provided criteria.
Step 3: Wait for the report to generate
Depending on the volume of data and complexity of the report, it may take some time for the system to process and generate the report.
Please be patient while the system completes this task.
Step 4: Review the report
Once the report is generated, it will be displayed on the screen.
Carefully review the report, focusing on the information about the number of each column and rows.
Step 5: Save or export the report
If needed, save or export the report for future reference or to share it with others within your organization.
This ensures that you retain the data and can access it whenever necessary.
By following these steps, you can generate the Report and leverage its insights to make informed decisions regarding outstanding transaction management.