Field selections for Return Export
The data for each record in the return export file is written in the following order:
- Header Information
- Company Information
- Check Request Information
- Report Information
Records don't contain spaces between fields. Numbers are zero padded, contain leading negative signs, and don't contain decimal punctuation.
Header information
The following fields comprise the header information and are only written once to each record. They are written in the order shown.
- Locator Name
- Tax Period Number
- Tax Period Name
- State Code
- State Name
- Return Name
Company information
The following fields can be selected from Company Information organizer within the locator.
Field | Length | Format |
|---|---|---|
Company Name Line 1 | 45 | N/A |
Company Name Line 2 | 45 | N/A |
Company Address | 45 | N/A |
Company City | 26 | N/A |
Company State Abbreviation | 2 | N/A |
Company ZIP Code | 10 | xxxxx-xxxx |
Company Phone Number | 13 | (xxx) xxx-xxxx |
Company Business Code | 5 | N/A |
Company Federal ID Number | 11 | N/A |
Company Social Security Number | 13 | N/A |
Division or Location Code | 16 | N/A |
Calendar/Fiscal Beginning Date | 10 | xx/ xx/ xxxx |
Calendar/Fiscal Ending Date | 10 | xx/ xx/ xxxx |
Signature Title | 20 | N/A |
Check request information
The following fields can be selected from the Check Requests associated with the tax returns.
A = Alphanumeric D = Dollar Format for Dates is MM/DD/YYYY
Field | Length |
|---|---|
Pay to Name | A-35 |
Pay to Name 2 | A-35 |
Pay to Address | A-35 |
Pay to City-State-Zip | A-35 |
Account Code | A-17 |
Voucher Number | A-15 |
Amount of Check | D-15 |
Check Number | A-15 |
Stub Description | A-53 |
Check Date | A-10 |
Date to Pay | A-10 |
Payables/Cash Account No. | A-15 |
Prepared By | A-20 |
Approved By | A-20 |
Account Description 1 | A-20 |
Company/Office/Dept 1 | A-24 |
Account 1 | A-10 |
Amount 1 | D-15 |
Account Description 2 | A-20 |
Company/Office/Dept 2 | A-24 |
Account 2 | A-10 |
Amount 2 | D-15 |
Account Description 3 | A-20 |
Company/Office/Dept 3 | A-24 |
Account 3 | A-10 |
Amount 3 | D-15 |
Account Description 4 | A-20 |
Company/Office/Dept 4 | A-24 |
Account 4 | A-10 |
Amount 4 | D-15 |
Account Description 5 | A-20 |
Company/Office/Dept 5 | A-24 |
Account 5 | A-10 |
Amount 5 | D-15 |
Account Description 6 | A-20 |
Company/Office/Dept 6 | A-24 |
Account 6 | A-10 |
Amount 6 | D-15 |
Account Description 7 | A-20 |
Company/Office/Dept 7 | A-24 |
Account 7 Detail | A-10 |
Amount 7 Detail | D-15 |
Account Description 8 | A-20 |
Company/Office/Dept 8 | A-24 |
Account 8 Detail | A-10 |
Amount 8 Detail | D-15 |
Account Description 9 | A-20 |
Company/Office/Dept 9 | A-24 |
Account 9 | A-10 |
Amount 9 | D-15 |
Account Description 10 | A-20 |
Company/Office/Dept 10 | A-24 |
Account 10 | A-10 |
Amount 10 | D-15 |
Account Description 11 | A-20 |
Company/Office/Dept 11 | A-24 |
Account 11 | A-10 |
Amount 11 | D-15 |
Account Description 12 | A-20 |
Company/Office/Dept 12 | A-24 |
Account 12 | A-10 |
Amount 12 | D-15 |
Account Description 13 | A-20 |
Company/Office/Dept 13 | A-24 |
Account 13 | A-10 |
Amount 13 | D-15 |
Account Description 14 | A-20 |
Company/Office/Dept 14 | A-24 |
Account 14 | A-10 |
Amount 14 | D-15 |
Account Description 15 | A-20 |
Company/Office/Dept 15 | A-24 |
Account 15 | A-10 |
Amount 15 | D-15 |
Account Description 16 | A-20 |
Company/Office/Dept 16 | A-24 |
Account 16 | A-10 |
Amount 16 | D-15 |
Account Description 17 | A-20 |
Company/Office/Dept 17 | A-24 |
Account 17 | A-10 |
Amount 17 | D-15 |
Account Description 18 | A-20 |
Company/Office/Dept 18 | A-24 |
Account 18 | A-10 |
Amount 18 | D-15 |
Account Description 19 | A-20 |
Company/Office/Dept 19 | A-24 |
Account 19 | A-10 |
Amount 19 | D-15 |
Account Description 20 | A-20 |
Company/Office/Dept 20 | A-24 |
Account 20 | A-10 |
Amount 20 | D-15 |
Account Description 21 | A-20 |
Company/Office/Dept 21 | A-24 |
Account 21 | A-10 |
Amount 21 | D-15 |
Account Description 22 | A-20 |
Company/Office/Dept 22 | A-24 |
Account 22 | A-10 |
Amount 22 | D-15 |
Account Description 23 | A-20 |
Company/Office/Dept 23 | A-24 |
Account 23 | A-10 |
Amount 23 | D-15 |
Account Description 24 | A-20 |
Company/Office/Dept 24 | A-24 |
Account 24 | A-10 |
Amount 24 | D-15 |
Account Description 25 | A-20 |
Company/Office/Dept 25 | A-24 |
Account 25 | A-10 |
Amount 25 | D-15 |
Account Description 26 | A-20 |
Company/Office/Dept 26 | A-24 |
Account 26 | A-10 |
Amount 26 | D-15 |
Account Description 27 | A-20 |
Company/Office/Dept 27 | A-24 |
Account 27 | A-10 |
Amount 27 | D-15 |
Account Description 28 | A-20 |
Company/Office/Dept 28 | A-24 |
Account 28 | A-10 |
Amount 28 | D-15 |
Page Total | D-15 |
Grand Total | D-15 |
Report information
The following fields can be selected from the report area for each tax return. All fields are Dollar fields.
Field | Length |
|---|---|
Gross Sales/Receipts | 15 |
Exemptions/Deductions | 15 |
State Taxable Sales | 15 |
State Taxable Purchases | 15 |
State Sales Tax | 15 |
State Use Tax | 15 |
tate Total Tax | 15 |
County Sales Tax | 15 |
County Use Tax | 15 |
County Total Tax | 15 |
Local Sales Tax | 15 |
Local Use Tax | 15 |
Local Total Tax | 15 |
Total Sales Tax - All Levels | 15 |
Total Use Tax - All Levels | 15 |
Total Tax | 15 |
Total Tax - Rentals | 15 |
Total Tax - Rental All Levels | 15 |
Adjustments | 15 |
Prepayments | 15 |
Discounts | 15 |
Penalties | 15 |
Interest | 15 |
Net Tax Due | 15 |
Tax Collected | 15 |
Amount of Check | 15 |