Review aged creditors and 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 involves these tasks:

Run the aged creditors report

Run the aged debtors report

Match aged creditors and aged debtors to the trial balance

Run the aged creditors report

  1. Select Processing Modules, then select Reporting Suite from the menu.
  2. Select Aged Creditors from the Creditors/Debtors panel.
  3. The IRIS Financials Reporting Services Browser appears. Select the criteria for these options:
    Please select the Company(s) - is defaulted to the company for which you are logged in.
    Please select the Location(s) - select the locations you want to include in the report. The system selects all locations by default.
    Please select the Ledger(s) - select the ledgers 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 to run aged creditors for (the results do not include the selected date).
    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 appear with the details for the selected criteria.
    To save a copy of the report, select the Save icon, then select an option from the list. To print a copy of the report, select the Print icon.

Run the aged debtors report

  1. Select Processing Modules, then select Reporting Suite from the menu.
  2. Select Aged Debtors from the Creditors/Debtors panel.
  3. The IRIS Financials Reporting Services Browser appears. Select the criteria for these options:
    Please select the Company(s) - is defaulted to the company for which you are logged in.
    Please select the Location(s) - select the locations you want to include in the report. The system selects all locations by default.
    Please select the Ledger(s) - select the ledgers 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 to run aged debtors for (the results do not include the selected date).
    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 appear with the details for the selected criteria.
    To save a copy of the report, select the Save icon, then select an option from the list. To print a copy of the report, select the Print icon.

Match 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 to compare the two using this 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, and so on. For more information, refer to Run 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-click , then select Details from the pop-up menu.
  4. The Detail Enquiry window opens. From the header, drag the Account column to the Drag a column header here to group by that column. message.


  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 (+) next 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.