Reviewing Aged Creditors/Debtors

In IRIS Financials you can run reports to view information about expected or overdue payments owed from or due to your establishment/organisation in an aged creditor or debtor report.

This topic details how to create the aged creditor or debtor report using the reports available in the Reporting Suite module and what to do if the aged creditors or debtor report does not match the details on the Trial Balance.

Reviewing aged creditors and debtors consists of the following:

Running the Aged Creditors Report

Running the Aged Debtors Report

Matching Aged Creditors and Aged Debtors to the Trial Balance

Running the Aged Creditors Report

  1. Select Processing Modules, then select myReports from the menu.
  2. Select Aged Creditors from the Creditors/Debtors panel.
  3. The IRIS Financials Reporting Services Browser is displayed. Select the criteria for the following options:
    Please select the Company(s) - is defaulted to the company for which you are logged in.
    Please select the Location(s) - select the location(s) you want to include in the report. (All locations are selected by default).
    Please select the Ledger(s) - select the ledger(s) you want to include in the report.
    Please select the Period - is defaulted to the current period. Select the required accounting period on which you want to report.
    Please select the as at Date - select the date for which you want to view aged creditors (the selected date is not included in the results).
    Hide or Show Detail Line(s) - select whether to Show or Hide detail lines for documents within the report.
    Show Comments - select Yes or No to display any document or detail comments within the report.
    Please select Main Grouping - select whether to group results by Creditor or Location.
  4. When you have selected the required criteria, select View Report.
  5. The details of the Aged Creditor report are displayed with the details for the selected criteria.
    To save a copy of the report, select the Save icon, then select an option from the drop-down menu. To print a copy of the report, select the Print icon.

Running the Aged Debtors Report

  1. Select Processing Modules, then select myReports from the menu.
  2. Select Aged Debtors from the Creditors/Debtors panel.
  3. The IRIS Financials Reporting Services Browser is displayed. Select the criteria for the following options:
    Please select the Company(s) - is defaulted to the company for which you are logged in.
    Please select the Location(s) - select the location(s) you want to include in the report. (All locations are selected by default).
    Please select the Ledger(s) - select the ledger(s) you want to include in the report.
    Please select the Period - is defaulted to the current period. Select the required accounting period on which you want to report.
    Please select the as at Date - select the date for which you want to view aged debtors (the selected date is not included in the results).
    Hide or Show Detail Line(s) - select whether to Show or Hide detail lines for documents within the report.
    Show Comments - select Yes or No to display any document or detail comments within the report.
    Please select Main Grouping - select whether to group results by Debtor or Location.
  4. When you have selected the required criteria, select View Report.
  5. The details of the Aged Debtor report are displayed with the details for the selected criteria.
    To save a copy of the report, select the Save icon, then select an option from the drop-down menu. To print a copy of the report, select the Print icon.

Matching Aged Creditors and Aged Debtors to the Trial Balance

If there is a discrepancy between the Trial Balance and the Aged Debtors/Creditors Report, it is usually down to documents allocated outside of the criteria being run for the report.

The most efficient way to identify the posting is by comparing the two using the following method:

  1. Run the Aged Creditor or Aged Debtor report and make a note of the criteria you selected.

  2. Run a Trial Balance with the same criteria used for the Aged Creditor or Debtor report. For example, for the AST location, period 2020/21.09, etc. For more information, please see Running a Trial Balance.


    Next, you need to compare the supplier balances on the Aged Creditors Report with that of the Trial Balance, to try and identify what the variances are.

  3. On the Trial Balance, right-select on , then select Details from the pop-up menu.
  4. The Detail Enquiry window is displayed. From the header, drag the Account column to Drag a column header here to group by that column. message at the top of the window.


  5. You can now compare the balances on the Aged Creditors (or Aged Debtors) report with that of the Trial Balance line by line.

  6. Select Expand (+) adjacent to the accounts on both the Trial Balance and Aged Creditors (or Aged Debtors) report, to display the detail lines making up the balance.
  7. Go through and match each transaction until you find one that is on the Trial Balance but not the Aged Creditors (or Aged Debtors) report.