Table - INTCAL

The INTCAL (Interest Calculation) table contains the dates and percentages required to calculate interest charge amounts.  The INTCAL table is used by the Prepare Lien File program in the Tax Billing module and the Tax Receipt Entry program in the Cash Receipts module.

Notes:

Example:

 

INTCAL Table Field Descriptions

Notes:

  • Each row represents a billing period.

  • Use as many rows in the table as there are outstanding billing periods for which interest must be calculated.  INTCAL allows a maximum of 12 rows.  For additional rows, use the INTCAL2 table.

  • The formatting for the data is special, because this table is stored in a numeric format.

Column

Description

1

Due Date:  Enter the four-digit Due Date.

Example:  For Due Date 0203 (billing 2 in 2003), enter 203.00.

2

From Date:  Enter the calendar date for the Due Date.  The programs use this date to calculate the number of days within a period and in turn calculate the interest charge for a period.

Example:  For April 18, 2003, enter 200304.18

3

Rate:  Enter the annual rate used to calculate interest charges as a percentage.

Example:  For 18.75%, enter 18.75.

4

Interest Days in Year:  Enter the number of days within the year.  The programs use this to determine the interest amount per day, and then in turn the interest amount for a period.

Note:  Some municipalities enter fewer than 365 days to accommodate holidays on which no interest is charged.

Example:  For 360 days, enter 360.00.

Other Tables