{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["YTD SUMMARY","MONTHLY EXPENSES","GL EXPENSE DATA","GL LIST"],"not_rendered":{"images":2,"defined_names":12,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"YTD SUMMARY","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
[]
[null,"2013 ACTUAL VS. BUDGET YTD"]
[]
[null,"G/L Expense","Account Title","Actual","Budget","Budget $","Budget %"]
[null,1000,{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],GL_List,2,0)","v":"Office"},{"$f":"SUMIF(tblData[G/L - Expense],tblYTD[[#This Row],[G/L Expense]],tblData[Amount of Check])","v":{"v":150,"d":"$150.00"}},{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],tblListData[],3,0)","v":{"v":50000,"d":"$50,000.00"}},{"$f":"tblYTD[[#This Row],[Budget]]-tblYTD[[#This Row],[Actual]]","v":{"v":49850,"d":"$49,850.00"}},{"$f":"tblYTD[[#This Row],[Budget $]]/tblYTD[[#This Row],[Budget]]","v":{"v":0.997,"d":"99.70%"}}]
[null,2000,{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],GL_List,2,0)","v":"Store"},{"$f":"SUMIF(tblData[G/L - Expense],tblYTD[[#This Row],[G/L Expense]],tblData[Amount of Check])","v":{"v":2905.27,"d":"$2,905.27"}},{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],tblListData[],3,0)","v":{"v":75000,"d":"$75,000.00"}},{"$f":"tblYTD[[#This Row],[Budget]]-tblYTD[[#This Row],[Actual]]","v":{"v":72094.73,"d":"$72,094.73"}},{"$f":"tblYTD[[#This Row],[Budget $]]/tblYTD[[#This Row],[Budget]]","v":{"v":0.9612630666666666,"d":"96.13%"}}]
[null,3000,{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],GL_List,2,0)","v":"Staffing"},{"$f":"SUMIF(tblData[G/L - Expense],tblYTD[[#This Row],[G/L Expense]],tblData[Amount of Check])","v":{"v":5500,"d":"$5,500.00"}},{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],tblListData[],3,0)","v":{"v":100000,"d":"$100,000.00"}},{"$f":"tblYTD[[#This Row],[Budget]]-tblYTD[[#This Row],[Actual]]","v":{"v":94500,"d":"$94,500.00"}},{"$f":"tblYTD[[#This Row],[Budget $]]/tblYTD[[#This Row],[Budget]]","v":{"v":0.945,"d":"94.50%"}}]
[null,4000,{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],GL_List,2,0)","v":"Equipment"},{"$f":"SUMIF(tblData[G/L - Expense],tblYTD[[#This Row],[G/L Expense]],tblData[Amount of Check])","v":{"v":1854,"d":"$1,854.00"}},{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],tblListData[],3,0)","v":{"v":25000,"d":"$25,000.00"}},{"$f":"tblYTD[[#This Row],[Budget]]-tblYTD[[#This Row],[Actual]]","v":{"v":23146,"d":"$23,146.00"}},{"$f":"tblYTD[[#This Row],[Budget $]]/tblYTD[[#This Row],[Budget]]","v":{"v":0.92584,"d":"92.58%"}}]
[null,5000,{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],GL_List,2,0)","v":"Other"},{"$f":"SUMIF(tblData[G/L - Expense],tblYTD[[#This Row],[G/L Expense]],tblData[Amount of Check])","v":{"v":35.6,"d":"$35.60"}},{"$f":"VLOOKUP(tblYTD[[#This Row],[G/L Expense]],tblListData[],3,0)","v":{"v":50000,"d":"$50,000.00"}},{"$f":"tblYTD[[#This Row],[Budget]]-tblYTD[[#This Row],[Actual]]","v":{"v":49964.4,"d":"$49,964.40"}},{"$f":"tblYTD[[#This Row],[Budget $]]/tblYTD[[#This Row],[Budget]]","v":{"v":0.9992880000000001,"d":"99.93%"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,tblYTD[Actual])","v":{"v":10444.87,"d":"$10,444.87"}},{"$f":"SUBTOTAL(109,tblYTD[Budget])","v":{"v":300000,"d":"$300,000.00"}},{"$f":"SUBTOTAL(109,tblYTD[Budget $])","v":{"v":289555.13,"d":"$289,555.13"}}]

{"sheet":"MONTHLY EXPENSES","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[]
[null,"G/L MONTHLY EXPENSE SUMMARY"]
{"$rows_empty":16}
[null,"Sum of Amount of Check","Month"]
[null,"G/L - Expense","Jan","Feb","Mar","Grand Total"]
[null,1000,{"v":100,"d":"$100.00"},{"v":50,"d":"$50.00"},null,{"v":150,"d":"$150.00"}]
[null,2000,{"v":905.27,"d":"$905.27"},{"v":2000,"d":"$2,000.00"},null,{"v":2905.27,"d":"$2,905.27"}]
[null,3000,null,{"v":2500,"d":"$2,500.00"},{"v":3000,"d":"$3,000.00"},{"v":5500,"d":"$5,500.00"}]
[null,4000,{"v":1854,"d":"$1,854.00"},null,null,{"v":1854,"d":"$1,854.00"}]
[null,5000,{"v":35.6,"d":"$35.60"},null,null,{"v":35.6,"d":"$35.60"}]
[null,"Grand Total",{"v":2894.87,"d":"$2,894.87"},{"v":4550,"d":"$4,550.00"},{"v":3000,"d":"$3,000.00"},{"v":10444.87,"d":"$10,444.87"}]

{"sheet":"GL EXPENSE DATA","index":2,"n_rows":13,"n_cols":12,"rows_kept":13}
[]
[null,"G/L EXPENSE DATA"]
[]
[null,"G/L - Expense","Account Title","Invoice Date","Month","Invoice #","Requested by","Amount of Check","Name of Payee","Check Use","Method of Distribution","File Date"]
[null,1000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Office"},{"v":41289,"d":"4128900.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Jan"},1,"David Daniels",{"v":100,"d":"$100.00"},"Consolidated Messenger ","Blank CDs","Credit",{"v":41294,"d":"4129400.00%"}]
[null,1000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Office"},{"v":41312,"d":"4131200.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Feb"},5,"David Daniels",{"v":50,"d":"$50.00"},"Consolidated Messenger ","Printer ink","Credit",{"v":41315,"d":"4131500.00%"}]
[null,2000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Store"},{"v":41291,"d":"4129100.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Jan"},2,"Marc Faeber",{"v":550,"d":"$550.00"},"Fabrikam, Inc. ","Replace store window","Credit",{"v":41294,"d":"4129400.00%"}]
[null,2000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Store"},{"v":41293,"d":"4129300.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Jan"},3,"Marc Faeber",{"v":355.27,"d":"$355.27"},"A. Datum Corporation ","New cash register","Credit",{"v":41294,"d":"4129400.00%"}]
[null,3000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Staffing"},{"v":41315,"d":"4131500.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Feb"},6,"Robert O'Hara",{"v":2500,"d":"$2,500.00"},"Graphic Design Institute ","contract designer","Check",{"v":41325,"d":"4132500.00%"}]
[null,4000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Equipment"},{"v":41299,"d":"4129900.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Jan"},5,"Robert Walters",{"v":1854,"d":"$1,854.00"},"Trey Research ","New laptop","Credit",{"v":41299,"d":"4129900.00%"}]
[null,5000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Other"},{"v":41297,"d":"4129700.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Jan"},4,"Bob Gage",{"v":35.6,"d":"$35.60"},"Bob Gage","Cab fare","Check",{"v":41297,"d":"4129700.00%"}]
[null,2000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Store"},{"v":41306,"d":"4130600.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Feb"},7,"Bob Gage",{"v":2000,"d":"$2,000.00"},"Bob Gage","Cab fare","Check",{"v":41307,"d":"4130700.00%"}]
[null,3000,{"$f":"IFERROR(VLOOKUP(tblData[[#This Row],[G/L - Expense]],GL_List,2,0),\"\")","v":"Staffing"},{"v":41334,"d":"4133400.00%"},{"$f":"IF(tblData[[#This Row],[Account Title]]=\"\",\"\",TEXT(tblData[[#This Row],[Invoice Date]],\"mmm\"))","v":"Mar"},8,"Bob Gage",{"v":3000,"d":"$3,000.00"},"Bob Gage","Cab fare","Check",{"v":41335,"d":"4133500.00%"}]

{"sheet":"GL LIST","index":3,"n_rows":9,"n_cols":4,"rows_kept":9}
[]
[null,"G/L ACCOUNT TITLES"]
[]
[null,"G/L - Expense","Account Title","Budget"]
[null,1000,"Office",{"v":50000,"d":"$50,000.00"}]
[null,2000,"Store",{"v":75000,"d":"$75,000.00"}]
[null,3000,"Staffing",{"v":100000,"d":"$100,000.00"}]
[null,4000,"Equipment",{"v":25000,"d":"$25,000.00"}]
[null,5000,"Other",{"v":50000,"d":"$50,000.00"}]