Before you generate aging reports, verify the following items are created:

• GL Accounts for accounts receivable and accounts payable.
• Currencies
• Exchange Rates if you recognize accounting entries in multiple currencies.

The following dates apply to aging reports:

• Transaction Date. The date that the economic event for the source document occurred. The source document represents the transfer of title for an economic resource between the parties.
• Finalized Date. The date that you sign off on recording the source document in Kenandy.
• Posting Date. The date that you report the economic event for the source document in the financial statements.

Aging reports show records that are finalized in Kenandy as of a specified date and time.

You generate an aging report for accounts receivable or accounts payable so that you can review account activity that might need your attention and investigate this activity as necessary.

1. From the Accounting Reports page, click AP/AR Aging Report.
2. On the Aging Report page that is displayed, complete the following steps:
   1. Select an accounts receivable or accounts payable account in the GL Account field.

      You can select only GL accounts that have a value of AP/AR Aging in the Reports field.

   2. In the As of field, select the date and time as of which to run the report.

      For example if you want to see a snapshot of aging data as of the end of August 2016, then enter 08/31/2016. In this field, you designate the posting date and time of the source documents to include in the report. Transactions that occurred on or before this date and time are included in the report.

   3. To exclude journal entries without supplier invoice references or customer invoice references, click Advanced Filters, and select the Exclude Opening Balances checkbox.

      These journal entries are displayed on the report with a customer name of Unknown.

   4. To exclude subaccounts for the GL account that you select, select the Ignore Subaccounts checkbox in the Advanced Filters section.

      If you select this checkbox, the report contains only the data for the parent GL account (not any subaccounts that are associated with it), and no subaccount data is available when you drill down on the report lines.

3. Click Run Report.

   The aging report is displayed. The customer or supplier name on the report is in bold, red font when a source document amount for the customer or supplier differs from the GL amount. The amounts in the age columns of the report are based on the invoice due dates for the source documents.

   If you recognize accounting entries in multiple currencies, the aging report is divided into a section for each currency. The report includes a column for the GL balance in the transaction currency and a column for the GL balance in the functional currency. The amounts for the remaining columns of the report are in the transaction currency.

4. To show or hide columns in the report, select or clear the checkboxes for the column fields in the drop-down menu that you access in the top left corner of the report.

   More information about some of the column fields follows:

   • Invoice Number: The invoice number for customer invoices and supplier invoices.
   • Invoiced Date: The invoiced date for the customer invoices and supplier invoices.
   • Due: The due date for customer invoices and supplier invoices.
   • Payment Term: The payment terms for customer invoices and supplier invoices.
5. To expand a report line and show the lines included in it, click the arrow icon at the beginning of the report line title.

   You can click the arrow icon again to collapse the report line and hide the lines included in it.

6. To export the report into a file, complete one of the following steps:
   • To export the report into an Excel file, click Export to Excel.

     The Excel file includes all of the lines in the report, regardless of whether the lines are displayed on the screen.

   • To export the report into a Portable Document Format file, click Export to PDF.

     The PDF file includes only the report lines that are displayed on the screen.

7. To view more details about a source document on a line of the report, click the link for the source document.

   Details about the source document are displayed in a separate window.