| | | Interest Calculation Explanation of how interest is calculated on Reconciliation Entries ACS Reconciliation Prototype: Interest Calculation Information RE: Corrected Version: September 9, 1999***This message is another replacement for earlier documents with the same title. The earlier version of 8/12/99 showed incorrect numbers of days. This was due to the improper use of a commercial spreadsheet function that assumes twelve 30-day months. The numbers of days and calculations were therefore incorrect, although the general illustration of the concepts was accurate. Copies of all earlier versions should be destroyed. We apologize for the inconvenience, again.***The legislation which authorizes the use of midpoint-date interest calculation for Reconciliations has been signed into law. A Federal Register notice was published on July 21, 1999 (64 FR 39187) announcing this change. This document explains how interest is to be calculated on Reconciliations, with illustrative examples.I. When Reconciliations result in a claim for a refund: For Value, 9802 and Classification Reconciliations where the importer claims a refund, interest calculation will be done by Customs upon liquidation of the Reconciliation, on an entry-by-entry basis. For NAFTA Reconciliations claiming a refund, Customs will calculate interest from the date of filing of the Reconciliation to the date it is liquidated. Refunds may only be claimed on Entry-by-entry Reconciliations.II. When Reconciliations result in additional money owed to Customs: The importer or filer calculates the Reconciliation interest due if the Reconciliation results in an increase in duties, taxes, or fees. The amount of interest calculated will be paid at the time of Reconciliation filing.Midpoint interest calculation will be used for Aggregate Reconciliations.Entry-by-entry interest calculation will be used for Entry-by-entry Reconciliations.III. Interest Rates The interest rates applicable are determined by the Internal Revenue Service and are published quarterly in the Federal Register. For reference, here are the rates in effect from the beginning of the prototype to present. When filing Reconciliations, filers need only calculate using the rate for underpayments, interest on overpayments (refunds) will be calculated by Customs. 04/01/98 - 12/31/98 | 8% | 01/01/01 - 03/31/01 | 9% | 04/01/01 - 06/30/01 | 8% | 07/01/01 - 09/30/01 | 7% | 01/01/02 - 12/31/02 | 6% | 01/01/03 | 5% | IV. How Reconciliation Interest Calculation Works (For additional payments) The formula below is used to calculate interest. It is used for both Entry-by-entry and Midpoint calculations of interest. For Entry-by-entry interest calculation, the formula is applied to each entry’s adjustment, from the date the importer was required to deposit each entry’s original payment, to the date the Reconciliation is filed with payment.For Midpoint interest calculation, the formula is applied to the total amount of adjustment made on the Reconciliation, from the midpoint date of the underlying entries until the Reconciliation payment date.V. Interest Formula Interest Is Calculated Using The Compound Interest Formula Of:(((1 + (RATE/NBR OF DAYS IN YR)) ^ NO OF DAYS) - 1) MULTIPLIED BY THE BILL/REFUND AMOUNT Basically, each day the amount is outstanding, interest accrues at the rate in effect for that day.EXAMPLE: RATE = 10% NUMBER OF DAYS IN YEAR = 365 NUMBER OF DAYS INTEREST = 60 BILL AMT = $1,000.00 STEP 1: (.10/365) = .00027395 (Daily Interest Rate...) STEP 2: (1 + .00027395) = 1.00027395 STEP 3: (1.00027395)^60 = 1.01657054 (...compounded for number of days...) STEP 4: (1.01657054 - 1) = .01657054 STEP 5: $1,000.00 * .01657054 = $16.57 (...applied to the principal) Where the "^" means, "Raised to the exponential power."IMPORTANT: When doing calculations across multiple time periods, such as different fiscal quarters, it is important to remember to add the interest determined for one period to the principal for calculation during the next period. (See example below.)VI. An example of extra payments on an Entry-by-entry Reconciliation:010104-5 | 01/05/99 | $300 | 010289-2 | 04/12/99 | $670 | 010346-8 | 05/28/99 | $600 | Reconciliation is filed on 09/15/99, making additional payment of $1570. Interest is separately calculated for each entry, using the additional amount of duties, taxes, and fees for each entry as the principal, with interest running from the date original payment was required through date of payment of the Reconciliation.The first step is to determine the number of days at each rate to apply interest to each additional payment amountEntry Number: 010104-5 on 01/05/99 | $300 | 01/05/99 – 03/31/99 (86 days) at 7%
04/01/99 – 06/30/99 (91 days) at 9%
07/01/99 – 09/15/99 (77 days) at 8% | Entry Number: 010289-2 on 04/12/99 | $670 | 04/12/99 - 06/30/99 (80 days) at 8%
07/01/99 - 09/15/99 (77 days) at 8% | Entry Number: 010346-8 on 05/28/99 | $600 | 05/28/99 - 06/30/99 (34 days) at 8%
07/01/99 - 09/15/99 (77 days) at 8% | Next, applying the formula from section V above we get the amount of interest applicable to the monetary adjustment of each entry via the Reconciliation. Because the interest is compound, the amount of interest for each calculated period becomes part of the principal for the next time period's calculation.Entry No. 010104-5
$300.00 | 01/05/99 - 03/31/99 (86 days) at 7% = | $4.99 | $304.99 | 04/01/99 - 06/30/99 (91 days) at 8% = | $6.14 | $311.13 | 07/01/99 - 09/15/99 (77 days) at 8% = | $5.29 | ----- | Total Interest for this entry: | $16.42 | Entry No. 010289-2
$670.00 | 04/12/99 - 06/30/99 (80 days) at 8% = | $11.85 | $681.85 | 07/01/99 - 09/15/99 (77 days) at 8% = | $11.60 | ----- | Total Interest for this entry: | $23.45 | Entry No. 010346-8
$600.00 | 05/28/99 - 06/30/99 (34 days) at 8% = | $4.49 | $604.49 | 07/01/99 - 09/15/99 (77 days) at 8% = | $10.29 | ----- | Total Interest for this entry: | $14.78 | Total Interest for Reconciliation.....................$54.65The individual amounts of interest are shown on the Association File, transmitted via ABI.VII. An example of extra payment on an Aggregate Reconciliation: Entry No. and Orig. Payment Date 010104-5 on 01/05/99 010289-2 on 04/12/99 010346-8 on 05/28/99Reconciliation is filed on 09/15/99, making additional payment of $1570. Because midpoint interest calculation is used for Aggregate Reconciliations, interest is calculated for the single amount of the additional payment on the Reconciliation as a whole, with interest running from the midpoint date through date of payment of the Reconciliation.The first step is to determine the midpoint date, and the number of days from that date until the filing/payment date of the Reconciliation.Midpoint Date = Earliest Date + ((Latest Date - Earliest Date)/2)The earliest summary payment date of the three entries above is 01/05/99, and the latest date is 05/28/99. There are 144 days between these dates. Halfway is 72. The earliest date + 72 days gives the midpoint date, which is 03/17/99. (If halfway between the dates comes up with a fraction, it is rounded down. For example, 71.5, is rounded to 71.)Next, applying the formula from section V above we get the amount of interest applicable to the monetary adjustment on the Reconciliation.Recon. No. 090966-8
$1570.00 | 03/17/99 - 03/31/99 (15 days) at 7% = | $4.52 | $1574.52 | 04/01/99 - 06/30/99 (91 days) at 8% = | $31.72 | $1606.24 | 07/01/99 - 09/15/99 (77 days) at 8% = | $27.34 | ----- | Total Interest for Reconciliation | $63.58 | VIII. Summary The process of calculating interest may appear complex, but the calculations involved are repetitive in nature, and the process can easily be facilitated through the use of commercial software such as general-purpose spreadsheets or specific accounting software packages. (As the different versions of this document illustrate, special care should be taken when initially setting up the process, so that it can be done correctly the first time.)Questions regarding this document, or the Reconciliation Prototype in general, may be directed to recon.help@dhs.gov. |
|
| | | |
|