Period End Processing Aging Report

 

The Period-End Processing AR Aging Report is exactly the same as that which is documented as part of the Accounts Receivable main menu in the Aging Report Main Menu section. It appears on both the main menu and the period end menu solely for the convenience of the operator.

 

Aging Report

 

Function

The Aging Report prints an aged trial balance of customer accounts in either numeric or alphabetic sequence, with the option of displaying detail or summarized information for each customer.

 

=> To access this task...

Select Aging Report from the Accounts Receivable Period End Processing menu.

 

AR Aging Report menu

AR Aging Report

 

About the Fields

 

In the Aging Date field...

  • Click Calendar button to select the date upon which aging is based. Today's date is the default.

In the Age by field...

  • Select Due Date (D) to age all invoices based on their due date.

  • Select Invoice Date (I) to age all invoices based on their invoice date.

NOTE: When using the aging report to help determine whether or not a customer should be assessed finance charges, pay close attention to the date selected for aging.

 

In the Summary or Detail field...

  • Select Summary (S) to print a single line for each customer.

  • Select Detail (D) to print all open invoices for each customer.

In the Report Sequence field...

  • Select Customer (C) for a report sorted by customer number.

  • Select Salesperson (S) for a report sorted by salesperson code.

In the Sort Sequence field...

  • Select Alternate Sequence (A) to sort in alphabetical order.

  • Select Customer ID Sequence (N) to sort in numeric sequence by customer number.

In the Beginning/Ending Customer ID field...

Is active when Customer ID Sequence (N) is selected in Sort Sequence step.

  • Enter the first/last customer number to begin the report.

  • Press [Enter] to start with the first/last on file.

  • Click Click to select from a list of all valid customers.

In the Beginning/Ending Alt Sequence field...

Is active when Alternate Sequence (A) is selected in Sort Sequence step.

  • Enter the first/last customer letter to begin the report.

  • Press [Enter] to start/end with the first/last on file.

In the Beginning/Ending Salesperson field...

Is active when Salesperson (S) is selected in the Report Sequence step.

  • Enter the first/last salesperson number to begin/end the report.

  • Click Click to select from a list of valid salespeople.

Future Aging checkbox...

  • Mark the box to include all invoices and payments regardless of their dates.

  • Unmark the box to exclude any accounts receivable transactions that occurred after the aging date for the report being run, such as a payment received after the end of the period.

 

NOTE: For an aging report that can be used to balance the accounts receivable general ledger account, select Invoice Date (I) in the Age by field and check the Future Aging field.

 

Age Credits checkbox...

  • Mark the box to include credit balances on the printed report.

  • Unmark the  box to print the report without credit balances.

  • Press [Enter] to leave blank and proceed to the next field.

Update Customer Aging Summary checkbox...

  • Mark the box to update customer information.

  • Unmark the box to print the report without updating customer information.

  • Press [Enter] to leave blank and proceed to the next field.

Example

If the current month is June, but you want to print an aging as of February 28, uncheck this box so that the aging displayed under customer maintenance is not changed to reflect February amounts.

 

Include Customer Comments checkbox...

  • Mark the box to include comments on the report that are associated with the customer.

  • Unmark the box to print the report without customer comments.

  • Press [Enter] to leave blank and proceed to the next field.

Fixed Size Aging Periods checkbox...

  • Mark the box to use fixed size for all buckets. The system will automatically calculate the periods using aging date and aging period size.

  • Unmark the box to enter date for each bucket separately.

In the Aging Period Size field...

  • Enter the number of days for each aging bucket. The number must be at least one (1) and can range up to199 days.

Export Format checkbox...

  • Mark the box to show the printed report in columnar format.

  • Unmark the box to show in non-columnar format.

When done making selections...

  • Click Run Process button when the information is correct and proceed with the printing.

  • Click Clear Form button to clear the form and begin again.

Attempting to leave an unsaved Aging Report by clicking the New/Clear Form button, the module issues this confirmation:

 

Save changes for this record?

Save Changes

 

  • Click [Yes] to save the current record and proceed with printing the report.

  • Click [No] to return to the Aging Date field in Aging Report form without printing and saving.

  • Click [Cancel] to return to the current Aging Report screen.

As the Aging Report prints, the aging summary figures are recalculated for each customer and written to the Customer Master File.

 

Sample Aging Report

 

See Output Options.

 



______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.