{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Autofill","July","August","September","Audit July-Aug-Sept","October","November","December","Audit Oct-Nov-Dec","January","February","March","Audit Jan-Feb-Mar","April","May","June","Audit Apr-May-June","Fiscal Year","Blank Audit"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":17,"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":"Autofill","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,8,19,19]]}
["Auxiliary #"]
["City"]
["State"]
["Year"]
["District"]
[null,null,null,null,null,null,null,null,"INSTRUCTIONS:\n\nComplete pertinent information in the yellow boxes. Leave blank if it does not apply to your Auxiliary.\n\nTo insert sheet rows to add more receipts or dispersements, make sure there are still at least two blank rows available above the \"Totals\". Select the entire row of the upper most blank row by clicking on the row number. Once highlighted, click on \"Insert\" then choose \"Insert Sheet Row\". This will insert unlocked rows and will be included in the calculations for the \"Totals\" row.\n\nTo clear all data that has been entered in the workbook (all sheets) click on the RESET button located at the top of this sheet (Autofill sheet) "]
["Auxiliary Funds other than General, Dept/Nat'l Dues & Relief"]
["Fund"]
["Fund"]
["Fund"]
[]
["Checking Balances from June 30"]
["Bank $"]
["General Fund"]
["Dept/Nat'l Dues"]
["Auxiliary Relief"]
[{"$f":"Autofill!B8","v":0}]
[{"$f":"Autofill!B9","v":0}]
[{"$f":"Autofill!B10","v":0}]
[]
["Savings Balances from June 30"]
["Savings $"]
[]
["Ending Balances April-May-June Audit"]
["General Fund"]
["Dept & Nat'l Dues"]
["Auxiliary Relief"]
[{"$f":"Autofill!B8","v":0}]
[{"$f":"Autofill!B9","v":0}]
[{"$f":"Autofill!B10","v":0}]

{"sheet":"July","index":1,"n_rows":50,"n_cols":19,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,17,4,18],[4,13,4,14],[4,15,4,16],[49,1,49,2],[48,1,48,2],[43,1,43,2],[44,1,44,2],[4,11,4,12],[4,5,4,6],[4,7,4,8],[4,9,4,10],[42,1,42,2],[45,1,45,2],[46,1,46,2],[47,1,47,2]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for July \"&Autofill!B4","v":"Treasurer's report for July "}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(Autofill!B13)","v":0},null,{"$f":"SUM(Autofill!B14)","v":0},null,{"$f":"SUM(Autofill!B15)","v":0},null,{"$f":"SUM(Autofill!B16)","v":0},null,{"$f":"SUM(Autofill!B17)","v":0},null,{"$f":"SUM(Autofill!B18)","v":0},null,{"$f":"SUM(Autofill!B19)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F37+F38)","v":0},null,{"$f":"SUM(H37+H38)","v":0},null,{"$f":"SUM(J37+J38)","v":0},null,{"$f":"SUM(L37+L38)","v":0},null,{"$f":"SUM(N37+N38)","v":0},null,{"$f":"SUM(P37+P38)","v":0},null,{"$f":"SUM(R37+R38)","v":0}]
[null,null,null,null,null,{"$f":"G37","v":0},null,{"$f":"I37","v":0},null,{"$f":"K37","v":0},null,{"$f":"M37","v":0},null,{"$f":"O37","v":0},null,{"$f":"Q37","v":0},null,{"$f":"S37","v":0}]
[null,null,null,null," ",{"$f":"SUM(F39-F40)","v":0},null,{"$f":"SUM(H39-H40)","v":0},null,{"$f":"SUM(J39-J40)","v":0},null,{"$f":"SUM(L39-L40)","v":0},null,{"$f":"SUM(N39-N40)","v":0},null,{"$f":"SUM(P39-P40)","v":0},null,{"$f":"SUM(R39-R40)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F41","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H41","v":0},null,{"$f":"SUM(Autofill!B22)","v":0},null,{"$f":"SUM(F44:G44)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J41","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L41","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N41","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P41","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R41","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D44:D49)","v":0}]

{"sheet":"August","index":2,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[4,17,4,18],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[4,13,4,14],[4,15,4,16],[44,1,44,2],[45,1,45,2],[46,1,46,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for August \"&Autofill!B4","v":"Treasurer's report for August "}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(July!F41)","v":0},null,{"$f":"SUM(July!H41)","v":0},null,{"$f":"SUM(July!J41)","v":0},null,{"$f":"SUM(July!L41)","v":0},null,{"$f":"SUM(July!N41)","v":0},null,{"$f":"SUM(July!P41)","v":0},null,{"$f":"SUM(July!R41)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F39+F40)","v":0},null,{"$f":"SUM(H39+H40)","v":0},null,{"$f":"SUM(J39+J40)","v":0},null,{"$f":"SUM(L39+L40)","v":0},null,{"$f":"SUM(N39+N40)","v":0},null,{"$f":"SUM(P39+P40)","v":0},null,{"$f":"SUM(R39+R40)","v":0}]
[null,null,null,null,null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0}]
[null,null,null,null," ",{"$f":"SUM(F41-F42)","v":0},null,{"$f":"SUM(H41-H42)","v":0},null,{"$f":"SUM(J41-J42)","v":0},null,{"$f":"SUM(L41-L42)","v":0},null,{"$f":"SUM(N41-N42)","v":0},null,{"$f":"SUM(P41-P42)","v":0},null,{"$f":"SUM(R41-R42)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F43","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H43","v":0},null,{"$f":"SUM(July!H44)","v":0},null,{"$f":"SUM(F46:G46)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J43","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L43","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N43","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P43","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R43","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D46:D51)","v":0}]

{"sheet":"September","index":3,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[4,17,4,18],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[4,5,4,6],[4,13,4,14],[4,15,4,16],[44,1,44,2],[45,1,45,2],[46,1,46,2],[4,7,4,8],[4,9,4,10],[4,11,4,12]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for September \"&Autofill!B4","v":"Treasurer's report for September "}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(August!F43)","v":0},null,{"$f":"SUM(August!H43)","v":0},null,{"$f":"SUM(August!J43)","v":0},null,{"$f":"SUM(August!L43)","v":0},null,{"$f":"SUM(August!N43)","v":0},null,{"$f":"SUM(August!P43)","v":0},null,{"$f":"SUM(August!R43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F38)","v":0},{"$f":" SUM(G8:G38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F39+F40)","v":0},null,{"$f":"SUM(H39+H40)","v":0},null,{"$f":"SUM(J39+J40)","v":0},null,{"$f":"SUM(L39+L40)","v":0},null,{"$f":"SUM(N39+N40)","v":0},null,{"$f":"SUM(P39+P40)","v":0},null,{"$f":"SUM(R39+R40)","v":0}]
[null,null,null,null,null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0}]
[null,null,null,null," ",{"$f":"SUM(F41-F42)","v":0},null,{"$f":"SUM(H41-H42)","v":0},null,{"$f":"SUM(J41-J42)","v":0},null,{"$f":"SUM(L41-L42)","v":0},null,{"$f":"SUM(N41-N42)","v":0},null,{"$f":"SUM(P41-P42)","v":0},null,{"$f":"SUM(R41-R42)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F43","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H43","v":0},null,{"$f":"SUM(August!H46)","v":0},null,{"$f":"SUM(F46:G46)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J43","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L43","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N43","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P43","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R43","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D46:D51)","v":0}]

