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' in the Accounting Module and select 'Customers' in the top header. Once opened, a listing of reports will be shown. 


Find 'AR Aging', as displayed in the image above, 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) Run Button - Runs the report



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