{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tax_By_Group","Nolanville -Absorbing Tax","Nolanville - AF-105","Nolanville -Adding "],"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":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Sales Tax2"]
["Group (club/organization)","Total"]
["Taxable Sales:"]
["Grand Total"]

{"sheet":"Nolanville -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 Nolanville"]
[]
[]
["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,{"$f":"E12-(E12*0.0762)","v":0},{"$f":"F12*0.0825","v":0},{"$f":"(G12*-0.005)+G12","v":0}]
[null,null,null,null,null,0,0,{"$f":"(G13*-0.005)+G13","v":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]
[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":"F34*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]
[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]
[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]
[null,null,null,null,null,0,0,{"$f":"(G77*-0.005)+G77","v":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]
[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]
[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]
[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]
[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,{"$f":"(G141*-0.005)+G141","v":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]
[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]
[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]
[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]
[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,{"$f":"(G205*-0.005)+G205","v":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]
[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]
[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]
[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}]
[]
[]
[]
["NOLANVILLE"]
["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":"Nolanville - AF-105","index":2,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,4,4,8],[5,4,5,6],[5,7,5,8],[6,4,6,8],[7,4,7,5],[7,6,7,8],[22,1,23,8],[22,9,23,11],[12,2,12,4],[13,2,13,4],[13,8,13,11],[14,2,14,4],[14,8,14,11],[18,1,18,8],[18,9,18,11],[19,2,19,3],[19,5,19,7],[19,8,19,10],[20,1,21,8],[20,9,21,11],[38,1,39,8],[38,9,39,11],[24,1,25,8],[24,9,25,11],[26,1,27,8],[26,9,27,11],[28,1,29,8],[28,9,29,11],[30,1,31,8],[30,9,31,11],[32,1,33,8],[32,9,33,11],[34,1,35,11],[53,1,53,3],[40,1,41,8],[40,9,41,11],[42,1,43,11],[46,1,46,2],[46,3,46,5],[46,8,46,9],[49,1,50,8]]}
[]
[]
[]
[]
[null,null,null,null,"Killeen Independent School District"]
[null,null,null,null,{"$f":"IF(ISBLANK('Nolanville -Absorbing Tax'!B5)=FALSE,'Nolanville -Absorbing Tax'!B5,IF(ISBLANK('Nolanville -Adding '!B5)=FALSE,'Nolanville -Adding '!B5,\"ERROR\"))","v":"ERROR"},null,null,"Campus Name"]
[null,null,null,null,"AF-105 Collections of Monie Due to KISD"]
[null,null,null,null,"For the Month Ending",null,{"$f":"IF(ISBLANK('Nolanville -Absorbing Tax'!F5)=FALSE,'Nolanville -Absorbing Tax'!F5,IF(ISBLANK('Nolanville -Adding '!F5)=FALSE,'Nolanville -Adding '!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":"'Nolanville -Absorbing Tax'!E292+'Nolanville -Adding '!E48","v":0}]
[]
[null,"2. Taxable Sales (from Sales Tax Recap Form)",null,null,null,null,null,null,null,{"$f":"'Nolanville -Absorbing Tax'!F292+'Nolanville -Adding '!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":"'Nolanville -Absorbing Tax'!G292+'Nolanville -Adding '!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":"Nolanville -Adding ","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 Nolanville"]
[]
[]
["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}]
[]
["NOLANVILLE"]
["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"]