AR Collection and Write-Off Procedures
|
Timeline for Collection Process
To ensure that our outstanding receivables are current, the following timeline has been created to outline which actions should occur when a receivable is X many days past due. We encourage organizations to keep copies of letters and note dates and times of phone calls in a file or on a note to the customer in the Central Customer Master File. In addition, we encourage these at the campus/administrative level to review all invoices over 90 days old.
| Days Past Due |
| Suggested Action |
| 0-15 days |
Step 1
| Organization Contacts Customer with Friendly Reminder Letter. This is intended to let the customer know that the invoice is past due.
|
| 16-30 days |
Step 2
| Organization Contacts Customer by Phone-- This phone call is intended to enable the organization and the customer to identify and discuss any problems with the sale or merchandise or to identify reason for late payment.
|
| 31-45 days |
Step 3
| Organization Contacts Customer with a Billing Letter.
|
| 46-60 days |
Step 4
| Organization Contacts Customer by Phone
|
| 61-75 days |
Step 5
| Organization Contacts Customer with Billing Letter.
|
| 76-90 days |
Step 6
| Organization Contacts Customer with Collection Agency Letter. This is intended to give the customer one last opportunity to pay prior to turning the invoice over to a collection agent.
*EXCEPTION FOR IUPUI DEPTS. - After completing suggested action steps 1 - 5 and the collection attempts have been unsuccessful, contact the IUPUI Accounting Office.
|
| 91-120 days |
Step 7
| 1st Placement of Debt with Collection Agency
|
Timeline for Write-off
(Goal: By End of 1st Quarter)
- Receivable on the AR System: An organization using the AR system should write off an AR when the organization deems it uncollectable.
- Receivable recorded on Auxiliary Voucher: An auxiliary or service unit not using the AR system should write-off the AR when it deems it uncollectable or by auxiliary closing. Note: Each receivable being written off should have been communicated to the AR Supervisor in writing during the year (address noted below).
- Receivable recorded on BARS: The bursar will continue to use the auto process in the system on 6/30. Information should be submitted to the AR Supervisor by the end of final close (address noted below).
- AR Not Recorded in GL: These should be submitted to the AR Supervisor by the end of final close (address noted below).
- Address to Send Information to AR Supervisor:
FMS
Kathy Cochard
Poplars 535
Bloomington Campus
AR Invoice Write-Off Process
Per IU Policy I-490, all receivable balances over 12 months old lacking current productive activity are to be written off. Link to policy: http://www.indiana.edu/~vpcfo/policies/accounting/i-490.html
The accounts receivable supervisor will identify, by account, all outstanding receivables that are 365 days old and send a report to the account manager once a year. The account manager should review this report and return the list to the AR supervisor noting which items were written off, by initiating a credit memo, or an explanation explaining why the receivable is not being written off. Please note the AR system allows organizations to write off receivables whenever the organization determines the receivable is uncollectable. We encourage organizations to write off uncollectable invoices in the AR system when they are deemed uncollectable.
Once the account manager determines that a receivable is uncollectable, (s)he should initiate a credit memo to write off the receivable (each invoice that is deemed uncollectable needs to have its own credit memo initiated). Each credit memo generated routes to the fiscal officer for approval in the system. Please use the following steps to initiate a credit memo that write-off a receivable:
- Enter Description: "To write off invoice."
- Enter Customer Number
- Enter Account Number: This should be the account number the invoice was generated on.
- Object Code: Depending on the which method your organization is using, the object code that should be used should be 8950 (Allowance Method) or 5105 (Direct Method)
- Amount: Enter the amount to be written off.
- Ref Inv Num: Enter the invoice number that needs to be written off.
- Attach a note to the credit memo: the note should document the reason for the write off and the age of the receivable.
In order to collect the write-off information for the trustees, the AR Supervisor will run an IUIE credit memo report based on object code 5105 and 8950 to gather the write offs for the letter to the trustees. Note: these object codes should only be used on the credit memo when an invoice is being written off.
Process for Write-Off for Auxiliary and Service Units
(not on the AR system)
The process for recording write-offs for auxiliary and service units will depend on which method to record the receivable the organization is using. Regardless of the method, however, the organization should send a letter to the AR supervisor identifying which invoices are being written off. An organization can send this letter to the AR supervisor anytime during the year-- you do not have to wait until the end of the year. All letters should be sent to the AR supervisor by July 31 for the previous fiscal year. Information can be sent via e-mail to: kjcochar@indiana.edu or through campus mail to: Kathy Cochard, Poplars 535
If an organization is using the accrual method to record the receivable, the following steps will address how the organization should write-off a receivable via the auxiliary voucher document:
- The next month do not re-accrue the amount of the receivable.
- Auxiliary or service unit will need to do an AV Doc with and Adjustment Type. Note: If adjustment is never done then income will have never been recorded, due to the automatic reversal. Contact FMS Auxiliary Consultant with questions.
- Send write-off information yearly/quarterly/monthly to the AR supervisor identifying what is being written off. All amounts need to be gathered by auxiliary July 31 for the previous fiscal year.
If an organization is using the adjustment method to record the receivable, the following steps will address how the organization should write-off a receivable via the auxiliary voucher document:
- Enter Description: To write off receivable.
- Posting Period: The month the organization is writing off the AR (within the normal edits of the document)
- Explanation: Further explanation of why the receivable is being written off.
- AV Type: Adjustment
- Enter Account Number: This should be the account number the invoice was generated on for the debit and credit amount.
- Object Code:
- Debit object code: Either 8950 (Allowance) or 5105 (Direct)
- Credit object code: Either 8119 or 8117
- See table below for example
- Amount: Enter the amount of the write off
- Send a report to the AR supervisor identifying what is being written off. The AR Supervisor will run an IUIE report to help ensure that all write-off information has been properly gathered for the report sent to the trustees.
The following table identifies entries for the auxiliary/service unit not using the AR system based on the method of uncollectables that the organization chooses to use.
| Method of Uncollectables |
Transaction |
Debit |
Credit |
| Direct Write Off |
To record initial receivable |
81xx-AR |
1800-Inc |
| Direct Write Off |
To record write off |
5105-Bad Debt Exp |
81xx-AR |
| Allowance for Uncollectables |
To record initial receivable |
81xx-AR |
1800-Inc |
| Allowance for Uncollectables |
To record allowance |
5105-Bad Debt Exp |
8950- Allow for Doubtful |
| Allowance for Uncollectables |
To record write off |
8950- Allow for Doubtful |
81xx-AR |
Accounts Receivable Not Recorded in GL
Organizations who have not recorded their receivables in the general ledger should send a letter before final close documenting the AR being written off to the AR Supervisor. This information will be gathered and summarized for the Trustees.
Failure to book accounts receivable in the general ledger is inappropriate. Please contact the AR Supervisor for assistance with booking.
|