How to Export Interest and Penalties - Custom Table

You can export all information in the Interest & Penalties Custom Rate tables to Excel.

1.Click Export Interest Table. Your export is added to the queue, and a message appears in the upper left corner when it is complete.
2.Click OK.
3.Select the #UTP_TABLE# tab.
4.Enter a Table Code.
5.Enter a Table Name.
6.Enter the Action of A for Add, U for Update, and D for Delete.
7.Select the #UTP_TABLE_DETAIL#.
8.Enter the Table Code.
9.Enter the Start Date.
10.Enter the End Date.
11.Enter the Compounding Option.
12.Enter the Interest Rate.

 

Notes:

•The separate tabs available in the workbook are #UTP_TABLE# and #UTP_TABLE_DETAIL#.
•When the custom rate table is exported you will see all the underlying rates for each Code, previously created.
•Typically, the Table Code would be the name of a country or something that would identify it as a certain subset of interests.
•The Name is to expand upon the code, given.
•Start Date and End Date are displayed for the custom rate table. The dates must be sequential, and rates entered for the rate table to work.
•The type of Compounding Option is required, as well. S=Simple, D=Daily, M=Monthly, Q=Quarterly. These options trigger the time value and tell time value how to do the math with the rates that are entered.
•Interest Rate can be entered in increments.
•This information can be imported back into the Uncertain Tax Positions Application in this format and then applied to a position.