Value Clothing is a large distributor of all types of clothing acquired from buy-outs, overstocks, and factory seconds. All sales are on account with terms of net 30 days from date of the monthly statement. The number of delinquent accounts and uncollectible accounts has increased significantly during the last 12 months. Management has determined that the information generated from the present accounts receivable system is inadequate and is not timely. Top management has requested a new system to satisfy the following objectives:

1. Produce current and timely reports regarding customers that would provide useful information to:

a. aid in controlling bad debts.

b. notify the Sales Department of customer accounts that are delinquent (accounts that should lose charging privileges).

c. notify the Sales Department of customers whose accounts are considered uncollectible (accounts that should be closed and written off).

2. Produce timely notices to customers regarding:

a. amounts owed to Value Clothing.

b. a change of status of their accounts (for example, loss of charge privileges, account closed).

3. Incorporate the necessary procedures and controls to minimize the chance for errors in customers accounts.

A project team youve been working with has selected a new accounting system with, what you believe, is a good customer (accounts receivable) module. A brief

description of the reports and other output generated by the new system is given below:

1. Accounts Receivable Registera daily alphabetical listing of all customers accounts that shows balance as of the last statement, activity since the last statement, and account balance.

2. Customer Statementsmonthly statements for each customer showing activity since the last statement and account balance; the top portion of the statement is returned with the payment and serves as the cash payment remittance advice.

3. Aging ScheduleAll Customersa monthly schedule of all customers with outstanding balances displaying the total amount owed with the total classified into age groups: 030 days, 3160 days, 6190 days, over 91 days; the schedule includes totals and percentages for each age category.

4. Aging SchedulePast Due Customersa schedule prepared monthly that includes only those customers whose accounts are past due, that is over 30 days outstanding classified by age. The credit manager uses this schedule to decide which customers will receive delinquent notices, temporary suspension of charge privileges, or have their accounts closed.

5. Activity Reportsmonthly reports that show:

a. Customers who have not purchased any merchandise for 90 days

b. Customers whose account balance exceeds their credit limit

b. Customers whose account balance exceeds their credit limit

c. Customers whose accounts are delinquent, yet they have current sales on account.

6. Delinquency and Write-off Registera monthly alphabetical listing of customers accounts that are:

a. delinquent

b. closed

These listings show name, account number, and balance. Related notices are prepared and sent to these customers.

7. Summary Journal Entriesentries are prepared monthly to record write-offs to the accounts receivable file.

Required:

a. Identify the data that should be captured and stored for each customer.

b. Review the proposed reports to be generated by the new accounts receivable system.

1. Discuss whether the proposed reports should be adequate to satisfy the objectives enumerated.

2. Recommend changes, if any, which should be made in the descriptions of the proposed reports and other output generated by the new accounts receivable system.