{"sheet":"Audit July-Aug-Sept","index":4,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,0,12,1],[12,2,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[10,7,10,9],[10,10,10,11],[11,7,11,9],[11,10,11,11],[14,7,14,9],[14,10,14,11],[10,0,10,1],[11,0,11,1],[10,2,10,3],[11,2,11,3],[10,4,10,6],[11,4,11,6],[27,1,27,2],[27,9,27,11],[28,9,33,11],[29,0,33,3],[21,0,21,3],[21,4,21,5],[23,0,25,3],[23,6,23,7],[23,8,23,9],[23,10,23,11],[24,8,24,9],[24,10,24,11],[25,8,25,9],[25,10,25,11],[21,7,21,11],[19,0,19,2],[19,4,19,5],[17,0,17,3],[17,4,17,5],[20,0,20,2],[20,4,20,5],[14,0,14,1],[14,2,14,3],[14,4,14,6],[18,0,18,2],[18,4,18,5],[9,0,9,1],[9,2,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,11],[13,0,13,1],[13,2,13,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[7,0,7,1],[7,2,7,3],[7,4,7,6],[7,7,7,9],[7,10,7,11],[8,0,8,1],[8,2,8,3],[8,4,8,6],[8,7,8,9],[8,10,8,11],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,9],[5,10,5,11],[6,0,6,1],[6,2,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,11],[3,0,3,2],[3,3,3,5],[3,7,3,9],[0,0,0,11],[1,0,1,4],[1,5,1,6],[1,7,1,9],[2,0,2,11]]}
["AUDIT REPORT"]
["                               VFW AUXILIARY TO POST NUMBER",null,null,null,null,{"$f":"SUM(Autofill!B1)","v":0},null,"DISTRICT NUMBER",null,null,{"$f":"SUM(Autofill!B5)","v":0}]
["DISTRIBUTION OF RECEIPTS, DISBURSEMENTS, AND CASH BALANCE BY FUND"]
["                                        FOR PERIOD OF",null,null,null,null,null,"TO"]
[]
["Name of FUND",null,"Cash Balance\nLast Audit Report",null,"Receipts Since\nLast Audit Report",null,null,"Disbursements\nSince Last Audit Report",null,null,"Cash Balance\nThis Report"]
["General Fund",null,{"$f":"Autofill!B25","v":0},null,{"$f":"SUM(July!H37,August!H39,September!H39)","v":0},null,null,{"$f":"SUM(July!I37,August!I39,September!I39)","v":0},null,null,{"$f":"SUM(C7+E7)-H7","v":0}]
["Dept/Nat’l Dues",null,{"$f":"Autofill!B26","v":0},null,{"$f":"SUM(July!J37,August!J39,September!J39)","v":0},null,null,{"$f":"SUM(July!K37,August!K39,September!K39)","v":0},null,null,{"$f":"SUM(C8+E8)-H8","v":0}]
[{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B28","v":0},null,{"$f":"SUM(July!N37,August!N39,September!N39)","v":0},null,null,{"$f":"SUM(July!O37,August!O39,September!O39)","v":0},null,null,{"$f":"SUM(C9+E9)-H9","v":0}]
[{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B29","v":0},null,{"$f":"SUM(July!P37,August!P39,September!P39)","v":0},null,null,{"$f":"SUM(July!Q37,August!Q39,September!Q39)","v":0},null,null,0]
["Aux Relief Fund",null,{"$f":"Autofill!B27","v":0},null,{"$f":"SUM(July!L37,August!L39,September!L39)","v":0},null,null,{"$f":"SUM(July!M37,August!M39,September!M39)","v":0},null,null,{"$f":"SUM(C11+E11)-H11","v":0}]
[{"$f":"Autofill!B10","v":0},null,{"$f":"Autofill!B30","v":0},null,{"$f":"SUM(July!R37,August!R39,September!R39)","v":0},null,null,{"$f":"SUM(July!S37,August!S39,September!S39)","v":0},null,null,{"$f":"SUM(C12+E12)-H12","v":0}]
["TOTALS",null,{"$f":"SUM(C7:D12)","v":0},null,{"$f":"SUM(E7:G12)","v":0},null,null,{"$f":"SUM(H7:J12)","v":0},null,null,{"$f":"SUM(C13+E13)-H13","v":0}]
["Savings/CD's",null,{"$f":"SUM(Autofill!B22)","v":0},null,{"$f":"SUM(July!G44,August!G46,September!G46)","v":0},null,null,null,null,null,{"$f":"SUM(C14+E14)-H14","v":0}]
["TOTALS - Including Savings",null,{"$f":"SUM(C13:D14)","v":0},null,{"$f":"SUM(E13:E14)","v":0},null,null,{"$f":"SUM(H13:H14)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null," "," "]
[]
["Bank Balance as shown on all Bank Statements"]
["Deposits in Transit – (please list below)",null,null,"Amount ",{"$f":"SUM(G34)","v":0}]
["Less Outstanding Checks –(please list below)",null,null,"Amount ",{"$f":"SUM(F34)","v":0}]
["Savings Account or CD’s",null,null,"Amount ",{"$f":"SUM(K14)","v":0}]
["TOTAL BANK BALANCE ",null,null,null,{"$f":"SUM(E18+E19+E21)-E20","v":0},null,null,"Approved by membership:_________________________"]
[]
["This is to certify that the books of the Secretary and Treasurer\nhave been audited, found correct and all moneys properly\naccounted for.",null,null,null,"Outstanding Checks",null,"Deposits",null,"Trustee #1"]
[null,null,null,null,"Check #","Amount","Amount","Date","Trustee #2"]
[null,null,null,null,null,null,null,null,"Trustee #3"]
[]
["Audited this date:","",null,null,null,null,null,null,null,"SEND TO:"]
[null,null,null,null,null,null,null,null,null,"Cindy Estell, Department Treasurer\nVFW Auxiliary\nP O Box 55850\nSt Petersburg  FL  33732-5850"]
["The Treasurer must have available for the audit committee all bank statements, savings account books, cancelled checks, and ledger books in order for the audit to be conducted in the proper manner. All outstanding checks should be listed with the number of check and amount of bank statement."]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F26:F33)","v":0},{"$f":"SUM(G26:G33)","v":0},""]

{"sheet":"October","index":5,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[4,17,4,18],[4,15,4,16],[44,1,44,2],[45,1,45,2],[46,1,46,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for October \"&Autofill!B4","v":"Treasurer's report for October "}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(September!F43)","v":0},null,{"$f":"SUM(September!H43)","v":0},null,{"$f":"SUM(September!J43)","v":0},null,{"$f":"SUM(September!L43)","v":0},null,{"$f":"SUM(September!N43)","v":0},null,{"$f":"SUM(September!P43)","v":0},null,{"$f":"SUM(September!R43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F38)","v":0},{"$f":" SUM(G8:G38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F39+F40)","v":0},null,{"$f":"SUM(H39+H40)","v":0},null,{"$f":"SUM(J39+J40)","v":0},null,{"$f":"SUM(L39+L40)","v":0},null,{"$f":"SUM(N39+N40)","v":0},null,{"$f":"SUM(P39+P40)","v":0},null,{"$f":"SUM(R39+R40)","v":0}]
[null,null,null,null,null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0}]
[null,null,null,null," ",{"$f":"SUM(F41-F42)","v":0},null,{"$f":"SUM(H41-H42)","v":0},null,{"$f":"SUM(J41-J42)","v":0},null,{"$f":"SUM(L41-L42)","v":0},null,{"$f":"SUM(N41-N42)","v":0},null,{"$f":"SUM(P41-P42)","v":0},null,{"$f":"SUM(R41-R42)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F43","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H43","v":0},null,{"$f":"SUM(September!H46)","v":0},null,{"$f":"SUM(F46:G46)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J43","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L43","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N43","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P43","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R43","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D46:D51)","v":0}]

{"sheet":"November","index":6,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[4,17,4,18],[4,15,4,16],[44,1,44,2],[45,1,45,2],[46,1,46,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for November \"&Autofill!B4","v":"Treasurer's report for November "}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(October!F43)","v":0},null,{"$f":"SUM(October!H43)","v":0},null,{"$f":"SUM(October!J43)","v":0},null,{"$f":"SUM(October!L43)","v":0},null,{"$f":"SUM(October!N43)","v":0},null,{"$f":"SUM(October!P43)","v":0},null,{"$f":"SUM(October!R43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F38)","v":0},{"$f":" SUM(G8:G38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F39+F40)","v":0},null,{"$f":"SUM(H39+H40)","v":0},null,{"$f":"SUM(J39+J40)","v":0},null,{"$f":"SUM(L39+L40)","v":0},null,{"$f":"SUM(N39+N40)","v":0},null,{"$f":"SUM(P39+P40)","v":0},null,{"$f":"SUM(R39+R40)","v":0}]
[null,null,null,null,null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0}]
[null,null,null,null," ",{"$f":"SUM(F41-F42)","v":0},null,{"$f":"SUM(H41-H42)","v":0},null,{"$f":"SUM(J41-J42)","v":0},null,{"$f":"SUM(L41-L42)","v":0},null,{"$f":"SUM(N41-N42)","v":0},null,{"$f":"SUM(P41-P42)","v":0},null,{"$f":"SUM(R41-R42)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F43","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H43","v":0},null,{"$f":"SUM(October!H46)","v":0},null,{"$f":"SUM(F46:G46)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J43","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L43","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N43","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P43","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R43","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D46:D51)","v":0}]

{"sheet":"December","index":7,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[4,17,4,18],[4,15,4,16],[44,1,44,2],[45,1,45,2],[46,1,46,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for December \"&Autofill!B4","v":"Treasurer's report for December "}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(November!F43)","v":0},null,{"$f":"SUM(November!H43)","v":0},null,{"$f":"SUM(November!J43)","v":0},null,{"$f":"SUM(November!L43)","v":0},null,{"$f":"SUM(November!N43)","v":0},null,{"$f":"SUM(November!P43)","v":0},null,{"$f":"SUM(November!R43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F38)","v":0},{"$f":" SUM(G8:G38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F39+F40)","v":0},null,{"$f":"SUM(H39+H40)","v":0},null,{"$f":"SUM(J39+J40)","v":0},null,{"$f":"SUM(L39+L40)","v":0},null,{"$f":"SUM(N39+N40)","v":0},null,{"$f":"SUM(P39+P40)","v":0},null,{"$f":"SUM(R39+R40)","v":0}]
[null,null,null,null,null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0}]
[null,null,null,null," ",{"$f":"SUM(F41-F42)","v":0},null,{"$f":"SUM(H41-H42)","v":0},null,{"$f":"SUM(J41-J42)","v":0},null,{"$f":"SUM(L41-L42)","v":0},null,{"$f":"SUM(N41-N42)","v":0},null,{"$f":"SUM(P41-P42)","v":0},null,{"$f":"SUM(R41-R42)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F43","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H43","v":0},null,{"$f":"SUM(November!H46)","v":0},null,{"$f":"SUM(F46:G46)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J43","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L43","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N43","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P43","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R43","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D46:D51)","v":0}]

{"sheet":"Audit Oct-Nov-Dec","index":8,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,0,12,1],[12,2,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[3,0,3,2],[3,3,3,5],[3,7,3,9],[0,0,0,11],[1,0,1,4],[1,5,1,6],[1,7,1,9],[2,0,2,11],[6,0,6,1],[6,2,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,11],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,9],[5,10,5,11],[8,0,8,1],[8,2,8,3],[8,4,8,6],[8,7,8,9],[8,10,8,11],[7,0,7,1],[7,2,7,3],[7,4,7,6],[7,7,7,9],[7,10,7,11],[10,0,10,1],[10,2,10,3],[10,4,10,6],[10,7,10,9],[10,10,10,11],[9,0,9,1],[9,2,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,11],[13,0,13,1],[13,2,13,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[11,0,11,1],[11,2,11,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[14,7,14,9],[14,10,14,11],[14,0,14,1],[14,2,14,3],[14,4,14,6],[17,0,17,3],[19,0,19,2],[19,4,19,5],[21,7,21,11],[25,8,25,9],[25,10,25,11],[20,4,20,5],[20,0,20,2],[21,0,21,3],[21,4,21,5],[23,0,25,3],[17,4,17,5],[18,0,18,2],[18,4,18,5],[28,9,33,11],[29,0,35,3],[24,8,24,9],[24,10,24,11],[23,6,23,7],[27,1,27,2],[27,9,27,11],[23,8,23,9],[23,10,23,11]]}
["AUDIT REPORT"]
["                               VFW AUXILIARY TO POST NUMBER",null,null,null,null,{"$f":"Autofill!B1","v":0},null,"DISTRICT NUMBER",null,null,{"$f":"Autofill!B5","v":0}]
["DISTRIBUTION OF RECEIPTS, DISBURSEMENTS, AND CASH BALANCE BY FUND"]
["                                        FOR PERIOD OF",null,null,null,null,null,"TO"]
[]
["Name of FUND",null,"Cash Balance\nLast Audit Report",null,"Receipts Since\nLast Audit Report",null,null,"Disbursements\nSince Last Audit Report",null,null,"Cash Balance\nThis Report"]
["General Fund",null,{"$f":"SUM('Audit July-Aug-Sept'!K7:L7)","v":0},null,{"$f":"SUM(October!H39,November!H39,December!H39)","v":0},null,null,{"$f":"SUM(October!I39,November!I39,December!I39)","v":0},null,null,{"$f":"SUM(C7+E7)-H7","v":0}]
["Dept/Nat’l Dues",null,{"$f":"SUM('Audit July-Aug-Sept'!K8:L8)","v":0},null,{"$f":"SUM(October!J39,November!J39,December!J39)","v":0},null,null,{"$f":"SUM(October!K39,November!K39,December!K39)","v":0},null,null,{"$f":"SUM(C8+E8)-H8","v":0}]
[{"$f":"Autofill!B8","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!K9:L9)","v":0},null,{"$f":"SUM(October!N39,November!N39,December!N39)","v":0},null,null,{"$f":"SUM(October!O39,November!O39,December!O39)","v":0},null,null,{"$f":"SUM(C9+E9)-H9","v":0}]
[{"$f":"Autofill!B9","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!K10:L10)","v":0},null,{"$f":"SUM(October!P39,November!P39,December!P39)","v":0},null,null,{"$f":"SUM(October!Q39,November!Q39,December!Q39)","v":0},null,null,0]
["Aux Relief Fund",null,{"$f":"SUM('Audit July-Aug-Sept'!K11:L11)","v":0},null,{"$f":"SUM(October!L39,November!L39,December!L39)","v":0},null,null,{"$f":"SUM(October!M39,November!M39,December!M39)","v":0},null,null,{"$f":"SUM(C11+E11)-H11","v":0}]
[{"$f":"Autofill!B10","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!K12:L12)","v":0},null,{"$f":"SUM(October!R39,November!R39,December!R39)","v":0},null,null,{"$f":"SUM(October!S39,November!S39,December!S39)","v":0},null,null,{"$f":"SUM(C12+E12)-H12","v":0}]
["TOTALS",null,{"$f":"SUM(C7:D12)","v":0},null,{"$f":"SUM(E7:G12)","v":0},null,null,{"$f":"SUM(H7:J12)","v":0},null,null,{"$f":"SUM(C13+E13)-H13","v":0}]
["Savings/CD's",null,{"$f":"SUM('Audit July-Aug-Sept'!K14:L14)","v":0},null,{"$f":"SUM(October!G46,November!G46,December!G46)","v":0},null,null,null,null,null,{"$f":"SUM(C14+E14)-H14","v":0}]
["TOTALS - Including Savings",null,{"$f":"SUM(C13:C14)","v":0},null,{"$f":"SUM(E13:E14)","v":0},null,null,{"$f":"SUM(H13:H14)","v":0},null,null,0]
[null,null,"Cindy Estell",null,null,null,null,null,null,null," "]
[]
["Bank Balance as shown on all Bank Statements"]
["Deposits in Transit – (please list below)",null,null,"Amount ",{"$f":"SUM(G34)","v":0}]
["Less Outstanding Checks –(please list below)",null,null,"Amount ",{"$f":"SUM(F34)","v":0}]
["Savings Account or CD’s",null,null,"Amount ",{"$f":"SUM(K14)","v":0}]
["TOTAL BANK BALANCE ",null,null,null,{"$f":"SUM(E18+E19+E21)-E20","v":0},null,null,"Approved by membership:_________________________"]
[]
["This is to certify that the books of the Secretary and Treasurer\nhave been audited, found correct and all moneys properly\naccounted for.",null,null,null,"Outstanding Checks",null,"Deposits",null,"Trustee #1"]
[null,null,null,null,"Check #","Amount","Amount","Date","Trustee #2"]
[null,null,null,null,null,null,null,null,"Trustee #3"]
[]
["Audited this date:",null,null,null,null,null,null,null,null,"SEND TO:"]
[null,null,null,null,null,null,null,null,null,"Cindy Estell, Department Treasurer\nVFW Auxiliary\nP O Box 55850\nSt Petersburg  FL  33732-5850"]
["The Treasurer must have available for the audit committee all bank statements, savings account books, cancelled checks, and ledger books in order for the audit to be conducted in the proper manner. All outstanding checks should be listed with the number of check and amount of bank statement."]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F26:F33)","v":0},{"$f":"SUM(G26:G33)","v":0},""]

{"sheet":"January","index":9,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,1,52,2],[4,17,4,18],[4,15,4,16],[45,1,45,2],[46,1,46,2],[47,1,47,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for January \"&Autofill!B4+1","v":"Treasurer's report for January 1"}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(December!F43)","v":0},null,{"$f":"SUM(December!H43)","v":0},null,{"$f":"SUM(December!J43)","v":0},null,{"$f":"SUM(December!L43)","v":0},null,{"$f":"SUM(December!N43)","v":0},null,{"$f":"SUM(December!P43)","v":0},null,{"$f":"SUM(December!R43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F39)","v":0},{"$f":" SUM(G8:G39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F40+F41)","v":0},null,{"$f":"SUM(H40+H41)","v":0},null,{"$f":"SUM(J40+J41)","v":0},null,{"$f":"SUM(L40+L41)","v":0},null,{"$f":"SUM(N40+N41)","v":0},null,{"$f":"SUM(P40+P41)","v":0},null,{"$f":"SUM(R40+R41)","v":0}]
[null,null,null,null,null,{"$f":"G40","v":0},null,{"$f":"I40","v":0},null,{"$f":"K40","v":0},null,{"$f":"M40","v":0},null,{"$f":"O40","v":0},null,{"$f":"Q40","v":0},null,{"$f":"S40","v":0}]
[null,null,null,null," ",{"$f":"SUM(F42-F43)","v":0},null,{"$f":"SUM(H42-H43)","v":0},null,{"$f":"SUM(J42-J43)","v":0},null,{"$f":"SUM(L42-L43)","v":0},null,{"$f":"SUM(N42-N43)","v":0},null,{"$f":"SUM(P42-P43)","v":0},null,{"$f":"SUM(R42-R43)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F44","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H44","v":0},null,{"$f":"SUM(December!H46)","v":0},null,{"$f":"SUM(F47:G47)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J44","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L44","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N44","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P44","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R44","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D47:D52)","v":0}]

{"sheet":"February","index":10,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[4,17,4,18],[4,15,4,16],[44,1,44,2],[45,1,45,2],[46,1,46,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for February \"&Autofill!B4+1","v":"Treasurer's report for February 1"}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(January!F44)","v":0},null,{"$f":"SUM(January!H44)","v":0},null,{"$f":"SUM(January!J44)","v":0},null,{"$f":"SUM(January!L44)","v":0},null,{"$f":"SUM(January!N44)","v":0},null,{"$f":"SUM(January!P44)","v":0},null,{"$f":"SUM(January!R44)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F38)","v":0},{"$f":" SUM(G8:G38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F39+F40)","v":0},null,{"$f":"SUM(H39+H40)","v":0},null,{"$f":"SUM(J39+J40)","v":0},null,{"$f":"SUM(L39+L40)","v":0},null,{"$f":"SUM(N39+N40)","v":0},null,{"$f":"SUM(P39+P40)","v":0},null,{"$f":"SUM(R39+R40)","v":0}]
[null,null,null,null,null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0}]
[null,null,null,null," ",{"$f":"SUM(F41-F42)","v":0},null,{"$f":"SUM(H41-H42)","v":0},null,{"$f":"SUM(J41-J42)","v":0},null,{"$f":"SUM(L41-L42)","v":0},null,{"$f":"SUM(N41-N42)","v":0},null,{"$f":"SUM(P41-P42)","v":0},null,{"$f":"SUM(R41-R42)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F43","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H43","v":0},null,{"$f":"SUM(January!H47)","v":0},null,{"$f":"SUM(F46:G46)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J43","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L43","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N43","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P43","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R43","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D46:D51)","v":0}]

{"sheet":"March","index":11,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[4,17,4,18],[4,15,4,16],[44,1,44,2],[45,1,45,2],[46,1,46,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for March \"&Autofill!B4+1","v":"Treasurer's report for March 1"}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(February!F43)","v":0},null,{"$f":"SUM(February!H43)","v":0},null,{"$f":"SUM(February!J43)","v":0},null,{"$f":"SUM(February!L43)","v":0},null,{"$f":"SUM(February!N43)","v":0},null,{"$f":"SUM(February!P43)","v":0},null,{"$f":"SUM(February!R43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F38)","v":0},{"$f":" SUM(G8:G38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F39+F40)","v":0},null,{"$f":"SUM(H39+H40)","v":0},null,{"$f":"SUM(J39+J40)","v":0},null,{"$f":"SUM(L39+L40)","v":0},null,{"$f":"SUM(N39+N40)","v":0},null,{"$f":"SUM(P39+P40)","v":0},null,{"$f":"SUM(R39+R40)","v":0}]
[null,null,null,null,null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0}]
[null,null,null,null," ",{"$f":"SUM(F41-F42)","v":0},null,{"$f":"SUM(H41-H42)","v":0},null,{"$f":"SUM(J41-J42)","v":0},null,{"$f":"SUM(L41-L42)","v":0},null,{"$f":"SUM(N41-N42)","v":0},null,{"$f":"SUM(P41-P42)","v":0},null,{"$f":"SUM(R41-R42)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F43","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H43","v":0},null,{"$f":"SUM(February!H46)","v":0},null,{"$f":"SUM(F46:G46)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J43","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L43","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N43","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P43","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R43","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D46:D51)","v":0}]

{"sheet":"Audit Jan-Feb-Mar","index":12,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[21,7,21,11],[12,0,12,1],[12,2,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[13,0,13,1],[13,2,13,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[14,7,14,9],[14,10,14,11],[14,0,14,1],[14,2,14,3],[14,4,14,6],[3,0,3,2],[3,3,3,5],[3,7,3,9],[0,0,0,11],[1,0,1,4],[1,5,1,6],[1,7,1,9],[2,0,2,11],[6,0,6,1],[6,2,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,11],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,9],[5,10,5,11],[8,0,8,1],[8,2,8,3],[8,4,8,6],[8,7,8,9],[8,10,8,11],[7,0,7,1],[7,2,7,3],[7,4,7,6],[7,7,7,9],[7,10,7,11],[10,0,10,1],[10,2,10,3],[10,4,10,6],[10,7,10,9],[10,10,10,11],[9,0,9,1],[9,2,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,11],[11,0,11,1],[11,2,11,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[24,8,24,9],[24,10,24,11],[17,4,17,5],[18,0,18,2],[18,4,18,5],[17,0,17,3],[19,0,19,2],[19,4,19,5],[20,4,20,5],[23,8,23,9],[23,10,23,11],[20,0,20,2],[21,0,21,3],[21,4,21,5],[23,0,25,3],[23,6,23,7],[25,8,25,9],[25,10,25,11],[27,1,27,2],[27,9,27,11],[28,9,33,11],[29,0,35,3]]}
["AUDIT REPORT"]
["                               VFW AUXILIARY TO POST NUMBER",null,null,null,null,{"$f":"Autofill!B1","v":0},null,"DISTRICT NUMBER",null,null,{"$f":"Autofill!B5","v":0}]
["DISTRIBUTION OF RECEIPTS, DISBURSEMENTS, AND CASH BALANCE BY FUND"]
["                                        FOR PERIOD OF",null,null,null,null,null,"TO"]
[]
["Name of FUND",null,"Cash Balance\nLast Audit Report",null,"Receipts Since\nLast Audit Report",null,null,"Disbursements\nSince Last Audit Report",null,null,"Cash Balance\nThis Report"]
["(GF) General Fund",null,{"$f":"SUM('Audit Oct-Nov-Dec'!K7:L7)","v":0},null,{"$f":"SUM(January!H40,February!H39,March!H39)","v":0},null,null,{"$f":"SUM(January!I40,February!I39,March!I39)","v":0},null,null,{"$f":"SUM(C7+E7)-H7","v":0}]
["(DND) Dept/Nat’l Dues",null,{"$f":"SUM('Audit Oct-Nov-Dec'!K8:L8)","v":0},null,{"$f":"SUM(January!J40,February!J39,March!J39)","v":0},null,null,{"$f":"SUM(January!K40,February!K39,March!K39)","v":0},null,null,{"$f":"SUM(C8+E8)-H8","v":0}]
[{"$f":"Autofill!B8","v":0},null,{"$f":"SUM('Audit Oct-Nov-Dec'!K9:L9)","v":0},null,{"$f":"SUM(January!N40,February!N39,March!N39)","v":0},null,null,{"$f":"SUM(January!O40,February!O39,March!O39)","v":0},null,null,{"$f":"SUM(C9+E9)-H9","v":0}]
[{"$f":"Autofill!B9","v":0},null,{"$f":"SUM('Audit Oct-Nov-Dec'!K10:L10)","v":0},null,{"$f":"SUM(January!P40,February!P39,March!P39)","v":0},null,null,{"$f":"SUM(January!Q40,February!Q39,March!Q39)","v":0},null,null,0]
["(ARF) Aux Relief Fund",null,{"$f":"SUM('Audit Oct-Nov-Dec'!K11:L11)","v":0},null,{"$f":"SUM(January!L40,February!L39,March!L39)","v":0},null,null,{"$f":"SUM(January!M40,February!M39,March!M39)","v":0},null,null,{"$f":"SUM(C11+E11)-H11","v":0}]
[{"$f":"Autofill!B10","v":0},null,{"$f":"SUM('Audit Oct-Nov-Dec'!K12:L12)","v":0},null,{"$f":"SUM(January!R40,February!R39,March!R39)","v":0},null,null,{"$f":"SUM(January!S40,February!S39,March!S39)","v":0},null,null,{"$f":"SUM(C12+E12)-H12","v":0}]
["TOTALS",null,{"$f":"SUM(C7:D12)","v":0},null,{"$f":"SUM(E7:G12)","v":0},null,null,{"$f":"SUM(H7:J12)","v":0},null,null,{"$f":"SUM(C13+E13)-H13","v":0}]
["(SV) Savings",null,{"$f":"SUM('Audit Oct-Nov-Dec'!K14:L14)","v":0},null,{"$f":"SUM(January!G47,February!G46,March!G46)","v":0},null,null,null,null,null,{"$f":"SUM(C14+E14)-H14","v":0}]
["TOTALS - Including Savings",null,{"$f":"SUM(C13:C14)","v":0},null,{"$f":"SUM(E13:E14)","v":0},null,null,{"$f":"SUM(H13:H14)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null," "]
[]
["Bank Balance as shown on all Bank Statements"]
["Deposits in Transit – (please list below)",null,null,"Amount ",{"$f":"SUM(G34)","v":0},null,null,{"$f":"SUM(E22-K15)","v":0}]
["Less Outstanding Checks –(please list below)",null,null,"Amount ",{"$f":"SUM(F34)","v":0}]
["Savings Account or CD’s",null,null,"Amount ",{"$f":"SUM(K14)","v":0}]
["TOTAL BANK BALANCE ",null,null,null,{"$f":"SUM(E18+E19+E21)-E20","v":0},null,null,"Approved by membership:_________________________"]
[]
["This is to certify that the books of the Secretary and Treasurer\nhave been audited, found correct and all moneys properly\naccounted for.",null,null,null,"Outstanding Checks",null,"Deposits",null,"Trustee #1"]
[null,null,null,null,"Check #","Amount","Amount","Date","Trustee #2"]
[null,null,null,null,null,null,null,null,"Trustee #3"]
[]
["Audited this date:","",null,null,null,null,null,null,null,"SEND TO:"]
[null,null,null,null,null,null,null,null,null,"Cindy Estell, Department Treasurer\nVFW Auxiliary\nP O Box 55850\nSt Petersburg  FL  33732-5850"]
["The Treasurer must have available for the audit committee all bank statements, savings account books, cancelled checks, and ledger books in order for the audit to be conducted in the proper manner. All outstanding checks should be listed with the number of check and amount of bank statement."]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F26:F33)","v":0},{"$f":"SUM(G26:G33)","v":0},""]

{"sheet":"April","index":13,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,1,52,2],[4,17,4,18],[4,15,4,16],[45,1,45,2],[46,1,46,2],[47,1,47,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for April \"&Autofill!B4+1","v":"Treasurer's report for April 1"}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(March!F43)","v":0},null,{"$f":"SUM(March!H43)","v":0},null,{"$f":"SUM(March!J43)","v":0},null,{"$f":"SUM(March!L43)","v":0},null,{"$f":"SUM(March!N43)","v":0},null,{"$f":"SUM(March!P43)","v":0},null,{"$f":"SUM(Autofill!B19)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F39)","v":0},{"$f":" SUM(G8:G39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F40+F41)","v":0},null,{"$f":"SUM(H40+H41)","v":0},null,{"$f":"SUM(J40+J41)","v":0},null,{"$f":"SUM(L40+L41)","v":0},null,{"$f":"SUM(N40+N41)","v":0},null,{"$f":"SUM(P40+P41)","v":0},null,{"$f":"SUM(R40+R41)","v":0}]
[null,null,null,null,null,{"$f":"G40","v":0},null,{"$f":"I40","v":0},null,{"$f":"K40","v":0},null,{"$f":"M40","v":0},null,{"$f":"O40","v":0},null,{"$f":"Q40","v":0},null,{"$f":"S40","v":0}]
[null,null,null,null," ",{"$f":"SUM(F42-F43)","v":0},null,{"$f":"SUM(H42-H43)","v":0},null,{"$f":"SUM(J42-J43)","v":0},null,{"$f":"SUM(L42-L43)","v":0},null,{"$f":"SUM(N42-N43)","v":0},null,{"$f":"SUM(P42-P43)","v":0},null,{"$f":"SUM(R42-R43)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F44","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H44","v":0},null,{"$f":"SUM(March!H46)","v":0},null,{"$f":"SUM(F47:G47)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J44","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L44","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N44","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P44","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R44","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D47:D52)","v":0}]

{"sheet":"May","index":14,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,48,2],[4,17,4,18],[4,15,4,16],[41,1,41,2],[42,1,42,2],[43,1,43,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for May \"&Autofill!B4+1","v":"Treasurer's report for May 1"}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(April!F44)","v":0},null,{"$f":"SUM(April!H44)","v":0},null,{"$f":"SUM(April!J44)","v":0},null,{"$f":"SUM(April!L44)","v":0},null,{"$f":"SUM(April!N44)","v":0},null,{"$f":"SUM(April!P44)","v":0},null,{"$f":"SUM(March!R43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F35)","v":0},{"$f":" SUM(G8:G35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F36+F37)","v":0},null,{"$f":"SUM(H36+H37)","v":0},null,{"$f":"SUM(J36+J37)","v":0},null,{"$f":"SUM(L36+L37)","v":0},null,{"$f":"SUM(N36+N37)","v":0},null,{"$f":"SUM(P36+P37)","v":0},null,{"$f":"SUM(R36+R37)","v":0}]
[null,null,null,null,null,{"$f":"G36","v":0},null,{"$f":"I36","v":0},null,{"$f":"K36","v":0},null,{"$f":"M36","v":0},null,{"$f":"O36","v":0},null,{"$f":"Q36","v":0},null,{"$f":"S36","v":0}]
[null,null,null,null," ",{"$f":"SUM(F38-F39)","v":0},null,{"$f":"SUM(H38-H39)","v":0},null,{"$f":"SUM(J38-J39)","v":0},null,{"$f":"SUM(L38-L39)","v":0},null,{"$f":"SUM(N38-N39)","v":0},null,{"$f":"SUM(P38-P39)","v":0},null,{"$f":"SUM(R38-R39)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F40","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H40","v":0},null,{"$f":"SUM(April!H47)","v":0},null,{"$f":"SUM(F43:G43)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J40","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L40","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N40","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P40","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R40","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D43:D48)","v":0}]

{"sheet":"June","index":15,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,2],[4,17,4,18],[4,15,4,16],[38,1,38,2],[39,1,39,2],[40,1,40,2],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[4,13,4,14]]}
[{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1","v":"VFW Auxiliary to Post "}]
[{"$f":"\"Located in \"&Autofill!B2&\", \"&Autofill!B3","v":"Located in , "}]
[{"$f":"\"Treasurer's report for June \"&Autofill!B4+1","v":"Treasurer's report for June 1"}]
[]
["Cleared/ Deposited","Date","Check","FROM or TO","REASON","Bank",null,"(GF) GENERAL FUND",null,"(DND Dept/Nat Dues",null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B8","v":0},null,{"$f":"Autofill!B9","v":0},null,{"$f":"Autofill!B10","v":0}]
[null,null,null,null,null,"RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP","RECEIPT","EXP"]
[null,null,null,"Balance Forward"," ",{"$f":"SUM(May!F40)","v":0},null,{"$f":"SUM(May!H40)","v":0},null,{"$f":"SUM(May!J40)","v":0},null,{"$f":"SUM(May!L40)","v":0},null,{"$f":"SUM(May!N40)","v":0},null,{"$f":"SUM(May!P40)","v":0},null,{"$f":"SUM(May!R40)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTALS",null,{"$f":"SUM(F8:F32)","v":0},{"$f":" SUM(G8:G32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F7","v":0},null,{"$f":"H7","v":0},null,{"$f":"J7","v":0},null,{"$f":"L7","v":0},null,{"$f":"N7","v":0},null,{"$f":"P7","v":0},null,{"$f":"R7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F33+F34)","v":0},null,{"$f":"SUM(H33+H34)","v":0},null,{"$f":"SUM(J33+J34)","v":0},null,{"$f":"SUM(L33+L34)","v":0},null,{"$f":"SUM(N33+N34)","v":0},null,{"$f":"SUM(P33+P34)","v":0},null,{"$f":"SUM(R33+R34)","v":0}]
[null,null,null,null,null,{"$f":"G33","v":0},null,{"$f":"I33","v":0},null,{"$f":"K33","v":0},null,{"$f":"M33","v":0},null,{"$f":"O33","v":0},null,{"$f":"Q33","v":0},null,{"$f":"S33","v":0}]
[null,null,null,null," ",{"$f":"SUM(F35-F36)","v":0},null,{"$f":"SUM(H35-H36)","v":0},null,{"$f":"SUM(J35-J36)","v":0},null,{"$f":"SUM(L35-L36)","v":0},null,{"$f":"SUM(N35-N36)","v":0},null,{"$f":"SUM(P35-P36)","v":0},null,{"$f":"SUM(R35-R36)","v":0}]
[]
[null,"SUMMARY",null,{"$f":"F37","v":0},null,"Savings","Interest","Total Savings"]
[null,"(GF) GENERAL FUND",null,{"$f":"H37","v":0},null,{"$f":"SUM(May!H43)","v":0},null,{"$f":"SUM(F40:G40)","v":0}]
[null,"(DND Dept/Nat Dues",null,{"$f":"J37","v":0}]
[null,"(ARF) Aux Relief Fund",null,{"$f":"L37","v":0}]
[null,{"$f":"Autofill!B8","v":0},null,{"$f":"N37","v":0}]
[null,{"$f":"Autofill!B9","v":0},null,{"$f":"P37","v":0}]
[null,{"$f":"Autofill!B10","v":0},null,{"$f":"R37","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D40:D45)","v":0}]

{"sheet":"Audit Apr-May-June","index":16,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,0,12,1],[12,2,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[3,0,3,2],[3,3,3,5],[3,7,3,9],[0,0,0,11],[1,0,1,4],[1,5,1,6],[1,7,1,9],[2,0,2,11],[6,0,6,1],[6,2,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,11],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,9],[5,10,5,11],[8,0,8,1],[8,2,8,3],[8,4,8,6],[8,7,8,9],[8,10,8,11],[7,0,7,1],[7,2,7,3],[7,4,7,6],[7,7,7,9],[7,10,7,11],[10,0,10,1],[10,2,10,3],[10,4,10,6],[10,7,10,9],[10,10,10,11],[9,0,9,1],[9,2,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,11],[13,0,13,1],[13,2,13,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[11,0,11,1],[11,2,11,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[14,7,14,9],[14,10,14,11],[14,0,14,1],[14,2,14,3],[14,4,14,6],[24,8,24,9],[24,10,24,11],[17,4,17,5],[18,0,18,2],[18,4,18,5],[17,0,17,3],[19,0,19,2],[19,4,19,5],[20,4,20,5],[23,8,23,9],[23,10,23,11],[20,0,20,2],[21,0,21,3],[21,4,21,5],[23,0,25,3],[23,6,23,7],[25,8,25,9],[25,10,25,11],[27,1,27,2],[27,9,27,11],[28,9,33,11],[29,0,35,3]]}
["AUDIT REPORT"]
["                               VFW AUXILIARY TO POST NUMBER",null,null,null,null,{"$f":"Autofill!B1","v":0},null,"DISTRICT NUMBER",null,null,{"$f":"Autofill!B5","v":0}]
["DISTRIBUTION OF RECEIPTS, DISBURSEMENTS, AND CASH BALANCE BY FUND"]
["                                        FOR PERIOD OF",null,null,null,null,null,"TO"]
[]
["Name of FUND",null,"Cash Balance\nLast Audit Report",null,"Receipts Since\nLast Audit Report",null,null,"Disbursements\nSince Last Audit Report",null,null,"Cash Balance\nThis Report"]
["(GF) General Fund",null,{"$f":"SUM('Audit Jan-Feb-Mar'!K7:L7)","v":0},null,{"$f":"SUM(April!H40,May!H36,June!H33)","v":0},null,null,{"$f":"SUM(April!I40,May!I36,June!I33)","v":0},null,null,{"$f":"SUM(C7+E7)-H7","v":0}]
["(DND) Dept/Nat’l Dues",null,{"$f":"SUM('Audit Jan-Feb-Mar'!K8:L8)","v":0},null,{"$f":"SUM(April!J40,May!J36,June!J33)","v":0},null,null,{"$f":"SUM(April!K40,May!K36,June!K33)","v":0},null,null,{"$f":"SUM(C8+E8)-H8","v":0}]
[{"$f":"Autofill!B8","v":0},null,{"$f":"SUM('Audit Jan-Feb-Mar'!K9:L9)","v":0},null,{"$f":"SUM(April!N40,May!N36,June!N33)","v":0},null,null,{"$f":"SUM(April!O40,May!O36,June!O33)","v":0},null,null,{"$f":"SUM(C9+E9)-H9","v":0}]
[{"$f":"Autofill!B9","v":0},null,{"$f":"SUM('Audit Jan-Feb-Mar'!K10:L10)","v":0},null,{"$f":"SUM(April!P40,May!P36,June!P33)","v":0},null,null,{"$f":"SUM(April!Q40,May!Q36,June!Q33)","v":0},null,null,0]
["(ARF) Aux Relief Fund",null,{"$f":"SUM('Audit Jan-Feb-Mar'!K11:L11)","v":0},null,{"$f":"SUM(April!L40,May!L36,June!L33)","v":0},null,null,{"$f":"SUM(April!M40,May!M36,June!M33)","v":0},null,null,{"$f":"SUM(C11+E11)-H11","v":0}]
[{"$f":"Autofill!B10","v":0},null,{"$f":"SUM('Audit Jan-Feb-Mar'!K12:L12)","v":0},null,{"$f":"SUM(April!R40,May!R36,June!R33)","v":0},null,null,{"$f":"SUM(April!S40,May!S36,June!S33)","v":0},null,null,{"$f":"SUM(C12+E12)-H12","v":0}]
["TOTALS",null,{"$f":"SUM(C7:D12)","v":0},null,{"$f":"SUM(E7:G12)","v":0},null,null,{"$f":"SUM(H7:J12)","v":0},null,null,{"$f":"SUM(C13+E13)-H13","v":0}]
["(SV) Savings",null,{"$f":"SUM('Audit Jan-Feb-Mar'!K14:L14)","v":0},null,{"$f":"SUM(April!G47,May!G43,June!G40)","v":0},null,null,null,null,null,{"$f":"SUM(C14+E14)-H14","v":0}]
["TOTALS - Including Savings",null,{"$f":"SUM(C13:C14)","v":0},null,{"$f":"SUM(E13:E14)","v":0},null,null,{"$f":"SUM(H13:H14)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null," "," "]
[]
["Bank Balance as shown on all Bank Statements"]
["Deposits in Transit – (please list below)",null,null,"Amount ",{"$f":"SUM(G34)","v":0}]
["Less Outstanding Checks –(please list below)",null,null,"Amount ",{"$f":"SUM(F34)","v":0}]
["Savings Account or CD’s",null,null,"Amount ",{"$f":"SUM(K14)","v":0}]
["TOTAL BANK BALANCE ",null,null,null,{"$f":"SUM(E18+E19+E21)-E20","v":0}]
[]
["This is to certify that the books of the Secretary and Treasurer\nhave been audited, found correct and all moneys properly\naccounted for.",null,null,null,"Outstanding Checks",null,"Deposits",null,"Trustee #1"]
[null,null,null,null,"Check #","Amount","Amount","Date","Trustee #2"]
[null,null,null,null,null,null,null,null,"Trustee #3"]
[]
["Audited this date:",null,null,null,null,null,null,null,null,"SEND TO:"]
[null,null,null,null,null,null,null,null,null,"Cindy Estell, Department Treasurer\nVFW Auxiliary\nP O Box 55850\nSt Petersburg  FL  33732-5850"]
["The Treasurer must have available for the audit committee all bank statements, savings account books, cancelled checks, and ledger books in order for the audit to be conducted in the proper manner. All outstanding checks should be listed with the number of check and amount of bank statement."]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F26:F33)","v":0},{"$f":"SUM(G26:G33)","v":0},""]

{"sheet":"Fiscal Year","index":17,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,11,13,12],[1,1,1,12],[2,1,2,12],[4,1,4,12],[15,1,15,2],[15,3,15,4],[15,5,15,7],[15,8,15,10],[15,11,15,12],[12,1,12,2],[12,3,12,4],[12,5,12,7],[12,8,12,10],[12,11,12,12],[14,1,14,2],[14,3,14,4],[14,5,14,7],[14,8,14,10],[14,11,14,12],[10,1,10,2],[10,3,10,4],[10,5,10,7],[10,8,10,10],[10,11,10,12],[11,1,11,2],[11,3,11,4],[11,5,11,7],[11,8,11,10],[11,11,11,12],[13,1,13,2],[13,3,13,4],[13,5,13,7],[13,8,13,10],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,8,8,10],[8,11,8,12],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,8,9,10],[9,11,9,12],[6,1,6,2],[6,3,6,4],[6,5,6,7],[6,8,6,10],[6,11,6,12],[7,1,7,2],[7,3,7,4],[7,5,7,7],[7,8,7,10],[7,11,7,12]]}
[]
[null,{"$f":"\"VFW Auxiliary to Post \"&Autofill!B1&\", District \"&Autofill!B5&\", Department of \"&Autofill!B3","v":"VFW Auxiliary to Post , District , Department of "}]
[null,"DISTRIBUTION OF RECEIPTS, DISBURSEMENTS, AND CASH BALANCE BY FUND"]
[]
[null,{"$f":"\"Fiscal Year of:   July 1, \"&Autofill!B4&\" thru June 30, \"&Autofill!B4+1","v":"Fiscal Year of:   July 1,  thru June 30, 1"}]
[]
[null,"Name of FUND",null,"Cash Balance\nLast Audit Report",null,"Receipts\nLast Audit Report",null,null,"Disbursements\nSince Last Audit Report",null,null,"Cash Balance\nThis Report"]
[null,"(GF) General Fund",null,{"$f":"Autofill!B14","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!E7:G7,'Audit Oct-Nov-Dec'!E7:G7,'Audit Jan-Feb-Mar'!E7:G7,'Audit Apr-May-June'!E7:G7)","v":0},null,null,{"$f":"SUM('Audit July-Aug-Sept'!H7:J7,'Audit Oct-Nov-Dec'!H7:J7,'Audit Jan-Feb-Mar'!H7:J7,'Audit Apr-May-June'!H7:J7)","v":0},null,null,{"$f":"SUM(D8+F8)-I8","v":0}]
[null,"(DND) Dept/Nat’l Dues",null,{"$f":"Autofill!B15","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!E8:G8,'Audit Oct-Nov-Dec'!E8:G8,'Audit Jan-Feb-Mar'!E8:G8,'Audit Apr-May-June'!E8:G8)","v":0},null,null,{"$f":"SUM('Audit July-Aug-Sept'!H8:J8,'Audit Oct-Nov-Dec'!H8:J8,'Audit Jan-Feb-Mar'!H8:J8,'Audit Apr-May-June'!H8:J8)","v":0},null,null,{"$f":"SUM(D9+F9)-I9","v":0}]
[null,{"$f":"Autofill!A17","v":0},null,{"$f":"Autofill!B17","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!E9:G9,'Audit Oct-Nov-Dec'!E9:G9,'Audit Jan-Feb-Mar'!E9:G9,'Audit Apr-May-June'!E9:G9)","v":0},null,null,{"$f":"SUM('Audit July-Aug-Sept'!H9:J9,'Audit Oct-Nov-Dec'!H9:J9,'Audit Jan-Feb-Mar'!H9:J9,'Audit Apr-May-June'!H9:J9)","v":0},null,null,{"$f":"SUM(D10+F10)-I10","v":0}]
[null,{"$f":"Autofill!A18","v":0},null,{"$f":"Autofill!B18","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!E10:G10,'Audit Oct-Nov-Dec'!E10:G10,'Audit Jan-Feb-Mar'!E10:G10,'Audit Apr-May-June'!E10:G10)","v":0},null,null,{"$f":"SUM('Audit July-Aug-Sept'!H10:J10,'Audit Oct-Nov-Dec'!H10:J10,'Audit Jan-Feb-Mar'!H10:J10,'Audit Apr-May-June'!H10:J10)","v":0},null,null,0]
[null,"(ARF) Aux Relief Fund",null,{"$f":"Autofill!B16","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!E11:G11,'Audit Oct-Nov-Dec'!E11:G11,'Audit Jan-Feb-Mar'!E11:G11,'Audit Apr-May-June'!E11:G11)","v":0},null,null,{"$f":"SUM('Audit July-Aug-Sept'!H11:J11,'Audit Oct-Nov-Dec'!H11:J11,'Audit Jan-Feb-Mar'!H11:J11,'Audit Apr-May-June'!H11:J11)","v":0},null,null,{"$f":"SUM(D12+F12)-I12","v":0}]
[null,{"$f":"Autofill!A19","v":0},null,{"$f":"Autofill!B19","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!E12:G12,'Audit Oct-Nov-Dec'!E12:G12,'Audit Jan-Feb-Mar'!E12:G12,'Audit Apr-May-June'!E12:G12)","v":0},null,null,{"$f":"SUM('Audit July-Aug-Sept'!H12:J12,'Audit Oct-Nov-Dec'!H12:J12,'Audit Jan-Feb-Mar'!H12:J12,'Audit Apr-May-June'!H12:J12)","v":0},null,null,{"$f":"SUM(D13+F13)-I13","v":0}]
[null,"TOTALS",null,{"$f":"SUM(D8:E13)","v":0},null,{"$f":"SUM(F8:H13)","v":0},null,null,{"$f":"SUM(I8:K13)","v":0},null,null,{"$f":"SUM(D14+F14)-I14","v":0}]
[null,"(SV) Savings",null,{"$f":"SUM(Autofill!B22)","v":0},null,{"$f":"SUM('Audit July-Aug-Sept'!E14:G14,'Audit Oct-Nov-Dec'!E14:G14,'Audit Jan-Feb-Mar'!E14:G14,'Audit Apr-May-June'!E14:G14)","v":0},null,null,{"$f":"SUM('Audit July-Aug-Sept'!H14:J14,'Audit Oct-Nov-Dec'!H14:J14,'Audit Jan-Feb-Mar'!H14:J14,'Audit Apr-May-June'!H14:J14)","v":0},null,null,{"$f":"SUM(D15+F15)-I15","v":0}]
[null,"FISCAL YEAR TOTALS",null,{"$f":"SUM(D8:D15)","v":0},null,{"$f":"SUM(F8:F15)","v":0},null,null,{"$f":"SUM(I8:I15)","v":0},null,null,0]

{"sheet":"Blank Audit","index":18,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,0,12,1],[12,2,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[3,0,3,2],[3,3,3,5],[3,7,3,9],[0,0,0,11],[1,0,1,4],[1,5,1,6],[1,7,1,9],[2,0,2,11],[6,0,6,1],[6,2,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,11],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,9],[5,10,5,11],[8,0,8,1],[8,2,8,3],[8,4,8,6],[8,7,8,9],[8,10,8,11],[7,0,7,1],[7,2,7,3],[7,4,7,6],[7,7,7,9],[7,10,7,11],[10,0,10,1],[10,2,10,3],[10,4,10,6],[10,7,10,9],[10,10,10,11],[9,0,9,1],[9,2,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,11],[13,0,13,1],[13,2,13,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[11,0,11,1],[11,2,11,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[14,7,14,9],[14,10,14,11],[14,0,14,1],[14,2,14,3],[14,4,14,6],[18,0,18,2],[18,4,18,5],[19,0,19,2],[19,4,19,5],[17,0,17,3],[17,4,17,5],[29,0,34,3],[20,0,20,2],[20,4,20,5],[27,1,27,2],[27,9,27,11],[28,9,33,11],[21,0,21,3],[21,4,21,5],[23,0,25,3],[23,6,23,7],[23,8,23,9],[23,10,23,11],[24,8,24,9],[24,10,24,11],[25,8,25,9],[25,10,25,11]]}
["AUDIT REPORT"]
["                               VFW AUXILIARY TO POST NUMBER",null,null,null,null,null,null,"DISTRICT NUMBER"]
["DISTRIBUTION OF RECEIPTS, DISBURSEMENTS, AND CASH BALANCE BY FUND"]
["                                        FOR PERIOD OF",null,null,"",null,null,"TO",""]
[]
["Name of FUND",null,"Cash Balance\nLast Audit Report",null,"Receipts Since\nLast Audit Report",null,null,"Disbursements\nSince Last Audit Report",null,null,"Cash Balance\nThis Report"]
["(GF) General Fund"]
["(DND) Dept/Nat’l Dues"]
[{"$f":"Autofill!B8","v":0}]
[{"$f":"Autofill!B9","v":0}]
["(ARF) Aux Relief Fund"]
[{"$f":"Autofill!B10","v":0}]
["TOTALS"]
["(SV) Savings"]
["TOTALS - Including Savings"]
[null,null,null,null,null,null,null,null,null,null," "," "]
[]
["Bank Balance as shown on all Bank Statements"]
["Deposits in Transit – (please list below)",null,null,"Amount "]
["Less Outstanding Checks –(please list below)",null,null,"Amount "]
["Savings Account or CD’s",null,null,"Amount "]
["TOTAL BANK BALANCE "]
[]
["This is to certify that the books of the Secretary and Treasurer\nhave been audited, found correct and all moneys properly\naccounted for.",null,null,null,"Outstanding Checks",null,"Deposits",null,"Trustee #1"]
[null,null,null,null,"Check #","Amount","Amount","Date","Trustee #2"]
[null,null,null,null,null,null,null,null,"Trustee #3"]
[]
["Audited this date:","",null,null,null,null,null,null,null,"SEND TO:"]
[null,null,null,null,null,null,null,null,null,"Cindy Estell, Department Treasurer\nVFW Auxiliary\nP O Box 55850\nSt Petersburg  FL  33732-5850"]
["The Treasurer must have available for the audit committee all bank statements, savings account books, cancelled checks, and ledger books in order for the audit to be conducted in the proper manner. All outstanding checks should be listed with the number of check and amount of bank statement."]
[]
[]
[]
[null,null,null,null,"TOTAL",null,null,""]