{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["FPA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"FPA","index":0,"n_rows":68,"n_cols":17,"rows_kept":68,"cut":false,"hidden":false,"merged":[[13,2,13,5],[13,6,13,12],[1,9,1,12],[2,9,2,12]]}
[]
[null,null,"Fixed Price Agreement (FPA)",null,null,null,null,null,null,"Client Name",null,null,null,null,null,null,"HIDE"]
[null,null,"Payments Commencing During the Year Ended 30 June 2017",null,null,null,null,null,null,"Preparer Name"]
[]
[null,null,null,null,null,null,"Notes",null,null,null,null,null,null,null,null,null,"Payment "]
[null,null,"Payment Frequency","Select",null,null,null,null,null,null,null,null,null,null,null,null,"Frequency"]
[null,null,"Date of First Payment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select"]
[null,null,"Number of Payments",null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly"]
[null,null,"Payment Amount (incl GST)",{"$f":"I68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Fortnightly"]
[null,null,"Date of Last Payment",{"$f":"IF(AND(D6<>\"Select\",D9>0),IF(D6=\"Select\",\"\",IF(D6=\"Weekly\",D7+((D8-1)*7),0)+IF(D6=\"Fortnightly\",D7+((D8-1)*14),0)+IF(D6=\"Monthly\",EDATE(D7,D8-1),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Monthly"]
[null,null,"FPA Period Ends",{"$f":"IF(AND(D6<>\"Select\",D7>0,D8>0),IF(D6<>\"Select\",IF(D6=\"Weekly\",D10+6,IF(D6=\"Fortnightly\",D10+13,IF(D6=\"Monthly\",EDATE(D10,1)-1))),\"\"),\"\")","v":""}]
[]
[]
[null,null,"Services to be Provided During the Agreement Period",null,null,null,"Calculation of Fees"]
[]
[null,null,"Job","Year","Qty","Entity Name","Year of Last Fee","Amount of Last Fee","% Markup Last Fee","Or Manual Calculation","Fixed Fee Per Unit","Times Qty","Fee For Agreement"]
[null,null,"Annual Financial Report & Tax Return",null,null,null,null,null,null,null,{"$f":"IF(J17>0,J17,IF(H17<>0,ROUNDUP(H17*(1+I17),-1),0))","v":0},{"$f":"IF(E17<>0,E17,IF(K17>0,1,0))","v":0},{"$f":"K17*L17","v":0}]
[null,null,"Annual Financial Report & Tax Return",null,null,null,null,null,null,null,0,0,{"$f":"K18*L18","v":0},null,null,null,{"$f":"IF(OR(M18<>0,F18<>0),0,\"blank\")","v":"blank"}]
[null,null,"Annual Financial Report & Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Annual Financial Report & Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Annual Financial Report & Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Quarterly Management Accounts",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Quarterly Management Accounts",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Monthly Management Accounts",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Monthly Management Accounts",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Income Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Income Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Income Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Income Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Income Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"FBT Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"FBT Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Payroll Tax Return",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Quarterly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Quarterly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Quarterly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Quarterly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Quarterly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Monthly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Monthly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Monthly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Monthly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Monthly Activity Statements ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Taxable Payments Annual Report",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"ASIC Annual Review ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"ASIC Annual Review ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"ASIC Annual Review ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Long Service Leave Certificate",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Bookkeeping ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Visits/Meetings ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Training ",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"Consulting",null,null,null,null,null,null,null,0,0,0,null,null,null,"blank"]
[null,null,"XERO Fee - Ledger",null,null,null,null,null,null,4.54,4.54,1,4.54,null,null,null,0]
[null,null,"XERO Fee - Cashbook",null,null,null,null,null,null,9.09,9.09,1,9.09,null,null,null,0]
[null,null,"XERO Fee - GST Cashbook ",null,null,null,null,null,null,17.27,17.27,1,17.27,null,null,null,0]
[null,null,"XERO Fee - Starter",null,null,null,null,null,null,22.72,22.72,1,22.72,null,null,null,0]
[null,null,"XERO Fee - Standard ",null,null,null,null,null,null,45.45,45.45,1,45.45,null,null,null,0]
[null,null,"XERO Fee - Premium 5",null,null,null,null,null,null,54.54,54.54,1,54.54,null,null,null,0]
[null,null,"XERO Fee - Premium 10",null,null,null,null,null,null,63.63,63.63,1,63.63,null,null,null,0]
[null,null,"XERO Fee - Premium 20",null,null,null,null,null,null,72.72,72.72,1,72.72,null,null,null,0]
[null,null,"XERO Fee - Premium 50",null,null,null,null,null,null,81.81,81.81,1,81.81,null,null,null,0]
[null,null,"XERO Fee - Premium 100",null,null,null,null,null,null,90.9,90.9,1,90.9]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M17:M62)","v":462.66999999999996}]
[null,null,null,null,null,"Summary Fees","GST Excl","Add GST","GST Incl"]
[null,null,null,null,null,"Total Fees",{"$f":"M64","v":462.66999999999996},{"$f":"ROUND(G66*0.1,2)","v":46.27},{"$f":"G66+H66","v":508.93999999999994}]
[null,null,null,null,null,"Divided by the Number of Payments",{"$f":"D8","v":0},{"$f":"G67","v":0},{"$f":"H67","v":0}]
[null,null,null,null,null,"Payment Amount",{"$f":"IF(G67>0,G66/G67,0)","v":0},{"$f":"IF(H67>0,ROUND(H66/H67,2),0)","v":0},{"$f":"G68+H68","v":0},null,null,null,null,null,null,null,{"$f":"IF(#REF!<>0,0,\"blank\")","v":{"$error":"#REF!"}}]