{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hire Purchase","Journal Worksheet","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hire Purchase","index":0,"n_rows":111,"n_cols":24,"rows_kept":111,"cut":false,"hidden":false,"merged":[[13,7,15,9],[9,7,9,8],[8,3,8,5],[9,3,9,5],[10,7,10,8],[11,7,11,8],[0,11,0,13],[1,11,1,13],[4,11,5,13],[6,3,6,5],[5,3,5,5],[17,18,17,19],[15,18,15,20],[6,23,10,25],[2,21,3,21],[6,7,6,8],[16,18,16,19],[4,23,5,25],[17,11,17,12],[17,8,17,10],[17,3,17,7],[7,7,7,8],[10,3,10,5],[7,3,7,5],[13,3,13,4],[12,3,12,4],[8,7,8,8]]}
[null,null,"ℹ","Hire Purchase Schedule - Standard Repayments",null,null,null,null,null,null,null,"Client Name",null,null,null,null,"HIDE"]
[null,null,null,{"$f":"CONCATENATE(\"Loan Commencing During the Year Ended \",TEXT(YearEnd,\"DD MMMM YYYY\"))","v":"Loan Commencing During the Year Ended 30 June 2023"},null,null,null,null,null,null,null,"Preparer Name"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Financial Year Summary",null,null,null,null,null,null,"Borrowing Expenses for Write-Off",null,null,100,null,"Journal Worksheet"]
[null,null,null,"Lender",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Borrowing Expenses Max Period",null,null,60]
[null,null,null,null,null,null,null,"Amount Borrowed",null,null,null,"Year","Interest","Borrowing",null,null,null,null,"Month commenced",null,{"$f":"MONTH($J$12)","v":1},null,null,"Enter your client's general ledger balances at the Journal Worksheet to quickly calculate the journal required to update the ledger with figures in this schedule."]
[null,null,null,"Asset Acquired",null,null,null,"Monthly Repayments",null,null,null,{"$f":"IF(J12>0,IF(MONTH(J12)<=6,YEAR(J12),YEAR(J12)+1),0)","v":0},{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U8,U8-1),$F$20:$F$109),0)","v":0},{"$f":"IF(S110>0,VLOOKUP(U8,S20:U109,3,FALSE),0)","v":0},null,null,null,null,"End of First Year",null,{"$f":"IF($U$7<=6,6-$U$7+1,6+12-$U$7+1)","v":6}]
[null,null,null,null,null,null,null,"Term (months)",null,null,null,{"$f":"IF(M9>1,L8+1,0)","v":0},{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U9,U9-1),$F$20:$F$109)-M8,0)","v":0},{"$f":"IF(S110>0,VLOOKUP(U9,S21:U110,3,FALSE)-N8,0)","v":0},null,null,null,null,"End of Second Year",null,{"$f":"U8+12","v":18}]
[null,null,null,"First Payment",null,null,null,"Residual",null,null,null,0,{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U10,U10-1),$F$20:$F$109)-SUM(M8:M9),0)","v":0},{"$f":"IF(S110>0,VLOOKUP(U10,S22:U111,3,FALSE)-SUM(N8:N9),0)","v":0},null,null,null,null,"End of Third Year",null,30]
[null,null,null,"Please Select",null,null,null,"Borrowing Costs",null,null,null,0,{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U11,U11-1),$F$20:$F$109)-SUM(M8:M10),0)","v":0},{"$f":"IF(S110>0,VLOOKUP(U11,S23:U112,3,FALSE)-SUM(N8:N10),0)","v":0},null,null,null,null,"End of Fourth Year",null,42]
[null,null,null,null,null,null,null,"Date Commenced",null,null,null,0,{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U12,U12-1),$F$20:$F$109)-SUM(M8:M11),0)","v":0},{"$f":"IF(S110>0,VLOOKUP(U12,S24:U113,3,FALSE)-SUM(N8:N11),0)","v":0},null,null,null,null,"End of Fifth Year",null,54]
[null,null,null,"Interest Rate/Month",null,{"$f":"IF(AND(J7>0,(J8*J9)+J10>J7),RATE(J9,J8,-J7,J10,IF(D11=\"On Commencement\",1,0)),0)","v":0},null,null,null,null,null,0,{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U13,U13-1),$F$20:$F$109)-SUM(M8:M12),0)","v":0},{"$f":"IF(S110>0,VLOOKUP(U13,S25:U114,3,FALSE)-SUM(N8:N12),0)","v":0},null,null,null,null,"End of Sixth Year",null,66]
[null,null,null,"Effective Annual Rate",null,{"$f":"IF(F13>0,EFFECT(F13*12,12),0)","v":0},null,{"$f":"IF(AND(J7>0,J8>0,J9>0),IF((J8*J9)+J10<=J7,\"There is no interest to calculate because monthly repayments plus any residual do not exceed the original amount borrowed\",\"\"),\"\")","v":""},null,null,null,0,{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U14,U14-1),$F$20:$F$109)-SUM(M8:M13),0)","v":0},null,null,null,null,null,"End of Seventh Year",null,78]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($J$12>0,SUMIF($S$20:$S$109,\"<=\" & IF($D$11=\"On Commencement\",U15,U15-1),$F$20:$F$109)-SUM(M8:M14),0)","v":0},null,null,null,null,null,"End of Eighth Year",null,90]
[null,null,null,null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(M8:M15)","v":0},{"$f":"SUM(N8:N15)","v":0},null,null,null,null,"Rolling Forward"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year from",null,"2022-07-01"]
[null,null,null,"Amortisation",null,null,null,null,"Liability",null,null,"Unexpired Interest",null,"Borrowing",null,null,null,null,"Year to",null,{"$f":"EOMONTH(U17,11)","v":"2023-06-30"}]
[null,null,null,"Month","Opening Balance","Add\n Interest","Less Repayments","Closing Balance","Account Balance","Current","Non\n Current","Current","Non\n Current","Monthly",null,null,null,null,"Payment No","Borrowing Expenses","Cumulative Borr Xps"]
[null,null,null,{"$f":"IF($J$12>0,IF(MONTH($J$12)=1,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=4,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=7,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=10,EOMONTH($J$12,0),0),0)","v":"00:00:00"},{"$f":"IF(D20>0,J7,0)","v":0},null,{"$f":"IF(AND(D20>0,$D$11=\"On Commencement\"),$J$8,0)","v":0},{"$f":"IF(D20>0,ROUND(E20+F20-G20,8),0)","v":0},{"$f":"IF(D20>0,($J$8*$J$9)+$J$10-G20,0)","v":0},{"$f":"IF(I20>0,SUM(G21:G32),0)","v":0},{"$f":"IF(I20>J20,I20-J20,0)","v":0},{"$f":"IF(I20>0,SUM(F21:F32),0)","v":0},{"$f":"IF(I20>0,SUM(F33:$F$109),0)","v":0},{"$f":"T20","v":0},null,null,null,null,{"$f":"IF(G20>0,1,0)","v":0},{"$f":"IF(AND(S20=1,$J$11<=$V$5),$J$11,IF(AND(S20>0,$J$11>$V$5,S20<=MIN($J$9,$V$6)),$J$11/MIN($J$9,$V$6),0))","v":0},{"$f":"T20","v":0}]
[null,null,null,{"$f":"IF(AND(J12>0,D20>0),EOMONTH(D20,1),IF(MONTH($J$12)=2,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=5,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=8,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=11,EOMONTH($J$12,0),0))","v":"00:00:00"},{"$f":"IF(H20>0,H20,IF(D21>0,J7,0))","v":0},{"$f":"IF(AND(E21>0,E20>0),E21*$F$13,0)","v":0},{"$f":"IF(AND(D20>0,D21>0),$J$8,IF(AND(D21>0,D11=\"On Commencement\"),$J$8,0))","v":0},{"$f":"IF(D21>0,ROUND(E21+F21-G21,8),0)","v":0},{"$f":"IF(I20>0,I20-G21,IF(D21>0,(J8*J9)+J10-G21,0))","v":0},{"$f":"IF(I21>0,SUM(G22:G33),0)","v":0},{"$f":"IF(I21>J21,I21-J21,0)","v":0},{"$f":"IF(I21>0,SUM(F22:F33),0)","v":0},{"$f":"IF(I21>0,SUM(F34:$F$109),0)","v":0},0,null,null,null,null,{"$f":"IF(S20>0,S20+1,IF(G21>0,1,0))","v":0},0,{"$f":"U20+T21","v":0}]
[null,null,null,{"$f":"IF(AND(J12>0,D21>0),EOMONTH(D21,1),IF(MONTH($J$12)=3,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=6,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=9,EOMONTH($J$12,0),0)+IF(MONTH($J$12)=12,EOMONTH($J$12,0),0))","v":"00:00:00"},{"$f":"IF(H21>0,H21,IF(D22>0,$J$7,0))","v":0},{"$f":"IF(AND(E22>0,E21>0),E22*$F$13,0)","v":0},{"$f":"IF(D21>0,$J$8,IF(AND(D22>0,$D$11=\"On Commencement\"),$J$8,0))","v":0},{"$f":"IF(D22>0,ROUND(E22+F22-G22,8),0)","v":0},{"$f":"IF(J12>0,IF(I21>0,I21-G22,(J8*J9)+J10-G22),0)","v":0},0,0,{"$f":"SUM(F23:F34)","v":0},{"$f":"IF(I22>0,SUM(F35:$F$109),0)","v":0},0,null,null,null,null,{"$f":"IF(S21>0,S21+1,IF(G22>0,1,0))","v":0},0,{"$f":"U21+T22","v":0}]
[null,null,null,{"$f":"IF($J$12>0,IF(S23<=$J$9+IF($J$10>0,1,0),EOMONTH(D22,1),0),0)","v":"00:00:00"},{"$f":"IF(AND(H22>0,D23>0),H22,0)","v":0},{"$f":"IF(AND(E23>0,S23<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E23*$F$13,0)","v":0},{"$f":"IF($J$12>0,IF(S23<=$J$9,$J$8,0)+IF(S23=$J$9+1,$J$10,0),0)","v":0},{"$f":"IF(D23>0,ROUND(E23+F23-G23,8),0)","v":0},{"$f":"ROUND(I22-G23,2)","v":0},0,0,0,{"$f":"IF(I23>0,SUM(F36:$F$109),0)","v":0},0,null,null,null,null,{"$f":"IF($J$12>0,S22+1,0)","v":0},0,0,{"$f":"IF(D23<>0,0,\"blank\")","v":"blank"}]
[null,null,null,"00:00:00",{"$f":"IF(AND(H23>0,D24>0),H23,0)","v":0},0,0,{"$f":"IF(D24>0,ROUND(E24+F24-G24,8),0)","v":0},{"$f":"ROUND(I23-G24,2)","v":0},0,0,0,{"$f":"IF(I24>0,SUM(F37:$F$109),0)","v":0},0,null,null,null,null,0,0,0,{"$f":"IF(D24<>0,0,\"blank\")","v":"blank"}]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I25>0,SUM(F38:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I26>0,SUM(F39:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I27>0,SUM(F40:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I28>0,SUM(F41:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I29>0,SUM(F42:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I30>0,SUM(F43:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I31>0,SUM(F44:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I32>0,SUM(F45:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I33>0,SUM(F46:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I34>0,SUM(F47:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I35>0,SUM(F48:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I36>0,SUM(F49:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I37>0,SUM(F50:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I38>0,SUM(F51:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I39>0,SUM(F52:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I40>0,SUM(F53:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I41>0,SUM(F54:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I42>0,SUM(F55:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I43>0,SUM(F56:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I44>0,SUM(F57:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I45>0,SUM(F58:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I46>0,SUM(F59:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I47>0,SUM(F60:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I48>0,SUM(F61:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I49>0,SUM(F62:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I50>0,SUM(F63:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I51>0,SUM(F64:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I52>0,SUM(F65:$F$109),0)","v":0},{"$f":"T52","v":0},null,null,null,null,0,{"$f":"IF(AND(S52=1,$J$11<=$V$5),$J$11,IF(AND(S52>0,$J$11>$V$5,S52<=MIN($J$9,$V$6)),$J$11/MIN($J$9,$V$6),0))","v":0},0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I53>0,SUM(F66:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,{"$f":"SUM(F55:F66)","v":0},{"$f":"IF(I54>0,SUM(F67:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,{"$f":"IF($J$12>0,IF(S55<=$J$9+IF($J$10>0,1,0),EOMONTH(D54,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(E55>0,S55<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E55*$F$13,0)","v":0},{"$f":"IF($J$12>0,IF(S55<=$J$9,$J$8,0)+IF(S55=$J$9+1,$J$10,0),0)","v":0},0,0,0,0,0,{"$f":"IF(I55>0,SUM(F68:$F$109),0)","v":0},0,null,null,null,null,{"$f":"IF($J$12>0,S54+1,0)","v":0},0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I56>0,SUM(F69:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I57>0,SUM(F70:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I58>0,SUM(F71:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I59>0,SUM(F72:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I60>0,SUM(F73:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I61>0,SUM(F74:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I62>0,SUM(F75:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I63>0,SUM(F76:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I64>0,SUM(F77:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I65>0,SUM(F78:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I66>0,SUM(F79:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I67>0,SUM(F80:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I68>0,SUM(F81:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I69>0,SUM(F82:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I70>0,SUM(F83:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I71>0,SUM(F84:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I72>0,SUM(F85:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I73>0,SUM(F86:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I74>0,SUM(F87:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I75>0,SUM(F88:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I76>0,SUM(F89:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I77>0,SUM(F90:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I78>0,SUM(F91:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I79>0,SUM(F92:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I80>0,SUM(F93:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I81>0,SUM(F94:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I82>0,SUM(F95:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I83>0,SUM(F96:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I84>0,SUM(F97:$F$109),0)","v":0},{"$f":"T84","v":0},null,null,null,null,0,{"$f":"IF(AND(S84=1,$J$11<=$V$5),$J$11,IF(AND(S84>0,$J$11>$V$5,S84<=MIN($J$9,$V$6)),$J$11/MIN($J$9,$V$6),0))","v":0},0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I85>0,SUM(G86:G97),0)","v":0},0,0,{"$f":"IF(I85>0,SUM(F98:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",{"$f":"IF(AND(H85>0,D86>0),H85,0)","v":0},0,0,{"$f":"IF(D86>0,ROUND(E86+F86-G86,8),0)","v":0},0,0,{"$f":"IF(I86>J86,I86-J86,0)","v":0},0,{"$f":"IF(I86>0,SUM(F99:$F$109),0)","v":0},0,null,null,null,null,0,0,{"$f":"U85+T86","v":0},"blank"]
[null,null,null,{"$f":"IF($J$12>0,IF(S87<=$J$9+IF($J$10>0,1,0),EOMONTH(D86,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(E87>0,S87<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E87*$F$13,0)","v":0},{"$f":"IF($J$12>0,IF(S87<=$J$9,$J$8,0)+IF(S87=$J$9+1,$J$10,0),0)","v":0},0,0,0,0,0,{"$f":"IF(I87>0,SUM(F100:$F$109),0)","v":0},0,null,null,null,null,{"$f":"IF($J$12>0,S86+1,0)","v":0},0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,{"$f":"ROUND(I87-G88,2)","v":0},0,0,0,{"$f":"IF(I88>0,SUM(F101:$F$109),0)","v":0},0,null,null,null,null,0,0,0,{"$f":"IF(D88<>0,0,\"blank\")","v":"blank"}]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I89>0,SUM(F102:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I90>0,SUM(F103:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I91>0,SUM(F104:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I92>0,SUM(F105:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I93>0,SUM(F106:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I94>0,SUM(F107:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I95>0,SUM(F108:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I96>0,SUM(F109:$F$109),0)","v":0},0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,{"$f":"SUM(F98:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I98>0,SUM(G99:G109),0)","v":0},0,{"$f":"SUM(F99:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I99>0,SUM(G100:G109),0)","v":0},0,{"$f":"SUM(F100:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I100>0,SUM(G101:G109),0)","v":0},0,{"$f":"SUM(F101:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I101>0,SUM(G102:G109),0)","v":0},0,{"$f":"SUM(F102:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I102>0,SUM(G103:G109),0)","v":0},0,{"$f":"SUM(F103:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I103>0,SUM(G104:G109),0)","v":0},0,{"$f":"SUM(F104:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I104>0,SUM(G105:G109),0)","v":0},0,{"$f":"SUM(F105:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I105>0,SUM(G106:G109),0)","v":0},0,{"$f":"SUM(F106:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I106>0,SUM(G107:G109),0)","v":0},0,{"$f":"SUM(F107:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I107>0,SUM(G108:G109),0)","v":0},0,{"$f":"SUM(F108:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I108>0,SUM(G109:G109),0)","v":0},0,{"$f":"SUM(F109:F109)","v":0},null,0,null,null,null,null,0,0,0,"blank"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0,0,0,"blank"]
[null,null,null,"TOTALS",{"$f":"J7","v":0},{"$f":"SUM(F20:F109)","v":0},{"$f":"SUM(G20:G109)","v":0},{"$f":"\"0 \"","v":"0 "},null,null,null,null,null,{"$f":"SUM(N20:N109)","v":0},null,null,null,null,{"$f":"SUM(S20:S109)","v":0},{"$f":"SUM(T20:T109)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"blank\"","v":"blank"}]

{"sheet":"Journal Worksheet","index":1,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,2,35,4],[35,7,35,9],[13,2,13,4],[13,7,13,9],[13,12,13,14],[24,2,24,4],[24,7,24,9],[24,12,24,14]]}
[]
[null,null,"Hire Purchase Journal Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Hire Purchase'!L1","v":"Client Name"}]
[null,null,{"$f":"'Hire Purchase'!D2","v":"Loan Commencing During the Year Ended 30 June 2023"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Prepared by \",'Hire Purchase'!L2)","v":"Prepared by Preparer Name"}]
[]
[null,null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(YearEnd,\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2023"},"Schedule","Ledger","Journal",null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(EOMONTH(YearEnd,12),\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2024"},"Schedule","Ledger","Journal",null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(EOMONTH(YearEnd,24),\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2025"},"Schedule","Ledger","Journal"]
[null,null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M8","v":0},null,{"$f":"D6-E6","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M9","v":0},null,{"$f":"I6-J6","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M10","v":0},null,{"$f":"N6-O6","v":0}]
[null,null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"D7-E7","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"I7-J7","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"N7-O7","v":0}]
[null,null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"D8-E8","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"I8-J8","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"N8-O8","v":0}]
[null,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,8,FALSE),0)","v":0},null,0]
[null,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,10,FALSE),0)","v":0},null,0]
[null,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N8","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N9","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N10","v":0},null,0]
[null,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0]
[null,null,"Borrowing costs written off",{"$f":"-D11","v":0},null,0,null,"Borrowing costs written off",{"$f":"D13-I11","v":0},null,0,null,"Borrowing costs written off",{"$f":"I13-N11","v":0},null,0]
[null,null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(F6:F13)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(K6:K13)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(P6:P13)","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(EOMONTH(YearEnd,36),\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2026"},"Schedule","Ledger","Journal",null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(EOMONTH(YearEnd,48),\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2027"},"Schedule","Ledger","Journal",null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(EOMONTH(YearEnd,60),\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2028"},"Schedule","Ledger","Journal"]
[null,null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M11","v":0},null,{"$f":"D17-E17","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M12","v":0},null,{"$f":"I17-J17","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M13","v":0},null,{"$f":"N17-O17","v":0}]
[null,null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"D18-E18","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"I18-J18","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"N18-O18","v":0}]
[null,null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"D19-E19","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"I19-J19","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"N19-O19","v":0}]
[null,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,8,FALSE),0)","v":0},null,0]
[null,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,10,FALSE),0)","v":0},null,0]
[null,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N11","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N12","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N13","v":0},null,0]
[null,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0]
[null,null,"Borrowing costs written off",{"$f":"N13-D22","v":0},null,0,null,"Borrowing costs written off",{"$f":"D24-I22","v":0},null,0,null,"Borrowing costs written off",{"$f":"I24-N22","v":0},null,0]
[null,null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(F17:F24)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(K17:K24)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(P17:P24)","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(EOMONTH(YearEnd,72),\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2029"},"Schedule","Ledger","Journal",null,{"$f":"CONCATENATE(\"Year Ended \",TEXT(EOMONTH(YearEnd,84),\"dd mmm yyyy\"))","v":"Year Ended 30 Jun 2030"},"Schedule","Ledger","Journal"]
[null,null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M14","v":0},null,{"$f":"D28-E28","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!M15","v":0},null,{"$f":"I28-J28","v":0}]
[null,null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"D29-E29","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"I29-J29","v":0}]
[null,null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"D30-E30","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"I30-J30","v":0}]
[null,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,8,FALSE),0)","v":0},null,0]
[null,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,10,FALSE),0)","v":0},null,0]
[null,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N14","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!N15","v":0},null,0]
[null,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$J$11","v":0},null,0]
[null,null,"Borrowing costs written off",{"$f":"N24-D33","v":0},null,0,null,"Borrowing costs written off",{"$f":"D35-I33","v":0},null,0]
[null,null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(F28:F35)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(K28:K35)","v":0}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}