Accounts Receivable Aging Report | Zayls

by Zayls
5 years ago

Accounts Receivable Aging Report

Accounts Receivable Aging report gives a detailed view of all outstanding bills and balances your customer owes to your company as of a certain date and based on the following timeline: current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and more than 90 days past the due date. This report is also used as a gauge to determine the financial health of a company’s customers.   


Accounts Receivable Aging Report Overview

ara 1

Report Filters

  • Search By — This filter will enable the user to filter by form type and number (INV #, BS #, SR #, Reference #).
  • As of – This filter will show the customers and their overdue amounts from the date selected.
  • Customer – This filter will show the overdue amounts of the customer/s selected.

By default, the report shows the accounts receivable as of the current date. 

The Customer filter is multi-select, which means that you can have as many customers as possible to get your desired results.  

Accounts Receivable Aging Report Columns

  • Customer  This column shows all customers involved in the transactions.
  • Transaction # — This column shows the transaction number of the corresponding balance breakdown. The breakdown can be shown by clicking the toggle button on the left of the customer’s name.
  • Date – This column shows the dates the transactions were made.
  • Due Date – This column shows the due dates of the transactions.
  • Current – This column shows the amounts the customers currently owe you 
  • 1-30 – This column shows the overdue amounts the customers owe you 1 to 30 days past the due date.
  • 31-60 – This column shows the overdue amounts the customers owe you 31 to 60 days pasthe due date.
  • 61-90 – This column shows the overdue amounts the customers owe you 61 to 90 days past the due date.
  • >90 – This column shows the overdue amounts the customers owe you at least 90 days past the due date.
  • Balance– This column shows the total amounts the customers owe you.

Hover over some column names on the header of the reports to access the guide with a description of what information the column is displaying.

Export Accounts Receivable Aging Report to PDF or Excel

  1. In the Accounts Receivable Aging Report, click Export. 
  2. There are two Export options: Export to PDF and Export to Excel. Click your desired format. 
  3. Upon clicking your desired formatthe file will be automatically downloaded to your computer. 
  4. You may also view the Export History of the report.

Related Article: Statement of Account