Detailed Field Information Related Information Examples & Tutorials

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

tip.gif 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.

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

Principal

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

Top of page.

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.

Top of page.

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.

Top of page.

Charges

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

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

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.

Top of page.

Actual Account Balances

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

Top of page.

Remaining Principal

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

Top of page.

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.

Top of page.

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!

Top of page.

See Also

- Interest Detail

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org