Accounts Payable Aging Report
This article talks about the Aged Accounts Payable Analysis Report in Connected Business.
The Aged Accounts Payable Analysis Report is a detailed and comprehensive report that shows supplier outstanding balances and payables in aging periods which ranges from 30days to 120+ days with indicated total days overdue. It also includes last-year-to-date and year-to-date analysis for each transaction recorded and sub-totals for all currencies used in the business.
How To View Aged A/P Analysis Report
The Accounts Payable Aging reports can be accessed from the Report Center menu of any modules in Connected Business. Click the Report Center menu to load the Report Center window. In the Report Explorer panel, click on Reports > System Reports > Accounting > Retrospective Analysis > Accounts Payable Aging and the reports under the A/P Aging Analysis will be displayed.
Click Image to Enlarge
The following are the Accounts Payable Aging reports:
- Aged Accounts Payable Analysis (Doc Date) – This report shows the calculation of outstanding payables to suppliers based on the transaction date.
Click Image to Enlarge
- Aged Accounts Payable Analysis – Doc Date (Value in Base) – This report shows the outstanding payables to suppliers which are converted to the home currency used by the business and based on the transaction date.
Click Image to Enlarge
- Aged Accounts Payable Analysis (Due Date) – This report shows the calculation of outstanding payables to suppliers based on the due date of the transaction.
Click Image to Enlarge
- Aged Accounts Payable Analysis – Due Date (Value in Base) – This report shows the outstanding payables to suppliers which are converted to the home currency used by the business and based on the due date the transaction.
Click Image to Enlarge
You can also view this report from the Retrospective Analysis form. Go to Accounting module > Retrospective Analysis. In the form, select Aged AP Analysis from the Report Analysis dropdown list.
Click Image to Enlarge
The Retrospective Analysis form is only available in Connected Business v14. Refer to The Retrospective Analysis Form for more details.
How To Filter Aged A/P Analysis Report Data
You can set the filter criteria to view the aging recap and statistical summary of all your accounts payable activities as of a particular date.
To set the filter criteria,
- Right-click on any report under Accounts Payable Aging and select Print Dialog. The Print Dialog form will be displayed.
- In the Filter Criteria panel, select the group operator (And, Or, Not End, Not Or) and click (
) to add a condition.
Click Image to Enlarge
- Select the “@As Of” and “Equals” condition criteria and select the date to appear on the report.
Click Image to Enlarge
- If you want to delete the condition, click on (
).
After setting the filter criteria, select the option on how you want to print the report. The printing options are: Print to File, Print Preview, Printer, Email, Fax, and Lowest Cost. After selecting the printing option, click Print.
Click Image to Enlarge
If you want to check the transactions from previous months or specific dates, you can set the filter by defining the date in the As Of field and selecting the date reference type from the Date Reference field (choose between Document Date or Due Date).
Click Image to Enlarge
To filter and print analysis reports from the Retrospective Analysis form, refer to The Retrospective Analysis Form.