The AR Aging Report provides a listing of all the open AR transactions that still haven't paid their invoices. This report helps to keep companies in check and allows restaurants to notify other companies of their outstanding invoices.
Navigation
To navigate to the AR Aging Report, click 'My Reports' under 'Reports' in the left pane and select 'Customers' in the top header of the reporting window. Once opened, a listing of reports will be shown.
Find 'AR Aging' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.
Report Parameters
Legal Entity - A listing of the Legal Entity or Entities tied to the AR Aging transactions
As of - The date that the AR transactions are ran as of
Customer - The company or companies that will be assessed
Hide $0 Balances - This either shows or hides companies that have no payment due
Detail Level - The 'Detail' level is the expanded out version of the 'Summary' level. Clicking 'Detail' will show all fields once it's ran
Group By - Organized by restaurants or by groups of restaurants (house accounts, royalties)
Days Past Grouping - The 'Basic' version displays payments up to 91+ days past due while 'Advanced' displays payments up to 365+ days past due
Sum By Location - This option will either include or exclude the Location before each listing of Vendors
Run Button - Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. Click here to learn more about this functionality
Click here to learn more about Report Views and their added functionality.
Report Columns
Trx # - The AR transactions hyperlinked to their transaction records and organized by Customer name
Trx Type - The type of AR transaction (Payment, AR Credit Memo, AR Invoice, Journal Entry, Bank Deposit)
Doc Date - The date on the AR transaction document
Due Date - The date the AR transaction is due
Current - The amount that is currently due. If this field is $0, the invoice is past due
1-30 Past - The 1-30 day date range an AR transaction is past due. If at $0, this AR transaction is either Currently due or even further past due
31-60 Past - The 31-60 day date range an AR transaction is past due. If at $0, this AR transaction is either Currently due, more recently past due, or even further past due
61-90 Past - The 61-90 day date range an AR transaction is past due. If at $0, this AR transaction is either Currently due, more recently past due, or even further past due
91-120 Past - The 91-120 day date range an AR transaction is past due. If at $0, this AR transaction is either Currently due, more recently past due, or even further past due
The 'Basic' version selected in the report parameters displays payments up to 91+ days past due while the 'Advanced' version displays payments up to 365+ days past due
121-180 Past - The 121-180 day date range an AR transaction is past due. If at $0, this AR transaction is either Currently due, more recently past due, or even further past due
191-365 Past - The 191-365 day date range an AR transaction is past due. If at $0, this AR transaction is either Currently due, more recently past due, or even further past due
365 + Past - The 365+ day date range an AR transaction is past due. If at $0, this AR transaction is either Currently due or more recently past due
Total Due - The total amount due for each Customer
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.