{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Assets","Liabilities","Categories"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":13,"n_cols":4,"rows_kept":13}
[]
[null,"BALANCE SHEET "]
[null,null,{"$f":"\"FY-\"&YEAR(TODAY())-1","v":"FY-2022"},{"$f":"\"FY-\"&YEAR(TODAY())","v":"FY-2023"}]
[null,"ASSET TYPE","PRIOR YEAR","CURRENT YEAR"]
[null,"Current assets",{"$f":"SUMIFS(Assets[PRIOR YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[PRIOR YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":600,"d":"600 "}},{"$f":"SUMIFS(Assets[CURRENT YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[CURRENT YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":600,"d":"600 "}}]
[null,"Fixed assets",{"$f":"SUMIFS(Assets[PRIOR YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[PRIOR YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":-100,"d":"(100)"}},{"$f":"SUMIFS(Assets[CURRENT YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[CURRENT YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":-85,"d":"(85)"}}]
[null,"Other assets",{"$f":"SUMIFS(Assets[PRIOR YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[PRIOR YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Assets[CURRENT YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[CURRENT YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":0,"d":"0 "}}]
[null,"Current liabilities",{"$f":"SUMIFS(Assets[PRIOR YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[PRIOR YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":500,"d":"500 "}},{"$f":"SUMIFS(Assets[CURRENT YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[CURRENT YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":350,"d":"350 "}}]
[null,"Long-term liabilities",{"$f":"SUMIFS(Assets[PRIOR YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[PRIOR YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Assets[CURRENT YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[CURRENT YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":0,"d":"0 "}}]
[null,"Owner equity",{"$f":"SUMIFS(Assets[PRIOR YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[PRIOR YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Assets[CURRENT YEAR],Assets[ASSET TYPE],Dashboard[[#This Row],[ASSET TYPE]])+SUMIFS(Liabilities[CURRENT YEAR],Liabilities[LIABILITY TYPE],Dashboard[[#This Row],[ASSET TYPE]])","v":{"v":350,"d":"350 "}}]
[null,"TOTAL ASSETS",{"$f":"Assets[[#Totals],[PRIOR YEAR]]","v":{"v":500,"d":"500 "}},{"$f":"Assets[[#Totals],[CURRENT YEAR]]","v":{"v":515,"d":"515 "}}]
[null,"TOTAL LIABILITIES & STOCKHOLDER EQUITY",{"$f":"Liabilities[[#Totals],[PRIOR YEAR]]","v":{"v":500,"d":"500 "}},{"$f":"Liabilities[[#Totals],[CURRENT YEAR]]","v":{"v":700,"d":"700 "}}]
[null,"BALANCE",{"$f":"C11-C12","v":{"v":0,"d":"0 "}},{"$f":"D11-D12","v":{"v":-185,"d":"(185)"}}]

{"sheet":"Assets","index":1,"n_rows":15,"n_cols":5,"rows_kept":15}
[]
[null,"ASSETS"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2022"},{"$f":"FY_YEAR_2","v":"FY-2023"}]
[null,"ASSET TYPE","DESCRIPTION","PRIOR YEAR","CURRENT YEAR"]
[null,"Current assets","Cash",{"v":600,"d":"600 "},{"v":600,"d":"600 "}]
[null,"Current assets","Investments"]
[null,"Current assets","Inventories"]
[null,"Current assets","Accounts receivable"]
[null,"Current assets","Pre-paid expenses"]
[null,"Fixed assets","Property and equipment"]
[null,"Fixed assets","Leasehold improvements"]
[null,"Fixed assets","Equity and other investments"]
[null,"Fixed assets","Less accumulated depreciation (negative value)",{"v":-100,"d":"(100)"},{"v":-85,"d":"(85)"}]
[null,"Other assets","Charity"]
[null,"TOTAL ASSETS",null,{"$f":"SUBTOTAL(109,Assets[PRIOR YEAR])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,Assets[CURRENT YEAR])","v":{"v":515,"d":"515 "}}]

{"sheet":"Liabilities","index":2,"n_rows":13,"n_cols":5,"rows_kept":13}
[]
[null,"LIABILITIES"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2022"},{"$f":"FY_YEAR_2","v":"FY-2023"}]
[null,"LIABILITY TYPE","DESCRIPTION","PRIOR YEAR","CURRENT YEAR"]
[null,"Current liabilities","Accounts payable",null,{"v":350,"d":"350 "}]
[null,"Current liabilities","Accrued wages"]
[null,"Current liabilities","Accrued compensation",{"v":500,"d":"500 "}]
[null,"Current liabilities","Income taxes payable"]
[null,"Current liabilities","Unearned revenue"]
[null,"Long-term liabilities","Mortgage payable"]
[null,"Owner equity","Investment capital",null,{"v":350,"d":"350 "}]
[null,"Owner equity","Accumulated retained earnings"]
[null,"TOTAL LIABILITIES & STOCKHOLDER EQUITY",null,{"$f":"SUBTOTAL(109,Liabilities[PRIOR YEAR])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,Liabilities[CURRENT YEAR])","v":{"v":700,"d":"700 "}}]

{"sheet":"Categories","index":3,"n_rows":10,"n_cols":2,"rows_kept":10}
[]
[null,"CATEGORIES"]
[]
[null,"CATEGORIES"]
[null,"Current assets"]
[null,"Fixed assets"]
[null,"Other assets"]
[null,"Current liabilities"]
[null,"Long-term liabilities"]
[null,"Owner equity"]