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