{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Account Ledgers"],"not_rendered":{"charts":4},"read":"whole","date_system":"1900"}

{"sheet":"Account Ledgers","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"merged":[[13,0,13,8],[24,0,24,8],[33,0,33,8],[43,0,43,8]]}
["Accounts Payable Ledger"]
[]
["ACCOUNT 1",{"$nulls":7},{"$f":"A3&\" BALANCE\"","v":"ACCOUNT 1 BALANCE"}]
["DATE","REFERENCE","TYPE","MEMO","ACCOUNT","DEBIT","CREDIT","BALANCE"," "]
["2012-02-02","Beginning Balance",{"$nulls":5},{"v":501,"d":"$501.00"},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-02",1003,"Payment","Invoice 3","500 Cash in bank",{"v":150,"d":"$150.00"},null,{"$f":"SUM(INDEX(Account1[BALANCE],ROW(Account1[[#This Row],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1))))+Account1[[#This Row],[DEBIT]]-Account1[[#This Row],[CREDIT]]","v":{"v":651,"d":"$651.00"}},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-02",1003,"Payment","Invoice 3","550 Accounts payable",null,{"v":140,"d":"$140.00"},{"$f":"SUM(INDEX(Account1[BALANCE],ROW(Account1[[#This Row],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1))))+Account1[[#This Row],[DEBIT]]-Account1[[#This Row],[CREDIT]]","v":{"v":511,"d":"$511.00"}},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":1}]
["2012-02-17","111","Purchase","Invoice 111","550 Accounts payable",{"v":200,"d":"$200.00"},null,{"$f":"SUM(INDEX(Account1[BALANCE],ROW(Account1[[#This Row],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1))))+Account1[[#This Row],[DEBIT]]-Account1[[#This Row],[CREDIT]]","v":{"v":711,"d":"$711.00"}},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-17","111","Purchase","Invoice 111","120 Uniforms",null,{"v":200,"d":"$200.00"},{"$f":"SUM(INDEX(Account1[BALANCE],ROW(Account1[[#This Row],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1))))+Account1[[#This Row],[DEBIT]]-Account1[[#This Row],[CREDIT]]","v":{"v":511,"d":"$511.00"}},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-27",1009,"Payment","Invoice 9","500 Cash in bank",{"v":450,"d":"$450.00"},null,{"$f":"SUM(INDEX(Account1[BALANCE],ROW(Account1[[#This Row],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1))))+Account1[[#This Row],[DEBIT]]-Account1[[#This Row],[CREDIT]]","v":{"v":961,"d":"$961.00"}},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-27",1009,"Payment","Invoice 9","550 Accounts payable",null,{"v":450,"d":"$450.00"},{"$f":"SUM(INDEX(Account1[BALANCE],ROW(Account1[[#This Row],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1))))+Account1[[#This Row],[DEBIT]]-Account1[[#This Row],[CREDIT]]","v":{"v":511,"d":"$511.00"}},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-28",1003,"Payment","Invoice #3 final","550 Accounts payable",null,{"v":10,"d":"$10.00"},{"$f":"SUM(INDEX(Account1[BALANCE],ROW(Account1[[#This Row],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1))))+Account1[[#This Row],[DEBIT]]-Account1[[#This Row],[CREDIT]]","v":{"v":501,"d":"$501.00"}},{"$f":"IF(COUNTIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[DEBIT],1):INDEX(Account1[DEBIT],ROW(Account1[[#This Row],[DEBIT]])-ROW(INDEX(Account1[DEBIT],1))+1))-SUMIF(INDEX(Account1[REFERENCE],1):INDEX(Account1[REFERENCE],ROW(Account1[[#This Row],[REFERENCE]])-ROW(INDEX(Account1[REFERENCE],1))+1),Account1[[#This Row],[REFERENCE]],INDEX(Account1[CREDIT],1):INDEX(Account1[CREDIT],ROW(Account1[[#This Row],[CREDIT]])-ROW(INDEX(Account1[CREDIT],1))+1))=0,0,1),0)","v":0}]
[{"$nulls":4},"Ending Balance",{"$f":"SUBTOTAL(109,Account1[DEBIT])","v":{"v":800,"d":"$800.00"}},{"$f":"SUBTOTAL(109,Account1[CREDIT])","v":{"v":800,"d":"$800.00"}},{"$f":"INDEX(Account1[BALANCE],ROW(Account1[[#Totals],[BALANCE]])-ROW(INDEX(Account1[BALANCE],1)))","v":{"v":501,"d":"$501.00"}}]
[]
["ACCOUNT 2",{"$nulls":7},{"$f":"A15&\" BALANCE\"","v":"ACCOUNT 2 BALANCE"}]
["DATE","REFERENCE","TYPE","MEMO","ACCOUNT","DEBIT","CREDIT","BALANCE"," "]
["2012-02-15","Beginning Balance",{"$nulls":5},{"v":502,"d":"$502.00"},{"$f":"IF(COUNTIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[DEBIT],1):INDEX(Account2[DEBIT],ROW(Account2[[#This Row],[DEBIT]])-ROW(INDEX(Account2[DEBIT],1))+1))-SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[CREDIT],1):INDEX(Account2[CREDIT],ROW(Account2[[#This Row],[CREDIT]])-ROW(INDEX(Account2[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-15","112","Purchase","Invoice 112","550 Accounts payable",null,{"v":650,"d":"$650.00"},{"$f":"SUM(INDEX(Account2[BALANCE],ROW(Account2[[#This Row],[BALANCE]])-ROW(INDEX(Account2[BALANCE],1))))+Account2[[#This Row],[DEBIT]]-Account2[[#This Row],[CREDIT]]","v":{"v":-148,"d":"-$148.00"}},{"$f":"IF(COUNTIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[DEBIT],1):INDEX(Account2[DEBIT],ROW(Account2[[#This Row],[DEBIT]])-ROW(INDEX(Account2[DEBIT],1))+1))-SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[CREDIT],1):INDEX(Account2[CREDIT],ROW(Account2[[#This Row],[CREDIT]])-ROW(INDEX(Account2[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-15","112","Purchase","Invoice 112","140 Office furniture",{"v":650,"d":"$650.00"},null,{"$f":"SUM(INDEX(Account2[BALANCE],ROW(Account2[[#This Row],[BALANCE]])-ROW(INDEX(Account2[BALANCE],1))))+Account2[[#This Row],[DEBIT]]-Account2[[#This Row],[CREDIT]]","v":{"v":502,"d":"$502.00"}},{"$f":"IF(COUNTIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[DEBIT],1):INDEX(Account2[DEBIT],ROW(Account2[[#This Row],[DEBIT]])-ROW(INDEX(Account2[DEBIT],1))+1))-SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[CREDIT],1):INDEX(Account2[CREDIT],ROW(Account2[[#This Row],[CREDIT]])-ROW(INDEX(Account2[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-27","1006","Payment","Invoice 6","500 Cash in bank",null,{"v":750,"d":"$750.00"},{"$f":"SUM(INDEX(Account2[BALANCE],ROW(Account2[[#This Row],[BALANCE]])-ROW(INDEX(Account2[BALANCE],1))))+Account2[[#This Row],[DEBIT]]-Account2[[#This Row],[CREDIT]]","v":{"v":-248,"d":"-$248.00"}},{"$f":"IF(COUNTIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[DEBIT],1):INDEX(Account2[DEBIT],ROW(Account2[[#This Row],[DEBIT]])-ROW(INDEX(Account2[DEBIT],1))+1))-SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[CREDIT],1):INDEX(Account2[CREDIT],ROW(Account2[[#This Row],[CREDIT]])-ROW(INDEX(Account2[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-27","1006","Payment","Invoice 6","550 Accounts payable",{"v":750,"d":"$750.00"},null,{"$f":"SUM(INDEX(Account2[BALANCE],ROW(Account2[[#This Row],[BALANCE]])-ROW(INDEX(Account2[BALANCE],1))))+Account2[[#This Row],[DEBIT]]-Account2[[#This Row],[CREDIT]]","v":{"v":502,"d":"$502.00"}},{"$f":"IF(COUNTIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[DEBIT],1):INDEX(Account2[DEBIT],ROW(Account2[[#This Row],[DEBIT]])-ROW(INDEX(Account2[DEBIT],1))+1))-SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[CREDIT],1):INDEX(Account2[CREDIT],ROW(Account2[[#This Row],[CREDIT]])-ROW(INDEX(Account2[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-28","1005","Payment","Invoice 99","500 Cash in bank",null,{"v":201,"d":"$201.00"},{"$f":"SUM(INDEX(Account2[BALANCE],ROW(Account2[[#This Row],[BALANCE]])-ROW(INDEX(Account2[BALANCE],1))))+Account2[[#This Row],[DEBIT]]-Account2[[#This Row],[CREDIT]]","v":{"v":301,"d":"$301.00"}},{"$f":"IF(COUNTIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[DEBIT],1):INDEX(Account2[DEBIT],ROW(Account2[[#This Row],[DEBIT]])-ROW(INDEX(Account2[DEBIT],1))+1))-SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[CREDIT],1):INDEX(Account2[CREDIT],ROW(Account2[[#This Row],[CREDIT]])-ROW(INDEX(Account2[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-28","1005","Payment","Invoice 99",null,{"v":201,"d":"$201.00"},null,{"$f":"SUM(INDEX(Account2[BALANCE],ROW(Account2[[#This Row],[BALANCE]])-ROW(INDEX(Account2[BALANCE],1))))+Account2[[#This Row],[DEBIT]]-Account2[[#This Row],[CREDIT]]","v":{"v":502,"d":"$502.00"}},{"$f":"IF(COUNTIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[DEBIT],1):INDEX(Account2[DEBIT],ROW(Account2[[#This Row],[DEBIT]])-ROW(INDEX(Account2[DEBIT],1))+1))-SUMIF(INDEX(Account2[REFERENCE],1):INDEX(Account2[REFERENCE],ROW(Account2[[#This Row],[REFERENCE]])-ROW(INDEX(Account2[REFERENCE],1))+1),Account2[[#This Row],[REFERENCE]],INDEX(Account2[CREDIT],1):INDEX(Account2[CREDIT],ROW(Account2[[#This Row],[CREDIT]])-ROW(INDEX(Account2[CREDIT],1))+1))=0,0,1),0)","v":0}]
[{"$nulls":4},"Ending balance",{"$f":"SUBTOTAL(109,Account2[DEBIT])","v":{"v":1601,"d":"$1,601.00"}},{"$f":"SUBTOTAL(109,Account2[CREDIT])","v":{"v":1601,"d":"$1,601.00"}},{"$f":"INDEX(Account2[BALANCE],ROW(Account2[[#Totals],[BALANCE]])-ROW(INDEX(Account2[BALANCE],1)))","v":{"v":502,"d":"$502.00"}}]
[]
["ACCOUNT 3",{"$nulls":7},{"$f":"A26&\" BALANCE\"","v":"ACCOUNT 3 BALANCE"}]
["DATE","REFERENCE","TYPE","MEMO","ACCOUNT","DEBIT","CREDIT","BALANCE"," "]
["2012-02-09","Beginning Balance",{"$nulls":5},{"v":503,"d":"$503.00"},{"$f":"IF(COUNTIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[DEBIT],1):INDEX(Account3[DEBIT],ROW(Account3[[#This Row],[DEBIT]])-ROW(INDEX(Account3[DEBIT],1))+1))-SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[CREDIT],1):INDEX(Account3[CREDIT],ROW(Account3[[#This Row],[CREDIT]])-ROW(INDEX(Account3[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-09","115","Purchase","Invoice 115","550 Accounts payable",null,{"v":125,"d":"$125.00"},{"$f":"SUM(INDEX(Account3[BALANCE],ROW(Account3[[#This Row],[BALANCE]])-ROW(INDEX(Account3[BALANCE],1))))+Account3[[#This Row],[DEBIT]]-Account3[[#This Row],[CREDIT]]","v":{"v":378,"d":"$378.00"}},{"$f":"IF(COUNTIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[DEBIT],1):INDEX(Account3[DEBIT],ROW(Account3[[#This Row],[DEBIT]])-ROW(INDEX(Account3[DEBIT],1))+1))-SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[CREDIT],1):INDEX(Account3[CREDIT],ROW(Account3[[#This Row],[CREDIT]])-ROW(INDEX(Account3[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-09","115","Purchase","Invoice 115","110 Office supplies",{"v":125,"d":"$125.00"},null,{"$f":"SUM(INDEX(Account3[BALANCE],ROW(Account3[[#This Row],[BALANCE]])-ROW(INDEX(Account3[BALANCE],1))))+Account3[[#This Row],[DEBIT]]-Account3[[#This Row],[CREDIT]]","v":{"v":503,"d":"$503.00"}},{"$f":"IF(COUNTIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[DEBIT],1):INDEX(Account3[DEBIT],ROW(Account3[[#This Row],[DEBIT]])-ROW(INDEX(Account3[DEBIT],1))+1))-SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[CREDIT],1):INDEX(Account3[CREDIT],ROW(Account3[[#This Row],[CREDIT]])-ROW(INDEX(Account3[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-13","1012","Payment","Invoice 12","500 Cash in bank",null,{"v":200,"d":"$200.00"},{"$f":"SUM(INDEX(Account3[BALANCE],ROW(Account3[[#This Row],[BALANCE]])-ROW(INDEX(Account3[BALANCE],1))))+Account3[[#This Row],[DEBIT]]-Account3[[#This Row],[CREDIT]]","v":{"v":303,"d":"$303.00"}},{"$f":"IF(COUNTIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[DEBIT],1):INDEX(Account3[DEBIT],ROW(Account3[[#This Row],[DEBIT]])-ROW(INDEX(Account3[DEBIT],1))+1))-SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[CREDIT],1):INDEX(Account3[CREDIT],ROW(Account3[[#This Row],[CREDIT]])-ROW(INDEX(Account3[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-13","1012","Payment","Invoice 12","550 Accounts payable",{"v":100,"d":"$100.00"},null,{"$f":"SUM(INDEX(Account3[BALANCE],ROW(Account3[[#This Row],[BALANCE]])-ROW(INDEX(Account3[BALANCE],1))))+Account3[[#This Row],[DEBIT]]-Account3[[#This Row],[CREDIT]]","v":{"v":403,"d":"$403.00"}},{"$f":"IF(COUNTIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[DEBIT],1):INDEX(Account3[DEBIT],ROW(Account3[[#This Row],[DEBIT]])-ROW(INDEX(Account3[DEBIT],1))+1))-SUMIF(INDEX(Account3[REFERENCE],1):INDEX(Account3[REFERENCE],ROW(Account3[[#This Row],[REFERENCE]])-ROW(INDEX(Account3[REFERENCE],1))+1),Account3[[#This Row],[REFERENCE]],INDEX(Account3[CREDIT],1):INDEX(Account3[CREDIT],ROW(Account3[[#This Row],[CREDIT]])-ROW(INDEX(Account3[CREDIT],1))+1))=0,0,1),0)","v":1}]
[{"$nulls":4},"Ending balance",{"$f":"SUBTOTAL(109,Account3[DEBIT])","v":{"v":225,"d":"$225.00"}},{"$f":"SUBTOTAL(109,Account3[CREDIT])","v":{"v":325,"d":"$325.00"}},{"$f":"INDEX(Account3[BALANCE],ROW(Account3[[#Totals],[BALANCE]])-ROW(INDEX(Account3[BALANCE],1)))","v":{"v":403,"d":"$403.00"}}]
[]
["ACCOUNT 4",{"$nulls":7},{"$f":"A35&\" BALANCE\"","v":"ACCOUNT 4 BALANCE"}]
["DATE","REFERENCE","TYPE","MEMO","ACCOUNT","DEBIT","CREDIT","BALANCE"," "]
["2012-02-09","Beginning Balance",{"$nulls":5},{"v":504,"d":"$504.00"},{"$f":"IF(COUNTIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[DEBIT],1):INDEX(Account4[DEBIT],ROW(Account4[[#This Row],[DEBIT]])-ROW(INDEX(Account4[DEBIT],1))+1))-SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[CREDIT],1):INDEX(Account4[CREDIT],ROW(Account4[[#This Row],[CREDIT]])-ROW(INDEX(Account4[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-09","115","Purchase","Invoice 115","550 Accounts payable",null,{"v":175,"d":"$175.00"},{"$f":"SUM(INDEX(Account4[BALANCE],ROW(Account4[[#This Row],[BALANCE]])-ROW(INDEX(Account4[BALANCE],1))))+Account4[[#This Row],[DEBIT]]-Account4[[#This Row],[CREDIT]]","v":{"v":329,"d":"$329.00"}},{"$f":"IF(COUNTIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[DEBIT],1):INDEX(Account4[DEBIT],ROW(Account4[[#This Row],[DEBIT]])-ROW(INDEX(Account4[DEBIT],1))+1))-SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[CREDIT],1):INDEX(Account4[CREDIT],ROW(Account4[[#This Row],[CREDIT]])-ROW(INDEX(Account4[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-09","115","Purchase","Invoice 115","110 Office supplies",{"v":160,"d":"$160.00"},null,{"$f":"SUM(INDEX(Account4[BALANCE],ROW(Account4[[#This Row],[BALANCE]])-ROW(INDEX(Account4[BALANCE],1))))+Account4[[#This Row],[DEBIT]]-Account4[[#This Row],[CREDIT]]","v":{"v":489,"d":"$489.00"}},{"$f":"IF(COUNTIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[DEBIT],1):INDEX(Account4[DEBIT],ROW(Account4[[#This Row],[DEBIT]])-ROW(INDEX(Account4[DEBIT],1))+1))-SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[CREDIT],1):INDEX(Account4[CREDIT],ROW(Account4[[#This Row],[CREDIT]])-ROW(INDEX(Account4[CREDIT],1))+1))=0,0,1),0)","v":1}]
["2012-02-13","1012","Payment","Invoice 12","500 Cash in bank",null,{"v":200,"d":"$200.00"},{"$f":"SUM(INDEX(Account4[BALANCE],ROW(Account4[[#This Row],[BALANCE]])-ROW(INDEX(Account4[BALANCE],1))))+Account4[[#This Row],[DEBIT]]-Account4[[#This Row],[CREDIT]]","v":{"v":289,"d":"$289.00"}},{"$f":"IF(COUNTIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[DEBIT],1):INDEX(Account4[DEBIT],ROW(Account4[[#This Row],[DEBIT]])-ROW(INDEX(Account4[DEBIT],1))+1))-SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[CREDIT],1):INDEX(Account4[CREDIT],ROW(Account4[[#This Row],[CREDIT]])-ROW(INDEX(Account4[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-13","1012","Payment","Invoice 12","550 Accounts payable",{"v":200,"d":"$200.00"},null,{"$f":"SUM(INDEX(Account4[BALANCE],ROW(Account4[[#This Row],[BALANCE]])-ROW(INDEX(Account4[BALANCE],1))))+Account4[[#This Row],[DEBIT]]-Account4[[#This Row],[CREDIT]]","v":{"v":489,"d":"$489.00"}},{"$f":"IF(COUNTIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[DEBIT],1):INDEX(Account4[DEBIT],ROW(Account4[[#This Row],[DEBIT]])-ROW(INDEX(Account4[DEBIT],1))+1))-SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[CREDIT],1):INDEX(Account4[CREDIT],ROW(Account4[[#This Row],[CREDIT]])-ROW(INDEX(Account4[CREDIT],1))+1))=0,0,1),0)","v":0}]
["2012-02-15","115","Purchase","Invoice #115","110 Office supplies",{"v":10,"d":"$10.00"},null,{"$f":"IF(((SUMIF(INDEX(Account4[REFERENCE],1):Account4[[#This Row],[REFERENCE]],Account4[[#This Row],[REFERENCE]],Account4[DEBIT])>0)*(SUMIF(INDEX(Account4[REFERENCE],1):Account4[[#This Row],[REFERENCE]],Account4[[#This Row],[REFERENCE]],Account4[CREDIT])>0)),SUMIF(INDEX(Account4[REFERENCE],1):Account4[[#This Row],[REFERENCE]],Account4[[#This Row],[REFERENCE]],INDEX(Account4[CREDIT],1):Account4[[#This Row],[CREDIT]])-SUMIF(INDEX(Account4[REFERENCE],1):Account4[[#This Row],[REFERENCE]],Account4[[#This Row],[REFERENCE]],INDEX(Account4[DEBIT],1):Account4[[#This Row],[DEBIT]]),0)","v":{"v":5,"d":"$5.00"}},{"$f":"IF(COUNTIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]])>1,IF(SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[DEBIT],1):INDEX(Account4[DEBIT],ROW(Account4[[#This Row],[DEBIT]])-ROW(INDEX(Account4[DEBIT],1))+1))-SUMIF(INDEX(Account4[REFERENCE],1):INDEX(Account4[REFERENCE],ROW(Account4[[#This Row],[REFERENCE]])-ROW(INDEX(Account4[REFERENCE],1))+1),Account4[[#This Row],[REFERENCE]],INDEX(Account4[CREDIT],1):INDEX(Account4[CREDIT],ROW(Account4[[#This Row],[CREDIT]])-ROW(INDEX(Account4[CREDIT],1))+1))=0,0,1),0)","v":1}]
[{"$nulls":4},"Ending balance",{"$f":"SUBTOTAL(109,Account4[DEBIT])","v":{"v":370,"d":"$370.00"}},{"$f":"SUBTOTAL(109,Account4[CREDIT])","v":{"v":375,"d":"$375.00"}},{"$f":"INDEX(Account4[BALANCE],ROW(Account4[[#Totals],[BALANCE]])-ROW(INDEX(Account4[BALANCE],1)))","v":{"v":5,"d":"$5.00"}}]