Spreadsheet: 62eae99a-a004-4173-8396-52eafd541c57
Sheet: Sheet1

 | Unnamed: 1 | Unnamed: 2 | DR 0100 Line 1 | DR 0100 Line 2a | Part A >>> | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Part B >>> | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Line 3 | Line 3a | Line 3b | Line 3c | Line 4 | DR 0100 | Line 5 | Line 6 | Line 7 | Line 8a | Line 8b | Line 9 | Line 10 | Line 10.1 | Line 11 | Line 12 | Line 13 | Line 14 | Line 15
Location Acct # | [NAME] | TaxCode | Gross Sales & Service | Licensed Dealer Sales | Service Sales | Govt Charitable Sales | Gas | Prescriptions Prosthetics | Trade-ins | Bad Debt | Utilities for Restaurant | Agricultural Compounds | Other Deduction | Other Deduction Explanation | Part A Total     DR 0100 Line 2b | Food | Machinery | Electricity | Farm Equipment | Pesticides | Low Emit Vehicles | School Related Sales | Cigarettes | Renewable Energy Components | Other Exemption | Other Exemption Explanation | Part B Total | Net Sales | Out of Taxing Area Sales | Exemptions | Overpayment from Previous Return | Net Taxable Sales | Tax Rate | Amount of Sales Tax | Excess Tax Collected | Total | Service Fee Rate | Service Fee Allowed | Sales Tax Due | Goods From Inventory | Tax on Goods from Inventory | Tax Due | Penalty | Interest | Total for each Tax Type | Total for each branch location
[PHONE] | 110059 | State | 600 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 600 |  | 0 |  | 600 | 0.029 | 17.4 |  | 17.4 | 0.0222 | 0.3862800000000001 | 17.01372 |  | 0 | 17.01372 |  |  | 17.01372 | 29.2674
[PHONE] | 110059 | LID |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 600 |  | 0 |  | 600 | 0.005 | 3 |  | 3 | 0.0333 | 0.09990000000000002 | 2.9001 | 0 | 0 | 2.9001 |  |  | 2.9001
[PHONE] | 110059 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 600 |  | 0 |  | 600 | 0.005 | 3 |  | 3 | 0.0333 | 0.09990000000000002 | 2.9001 | 0 | 0 | 2.9001 |  |  | 2.9001
[PHONE] | 110059 | RTD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 600 |  | 0 |  | 600 | 0.01 | 6 |  | 6 | 0.0222 | 0.1332 | 5.8668 | 0 | 0 | 5.8668 |  |  | 5.8668
[PHONE] | 110059 | CD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 600 |  | 0 |  | 600 | 0.001 | 0.6 |  | 0.6 | 0.0222 | 0.01332 | 0.58668 | 0 | 0 | 0.58668 |  |  | 0.58668
[PHONE] | 470206 | State | 300 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 300 |  | 0 |  | 300 | 0.029 | 8.700000000000001 |  | 8.700000000000001 | 0.0222 | 0.19314 | 8.506860000000001 |  | 0 | 8.506860000000001 |  |  | 8.506860000000001 | 11.7303
[PHONE] | 470206 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 300 |  | 0 |  | 300 | 0.01 | 3 |  | 3 | 0.0233 | 0.0699 | 2.9301 | 0 | 0 | 2.9301 |  |  | 2.9301
[PHONE] | 470206 | CD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 300 |  | 0 |  | 300 | 0.001 | 0.3 |  | 0.3 | 0.0222 | 0.00666 | 0.29334 | 0 | 0 | 0.29334 |  |  | 0.29334
[PHONE] | 040052 | State | 400 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 400 |  | 0 |  | 400 | 0.029 | 11.6 |  | 11.6 | 0.0222 | 0.25752 | 11.34248 |  | 0 | 11.34248 |  |  | 11.34248 | 34.14248000000001
[PHONE] | 040052 | City |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 400 |  | 0 |  | 400 | 0.039 | 15.6 |  | 15.6 | 0 | 0 | 15.6 | 0 | 0 | 15.6 |  |  | 15.6
[PHONE] | 040052 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 400 |  | 0 |  | 400 | 0.01 | 4 |  | 4 | 0 | 0 | 4 | 0 | 0 | 4 |  |  | 4
[PHONE] | 040052 | RTA |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 400 |  | 0 |  | 400 | 0.008 | 3.2 |  | 3.2 | 0 | 0 | 3.2 | 0 | 0 | 3.2 |  |  | 3.2
[PHONE] | 060031 | State | 200 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 200 |  | 0 |  | 200 | 0.029 | 5.800000000000001 |  | 5.800000000000001 | 0.0222 | 0.12876 | 5.671240000000001 |  | 0 | 5.671240000000001 |  |  | 5.671240000000001 | 7.217960000000001
[PHONE] | 060031 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 200 |  | 0 |  | 200 | 0.008 | 1.6 |  | 1.6 | 0.0333 | 0.05328000000000001 | 1.54672 | 0 | 0 | 1.54672 |  |  | 1.54672
[PHONE] | 030206 | State | 1000 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1000 |  | 0 |  | 1000 | 0.029 | 29 |  | 29 | 0.0222 | 0.6438 | 28.3562 |  | 0 | 28.3562 |  |  | 28.3562 | 28.3562
[PHONE] | 070206 | State | 900 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 900 |  | 0 |  | 900 | 0.029 | 26.1 |  | 26.1 | 0.0222 | 0.57942 | 25.52058 |  | 0 | 25.52058 |  |  | 25.52058 | 42.4008
[PHONE] | 070206 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 900 |  | 0 |  | 900 | 0.008 | 7.2 |  | 7.2 | 0 | 0 | 7.2 | 0 | 0 | 7.2 |  |  | 7.2
[PHONE] | 070206 | RTD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 900 |  | 0 |  | 900 | 0.01 | 9 |  | 9 | 0.0222 | 0.1998 | 8.8002 | 0 | 0 | 8.8002 |  |  | 8.8002
[PHONE] | 070206 | CD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 900 |  | 0 |  | 900 | 0.001 | 0.9 |  | 0.9 | 0.0222 | 0.01998 | 0.88002 | 0 | 0 | 0.88002 |  |  | 0.88002
[PHONE] | 470031 | State | 750 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 750 |  | 0 |  | 750 | 0.029 | 21.75 |  | 21.75 | 0.0222 | 0.48285 | 21.26715 |  | 0 | 21.26715 |  |  | 21.26715 | 36.65925
[PHONE] | 470031 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 750 |  | 0 |  | 750 | 0.01 | 7.5 |  | 7.5 | 0.0233 | 0.17475 | 7.32525 | 0 | 0 | 7.32525 |  |  | 7.32525
[PHONE] | 470031 | RTD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 750 |  | 0 |  | 750 | 0.01 | 7.5 |  | 7.5 | 0.0222 | 0.1665 | 7.3335 | 0 | 0 | 7.3335 |  |  | 7.3335
[PHONE] | 470031 | CD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 750 |  | 0 |  | 750 | 0.001 | 0.75 |  | 0.75 | 0.0222 | 0.01665 | 0.73335 | 0 | 0 | 0.73335 |  |  | 0.73335
[PHONE] | 540007 | State | 500 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 500 |  | 0 |  | 500 | 0.029 | 14.5 |  | 14.5 | 0.0222 | 0.3219 | 14.1781 |  | 0 | 14.1781 |  |  | 14.1781 | 38.3456
[PHONE] | 540007 | City |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 500 |  | 0 |  | 500 | 0.04 | 20 |  | 20 | 0.0333 | 0.666 | 19.334 | 0 | 0 | 19.334 |  |  | 19.334
[PHONE] | 540007 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 500 |  | 0 |  | 500 | 0.01 | 5 |  | 5 | 0.0333 | 0.1665 | 4.8335 | 0 | 0 | 4.8335 |  |  | 4.8335
[PHONE] | 610005 | State | 800 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 800 |  | 0 |  | 800 | 0.029 | 23.2 |  | 23.2 | 0.0222 | 0.51504 | 22.68496 |  | 0 | 22.68496 |  |  | 22.68496 | 52.65266000000001
[PHONE] | 610005 | City |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 800 |  | 0 |  | 800 | 0.01 | 8 |  | 8 | 0.0333 | 0.2664 | 7.7336 | 0 | 0 | 7.7336 |  |  | 7.7336
[PHONE] | 610005 | Cnty |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 800 |  | 0 |  | 800 | 0.02 | 16 |  | 16 | 0.0333 | 0.5328 | 15.4672 | 0 | 0 | 15.4672 |  |  | 15.4672
[PHONE] | 610005 | MT |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 800 |  | 0 |  | 800 | 0.0075 | 6 |  | 6 | 0.0333 | 0.1998 | 5.8002 | 0 | 0 | 5.8002 |  |  | 5.8002
[PHONE] | 610005 | MHA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 800 |  | 0 |  | 800 | 0.00125 | 1 |  | 1 | 0.0333 | 0.0333 | 0.9667 | 0 | 0 | 0.9667 |  |  | 0.9667
[PHONE] | 010006 | State | 600 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 600 |  | 0 |  | 600 | 0.029 | 17.4 |  | 17.4 | 0.0222 | 0.3862800000000001 | 17.01372 |  | 0 | 17.01372 |  |  | 17.01372 | 23.46720000000001
[PHONE] | 010006 | RTD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 600 |  | 0 |  | 600 | 0.01 | 6 |  | 6 | 0.0222 | 0.1332 | 5.8668 | 0 | 0 | 5.8668 |  |  | 5.8668
[PHONE] | 010006 | CD |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 600 |  | 0 |  | 600 | 0.001 | 0.6 |  | 0.6 | 0.0222 | 0.01332 | 0.58668 | 0 | 0 | 0.58668 |  |  | 0.58668