Processing a Charge Off and Non-Accruals

Processing a Charge Off and Non-Accruals

Charging off a Lease or a Loan in ASPIRE is a straightforward process although there are a couple different methods and options to do so. 

There are two ways to process a Loan charge-off.  The first way uses a contract modification and the other way uses a rewrite type.  There are subtle differences between the two methods.  Leases will always utilize a contract modification. 

A Global Setting controls the variability for loan Charge-Offs:

 

 Loans

Contract items for charge offs are system defined so users do not need to create a new contract item for them. 

The only other configuration for these items are the interface accounts.  Once they are configured, open the contract > Contract Explorer > Main.  Select Rewrite Type > Contract Modification and then Charge-Off for the Reason Code if applicable. 

Go into the Financing and Adjustments tab and add a non-financed contract item. 

Using the contract modification allows for partial charge-off to principal. 

The value field will default in the outstanding principal but it can be adjusted as necessary. 

 

 

Charging off though re-write type requires the configuration change in the first screenshot. 

Once this has been updated, rewrite type becomes available.

 Simply select a Reason Code, Effective Date, and hit Post. 

The contract status will change to Charge-Off using the rewrite type.

 


Loans – Journal Entries

Below are examples of Journal Entries based on the Charge-Off type for the Loan and what it looks like if the contract continues to be serviced. 

 

Contract Modification

Booking

DR. Principal

100,000

CR. Notes Payable

100,000

Charge-Off

DR. Charge-Off

100,000

CR. Write-Off Reserve

100,000

 

DR. Current Due - Loan

4,600

CR. Interest Income - Loan

4,600

Cash Posting

DR. Cash

1887.1

CR. Recovery - Loan

1887.1

 

 

Re-write Type

Booking

DR. Principal

100,000

CR. Notes Payable

100,000

Charge-Off

DR. Charge-Off

104,600

CR. Interest Income - Loan

4,600

 

 

 

CR. Principal

100,000

Cash Posting

DR. Cash

1887.1

CR. Recovery - Loan

1887.1

 

Usually charged-off with an effective date of the last payment received or that  plus one day.

  

Another Example of Loan Charge-Off Journal Entries

 

 

 

Leases

For leases, the process is like the loan example with the contract modification.  There are system defined contract items for Fee, lease, Residual, and Sales Tax Receivable. 

Select any one of these to charge-off the respective amount. 

The system will default the outstanding amount into the field but this can be changed as in the loan example.

  

 

Below are the Journal Entries that would be expected in ASPIRE.

 

Booking

DR. Contract Receivable

90,000

CR. Unearned Income

5,000

 

DR. Residual

10,000

CR. Accounts Payable

95,000

Charge-Off

DR. Charge-Off

90,000

CR. Write-Off Reserve

90,000

 

DR. Unearned Income

3,000

CR. Contract Receivable

3,000

Cash Posting

DR. Cash

1500

CR. Contract Receivable

1500

 

 Usual effective date of charge off 90 days after last payment received.

 

 


Non-Accrual

Allows seeing true contract earnings on non-performing contracts. Usually 1st step before terminating and repossessing. Non-

accrual keeps the deal active as it goes thru court/bankruptcy.

1.       Do a contract modification

2.       On the CE – Main screen – Accounting tab, check Non-Accrual and set Non-Accrual Effective Date.

a.       Leases - Usual effective date of charge off 90 days after last payment received.

b.       Loans - Usually charged-off with an effective date of the last payment received or that  plus one day.

3.      Have I run contract Earnings since the Effective Date of Non-Accrual, if so, posting the Non-Accrual will reverse contract earnings and put the reversed amount in non-accrual earnings account.

a.       Needs GL account setup with non-accrual earnings

b.       Moves income from earned income to non-accrual income

4.       If still receiving payments on contract in non-accrual

a.       Works like it normally does, lease receivable and current receivable will be written down

b.       Earnings on those payments will go to non-accrual income until the deal is taken off non-accrual

c.       Apply payment as example,

 

5.       Take off non-accrual when caught up, or within 30 days, depends on fin co/bank.

6.       To take off non-accrual, do another contract modification, uncheck the non-accrual box on the Accounting tab, earnings will be removed from non-accrual earnings back to contract earnings when posted.

 

 

Charge off

Write off the PV of the deal, remove from balance sheet. Puts it in reserve.  No longer any contract earnings on this deal after a

charge-off. This is bad debt that will be written off. Any payments received on this will go into a recovery account. There is no Undo Charge-off.

You can continue to invoice a charged off deal, maybe required for legal reasons.


1.       Do contract mod – reason code may equal bankruptcy.

2.       Go to Financing and Adjustments tab, there are Charge Off – Add Adjustment Items

a.       Able to charge off fees, lease receivable, residual, sales tax – each done separately

b.       PV of the asset receivable defaults into the value

c.       May leave residual on the books because that’s the value of the asset after repo

d.       Posting Confirmation – puts the charged off value into bad debt reserve account, charges off the interest portion of deferred income lease and gross lease receivable because this won’t earn interest any longer

e.       After posting, the accounting tab shows

                                                               i.      Current contract receivable and current receivable (currently open invoices) still show (sum those two and that was the amount charged off)

                                                             ii.      No deferred income cause it’s not earning any longer

                                                           iii.      Current residual still shows

                                                           iv.      There are some accelerate at charge-off settings for IDC (Global Settings)

f.        Go to Cash Receipts to apply $$ to a charge off

                                                               i.      Post payment and see there is some Recover and bad debt reserve activity


 




    • Related Articles

    • PTMS Processing Video

      See the attached documents and linked video for complete understanding. The linked video covers the import/export procedure for processing PTMS in ASPIRE. The attached documents provide a PPT deck for review and a document that provides file layout ...
    • Processing Partial Termination on Non-Accrual Direct Finance Lease

      This article was derived from a Community Posting asking the question - How do we process a partial termination on a Non-Accrual contract and what should we expect ASPIRE to produce for journal entries? Attached are the journal entries for the ...
    • Bulk Processing of Payment Extensions

      See attached document for details. In response to the increased number of borrower payment deferment requests, LTi has developed an add-on utility that allows bulk modifying multiple contracts for payment extensions.
    • Bulk Contract Update - Processing Bulk Contract Sales

      The attached document outlines the steps to process existing or new Bank Funding and Discount Pools The purpose of the document is to provide an overview of processing a bulk Contract Sales procedure. ASPIRE has tools available to automate this ...
    • Non-Accrual Configuration

      Non-Accrual Setup When a contract is placed on non-accrual it is due to the customer being past due (typically done at 90 days delinquent for most finance companies). This stops the contract from earning in the system and can also stop any amortized ...