{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Revenue","Expenses","Totals"],"not_rendered":{"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"merged":[[0,0,0,8],[1,0,1,12],[3,0,3,12],[5,0,5,12],[7,0,7,12],[9,0,9,12],[11,0,11,12]]}
["INSTRUCTION SHEET"]
["There is a sheet for listing your revenue, one for expenses, and one that shows the totals of  revenue and expense by category."]
[]
["I've included the most common categories I track. These do not necessarily correspond to the IRS Schedule C. Ihave several sources of income and like to track each separately. I also like to track specific expense categories that the IRS would consider one category. You can delete and add columns as needed for your particular needs."]
[]
["Each category is totaled on each sheet so you can quickly see how much you've spent in the category Year To Date. That total is then carried over to the totals page, where you can see each in an overall total."]
[]
["I've entered a sample on each sheet so you can see how the numbers come together. Enter you own data in that row or delete the row. Insesrt new lines and columns as needed. If you insert new column categories, be sure to add those to the Totals Sheet.The cells are formatted according to Accounting."]
[]
["This document has been saved as a template. Once you enter in your own data, save the file and name it accordingly. Each year you will be able to use this template to begin your new year accounting."]
[]
["SALARY YOU PAY YOURSELF IS NOT DEDUCTIBLE. YOU'LL NOTICE I TRACK MY TOTAL SALARY, BUT IT IS NOT INCLUDED IN THE TOTAL EXPENSES COLUMN. I LIST IT JUST BELOW MY REVENUE AND EXPENSE SO I HAVE A QUICK OVERVIEW OF HOW MY SALARY EQUATES TO THE REST OF MY REV AND EXP."]

{"sheet":"Revenue","index":1,"n_rows":9,"n_cols":9,"rows_kept":9}
["DATE","REVENUE DESC","BOOK SALES","BOOK ROYALTIES","SPEAKING REVENUE","CONFERENCES","NOTES"]
["2018-01-01","Book signing",{"v":40,"d":"40.00"},{"$nulls":3},"Barnes and Noble"]
[]
[]
[]
[]
[]
[]
[null,"Category Totals",{"$f":"SUM(C2:C8)","v":{"v":40,"d":"40.00"}},{"$f":"SUM(D2:D8)","v":0},{"$f":"SUM(E2:E8)","v":0},{"$f":"SUM(F2:F8)","v":0},null,{"$f":"SUM(C9:G9)","v":{"v":40,"d":"40.00"}},"Revenue Total"]

{"sheet":"Expenses","index":2,"n_rows":24,"n_cols":24,"rows_kept":24}
["DATE","FORM OF PAYMENT","EXPENSE DESC","INTERNET","SOFTWARE/ ONLINE SVCS","SALARY","EDUCATION/CONFERENCE","OFFICE SUPPLIES","MISC","POSTAGE","PUBLISHING EXP","BOOKS","DUES AND SUBS","MRKT - ADV","EQUIPMENT","MEALS","HOTEL EXP","TRAVEL EXPs","LEGAL & PRO FEES","INCOME TAX","SALES TAX TO MO","NOTES"]
["2018-01-01","debit","Internet",{"v":70,"d":"70.00"}]
{"$rows_empty":21}
[null,null,"Category Totals",{"$f":"SUM(D2:D23)","v":{"v":70,"d":"70.00"}},{"$f":"SUM(E2:E23)","v":0},{"$f":"SUM(F2:F23)","v":0},{"$f":"SUM(G2:G23)","v":0},{"$f":"SUM(H2:H23)","v":0},{"$f":"SUM(I2:I23)","v":0},{"$f":"SUM(J2:J23)","v":0},{"$f":"SUM(K2:K23)","v":0},{"$f":"SUM(L2:L23)","v":0},{"$f":"SUM(M2:M23)","v":0},{"$f":"SUM(N2:N23)","v":0},{"$f":"SUM(O2:O23)","v":0},{"$f":"SUM(P2:P23)","v":0},{"$f":"SUM(Q2:Q23)","v":0},{"$f":"SUM(R2:R23)","v":0},{"$f":"SUM(S2:S23)","v":0},{"$f":"SUM(T2:T23)","v":0},{"$f":"SUM(U2:U23)","v":0},null,{"$f":"SUM(D24:V24)","v":{"v":70,"d":"70.00"}},"Total Expenses"]

{"sheet":"Totals","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[0,5,0,7],[1,5,1,6],[2,5,2,6],[4,5,4,6],[5,5,5,6]]}
["Business Revenue","Amt",{"$nulls":3},"Yearly Profit/Loss"]
["Book sales",{"$f":"bksales","v":{"v":40,"d":"40.00"}},{"$nulls":3},"Revenue",null,{"$f":"totalrev","v":{"v":40,"d":"40.00"}}]
["Book royalites",{"$f":"bkroyalties","v":0},{"$nulls":3},"Expenses",null,{"$f":"totalexp","v":{"v":70,"d":"70.00"}}]
["Speaking",{"$f":"speaking","v":0}]
["Conferences",{"$f":"conferences","v":0},{"$nulls":3},"Profit/Loss",null,{"$f":"H2-H3","v":{"v":-30,"d":"(30.00)"}}]
["TOTAL REVENUE",{"$f":"SUM(B2:B5)","v":{"v":40,"d":"40.00"}},{"$nulls":3},"My salary",null,{"$f":"salary","v":0}]
[]
[]
[]
[]
[]
[]
["Business Expenses","Amt"]
["Internet",{"$f":"Internet","v":{"v":70,"d":"70.00"}}]
["Online software services",{"$f":"software","v":0}]
["Education",{"$f":"education","v":0}]
["Office Supplies",{"$f":"office","v":0}]
["Misc.",{"$f":"misc","v":0}]
["Postage",{"$f":"postage","v":0}]
["Publishing Expenses",{"$f":"publishing","v":0}]
["Books",{"$f":"books","v":0}]
["Member dues",{"$f":"dues","v":0}]
["marketing/advertising",{"$f":"advertising","v":0}]
["Equipment",{"$f":"equipment","v":0}]
["Meals",{"$f":"meals","v":0}]
["Hotel expenses",{"$f":"hotels","v":0}]
["Travel expenses",{"$f":"travel","v":0}]
["Legal/Professional fees",{"$f":"pro_fees","v":0}]
["Income tax",{"$f":"fedtax","v":0}]
["State Sales tax",{"$f":"statetax","v":0}]
["TOTAL EXPENSES",{"$f":"SUM(B14:B30)","v":{"v":70,"d":"70.00"}}]