My WebLink
|
Help
|
About
|
Sign Out
Home
TAT Bulk Filers Instructions - HCTAT
PublicDocuments
>
Finance Department
>
Internal Control and Transient Accomodations Tax Division
>
Archived
>
TAT Bulk Filers Instructions - HCTAT
Metadata
Thumbnails
Annotations
Entry Properties
Last modified
2/7/2022 11:31:32 AM
Creation date
2/7/2022 11:31:16 AM
Metadata
There are no annotations on this page.
Document management portal powered by Laserfiche WebLink 9 © 1998-2015
Laserfiche.
All rights reserved.
/
7
PDF
Print
Pages to print
Enter page numbers and/or page ranges separated by commas. For example, 1,3,5-12.
After downloading, print the document using a PDF reader (e.g. Adobe Reader).
View images
View plain text
COUNTY O IHAWAI'l HCi"A i°>E '<.NLk, >E Ip.,FR [`R0(JRAM IHANpi>E OOIk, <br />a. Do not include blank rows within your data set. A blank row is interpreted as the <br />end of your file. Payment data entered after the blank row will not be imported. <br />b. The first row is reserved for column headings. Return data entered in Row 1 will <br />result in a file being rejected by Internal Control Division. <br />c. Each row represents one Hawaii Tax ID Number. <br />d. A separate column must be used for each piece of information. <br />e. File type must be in Microsoft Excel (.xlsx) format. Please refer to File Naming <br />Standard section of this Handbook for naming the worksheet. <br />f. The workbook's worksheet tab name must not be modified or renamed. <br />g. Non -currency fields should be formatted as a text. <br />h. Include dashes in Hawaii Tax ID Number. <br />i. Do not include duplicate Hawaii Tax ID Numbers. <br />j. If an amount field is imported as blank, the Internal Control Division will process <br />it as zero. <br />k. Amounts containing cents must contain a decimal. <br />I. All amounts must be positive. <br />m. ACH payment submitted to the online portal must equal to the sum of the column <br />"Amount of Payment". <br />
The URL can be used to link to this page
Your browser does not support the video tag.