ARAGEMNU Accounts Receivable Aging Reports

Reports

Aging Reports

Application Overview

 

The Aging Reports are reports that can tell you a great deal about the state of a customer's account. It will tell you how much the customer owes you, and how old these owed amounts are.

 

In A/R Setup, you entered the length of the four aging periods to be used for aging your customer's accounts.  For example, you may have decided to age a customer's account into these four periods:  Current (less than 30 days old), 31‑60 Days, 61‑90 Days, and Over 90 Days.  The program which prints the Aging Report will ask you to enter the date you want to base the aging calculations on, and then will proceed to calculate which of these four periods each open item on the customer's account belongs in, and report that to you, along with totals owed in each of the four periods.

 

The Aging Report can be printed in either a summarized format or a detailed format.  If you elect to print the summarized format, only the total amount the customer currently owes, and a breakdown of this amount by period, will be reported.  The detailed format prints this same summary information but then also lists each open item currently on the customer's account.


Run Instructions

 

Select Aging Reports from the pull down A/R Reports window.   The following screen will then be displayed:

 

 

 

Aging Reports Entry Screen

 

 

The following print options are available:

  • Print by customer number order, customer name order or in collector order

 

Entry Field Descriptions

 

Report By Customer Number

 

Name

Type and Description

1.  Detail or Summary ?

1 alphanumeric character. 

Enter either D to print the report in detail format, or S to print the report in summary format.

Defaults to S.

2.  Print In Apply‑To Number Order or Document Date Order ?

 

 

 

 

 

 

 

Show Doc Age Detail?

1 alphanumeric character.

Enter A to specify apply‑to number order, or D to specify document date order.

If the items are printed in apply‑to number order, each invoice will be immediately followed by those payments, credit memos, etc. that apply to it.  Otherwise, the report will be printed in document date order, without any reference to the apply‑to number of the document.

Y or N.

Enter whether you want to show aged detail on the aging report or not.

 

If you answer Y to this question, the report will place each open item with a non‑zero balance into the correct aging period.

This option will appear only if the Aging Report is printed in detail and printed in apply‑toorder.

3.  Aging Date

A date in the standard date format. 

Enter the date to be used for calculating the age of the open items.  For example, if you want to know how old a customer's account was as of the end of December 1989, enter 12/31/89 for the aging date.  A document on the customer's account that is dated 11/15/89 would then be more than 30 days old, and would appear in the second aging period, if we use the periods as we defined them above.

 Defaults to system date.

4. Include Items Past Aging Date?

Y or N.

If you answer N to this question, no open items will appear on the report whose date is after the aging date.  On the other hand, if you answer Y here, all items will still be aged as of the aging date, but all open items on a customer's account will be printed (assuming you specified you want to print the report in detail format above).  Any items not yet due will appear in aging period one.

5.  Starting Customer No

6 alphanumeric characters. 

This question and the next one (Ending Customer No) allow you to specify a range of customers to print on the Aging Report.

If you press RETURN for the entry of the Starting Customer No, the field will default to Allcus­tomers, and the entry of the End­ing Customer No will be skipped.

6.  Ending Customer No.

6 alphanumeric characters.

This question and the next one (Ending Customer No) allow you to specify a range of customers to print on the Aging Report.

If you press RETURN for the entry of the ending Customer No, the field will default to the same value as entered fr the Starting customer No. In other words, only the customer specified by Starting customer No. will appear on the report.

In This Aging Prd Or Older (continued)

If a number from 2 to 4 is entered, only those customers who have had the amount due for the specified aging period or longer will appear on the report.  For example, if $200 is specified for this field only those customers who have at least $200 due from the third or fourth aging period will appear on the report.  If 1 had been specified as the aging period then more customers would appear on the report because cus­tomers who had at least $200 due in any aging period would appear on the report.

If you are trying to find those customers who have the most amount of money which has been overdue for the longest period of time, then this field is used, otherwise just specify1.  When 1 is entered, All is dis­played to remind you that all aging periods will be used.

8.   Show Cr Bal Cust Only ?

Y or N.

The option to print customer's with credit balances only.

9.  Show Open Items Only ?

Y or N.

If you answer Y to this, only invoices that have not been paid will be reported, otherwise, all transactions for the selected customer range will be printed.

10. Print Notes

Y = Report will print notes attached to customer record in File Maintenance and any other notes specified in Notes Type default values.

 

Report By Customer Name

 

Name

Type and Description

1.  Detail or Summary ?

