{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tax_By_Group","Killeen -Absorbing Tax","Killeen - AF-105 Monies Due","Killeen -Adding Tax "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":"Tax_By_Group","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Sales Tax2"]
["Group (club/organization)","Total"]
["Grand Total"]

{"sheet":"Killeen -Absorbing Tax","index":1,"n_rows":319,"n_cols":8,"rows_kept":319,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
["Killeen Independent School District"]
["AF-105 Monthly Sales Tax Recap Report - City of Killeen"]
[]
[]
["Campus: ",null,null,null,"Month/Year:  "]
[]
["Complete the gray columns  only"]
[null,null,null,null,null,"Taxable"]
["Group (club/organization)","Type of Sale","Receipt #","Date(s)","Gross Sales","Sales","Sales Tax","Sales Tax"]
["Taxable Sales:"]
[null,null,null,null,null,{"$f":"E11-(E11*0.0762)","v":0},{"$f":"F11*0.0825","v":0},{"$f":"(G11*-0.005)+G11","v":0}]
[null,null,null,null,null,0,{"$f":"F12*0.0825","v":0},{"$f":"(G12*-0.005)+G12","v":0}]
[null,null,null,null,null,0,{"$f":"F13*0.0825","v":0},{"$f":"(G13*-0.005)+G13","v":0}]
[null,null,null,null,null,0,{"$f":"F14*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F15*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E16-(E16*0.0762)","v":0},{"$f":"F16*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E17-(E17*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E18-(E18*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E19-(E19*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F21*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F22*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F23*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F24*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E25-(E25*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E26-(E26*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E27-(E27*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E28-(E28*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F30*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F31*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F32*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F33*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E34-(E34*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E35-(E35*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E36-(E36*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E37-(E37*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F39*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F40*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F41*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F42*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E43-(E43*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E44-(E44*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E45-(E45*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E46-(E46*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F48*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F49*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F50*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F51*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E52-(E52*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E53-(E53*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E54-(E54*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E55-(E55*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F57*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F58*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F59*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F60*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E61-(E61*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E62-(E62*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E63-(E63*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E64-(E64*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F66*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F67*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F68*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F69*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E70-(E70*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E71-(E71*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E72-(E72*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E73-(E73*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F75*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F76*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F77*0.0825","v":0},{"$f":"(G77*-0.005)+G77","v":0}]
[null,null,null,null,null,0,{"$f":"F78*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E79-(E79*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E80-(E80*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E81-(E81*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E82-(E82*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F84*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F85*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F86*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F87*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E88-(E88*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E89-(E89*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E90-(E90*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E91-(E91*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F93*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F94*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F95*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F96*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E97-(E97*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E98-(E98*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E99-(E99*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E100-(E100*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F102*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F103*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F104*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F105*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E106-(E106*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E107-(E107*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E108-(E108*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E109-(E109*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F111*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F112*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F113*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F114*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E115-(E115*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E116-(E116*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E117-(E117*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E118-(E118*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F120*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F121*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F122*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F123*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E124-(E124*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E125-(E125*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E126-(E126*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E127-(E127*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F129*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F130*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F131*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F132*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E133-(E133*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E134-(E134*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E135-(E135*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E136-(E136*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F138*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F139*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F140*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F141*0.0825","v":0},{"$f":"(G141*-0.005)+G141","v":0}]
[null,null,null,null,null,{"$f":"E142-(E142*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E143-(E143*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E144-(E144*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E145-(E145*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F147*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F148*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F149*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F150*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E151-(E151*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E152-(E152*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E153-(E153*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E154-(E154*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F156*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F157*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F158*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F159*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E160-(E160*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E161-(E161*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E162-(E162*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E163-(E163*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F165*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F166*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F167*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F168*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E169-(E169*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E170-(E170*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E171-(E171*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E172-(E172*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F174*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F175*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F176*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F177*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E178-(E178*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E179-(E179*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E180-(E180*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E181-(E181*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F183*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F184*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F185*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F186*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E187-(E187*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E188-(E188*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E189-(E189*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E190-(E190*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F192*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F193*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F194*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F195*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E196-(E196*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E197-(E197*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E198-(E198*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E199-(E199*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F201*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F202*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F203*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F204*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E205-(E205*0.0762)","v":0},0,{"$f":"(G205*-0.005)+G205","v":0}]
[null,null,null,null,null,{"$f":"E206-(E206*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E207-(E207*0.0762)","v":0},0,0]
[null,null,null,null,null,{"$f":"E208-(E208*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F210*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F211*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F212*0.0825","v":0},0]
[null,null,null,null,null,0,{"$f":"F213*0.0825","v":0},0]
[null,null,null,null,null,{"$f":"E214-(E214*0.0762)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F227*0.0825","v":0},0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,{"$f":"E230-(E230*0.0762)","v":0},{"$f":"F230*0.0825","v":0},0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F236*0.0825","v":0},0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
["Total Taxable Gross Sales",null,null,null,{"$f":"SUM(E11:E250)","v":0},{"$f":"SUM(F11:F250)","v":0},{"$f":"SUM(G11:G250)","v":0},{"$f":"SUM(H11:H250)","v":0}]
["Tax Free Sales:"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTAL GROSS SALES",null,null,null,{"$f":"SUM(E251:E291)","v":0},{"$f":"SUM(F251:F291)","v":0},{"$f":"SUM(G251:G291)","v":0}]
[]
[]
[]
["KILLEEN"]
["ABSORBING SALES TAX METHOD"]
[]
[]
["Total Gross Sales",{"$f":"E292","v":0}]
[null," "," "]
[]
["Total Taxable Gross Sales",{"$f":"E251","v":0}]
["x Absorbing Tax Rate",7.6200000000000004E-2]
["= Total Sales Tax Collected",{"$f":"(B303*B304)","v":0}]
[]
[]
["Total Taxable Gross Sales",{"$f":"B303","v":0}]
["- Total Sales Tax Collected",{"$f":"-B305","v":0}]
["= Taxable Sales",{"$f":"B308+B309","v":0}]
[]
[]
["Taxable Sales",{"$f":"SUM(B310)","v":0},"Taxable Sales"]
["x Sales Tax Rate",8.2500000000000004E-2]
["= Sales tax to be paid",{"$f":"B313*B314","v":0},"Sales tax"]
[]
["Discount",{"$f":"B305*0.005","v":0},"Discount (apply only if applicable)"]
[]
["Sales tax to remit",{"$f":"B315-B317","v":0},"Sales tax paid - remit to Treasury"]

{"sheet":"Killeen - AF-105 Monies Due","index":2,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[30,1,31,8],[30,9,31,11],[20,9,21,11],[28,9,29,11],[28,1,29,8],[26,1,27,8],[24,1,25,8],[26,9,27,11],[24,9,25,11],[18,9,18,11],[20,1,21,8],[19,8,19,10],[22,1,23,8],[22,9,23,11],[18,1,18,8],[19,5,19,7],[19,2,19,3],[4,4,4,8],[14,2,14,4],[14,8,14,11],[6,4,6,8],[7,4,7,5],[5,4,5,6],[12,2,12,4],[13,2,13,4],[13,8,13,11],[7,6,7,8],[5,7,5,8],[53,1,53,3],[32,1,33,8],[32,9,33,11],[34,1,35,11],[38,1,39,8],[38,9,39,11],[46,1,46,2],[49,1,50,8],[46,8,46,9],[42,1,43,11],[40,1,41,8],[40,9,41,11],[46,3,46,5]]}
[]
[]
[]
[]
[null,null,null,null,"Killeen Independent School District"]
[null,null,null,null,{"$f":"IF(ISBLANK('Killeen -Absorbing Tax'!B5)=FALSE,'Killeen -Absorbing Tax'!B5,IF(ISBLANK('Killeen -Adding Tax '!B5)=FALSE,'Killeen -Adding Tax '!B5,\"ERROR\"))","v":"ERROR"},null,null,"Campus Name"]
[null,null,null,null,"AF-105 Collections of Monies Due to KISD"]
[null,null,null,null,"For the Month Ending",null,{"$f":"IF(ISBLANK('Killeen -Absorbing Tax'!F5)=FALSE,'Killeen -Absorbing Tax'!F5,IF(ISBLANK('Killeen -Adding Tax '!F5)=FALSE,'Killeen -Adding Tax '!F5,\"ERROR\"))","v":"ERROR"}]
[]
[]
[]
[null,"Remit To:",null,null,null,null,null,null,"Note:"]
[null,null,"ATTN: Cash Receipts Clerk",null,null,null,null,null,"This form should be completed and"]
[null,null,"Killeen Independent School District",null,null,null,null,null,"submitted to Treasury Services, with"]
[null,null,"Treasury Services",null,null,null,null,null,"a check, when funds are collected"]
[]
[]
[]
[null,"Description",null,null,null,null,null,null,null,"Amount"]
[]
[null,"1. Gross (Total) Sales (from Sales Tax Recap Form)",null,null,null,null,null,null,null,{"$f":"'Killeen -Absorbing Tax'!E292+'Killeen -Adding Tax '!E48","v":0}]
[]
[null,"2. Taxable Sales (from Sales Tax Recap Form)",null,null,null,null,null,null,null,{"$f":"'Killeen -Absorbing Tax'!F292+'Killeen -Adding Tax '!F48","v":0}]
[]
[null,"3. Taxable Purchases (Use tax if not paid with purchase)"]
[]
[null,"4. Total Taxable Sales and Purchases (add lines 2&3)",null,null,null,null,null,null,null,{"$f":"J23+J25","v":0}]
[]
[null,"5. Sales Tax Due (Line 4 x sales tax rate or Sales Tax Recap Form)",null,null,null,null,null,null,null,{"$f":"'Killeen -Absorbing Tax'!G292+'Killeen -Adding Tax '!G48","v":0}]
[]
[null,"6. Discount - if applicalbe (Line 5 x .005 or Sales Tax Recap Form)",null,null,null,null,null,null,null,{"$f":"J29*0.005","v":0}]
[]
[null,"7. Sales Tax Paid (subtract line 6 from 5 or Sales Tax Recap Form)",null,null,null,null,null,null,null,{"$f":"J29-J31","v":0}]
[]
[null,"Paid on school check number _______________                                                       Check Dated: ______________________"]
[]
[]
[]
[null,"Replacement ID cards"]
[]
[null,"Other:"]
[]
[null,"Paid on school check number _______________                                                       Check Dated: ______________________"]
[]
[]
[]
[null,"Principal Signature:",null,null,null,null,null,"Date:"]
[]
[]
[null,"Note:  Sales tax must be remitted on a separate check than other items remitted. Rounding differences may occur in discount calculation. Pay line 7."]
[]
[]
[]
[null,"KISD SAF-105 (Rev. 03/15)"]

{"sheet":"Killeen -Adding Tax ","index":3,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
["Killeen Independent School District"]
["AF-105 Monthly Sales Tax Recap Report - City of Killeen"]
[]
[]
["Campus:",null,null,null,"Month/Year:"]
[]
["Complete the gray columns  only"]
[null,null,null,null,null,"Taxable","Sales Tax"]
["Group (club/organization)","Type of Sale","Receipt #","Date(s)","Gross Sales","Sales"]
[null,null,null,null,null,{"$f":"E10","v":0},{"$f":"SUM(F10*0.0825)","v":0}]
[null,null,null,null,null,{"$f":"E11","v":0},0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTAL",null,null,null,{"$f":"SUM(E10:E47)","v":0},{"$f":"SUM(F10:F47)","v":0},{"$f":"SUM(G10:G47)","v":0}]
[]
["KILLEEN"]
["ADDING SALES TAX METHOD"]
[]
[]
[]
["Total Sales subject to tax",{"$f":"F48","v":0},"Taxable Sales"]
["x Sales Tax Rate",8.2500000000000004E-2]
["=Sales Tax to be paid",{"$f":"(B55*B56)","v":0},"Sales Tax "]
[]
[]
["Discount",{"$f":"B57*0.005","v":0},"Discount (use only if applicable)"]
[]
["Sales tax to remit",{"$f":"B57-B60","v":0},"Sales tax paid - remit to Treasury"]
[]
[]
[]
[]
[null,{"$f":"SUM(E48)","v":0},"Gross Sales"]