Skip to main content
Avalara Help Center

TM_00523_srtcomma20l

KEY FOR COMMA-DELIMITED SSF FILES SORTED WITH SRTCOMMA20L.EXE 

FORMAT (when not using –p option to generate PCodes) 

Country, State, County, Locality, Tax type, Tax level, Tax rate, Tax amount, Gross sales, Exempt, Adjustments, Taxable measure, Minutes, Lines 

TAX TYPE 

See Tax Types table for listing. 

TAX LEVEL 

0 = Federal, 1 = State, 2 = County, 3 = City, 4 = Un-incorporated 

SAMPLE DATA FROM COMMA-DELIMITED SSF FILE (when not using –p option to generate PCodes) 

USA, , , , 6, 0, 0.030000, 3918.885187, 131232.584624, 0.000000, 301.537740, 130931.046884, 8499.8, 2787 

USA, , , , 18, 0, 0.089000, 2516.016936, 28557.808862, 0.000000, 143.978070, 28413.830792, 1672.2, 0 

USA, CA, , , 9, 1, 0.001100, 0.045892, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

USA, CA, , , 10, 1, 0.007200, 0.311699, 43.291581, 0.000000, 0.000000, 43.291581, 1.6, 0 

USA, CA, , , 19, 1, 0.022000, 0.917840, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

USA, CA, , , 22, 1, 0.012000, 0.500640, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

USA, CA, , , 23, 1, 0.000470, 0.019608, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

USA, CA, , , 60, 1, 0.002100, 0.087612, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

USA, CA, SANTA CLARA, SAN JOSE, 16, 3, 0.050000, 0.817500, 16.349999, 0.000000, 0.000000, 16.349999, 1.0, 0 

USA, CO, , , 13, 1, 0.023000, 777.750275, 33859.089271, 0.000000, 21.929999, 33837.159272, 467.2, 0 

FORMAT (when using –p option) 

PCodes displayed in SSF file instead of country, county, and locality 

PCode, Tax type, Tax level, Tax rate, Tax amount, Gross sales, Exempt, Adjustments, Taxable measure, Minutes, Lines 

TAX TYPE 

See Tax Types table for listing. 

TAX LEVEL 

0 = Federal, 1 = State, 2 = County, 3 = City, 4 = Un-incorporated 

SAMPLE DATA FROM COMMA-DELIMITED SSF FILE (when using –p option) 

PCodes displayed in SSF file instead of country, county, and locality 

0, 6, 0, 0.030000, 3918.885187, 131232.584624, 0.000000, 301.537740, 130931.046884, 8499.8, 2787 

0, 18, 0, 0.089000, 2516.016936, 28557.808862, 0.000000, 143.978070, 28413.830792, 1672.2, 0 

253500, 9, 1, 0.001100, 0.045892, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

253500, 10, 1, 0.007200, 0.311699, 43.291581, 0.000000, 0.000000, 43.291581, 1.6, 0 

253500, 19, 1, 0.022000, 0.917840, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

253500, 22, 1, 0.012000, 0.500640, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

253500, 23, 1, 0.000470, 0.019608, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

253500, 60, 1, 0.002100, 0.087612, 41.719989, 0.000000, 0.000000, 41.719989, 1.6, 0 

390700, 16, 3, 0.050000, 0.817500, 16.349999, 0.000000, 0.000000, 16.349999, 1.0, 0 

427200, 13, 1, 0.023000, 777.750275, 33859.089271, 0.000000, 21.929999, 33837.159272, 467.2, 0

  • Was this article helpful?