{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Balance sheet","Year-over-year chart"],"not_rendered":{"charts":2},"unopened":[{"sheet":"Year-over-year chart","index":2,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[null,"Track your Total assets, Liabilities, Owner’s equity and Balance using this workbook."]
[null,"Enter Assets and Liabilities in respective tables in Balance sheet worksheet."]
[null,"Total current, fixed and other assets, Total current and long-term liabilities, Total owner’s equity and Balance are automatically calculated."]
[null,"Year-over-year chart is automatically updated in the other worksheet."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in BALANCE SHEET worksheet and in cell A1 in YEAR-OVER-YEAR CHART worksheet. This text has been intentionally hidden. To remove text, select column A or cell A1, then select DELETE. To unhide text, select column A or cell A1, then change font colour."]
[null,"To learn more about tables in the BALANCE SHEET worksheet, press SHIFT and then F10 within a table, select the TABLE option, then select ALTERNATIVE TEXT."]

{"sheet":"Balance sheet","index":1,"n_rows":49,"n_cols":4,"rows_kept":49,"merged":[[0,1,1,2],[0,3,1,3]]}
["Create a Balance sheet in this worksheet. Helpful instructions on how to use this worksheet are in the cells in this column. Arrow down to get started.","Your Company name",null,"Balance sheet"]
["Enter Company name in cell to the right. Title of this worksheet is in cell D1. The next instruction is in cell A4."]
[]
["Assets label is in cell to the right.","Assets"]
["Enter details in Current assets table starting in cell to the right. Next instruction is in cell A14.","Current assets:","Previous year","Current year"]
[null,"Cash",0,0]
[null,"Investments",0,0]
[null,"Inventories",0,0]
[null,"Accounts receivable",0,0]
[null,"Pre-paid expenses",0,0]
[null,"Other",0,0]
[null,"Total current assets",{"$f":"SUBTOTAL(109,CurrentAssets[Previous year])","v":0},{"$f":"SUBTOTAL(109,CurrentAssets[Current year])","v":0}]
[]
["Enter details in Fixed assets table starting in cell to the right. Next instruction is in cell A21.","Fixed assets:","Previous year","Current year"]
[null,"Property and equipment",0,0]
[null,"Leasehold improvements",0,0]
[null,"Equity and other investments",0,0]
[null,"Less accumulated depreciation",0,0]
[null,"Total fixed assets",{"$f":"SUBTOTAL(109,FixedAssets[Previous year])","v":0},{"$f":"SUBTOTAL(109,FixedAssets[Current year])","v":0}]
[]
["Enter details in Other assets table starting in cell to the right. Next instruction is in cell A25.","Other assets:","Previous year","Current year"]
[null,"Goodwill",0,0]
[null,"Total other assets",{"$f":"SUBTOTAL(109,OtherAssets[Previous year])","v":0},{"$f":"SUBTOTAL(109,OtherAssets[Current year])","v":0}]
[]
["Total assets for previous year are auto-calculated in cell C25 and Total assets for current year in cell D25. The next instruction is in cell A27.","Total assets",{"$f":"OtherAssets[[#Totals],[Previous year]]+FixedAssets[[#Totals],[Previous year]]+CurrentAssets[[#Totals],[Previous year]]","v":0},{"$f":"OtherAssets[[#Totals],[Current year]]+FixedAssets[[#Totals],[Current year]]+CurrentAssets[[#Totals],[Current year]]","v":0}]
[]
["Liabilities and owner’s equity label is in cell to the right.","Liabilities and owner’s equity"]
["Enter details in Current liabilities table starting in cell to the right. The next instruction is in cell A37.","Current liabilities:","Previous year","Current year"]
[null,"Accounts payable",0,0]
[null,"Accrued wages",0,0]
[null,"Accrued compensation",0,0]
[null,"Income tax payable",0,0]
[null,"Unearned revenue",0,0]
[null,"Other",0,0]
[null,"Total current liabilities",{"$f":"SUBTOTAL(109,CurrentLiabilities[Previous year])","v":0},{"$f":"SUBTOTAL(109,CurrentLiabilities[Current year])","v":0}]
[]
["Enter details in Long-term liabilities table starting in cell to the right. Next instruction is in cell A41.","Long-term liabilities:","Previous year","Current year"]
[null,"Mortgage payable",0,0]
[null,"Total long-term liabilities",{"$f":"SUBTOTAL(109,LongTermLiabilities[Previous year])","v":0},{"$f":"SUBTOTAL(109,LongTermLiabilities[Current year])","v":0}]
[]
["Enter details in Owner’s equity table starting in cell to the right. Next instruction is in cell A46.","Owner’s equity:","Previous year","Current year"]
[null,"Investment capital",0,0]
[null,"Accumulated retained earnings",0,0]
[null,"Total owner’s equity",{"$f":"SUBTOTAL(109,OwnersEquity[Previous year])","v":0},{"$f":"SUBTOTAL(109,OwnersEquity[Current year])","v":0}]
[]
["Total liabilities and owner’s equity for previous year are auto-calculated in cell C46 and for the current year in cell D46. Next instruction is in cell A49.","Total liabilities and owner’s equity",{"$f":"OwnersEquity[[#Totals],[Previous year]]+LongTermLiabilities[[#Totals],[Previous year]]+CurrentLiabilities[[#Totals],[Previous year]]","v":0},{"$f":"OwnersEquity[[#Totals],[Current year]]+LongTermLiabilities[[#Totals],[Current year]]+CurrentLiabilities[[#Totals],[Current year]]","v":0}]
[]
[]
["Previous year balance is auto-calculated in cell C49 and Current year balance in cell D49.","Balance",{"$f":"SUM(C25-C46)","v":0},{"$f":"SUM(D25-D46)","v":0}]