1 alphanumeric character.

Enter either D to print the report in detail format, or S to print the report in summary format.

Defaults to S.

2.  Print In Apply‑To Number Order Or Document Date Order

 

 

 

 

 

 

 

Show Doc Age Detail ?

1 alphanumeric character.

Enter A to specify apply‑to number order, or D to specify document date order.

If the items are printed in apply‑to number order, each invoice will be immediately followed by those payments, credit memos, etc. that apply to it.  Otherwise, the report will be printed in document date order, without any reference to the apply‑to number of the document.

Y or N.

Enter whether you want to show aged detail on the aging report or not.

 

If you answer Y to this question, the report will place each open item with a non‑zero balance into the correct aging period.

This option will appear only if the Aging Report is printed in detail and printed in apply‑to order.

3.  Aging Date

A date in the standard date format.

Enter the date to be used for calculating the age of the open items.  For example, if you want to know how old a customer's account was as of the end of December 1989, enter 12/31/89 for the aging date.  A document on the customer's account that is dated 11/15/89 would then be more than 30 days old, and would appear in the second aging period, if we use the periods as we defined them above.

Defaults to system date.

4.  Include Items Past Aging Date ?

Y or N.

If you answer N to this question, no open items will appear on the report whose date is after the aging date.  On the other hand, if you answer Y here, all items will still be aged as of the aging date, but all open items on a customer's account will be printed (assuming you specified you want to print the report in detail format above).  Any items not yet due will appear in aging period one.

5.  Starting Customer No

30 alphanumeric characters.

This question and the next one (Ending Customer Name) allow you to specify a range of customers to print on the Aging Report.

If you press RETURN for the entry of the Starting Customer Name, the field will default toAll cus­tomers, and the entry of the end­ing customer name will be skipped.

6.  Ending Customer No

30 alphanumeric characters.

If you press RETURN for the entry of the ending customer name, the field will default to the same value as entered for the Starting Customer Name.  In other words, only the customer specified by Starting Customer Name will appear on the report.

7.  Minimum Balance Due

9 numeric digits (999,999,999).

This question allows you to speci­fy the minimum balance a customer must have in the specified aging periods (see below) in order to appear on the report.

If you press RETURN, the entry will default to All, meaning a minimum balance of zero dollars and entry of this aging period or older will be skipped.

In This Aging Prd Or Older ?

1 numeric character from 1 to 4.

This field defaults to 1, which means that any customer who owes at least the specified amount due will appear on the report.

If a number from 2 to 4 is entered, only those customers who have had the amount due for the specified aging period or longer will appear on the report.  For example, if $200 is specified for this field only those customers who have at least $200 due from the third or fourth aging period will appear on the report.  If 1 had been specified as the aging period then more customers would appear on the report because cus­tomers who had at least $200 due in any aging period would appear on the report.

If you are trying to find those customers who have the most amount of money, which has been overdue for the longest period of time, then this field is used, otherwise just specify1.  When 1 is entered, All is dis­played to remind you that all aging periods will be used.

8.  Show Cr Bal Cust Only ?

Y or N.

The option to print customers with credit balances only.

9.  Show Open Items Only ?

Y or N.

If you answer Y to this, only invoices that have not been paid will be reported, otherwise, all transactions for the selected customer range will be printed.

10. Print Notes

Y = Report will print notes attached to customer record in File Maintenance and any other notes specified in Notes Type default values.

Report By Collector

 

Name

Type and Description

1  .Detail Or Summary ?

1 alphanumeric character.

Enter either D to print the report in detail format, or S to print the report in summary format.

Defaults to S.

2.  Print In Apply‑To Number Order Or Document Date Order

1 alphanumeric character.

Enter A to specify apply‑to number order, or D to specify document date order.

If the items are printed in apply‑to number order, each invoice will be immediately followed by those payments, credit memos, etc. that apply to it.  Otherwise, the report will be printed in document date order, without any reference to the apply‑to number of the document.

Show Doc Age Detail ?

Y or N.

Enter whether you want to show aged detail on the aging report or not.

If you answer Y to this question, the report will place each open item with a non‑zero balance into the correct aging period.

This option will appear only if the Aging Report is printed in detail and printed in apply‑to order.

3.   Aging Date

 

 

A date in the standard date format.

Enter the date to be used for calculating the age of the open items.  For example, if you want to know how old a customer's account was as of the end of December 1989, enter 12/31/89 for the aging date.  A document on the customer's account that is dated 11/15/89 would then be more than 30 days old, and would appear in the second aging period, if we use the periods as we defined them above.

