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



1) Legal Entity - A listing of the Legal Entity or Entities tied to the AR Aging transactions

2) As of - The date that the AR transactions are ran as of

3) Customer - The company or companies that will be assessed

4) Hide $0 Balances - This either shows or hides companies that have no payment due

5) Detail Level - The 'Detail' level is the expanded out version of the 'Summary' level. Clicking 'Detail' will show all fields once it's ran 

6) Group By - Organized by restaurants or by groups of restaurants (house accounts, royalties)

7) Days Past Grouping - The 'Basic' version displays payments up to 91+ days past due while 'Advanced' displays payments up to 365+ days past due

8) Sum By Location - This option will either include or exclude the Location before each listing of Vendors

9) 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



1) Trx # - The AR transactions hyperlinked to their transaction records and organized by Customer name 

2) Trx Type - The type of AR transaction (Payment, AR Credit Memo, AR Invoice, Journal Entry, Bank Deposit)

3) Doc Date - The date on the AR transaction document

4) Due Date - The date the AR transaction is due

5) Current - The amount that is currently due. If this field is $0, the invoice is past due

6) 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 


7) 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 

8) 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  

9) 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

  • Note: 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

10) 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  

11) 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  

12) 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 

13) 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.