Atable Entries

The Atable Entries form displays all details of payments and interest calculations for the amortization payment schedule. This includes break down of payments into amounts paid to Principal and paid to Interest, Remaining principal and Interest negated.

Amortization Table Summary

To print this to the Browser for easy viewing, please see How To Use the Amortization Schedule.

This table is divided into three sections:

Actual account activity
Running payment schedule, including - declining principal and interest

- owing

- amount of each payment applied to principal and interest
Actual account balances.

Actual Account Activity

The first ten columns in this table record actual account activity.

This includes payment amount and breakdown, fees, charges and outstanding interest, balance and CBR status.

Term

This is the number of the Term payment the line entry refers to. The total number of payments in this column is taken from the Term set up for the schedule.

Date

This is the Date the Term payment is due. This is taken from the payment setup. It is determined by the First Payment Date and the period of the loan.

Paid

This column shows the actual amount posted to the account as a payment. Normally, this would be the same as the Payment Amount agreed upon in the schedule.

Principal

This columns is the portion of the payment that is applied to Principal.

Interest

This column is the portion of the payment that is applied to Interest. When payments are missed, the interest is displayed in the Interest Charged column and is added to the Balance.

Fees

This column is the portion of the payment that is applied to Fees. Normally, this is the same as an amount in the Charges column.

Charges

This column shows any fees charged for the period, such as late fees. This amount is added to the Balance.

Interest Charged

This is Interest that is outstanding for the period because a Term payment was missed or underpaid. This amount is added to the Balance and is figured into the next payment's breakdown.

Balance

This is the Balance Owing on the account. This amount diminishes as payments are made. If payments are missed, the Interest accumulates and is added to the Balance. Charges are also added into this amount.

CBR

This is the CBR Status of the account. If you are using Credit Bureau Reporting, the account will be reported with the Status Code shown here. This Code may change depending on the account activity for the reporting period.

Running Payment Schedule

The next five columns in this table display the payment contract set up in the amortization schedule. If payments are made regularly and on time, the amounts in these columns indicate the declining principal, interest, owing, and payment breakdown. Missed payments or underpayments will affect this running schedule.

Original Principal

The amounts in this column show the declining principal as payments are made regularly and on time. This column will always show figures as originally calculated when the schedule was set up.

Original Interest

The amounts in this column show the interest calculated on the principal for the term. This column will always show figures as originally calculated when the schedule was set up.

Original Owing

The amounts in this column show the declining owing as payments are made regularly and on time. This column will always show figures as originally calculated when the schedule was set up.

Original To Principal

The amounts in this column show the amount of the Term payment that will be applied to principal. The amounts in this column will fluctuate if a payment is missed or underpaid.

Original To Interest

The amounts in this column show the amount of the Term payment that will be applied to interest. The amounts in this column will fluctuate if a payment is missed or underpaid.

Actual Account Balances

The last two columns in this table show the actual outstanding balance for the account and the outstanding interest.

Remaining Principal

This is the actual principal amount still owing on the account. This amount may fluctuate depending on missed payments, overpayments or underpayments.

Total Interest Negated

This column keeps track of interest accumulated when payments are missed. The amount in this column is applied to interest when a payment is made. If necessary, it may take several payments to satisfy the outstanding interest before an amount is applied to principal again.

Summary

The Atable Entries table is a very comprehensive representation of account activity and interest details. You may run the Amortize Running report from the Demodb database for a condensed version of this table. If you do not have this report in your Demo, please request it from Collect! Technical Services.

Email Collect!