Defaults to system date.

Y or N

Enter whether you want to show aged detail n the aging report or not.  If you answer BYB, the report will place each open item with a non-zero balance into the correct againg period (bucket).

This option will appear only if the Aging Report is printed in detail and printed in Apply-To Order.

4.  Include Items Past Aging Date ?

Y or N.

If you answer N to this question, no open items will appear on the report whose date is after the aging date.  On the other hand, if you answer Y here, all items will still be aged as of the aging date, but all open items on a customer's account will be printed (assuming you specified you want to print the report in detail format above).  Any items not yet due will appear in aging period one.

5.  Starting Collector

3 alphanumeric characters.

This question and the next one (Ending Collector) allow you to specify a range of collectors to print on the Aging Report.

If you press RETURN for the entry of the starting collector, the field will default to All col­lectors and the entry of the ending collector will be skipped.

6.  Ending Collector

3 alphanumeric characters.

If you press RETURN for the entry of the ending collector, the field will default to the same value as entered for the starting col­lector.  In other words, only the collector specified by starting collector will appear on the report.

7.  Minimum Balance Due

9 numeric digits (999,999,999).

This question allows you to speci­fy the minimum balance a customer must have in the specified aging periods (see below) in order to appear on the report.

If you press RETURN, the entry will default to All, meaning a minimum balance of zero dollars and entry of this aging period or older will be skipped.

In This Aging Prd Or Older

1 numeric character from 1 to 4.

This field defaults to 1 which means that any customer who owes at least the specified amount due will appear on the report.

In This Aging Prd Or Older

If a number from 2 to 4 is entered, only those customers who have had the amount due for the specified aging period or longer will appear on the report.  For example, if $200 is specified for this field only those customers who have at least $200 due from the third or fourth aging period will appear on the report.  If 1 had been specified as the aging period then more customers would appear on the report because cus­tomers who had at least $200 due in any aging period would appear on the report.  If you are trying to find those customers who have the most amount of money which has been overdue for the longest period of time, then this field is used, otherwise just specify 1.  When 1 is entered, All is dis­played to remind you that all aging periods will be used.

8.  Show Cr Bal Cust Only ?

Y or N.

The option to print customers with credit balances only.

9.  Show Open Items Only ?

Y or N.

If you answer Y to this, only invoices that have not been paid will be reported, otherwise, all transaction for the selected customer range will be printed.

10. Print Separate Page

Y or N.

If you answer Y, then each collector will print on separate pages, otherwise it will print one collector after the other on the same page.

11. Print Notes

Y = Report will print notes attached to customer record in File Maintenance and any other notes specified in Notes Type default values.

 


Aging Report Selections

 

 

 

 

 

Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check an Order After Filling Back Order
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - ACH Deposit Effective Date
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. Feature - Customer Account Inquiry Reference Search
  64. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  65. ARFRMMNT Accounts Receivable Invoice Form Setup
  66. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  67. Feature - Ship Via Group Support
  68. Feature - Scheduling ACH Payments
  69. How to Print A/R Aging Report by Salesman
  70. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  71. Feature - Add Acct Name to ACH Account Detail Screen
  72. Feature - ACH Add and Change Event
  73. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  74. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  75. Feature - Age Customer Accounts When Cash Receipts Are Posted
  76. Feature - Validate Collector Against Salesman File
  77. NSCTLMN2 Accounts Receivable Global Setup 1
  78. NSCTLMN2 Accounts Receivable Global Setup 2
  79. NSCTLMN2 Accounts Receivable Global Setup 3
  80. NSCTLMN2 Accounts Payable Global Setup 1
  81. NSCTLMN2 Accounts Payable Global Setup 2
  82. NSCTLMN2 Accounts Payable Global Setup 3
  83. NSCTLMN2 Accounts Payable Global Setup 4
  84. NSCTLMN2 Accounts Payable Global Setup 5
  85. NSCTLMN2 Accounts Payable Global Setup 6
  86. NSCTLMN2 Accounting Global Setup: Index
  87. Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
  88. What Does the Asterisk Mean in A/R Account Inquiry?
  89. ARRECMNT Accounts Receivable Customer/eContact Import Utility
  90. Refund Customer for Open Credit or Over Payment
  91. Feature - Defer Cash Receipts with Wildcard Batch Entry
  92. Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd

Feedback and Knowledge Base