{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Form"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form","index":0,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[50,0,50,10],[37,1,37,2],[38,1,38,2],[37,3,37,4],[38,3,38,4],[38,5,38,6],[38,9,38,10],[38,7,38,8],[40,1,40,2],[39,5,39,6],[39,7,39,8],[47,7,49,10],[41,9,41,10],[45,9,45,10],[39,1,39,2],[39,3,39,4],[36,1,36,2],[32,1,32,2],[30,1,30,2],[31,1,31,2],[34,1,34,2],[35,1,35,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[20,1,21,3],[25,1,26,3],[14,1,14,2],[13,1,13,2],[52,0,53,10],[33,1,33,2],[30,9,30,10],[31,9,31,10],[33,9,33,10],[33,5,33,6],[34,3,34,4],[32,7,32,8],[32,9,32,10],[30,7,30,8],[36,5,36,6],[34,9,34,10],[34,7,34,8],[35,7,35,8],[35,9,35,10],[34,5,34,6],[35,5,35,6],[40,9,40,10],[36,9,36,10],[37,9,37,10],[40,7,40,8],[39,9,39,10],[37,7,37,8],[36,7,36,8],[20,6,21,7],[20,8,21,8],[20,9,21,10],[25,7,26,7],[25,8,26,8],[25,9,26,10],[22,4,22,5],[20,4,21,5],[33,3,33,4],[22,6,22,7],[22,9,22,10],[27,9,27,10],[25,5,26,5],[25,6,26,6],[31,5,31,6],[31,3,31,4],[27,1,27,3],[25,4,26,4],[31,7,31,8],[33,7,33,8],[32,5,32,6],[0,0,0,10],[1,0,1,10],[5,1,5,2],[6,1,6,2],[2,0,4,1],[2,2,2,10],[3,2,3,10],[6,0,7,0],[7,1,7,2],[8,1,8,2],[49,5,49,6],[35,3,35,4],[47,5,48,6],[45,5,45,6],[40,3,40,4],[40,5,40,6],[30,5,30,6],[30,3,30,4],[37,5,37,6],[41,5,41,6],[44,0,49,4],[43,5,43,10],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,7,45,8],[31,0,32,0],[11,0,13,0],[36,0,39,0],[15,1,15,2],[22,1,22,3],[32,3,32,4],[36,3,36,4]]}
["VENDING MACHINE WORKSHEET\n\n                              Keep this form for your reference. Do not send with your tax return."]
["This form may be used to calculate Vending Machine taxes only. Additional taxes for non vending machine sales not calculated in this worksheet, should be added to the amounts reported on your Combined Excise Tax Return (CETR) or Retailing Return."]
["DATA ENTRY",null,"* For location codes and tax rates, please refer to the Local Sales and Use Tax (LSU) Flyer located on our website at "]
[null,null,"https://dor.wa.gov/taxes-rates/sales-use-tax-rates/local-sales-use-tax"]
[]
[null,"City",null,"Location Code *","Retail Sales Combined Tax Rate *","Gross Food","57% of Gross Food Sales","Sales Tax on 57%","Gross Soft Drink & Misc. Non-Food Product Sales","Net Taxable Sales"," Total Sales Tax within Gross Sales"]
["Current Tax Rate",null,null,null,null,null,{"$f":"F7*0.57","v":0},{"$f":"IF(D7=0,\"\",G7*E7)","v":""},null,{"$f":"IF(D7=0,\"\",I7/(E7+1))","v":""},{"$f":"IF(D7=0,\"\",I7-J7+H7)","v":""}]
[null,null,null,null,null,null,0,"",null,{"$f":"IF(D8=0,\"\",I8/(E8+1))","v":""},""]
[null,null,null,null,null,null,0,"",null,"",""]
[null,null,null,null,null,null,0,"",null,"",""]
[null,null,null,null,null,null,0,"",null,"",""]
["Previous Tax Rates *\n(ex.  0.089)",null,null,null,null,null,0,"",null,"",""]
[null,null,null,null,null,null,0,"",null,"",""]
[null,null,null,null,null,null,0,"",null,"",""]
[null,null,null,null,null,null,0,"",null,"",""]
[null,null,null,null,null,null,0,"",null,"",""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F7:F16)","v":0},0,0,0,0,0]
[]
["CALCULATIONS - Transfer amounts to appropriate lines on the Excise Tax Return."]
[null,"Retailing B&O Tax "]
[null,"Gross Vending Machine Sales",null,null,"Less Sales Tax in Gross,\nDeduction 0214 **",null,"Taxable Sales Subject to Retailing B&O Tax",null,"Rate","Tax Due"]
[]
[null,{"$f":"F17+I17","v":0},null,null,{"$f":"K17","v":0},null,{"$f":"B23-E23","v":0},null,4.7099999999999998E-3,{"$f":"G23*I23","v":0}]
[]
[null,"Retail Sales Tax "]
[null,"Gross Vending Machine Sales",null,null,"Less Sales Tax in Gross,\nDeduction 0114 **","Less Exempt Food,\nDeduction \n0122 **","Total Deductions","Taxable Sales","Rate","Tax Due"]
[]
[null,{"$f":"B23","v":0},null,null,{"$f":"K17","v":0},{"$f":"F17-G17-H17","v":0},{"$f":"SUM(E28:F28)","v":0},{"$f":"B28-G28","v":0},6.5000000000000002E-2,{"$f":"H28*I28","v":0}]
[null,"** Itemize deductions on page 4, then transfer the totals to page 1, column 2."]
[null,"Local Sales Tax"]
[null,"City",null,"Location Code",null,"Taxable Amount",null,"Local Sales Tax Rate *",null,"Tax Due","Tax Due"]
["Current Tax Rate",{"$f":"B7","v":0},null,{"$f":"D7","v":0},null,{"$f":"IF(D32=0,\"\",(F7+I7)-(F7-G7-H7)-K7)","v":""},null,{"$f":"E7-$I$28","v":-6.5000000000000002E-2},null,{"$f":"IF(D32=0,\"\",F32*H32)","v":""}]
[null,0,null,{"$f":"D8","v":0},null,{"$f":"IF(D33=0,\"\",(F8+I8)-(F8-G8-H8)-K8)","v":""},null,{"$f":"E8-$I$28","v":-6.5000000000000002E-2},null,{"$f":"IF(D33=0,\"\",F33*H33)","v":""}]
[null,0,null,0,null,"",null,-6.5000000000000002E-2,null,""]
[null,0,null,0,null,"",null,-6.5000000000000002E-2,null,""]
[null,0,null,0,null,"",null,-6.5000000000000002E-2,null,""]
["Previous Local Tax Rates *\n(ex.  0.089)",0,null,0,null,"",null,{"$f":"E12-$I$28","v":-6.5000000000000002E-2},null,""]
[null,0,null,0,null,"",null,-6.5000000000000002E-2,null,""]
[null,0,null,0,null,"",null,-6.5000000000000002E-2,null,""]
[null,0,null,0,null,"",null,-6.5000000000000002E-2,null,""]
[null,0,null,0,null,"",null,-6.5000000000000002E-2,null,""]
[null,null,null,null,null,{"$f":"SUM(F32:F41)","v":0},null,null,null,{"$f":"SUM(J32:J41)","v":0}]
[]
[null,null,null,null,null,"Litter Tax "]
["Tax Due amount does not reflect the Small Business & Occupation Tax Credit.  To take your B&O Tax credit, please refer to the Small Business Credit Tables on our website at:",null,null,null,null,"Taxable Amount",null,"Tax Rate",null,"Tax Due","Tax Due"]
[null,null,null,null,null,{"$f":"G23","v":0},null,1.4999999999999999E-4,null,{"$f":"F46*H46","v":0}]
[null,null,null,null,null,"TOTALS"]
[null,null,null,null,null,"TAX DUE AMOUNTS FROM ABOVE"]
[]
[null,null,null,null,null,{"$f":"J49+J46+J42+J28+J23","v":0}]
["http://dor.wa.gov/Content/GetAFormOrPublication/FormBySubject/excise/default.aspx"]
[]
["For tax assistance or to request this document in an alternate format, visit http://dor.wa.gov or call 360-705-6705. Teletype (TTY) users may use the Washington Relay Service by calling 711. "]
[]
["REV 27 0035e-xls (4/10/25)"]