{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","Help","Cashflow","Summary","DSCoA","Working"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":84,"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":"Cover","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[44,1,47,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Dairy Cash Budgeting tool"]
[]
[]
[null,null,null,{"$f":"Cashflow!R14","v":"2026/27"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Published by Dairy Australia Limited."]
[null,"This is a reference tool to assist in the decision making process. Whilst all reasonable efforts have been taken to ensure the accuracy of the Dairy Cash Budgeting tool, use of the information contained herein is at one's own risk. To the fullest extent permitted by Australian law, Dairy Australia disclaims all liability for any losses, costs, damages and the like sustained or incurred as a result of the use of or reliance upon the information contained herein, including, without limitation, liability stemming from reliance upon any part which may contain inadvertent errors, whether typographical or otherwise, or ommisions of any kind."]
[]
[]
[]
[null,"© Dairy Australia Limited 2025. All right reserved."]

{"sheet":"Help","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,1,7,16],[12,4,12,16],[30,8,36,16],[39,4,43,16],[14,4,14,16],[19,4,20,16],[22,4,25,16],[27,4,28,16],[16,4,18,16],[8,1,8,16]]}
[]
[null,"Dairy Cash Budgeting tool"]
[null,{"$f":"Cashflow!B17","v":"Version 12 July 2026"}]
[]
[]
[]
[]
[null,"The Dairy Australia Dairy Cash Budgeting tool is designed to help dairy farmers manage and plan their farm finances more effectively, enabling you to forecast monthly income and expenses and manage seasonal cashflow requirements. It allows you to create a realistic budget for your farm. Where possible, it is preferable to use the monthly income and expenses from your previous financial year as the starting point for a budget for the coming financial year. Then make adjustments to the relevant income and expense items that you envisage will change in the coming year. This will likely require updates to your milk income based on the expected milk production and milk price. A review of all the income and expense items would be ideal but you may elect to leave some expenses as per the previous financial year and update the key areas across herd, shed and feed costs to ensure they reflect what you are expecting for the year ahead.\nThe first column of the Cashflow tab is where you can enter your actual figures from the previous financial year to use as a reference and comparison for the budget."]
[null,"This tool requires Excel macros to be enabled. It is recommended that you do not open the spreadsheet directly from an email message as macros may then be disabled automatically. First copy the spreadsheet to your Desktop or other documents folder and open it from that location."]
[]
[null,"Sheet functions"]
[]
[null,null,null,null,"Cells that the user can enter values into are coloured light blue or light green."]
[]
[null,null,null,null,"The Goto drop down menu provides a fast way to jump to another section of the sheet. "]
[]
[null,null,null,null,"The L and U buttons lock and unlock the sheets. It is recommended you keep the sheets locked so changes are not inadvertently made to the cell contents."]
[]
[]
[null,null,null,null,"The +/- button toggles the visiblity of the subgroup controls down the left of the sheet. This allows you to customise the visibility of individual sections (see below).\nThe H button toggles the visibility of the coloumn and row headers."]
[]
[]
[null,null,null,null,"The detail of the entire sheet can be decreased and increased by hiding and showing subsections of the sheet.\nThe 'Level 2' button shows the main sections and subsection headings and the 'Level 3' button displays all three levels of detail. When level 3 accounts are visible the level 2 parent calculates the sum of the values. When the level 3 detail is hidden values are entered directly into the level 2 accounts."]
[]
[]
[]
[]
[null,null,null,null,"The L2 and L3 buttons work in the same manner as the Level buttons but only adjust the visibilty of that section of the sheet."]
[]
[]
[null,null,null,null,null,null,null,null,"The level of detail within a section can also be adjusted individually using the group controls in the left margin of the sheet when they are visible (see +/- button). In the figure to the left the full detail of the Herd Costs section is visible. By clicking on the left most squares with a - in them each of the three subsections, AI & Herd Test, Animal Health and/or Calf Rearing can be contracted back. If only the section heading is needed the left most group control can be clicked to hide all the detail for the Herd Costs section."]

{"sheet":"Cashflow","index":2,"n_rows":281,"n_cols":25,"rows_kept":281,"cut":false,"hidden":false,"merged":[[1,18,12,19],[96,2,96,3],[191,1,191,2],[193,1,193,2],[280,0,280,19]]}
[null,null,null,null,null,"Year"]
[null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Milk Production"]
[]
[null,null,null,null,"Annual","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Annual"]
[null,null,null,null,{"$f":"YEAR(F15-1)","v":2026},{"$f":"YEAR(F15)","v":2026},2026,2026,2026,2026,2026,2027,2027,2027,2027,2027,2027,{"$f":"Q5","v":2027}]
[null,null,null,null,{"$f":"IF(E8<=6,E5-1,E5)","v":2025},{"$f":"IF(F8<=6,F5-1,F5)","v":2026},{"$f":"IF(G8<=6,G5-1,G5)","v":2026},2026,2026,2026,2026,2026,2026,2026,2026,2026,2026,{"$f":"Q6","v":2026}]
[null,null,null,null,null,{"$f":"VLOOKUP(F8,Quarters,2,FALSE)","v":1},1,1,2,2,2,3,3,3,4,4,4]
[null,null,null,null,null,{"$f":"MONTH(F15)","v":7},8,9,10,11,12,1,2,3,4,5,6]
[null,null,null,null,365,{"$f":"DAY(DATE(YEAR(F15),MONTH(F15)+1,1)-1)","v":31},31,30,31,30,31,31,28,31,30,31,30,365]
[null,null,null,null,null,{"$f":"TRIM(TEXT(F5,\"####\"))&TRIM(TEXT(F8,\"0#\"))","v":"202607"},"202608","202609","202610","202611","202612","202701","202702","202703","202704","202705","202706"]
[null,null,null,null,{"$f":"E16","v":0},{"$f":"F16","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"R16","v":"Budget"}]
[]
[]
[null,null,null,null,{"$f":"TRIM(TEXT(E6,\"####\")) & \"/\" & RIGHT(TRIM(TEXT(E6+1,\"####\")),2)","v":"2025/26"},{"$f":"F2","v":2026},{"$f":"YEAR(G15)","v":2026},2026,2026,2026,2026,{"$f":"YEAR(L15)","v":2027},2027,2027,2027,2027,2027,{"$f":"TRIM(TEXT(R6,\"####\")) & \"/\" & RIGHT(TRIM(TEXT(R6+1,\"####\")),2)","v":"2026/27"},"(litres)","(kg MS)"]
[null,null,null,null,"Actuals",{"$f":"DATEVALUE(\"15/07/\"&TRIM(TEXT($F$14,\"####\")))","v":"2026-07-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(F15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(F15),\"####\")))","v":"2026-08-15"},"2026-09-15","2026-10-15","2026-11-15","2026-12-15",{"$f":"DATEVALUE(\"15/01/\"&TRIM(TEXT(YEAR(K15)+1,\"####\")))","v":"2027-01-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(L15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(L15),\"####\")))","v":"2027-02-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(M15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(M15),\"####\")))","v":"2027-03-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(N15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(N15),\"####\")))","v":"2027-04-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(O15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(O15),\"####\")))","v":"2027-05-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(P15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(P15),\"####\")))","v":"2027-06-15"},"Annual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget","Fat (%)","Protein (%)"]
[null,{"$f":"GetVersion()","v":"Version 12 July 2026"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2000000000000003E-2,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c/litre","$/kg MS"]
[null,"Milk income (Current year)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F19:Q19)","v":0},{"$f":"IF(AND(R19>0,ISNUMBER($S$15),$S$15>0),R19/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R19>0,ISNUMBER($T$15),$T$15>0),R19/$T$15,\"-\")","v":"-"}]
[null,"Milk income (Retrospective/step ups)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F20:Q20)","v":0},"-","-",null,null,null,null," "]
[null,"Livestock sales",null,null,{"$f":"SUM(E22:E24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Calf sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Cull sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other livestock sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Feed sales",null,null,{"$f":"SUM(E26:E28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Hay sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Silage sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other feed sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Water sales",null,null,{"$f":"SUM(E30:E31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Temporary water sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other water sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other farm income",null,null,{"$f":"SUM(E33:E43)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Interest income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Contracting income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Milk company dividends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Incentives",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Rebates - fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Rebates - fertiliser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Rebates  - other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Government payments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Insurance recoveries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other farm income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Income",null,null,{"$f":"SUM(E32,E29,E25,E21,E20,E19)","v":0},{"$f":"SUM(F32,F29,F25,F21,F20,F19)","v":0},{"$f":"SUM(G32,G29,G25,G21,G20,G19)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"AI and herd test ",null,null,{"$f":"SUM(E47:E49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F46:Q46)","v":0},{"$f":"IF(AND(R46>0,ISNUMBER($S$15),$S$15>0),R46/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R46>0,ISNUMBER($T$15),$T$15>0),R46/$T$15,\"-\")","v":"-"}]
[null,null,"AI/semen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Herd test",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other breeding costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Animal health",null,null,{"$f":"SUM(E51:E52)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Drugs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Veterinary fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Calf rearing",null,null,{"$f":"SUM(E54:E57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Calf feed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Milk powder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Bedding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other calf rearing costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other herd costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Herd costs",null,null,{"$f":"SUM(E58,E53,E50,E46)","v":0},{"$f":"SUM(F58,F53,F50,F46)","v":0},{"$f":"SUM(G58,G53,G50,G46)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Shed power",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F61:Q61)","v":0},{"$f":"IF(AND(R61>0,ISNUMBER($S$15),$S$15>0),R61/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R61>0,ISNUMBER($T$15),$T$15>0),R61/$T$15,\"-\")","v":"-"}]
[null,"Dairy supplies",null,null,{"$f":"SUM(E63:E64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Dairy consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Rubberware",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other shed costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Shed costs",null,null,{"$f":"SUM(E61,E62,E65)","v":0},{"$f":"SUM(F61,F62,F65)","v":0},{"$f":"SUM(G61,G62,G65)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Fertiliser",null,null,{"$f":"SUM(E69:E74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F68:Q68)","v":0},{"$f":"IF(AND(R68>0,ISNUMBER($S$15),$S$15>0),R68/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R68>0,ISNUMBER($T$15),$T$15>0),R68/$T$15,\"-\")","v":"-"}]
[null,null,"PKS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Urea",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Nitrogen blends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lime & gypsum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Effluent spreading/disposal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other fertiliser costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Irrigation",null,null,{"$f":"SUM(E76:E80)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Water authority rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"TWE purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Pumping costs  - electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Pumping costs  - diesel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other irrigation costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Hay and silage making",null,null,{"$f":"SUM(E82:E85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Hay making",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Silage making",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Crop harvesting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other hay & silage making costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Pasture and cropping",null,null,{"$f":"SUM(E87:E89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Seed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Weed & pest control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other pasture & cropping costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Fuel and oil",null,null,{"$f":"SUM(E91:E94)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Diesel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Unleaded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Oil/Grease",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Home grown feed costs",null,null,{"$f":"SUM(E90,E86,E81,E75,E68)","v":0},{"$f":"SUM(F90,F86,F81,F75,F68)","v":0},{"$f":"SUM(G90,G86,G81,G75,G68)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Concentrates",null,null,{"$f":"SUM(E98:E103)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F97:Q97)","v":0},{"$f":"IF(AND(R97>0,ISNUMBER($S$15),$S$15>0),R97/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R97>0,ISNUMBER($T$15),$T$15>0),R97/$T$15,\"-\")","v":"-"}]
[null,null,"Concentrate 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Concentrate 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Concentrate 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Concentrate 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Concentrate 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Concentrate 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Purchased fodder",null,null,{"$f":"SUM(E105:E110)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Purchased fodder 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Purchased fodder 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Purchased fodder 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Purchased fodder 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Purchased fodder 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Purchased fodder 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Byproducts",null,null,{"$f":"SUM(E112:E115)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Byproduct 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Byproduct 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Byproduct 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Byproduct 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other puchased feeds",null,null,{"$f":"SUM(E117:E120)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Other purchased feed 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other purchased feed 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other purchased feed 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other purchased feed 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Agistment",null,null,{"$f":"SUM(E122:E125)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Milker agistment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Dry cow agistment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Replacement agistment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other agistment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other feed costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Purchased feed costs",null,null,{"$f":"SUM(E126,E121,E116,E111,E104,E97)","v":0},{"$f":"SUM(F126,F121,F116,F111,F104,F97)","v":0},{"$f":"SUM(G126,G121,G116,G111,G104,G97)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Variable costs",null,null,{"$f":"SUM(E59,E66,E95,E127)","v":0},{"$f":"SUM(F59,F66,F95,F127)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F129:Q129)","v":0},{"$f":"IF(AND(R129>0,ISNUMBER($S$15),$S$15>0),R129/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R129>0,ISNUMBER($T$15),$T$15>0),R129/$T$15,\"-\")","v":"-"}]
[]
[null,"Wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F131:Q131)","v":0},{"$f":"IF(AND(R131>0,ISNUMBER($S$15),$S$15>0),R131/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R131>0,ISNUMBER($T$15),$T$15>0),R131/$T$15,\"-\")","v":"-"}]
[null,"Sharefarmer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Contract labour/relief milker",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Protective clothing ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Staff amenities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Training & development",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Superannuation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Workcover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Employed labour costs",null,null,{"$f":"SUM(E131:E138)","v":0},{"$f":"SUM(F131:F138)","v":0},{"$f":"SUM(G131:G138)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Repairs & maintenance buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F141:Q141)","v":0},{"$f":"IF(AND(R141>0,ISNUMBER($S$15),$S$15>0),R141/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R141>0,ISNUMBER($T$15),$T$15>0),R141/$T$15,\"-\")","v":"-"}]
[null,"Repairs & maintenance fencing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs & maintenance houses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs & maintenance irrigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs & maintenance dairy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs & maintenance plant & equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs & maintenance water supply",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs & maintenance tracks and laneways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs & maintenance replacement tools",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Repairs and maintenance costs",null,null,{"$f":"SUM(E141:E149)","v":0},{"$f":"SUM(F141:F149)","v":0},{"$f":"SUM(G141:G149)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Administration",null,null,{"$f":"SUM(E153:E167)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F152:Q152)","v":0},{"$f":"IF(AND(R152>0,ISNUMBER($S$15),$S$15>0),R152/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R152>0,ISNUMBER($T$15),$T$15>0),R152/$T$15,\"-\")","v":"-"}]
[null,null,"Accounting fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Advertising",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Bank fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Borrowing costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Computer expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Consultants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Donations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Filing fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Internet costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Legal fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Light & power",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Printing, postage & stationery ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Subscriptions & journals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Telephone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Travel & accomodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Milk selling expenses",null,null,{"$f":"SUM(E169:E170)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Milk levies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Milk volume charge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Motor vehicle expenses",null,null,{"$f":"SUM(E172:E175)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Motor vehicle fuel & oil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Motor vehicle R&M servicing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Motor vehicle registrations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Motor vehicle insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Miscellaneous expenses",null,null,{"$f":"SUM(E177:E187)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Cleaning & waste disposal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Dog keep",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Farm insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"General expenses (misc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"General freight & cartage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Hire of plant & equip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Industry levies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Livestock selling expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Registration & licences",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Shelter trees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other overheads costs",null,null,{"$f":"SUM(E176,E171,E168,E152)","v":0},{"$f":"SUM(F176,F171,F168,F152)","v":0},{"$f":"SUM(G176,G171,G168,G152)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Overhead costs",null,null,{"$f":"SUM(E188,E150,E139)","v":0},{"$f":"SUM(F188,F150,F139)","v":0},{"$f":"SUM(G188,G150,G139)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(R190>0,ISNUMBER($S$15),$S$15>0),R190/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R190>0,ISNUMBER($T$15),$T$15>0),R190/$T$15,\"-\")","v":"-"}]
[]
[null,"Farm working expenses (FWE)\n(Variable plus cash overhead costs)",null,null,{"$f":"E190+E129","v":0},{"$f":"F190+F129","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F192:Q192)","v":0},{"$f":"IF(AND(R192>0,ISNUMBER($S$15),$S$15>0),R192/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R192>0,ISNUMBER($T$15),$T$15>0),R192/$T$15,\"-\")","v":"-"}]
[]
[null,"Farm operating surplus\n(Total cash income minus Farm working expenses)",null,null,{"$f":"E44-E192","v":0},{"$f":"F44-F192","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F194:Q194)","v":0},{"$f":"IF(AND(R194>0,ISNUMBER($S$15),$S$15>0),R194/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R194>0,ISNUMBER($T$15),$T$15>0),R194/$T$15,\"-\")","v":"-"}]
[]
[null,"Interest",null,null,{"$f":"SUM(E197:E208)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F196:Q196)","v":0},{"$f":"IF(AND(R196>0,ISNUMBER($S$15),$S$15>0),R196/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R196>0,ISNUMBER($T$15),$T$15>0),R196/$T$15,\"-\")","v":"-"}]
[null,null,"Interest on loan 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on loan 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Interest on overdraft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other interest expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Leases expense",null,null,{"$f":"SUM(E210:E222)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Lease expense plant & equipment 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense plant & equipment 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense plant & equipment 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense plant & equipment 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense livestock 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense livestock 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense livestock 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense livestock 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense land & water 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense land & water 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense land & water 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense land & water 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Lease expense land & water 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Finance costs",null,null,{"$f":"SUM(E209,E196)","v":0},{"$f":"SUM(F209,F196)","v":0},{"$f":"SUM(G209,G196)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Livestock purchases",null,null,{"$f":"SUM(E226:E228)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F225:Q225)","v":0},{"$f":"IF(AND(R225>0,ISNUMBER($S$15),$S$15>0),R225/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R225>0,ISNUMBER($T$15),$T$15>0),R225/$T$15,\"-\")","v":"-"}]
[null,null,"Milker purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Replacement purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Bulls/other purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other capital purchases",null,null,{"$f":"SUM(E230:E239)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Asset improvements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Equipment/machinery purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Asset development",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Land purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Permanent water purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Share purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Other capital purchase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Farm management deposits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Farm management deposits - withdrawals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Capital introduced",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Capital sales",null,null,{"$f":"SUM(E241:E243)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Land sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Permanent water sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Equipment /machinery sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Loan principal repayments",null,null,{"$f":"SUM(E245:E246)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[null,null,"Principal payments  - loans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Principal payments - HP's or CM's",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Capital transactions",null,null,{"$f":"SUM(E244,E240,E229,E225)","v":0},{"$f":"SUM(F244,F240,F229,F225)","v":0},{"$f":"SUM(G244,G240,G229,G225)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"Net farm cashflow",null,null,{"$f":"E194-(E223+E247)","v":0},{"$f":"F194-(F223+F247)","v":0},{"$f":"G194-(G223+G247)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F249:Q249)","v":0},{"$f":"IF(AND(R249>0,ISNUMBER($S$15),$S$15>0),R249/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R249>0,ISNUMBER($T$15),$T$15>0),R249/$T$15,\"-\")","v":"-"}]
[]
[null,"Non-farm wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F251:Q251)","v":0},{"$f":"IF(AND(R251>0,ISNUMBER($S$15),$S$15>0),R251/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R251>0,ISNUMBER($T$15),$T$15>0),R251/$T$15,\"-\")","v":"-"}]
[null,"Non-farm rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(R252>0,ISNUMBER($S$15),$S$15>0),R252/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R252>0,ISNUMBER($T$15),$T$15>0),R252/$T$15,\"-\")","v":"-"}]
[null,"Funds contributed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(R253>0,ISNUMBER($S$15),$S$15>0),R253/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R253>0,ISNUMBER($T$15),$T$15>0),R253/$T$15,\"-\")","v":"-"}]
[null,"Non-farm dividends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(R254>0,ISNUMBER($S$15),$S$15>0),R254/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R254>0,ISNUMBER($T$15),$T$15>0),R254/$T$15,\"-\")","v":"-"}]
[null,"Non farm income",null,null,{"$f":"SUM(E251:E254)","v":0},{"$f":"SUM(F251:F254)","v":0},{"$f":"SUM(G251:G254)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(R255>0,ISNUMBER($S$15),$S$15>0),R255/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R255>0,ISNUMBER($T$15),$T$15>0),R255/$T$15,\"-\")","v":"-"}]
[]
[null,"Drawings 1",null,null,{"$f":"SUM(E258:E263)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F257:Q257)","v":0},{"$f":"IF(AND(R257>0,ISNUMBER($S$15),$S$15>0),R257/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R257>0,ISNUMBER($T$15),$T$15>0),R257/$T$15,\"-\")","v":"-"}]
[null,null,"Drawings - living",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Drawings - education",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Drawings - insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Drawings - medical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Drawings - income tax paid/refunded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,null,"Drawings - superannuation contributions (partners)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Drawings 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Drawings 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Other non farm expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"-","-"]
[null,"Non farm personal expenses",null,null,{"$f":"SUM(E264:E266,E257)","v":0},{"$f":"SUM(F264:F266,F257)","v":0},{"$f":"SUM(G264:G266,G257)","v":0},0,0,0,0,0,0,0,0,0,0,0,"-","-"]
[]
[null,"GST estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F269:Q269)","v":0},{"$f":"IF(AND(R269>0,ISNUMBER($S$15),$S$15>0),R269/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R269>0,ISNUMBER($T$15),$T$15>0),R269/$T$15,\"-\")","v":"-"}]
[null,"PAYG instalments estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(R270>0,ISNUMBER($S$15),$S$15>0),R270/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R270>0,ISNUMBER($T$15),$T$15>0),R270/$T$15,\"-\")","v":"-"}]
[null,"PAYG withheld estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(R271>0,ISNUMBER($S$15),$S$15>0),R271/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R271>0,ISNUMBER($T$15),$T$15>0),R271/$T$15,\"-\")","v":"-"}]
[null,"Income tax estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(R272>0,ISNUMBER($S$15),$S$15>0),R272/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R272>0,ISNUMBER($T$15),$T$15>0),R272/$T$15,\"-\")","v":"-"}]
[null,"Tax expenses",null,null,{"$f":"SUM(E269:E272)","v":0},{"$f":"SUM(F269:F272)","v":0},{"$f":"SUM(G269:G272)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(R273>0,ISNUMBER($S$15),$S$15>0),R273/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R273>0,ISNUMBER($T$15),$T$15>0),R273/$T$15,\"-\")","v":"-"}]
[]
[null,"Net non-farm income and tax",null,null,{"$f":"E255-E267-E273","v":0},{"$f":"F255-F267-F273","v":0},{"$f":"G255-G267-G273","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R255,R267,R273)","v":0},{"$f":"IF(AND(R275>0,ISNUMBER($S$15),$S$15>0),R275/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R275>0,ISNUMBER($T$15),$T$15>0),R275/$T$15,\"-\")","v":"-"}]
[]
[null,"Net monthly cash flow total",null,null,{"$f":"E249+E275","v":0},{"$f":"F249+F275","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F277:Q277)","v":0},{"$f":"IF(AND(R277>0,ISNUMBER($S$15),$S$15>0),R277/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R277>0,ISNUMBER($T$15),$T$15>0),R277/$T$15,\"-\")","v":"-"}]
[null,null,null,"Opening Balance",null,null,null,null,null,null,null,null,null,null,null,null,"Closing Balance"]
[null,"Cumulative cash flow",null,null,null,{"$f":"F277+D279","v":0},{"$f":"F279+G277","v":0},{"$f":"G279+H277","v":0},{"$f":"H279+I277","v":0},0,0,0,0,0,0,0,0,{"$f":"Q279","v":0},{"$f":"IF(AND(R279>0,ISNUMBER($S$15),$S$15>0),R279/$S$15,\"-\")","v":"-"},{"$f":"IF(AND(R279>0,ISNUMBER($T$15),$T$15>0),R279/$T$15,\"-\")","v":"-"}]
[]
[{"$f":"Cover!B44 & \" \" & Cover!B45 & \" \" & Cover!B49","v":"Published by Dairy Australia Limited. This is a reference tool to assist in the decision making process. Whilst all reasonable efforts have been taken to ensure the accuracy of the Dairy Cash Budgeting tool, use of the information contained herein is at one's own risk. To the fullest extent permitted by Australian law, Dairy Australia disclaims all liability for any losses, costs, damages and the like sustained or incurred as a result of the use of or reliance upon the information contained herein, including, without limitation, liability stemming from reliance upon any part which may contain inadvertent errors, whether typographical or otherwise, or ommisions of any kind. © Dairy Australia Limited 2025. All right reserved."}]

{"sheet":"Summary","index":3,"n_rows":284,"n_cols":12,"rows_kept":284,"cut":false,"hidden":false,"merged":[[198,1,198,2],[200,1,200,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Summary",null,null,null,"Milk solids","Milk","Cows","% Income","Milking area","Total area"]
[null,null,null,null,null,null,"(kg)","(c/litre)",null,null,"(ha)","(ha)"]
[]
[null,null,null,null,null,null,{"$f":"E20","v":0},{"$f":"E19","v":0},{"$f":"IF(ISNUMBER(E21),E21,0)","v":300},null,300,400]
[null,"MILK PRODUCTION"]
[null,"Milk production - litres (l)",null,null,{"$f":"IF(AND(ISNUMBER(MilkLitres), MilkLitres>0),MilkLitres,0)","v":0},null,null,null,{"$f":"IF(AND(I17>0,E19>0,ISNUMBER(I17),ISNUMBER(E19)),E19/I17,0)","v":0},null,{"$f":"IF(AND(E19>0,K17>0,ISNUMBER(E19),ISNUMBER(K17)),E19/K17,0)","v":0},{"$f":"IF(AND(E19>0,L17>0,ISNUMBER(E19),ISNUMBER(L17)),E19/L17,0)","v":0}]
[null,"Milk production - milk solids (kg)",null,null,{"$f":"IF(AND(ISNUMBER(MilkSolids), MilkSolids>0),MilkSolids,0)","v":0},null,{"$f":"IF(AND(G17>0,E19>0,ISNUMBER(G17),ISNUMBER(E17)),1/(E19/G17),0)","v":0},null,{"$f":"IF(I$17>0,$E20/I$17,0)","v":0},null,{"$f":"IF(K$17>0,$E20/K$17,0)","v":0},{"$f":"IF(L$17>0,$E20/L$17,0)","v":0}]
[null,"Cows",null,null,300]
[null,"Butterfat (% m/v)",null,null,{"$f":"IF(AND(ISNUMBER(MilkFat),MilkFat>0), MilkFat,0.42)","v":4.2000000000000003E-2}]
[null,"Protein (% m/v)",null,null,{"$f":"IF(AND(ISNUMBER(MilkProtein),MilkProtein>0), MilkProtein,0.3)","v":0.03}]
[null,"Milk payment equivilent ($/kg MS)",null,null,{"$f":"IF(E20>0,E27/E20,0)","v":0}]
[null,"Milk payment (cpl)",null,null,{"$f":"IF(AND(E27>0,E19>0,ISNUMBER(E27),ISNUMBER(E19)),E27*100/E19,0)","v":0}]
[]
[null,{"$f":"Cashflow!B19","v":"Milk income (Current year)"},null,null,{"$f":"Cashflow!R19","v":0},null,{"$f":"IF(AND(G$17>0,$E27>0),$E27/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E27>0),$E27/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E27>0),$E27/K$17,\"-\")","v":"-"},"-"]
[null,{"$f":"Cashflow!B20","v":"Milk income (Retrospective/step ups)"},null,null,{"$f":"Cashflow!R20","v":0},null,"-","-","-",{"$f":"IF(AND(E$52>0,$E28>0),$E28/E$52,\"-\")","v":"-"},"-","-"]
[null,{"$f":"Cashflow!B21","v":"Livestock sales"},null,null,{"$f":"Cashflow!R21","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C22","v":"Calf sales"},null,{"$f":"Cashflow!R22","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C23","v":"Cull sales"},null,{"$f":"Cashflow!R23","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C24","v":"Other livestock sales"},null,{"$f":"Cashflow!R24","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B25","v":"Feed sales"},null,null,{"$f":"Cashflow!R25","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C26","v":"Hay sales"},null,{"$f":"Cashflow!R26","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C27","v":"Silage sales"},null,{"$f":"Cashflow!R27","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C28","v":"Other feed sales"},null,{"$f":"Cashflow!R28","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B29","v":"Water sales"},null,null,{"$f":"Cashflow!R29","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C30","v":"Temporary water sales"},null,{"$f":"Cashflow!R30","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C31","v":"Other water sales"},null,{"$f":"Cashflow!R31","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B32","v":"Other farm income"},null,null,{"$f":"Cashflow!R32","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C33","v":"Interest income"},null,{"$f":"Cashflow!R33","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C34","v":"Contracting income"},null,{"$f":"Cashflow!R34","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C35","v":"Milk company dividends"},null,{"$f":"Cashflow!R35","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C36","v":"Incentives"},null,{"$f":"Cashflow!R36","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C37","v":"Lease income"},null,{"$f":"Cashflow!R37","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C38","v":"Rebates - fuel"},null,{"$f":"Cashflow!R38","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C39","v":"Rebates - fertiliser"},null,{"$f":"Cashflow!R39","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C40","v":"Rebates  - other"},null,{"$f":"Cashflow!R40","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C41","v":"Government payments"},null,{"$f":"Cashflow!R41","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C42","v":"Insurance recoveries"},null,{"$f":"Cashflow!R42","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C43","v":"Other farm income"},null,{"$f":"Cashflow!R43","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B44","v":"Income"},null,null,{"$f":"Cashflow!R44","v":0},null,"-","-","-",{"$f":"IF(AND(E$52>0,$E52>0),$E52/E$52,\"-\")","v":"-"},"-","-"]
[]
[null,{"$f":"Cashflow!B46","v":"AI and herd test "},null,null,{"$f":"Cashflow!R46","v":0},null,{"$f":"IF(AND(G$17>0,$E54>0),$E54/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E54>0),$E54/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E54>0),$E54/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C47","v":"AI/semen"},null,{"$f":"Cashflow!R47","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C48","v":"Herd test"},null,{"$f":"Cashflow!R48","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C49","v":"Other breeding costs"},null,{"$f":"Cashflow!R49","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B50","v":"Animal health"},null,null,{"$f":"Cashflow!R50","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C51","v":"Drugs"},null,{"$f":"Cashflow!R51","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C52","v":"Veterinary fees"},null,{"$f":"Cashflow!R52","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B53","v":"Calf rearing"},null,null,{"$f":"Cashflow!R53","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C54","v":"Calf feed"},null,{"$f":"Cashflow!R54","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C55","v":"Milk powder"},null,{"$f":"Cashflow!R55","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C56","v":"Bedding"},null,{"$f":"Cashflow!R56","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C57","v":"Other calf rearing costs"},null,{"$f":"Cashflow!R57","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B58","v":"Other herd costs"},null,null,{"$f":"Cashflow!R58","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B59","v":"Herd costs"},null,null,{"$f":"Cashflow!R59","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B61","v":"Shed power"},null,null,{"$f":"Cashflow!R61","v":0},null,{"$f":"IF(AND(G$17>0,$E69>0),$E69/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E69>0),$E69/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E69>0),$E69/K$17,\"-\")","v":"-"},"-"]
[null,{"$f":"Cashflow!B62","v":"Dairy supplies"},null,null,{"$f":"Cashflow!R62","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C63","v":"Dairy consumables"},null,{"$f":"Cashflow!R63","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C64","v":"Rubberware"},null,{"$f":"Cashflow!R64","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B65","v":"Other shed costs"},null,null,{"$f":"Cashflow!R65","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B66","v":"Shed costs"},null,null,{"$f":"Cashflow!R66","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B68","v":"Fertiliser"},null,null,{"$f":"Cashflow!R68","v":0},null,{"$f":"IF(AND(G$17>0,$E76>0),$E76/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E76>0),$E76/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E76>0),$E76/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C69","v":"PKS"},null,{"$f":"Cashflow!R69","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C70","v":"Urea"},null,{"$f":"Cashflow!R70","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C71","v":"Nitrogen blends"},null,{"$f":"Cashflow!R71","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C72","v":"Lime & gypsum"},null,{"$f":"Cashflow!R72","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C73","v":"Effluent spreading/disposal"},null,{"$f":"Cashflow!R73","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C74","v":"Other fertiliser costs"},null,{"$f":"Cashflow!R74","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B75","v":"Irrigation"},null,null,{"$f":"Cashflow!R75","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C76","v":"Water authority rates"},null,{"$f":"Cashflow!R76","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C77","v":"TWE purchases"},null,{"$f":"Cashflow!R77","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C78","v":"Pumping costs  - electricity"},null,{"$f":"Cashflow!R78","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C79","v":"Pumping costs  - diesel"},null,{"$f":"Cashflow!R79","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C80","v":"Other irrigation costs"},null,{"$f":"Cashflow!R80","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B81","v":"Hay and silage making"},null,null,{"$f":"Cashflow!R81","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C82","v":"Hay making"},null,{"$f":"Cashflow!R82","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C83","v":"Silage making"},null,{"$f":"Cashflow!R83","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C84","v":"Crop harvesting"},null,{"$f":"Cashflow!R84","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C85","v":"Other hay & silage making costs"},null,{"$f":"Cashflow!R85","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B86","v":"Pasture and cropping"},null,null,{"$f":"Cashflow!R86","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C87","v":"Seed"},null,{"$f":"Cashflow!R87","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C88","v":"Weed & pest control"},null,{"$f":"Cashflow!R88","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C89","v":"Other pasture & cropping costs"},null,{"$f":"Cashflow!R89","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B90","v":"Fuel and oil"},null,null,{"$f":"Cashflow!R90","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C91","v":"Diesel"},null,{"$f":"Cashflow!R91","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C92","v":"Unleaded"},null,{"$f":"Cashflow!R92","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C93","v":"Gas"},null,{"$f":"Cashflow!R93","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C94","v":"Oil/Grease"},null,{"$f":"Cashflow!R94","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B95","v":"Home grown feed costs"},null,null,{"$f":"Cashflow!R95","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B97","v":"Concentrates"},null,null,{"$f":"Cashflow!R97","v":0},null,{"$f":"IF(AND(G$17>0,$E105>0),$E105/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E105>0),$E105/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E105>0),$E105/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C98","v":"Concentrate 1"},null,{"$f":"Cashflow!R98","v":0},null,"-","-","-",{"$f":"IF(AND(E$52>0,$E106>0),$E106/E$52,\"-\")","v":"-"},"-","-"]
[null,null,{"$f":"Cashflow!C99","v":"Concentrate 2"},null,{"$f":"Cashflow!R99","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C100","v":"Concentrate 3"},null,{"$f":"Cashflow!R100","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C101","v":"Concentrate 4"},null,{"$f":"Cashflow!R101","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C102","v":"Concentrate 5"},null,{"$f":"Cashflow!R102","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C103","v":"Concentrate 6"},null,{"$f":"Cashflow!R103","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B104","v":"Purchased fodder"},null,null,{"$f":"Cashflow!R104","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C105","v":"Purchased fodder 1"},null,{"$f":"Cashflow!R105","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C106","v":"Purchased fodder 2"},null,{"$f":"Cashflow!R106","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C107","v":"Purchased fodder 3"},null,{"$f":"Cashflow!R107","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C108","v":"Purchased fodder 4"},null,{"$f":"Cashflow!R108","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C109","v":"Purchased fodder 5"},null,{"$f":"Cashflow!R109","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C110","v":"Purchased fodder 6"},null,{"$f":"Cashflow!R110","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B111","v":"Byproducts"},null,null,{"$f":"Cashflow!R111","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C112","v":"Byproduct 1"},null,{"$f":"Cashflow!R112","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C113","v":"Byproduct 2"},null,{"$f":"Cashflow!R113","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C114","v":"Byproduct 3"},null,{"$f":"Cashflow!R114","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C115","v":"Byproduct 4"},null,{"$f":"Cashflow!R115","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B116","v":"Other puchased feeds"},null,null,{"$f":"Cashflow!R116","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C117","v":"Other purchased feed 1"},null,{"$f":"Cashflow!R117","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C118","v":"Other purchased feed 2"},null,{"$f":"Cashflow!R118","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C119","v":"Other purchased feed 3"},null,{"$f":"Cashflow!R119","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C120","v":"Other purchased feed 4"},null,{"$f":"Cashflow!R120","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B121","v":"Agistment"},null,null,{"$f":"Cashflow!R121","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C122","v":"Milker agistment"},null,{"$f":"Cashflow!R122","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C123","v":"Dry cow agistment"},null,{"$f":"Cashflow!R123","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C124","v":"Replacement agistment"},null,{"$f":"Cashflow!R124","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C125","v":"Other agistment"},null,{"$f":"Cashflow!R125","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B126","v":"Other feed costs"},null,null,{"$f":"Cashflow!R126","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B127","v":"Purchased feed costs"},null,null,{"$f":"Cashflow!R127","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B129","v":"Variable costs"},null,null,{"$f":"Cashflow!R129","v":0},null,{"$f":"IF(AND(G$17>0,$E137>0),$E137/G$17,\"-\")","v":"-"},{"$f":"IF(AND(H$17>0,$E137>0),$E137/H$17,\"-\")","v":"-"},{"$f":"IF(AND(I$17>0,$E137>0),$E137/I$17,\"-\")","v":"-"},{"$f":"IF(AND(E$52>0,$E137>0),$E137/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E137>0),$E137/K$17,\"-\")","v":"-"},{"$f":"IF(AND(L$17>0,$E137>0),$E137/L$17,\"-\")","v":"-"}]
[]
[null,{"$f":"Cashflow!B131","v":"Wages"},null,null,{"$f":"Cashflow!R131","v":0},null,{"$f":"IF(AND(G$17>0,$E139>0),$E139/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E139>0),$E139/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E139>0),$E139/K$17,\"-\")","v":"-"},"-"]
[null,{"$f":"Cashflow!B132","v":"Sharefarmer"},null,null,{"$f":"Cashflow!R132","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B133","v":"Contract labour/relief milker"},null,null,{"$f":"Cashflow!R133","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B134","v":"Protective clothing "},null,null,{"$f":"Cashflow!R134","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B135","v":"Staff amenities"},null,null,{"$f":"Cashflow!R135","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B136","v":"Training & development"},null,null,{"$f":"Cashflow!R136","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B137","v":"Superannuation"},null,null,{"$f":"Cashflow!R137","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B138","v":"Workcover"},null,null,{"$f":"Cashflow!R138","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B139","v":"Employed labour costs"},null,null,{"$f":"Cashflow!R139","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B141","v":"Repairs & maintenance buildings"},null,null,{"$f":"Cashflow!R141","v":0},null,{"$f":"IF(AND(G$17>0,$E149>0),$E149/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E149>0),$E149/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E149>0),$E149/K$17,\"-\")","v":"-"},"-"]
[null,{"$f":"Cashflow!B142","v":"Repairs & maintenance fencing"},null,null,{"$f":"Cashflow!R142","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B143","v":"Repairs & maintenance houses"},null,null,{"$f":"Cashflow!R143","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B144","v":"Repairs & maintenance irrigation"},null,null,{"$f":"Cashflow!R144","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B145","v":"Repairs & maintenance dairy"},null,null,{"$f":"Cashflow!R145","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B146","v":"Repairs & maintenance plant & equipment"},null,null,{"$f":"Cashflow!R146","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B147","v":"Repairs & maintenance water supply"},null,null,{"$f":"Cashflow!R147","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B148","v":"Repairs & maintenance tracks and laneways"},null,null,{"$f":"Cashflow!R148","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B150","v":"Repairs and maintenance costs"},null,null,{"$f":"Cashflow!R150","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B152","v":"Administration"},null,null,{"$f":"Cashflow!R152","v":0},null,{"$f":"IF(AND(G$17>0,$E159>0),$E159/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E159>0),$E159/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E159>0),$E159/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C153","v":"Accounting fees"},null,{"$f":"Cashflow!R153","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C154","v":"Advertising"},null,{"$f":"Cashflow!R154","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C155","v":"Bank fees"},null,{"$f":"Cashflow!R155","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C156","v":"Borrowing costs"},null,{"$f":"Cashflow!R156","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C157","v":"Computer expenses"},null,{"$f":"Cashflow!R157","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C158","v":"Consultants"},null,{"$f":"Cashflow!R158","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C159","v":"Donations"},null,{"$f":"Cashflow!R159","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C160","v":"Filing fees"},null,{"$f":"Cashflow!R160","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C161","v":"Internet costs"},null,{"$f":"Cashflow!R161","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C162","v":"Legal fees"},null,{"$f":"Cashflow!R162","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C163","v":"Light & power"},null,{"$f":"Cashflow!R163","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C164","v":"Printing, postage & stationery "},null,{"$f":"Cashflow!R164","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C165","v":"Subscriptions & journals"},null,{"$f":"Cashflow!R165","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C166","v":"Telephone"},null,{"$f":"Cashflow!R166","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C167","v":"Travel & accomodation"},null,{"$f":"Cashflow!R167","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B168","v":"Milk selling expenses"},null,null,{"$f":"Cashflow!R168","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C169","v":"Milk levies"},null,{"$f":"Cashflow!R169","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C170","v":"Milk volume charge"},null,{"$f":"Cashflow!R170","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B171","v":"Motor vehicle expenses"},null,null,{"$f":"Cashflow!R171","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C172","v":"Motor vehicle fuel & oil"},null,{"$f":"Cashflow!R172","v":0},null,{"$f":"IF(AND(G$17>0,$E179>0),$E179/G$17,\"-\")","v":"-"},"-","-","-",{"$f":"IF(AND(K$17>0,$E179>0),$E179/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C173","v":"Motor vehicle R&M servicing"},null,{"$f":"Cashflow!R173","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C174","v":"Motor vehicle registrations"},null,{"$f":"Cashflow!R174","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C175","v":"Motor vehicle insurance"},null,{"$f":"Cashflow!R175","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B176","v":"Miscellaneous expenses"},null,null,{"$f":"Cashflow!R176","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C177","v":"Cleaning & waste disposal"},null,{"$f":"Cashflow!R177","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C178","v":"Dog keep"},null,{"$f":"Cashflow!R178","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C179","v":"Farm insurance"},null,{"$f":"Cashflow!R179","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C180","v":"General expenses (misc.)"},null,{"$f":"Cashflow!R180","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C181","v":"General freight & cartage"},null,{"$f":"Cashflow!R181","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C182","v":"Hire of plant & equip"},null,{"$f":"Cashflow!R182","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C183","v":"Industry levies"},null,{"$f":"Cashflow!R183","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C184","v":"Livestock selling expenses"},null,{"$f":"Cashflow!R184","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C185","v":"Rates"},null,{"$f":"Cashflow!R185","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C186","v":"Registration & licences"},null,{"$f":"Cashflow!R186","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C187","v":"Shelter trees"},null,{"$f":"Cashflow!R187","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B188","v":"Other overheads costs"},null,null,{"$f":"Cashflow!R188","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B190","v":"Overhead costs"},null,null,{"$f":"Cashflow!R190","v":0},null,{"$f":"IF(AND(G$17>0,$E197>0),$E197/G$17,\"-\")","v":"-"},{"$f":"IF(AND(H$17>0,$E197>0),$E197/H$17,\"-\")","v":"-"},{"$f":"IF(AND(I$17>0,$E197>0),$E197/I$17,\"-\")","v":"-"},{"$f":"IF(AND(E$52>0,$E197>0),$E197/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E197>0),$E197/K$17,\"-\")","v":"-"},{"$f":"IF(AND(L$17>0,$E197>0),$E197/L$17,\"-\")","v":"-"}]
[]
[null,{"$f":"Cashflow!B192","v":"Farm working expenses (FWE)\n(Variable plus cash overhead costs)"},null,null,{"$f":"Cashflow!R192","v":0},null,{"$f":"IF(AND(G$17>0,$E199>0),$E199/G$17,\"-\")","v":"-"},{"$f":"IF(AND(H$17>0,$E199>0),$E199/H$17,\"-\")","v":"-"},{"$f":"IF(AND(I$17>0,$E199>0),$E199/I$17,\"-\")","v":"-"},{"$f":"IF(AND(E$52>0,$E199>0),$E199/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E199>0),$E199/K$17,\"-\")","v":"-"},{"$f":"IF(AND(L$17>0,$E199>0),$E199/L$17,\"-\")","v":"-"}]
[]
[null,{"$f":"Cashflow!B194","v":"Farm operating surplus\n(Total cash income minus Farm working expenses)"},null,null,{"$f":"Cashflow!R194","v":0},null,{"$f":"IF(AND(G$17>0,$E201>0),$E201/G$17,\"-\")","v":"-"},{"$f":"IF(AND(H$17>0,$E201>0),$E201/H$17,\"-\")","v":"-"},{"$f":"IF(AND(I$17>0,$E201>0),$E201/I$17,\"-\")","v":"-"},{"$f":"IF(AND(E$52>0,$E201>0),$E201/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E201>0),$E201/K$17,\"-\")","v":"-"},{"$f":"IF(AND(L$17>0,$E201>0),$E201/L$17,\"-\")","v":"-"}]
[]
[null,{"$f":"Cashflow!B196","v":"Interest"},null,null,{"$f":"Cashflow!R196","v":0},null,{"$f":"IF(AND(G$17>0,$E203>0),$E203/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E203>0),$E203/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E203>0),$E203/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C197","v":"Interest on loan 1"},null,{"$f":"Cashflow!R197","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C198","v":"Interest on loan 2"},null,{"$f":"Cashflow!R198","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C199","v":"Interest on loan 3"},null,{"$f":"Cashflow!R199","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C200","v":"Interest on loan 4"},null,{"$f":"Cashflow!R200","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C201","v":"Interest on loan 5"},null,{"$f":"Cashflow!R201","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C202","v":"Interest on loan 6"},null,{"$f":"Cashflow!R202","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C203","v":"Interest on loan 7"},null,{"$f":"Cashflow!R203","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C204","v":"Interest on loan 8"},null,{"$f":"Cashflow!R204","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C205","v":"Interest on loan 9"},null,{"$f":"Cashflow!R205","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C206","v":"Interest on loan 10"},null,{"$f":"Cashflow!R206","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C207","v":"Interest on overdraft"},null,{"$f":"Cashflow!R207","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C208","v":"Other interest expense"},null,{"$f":"Cashflow!R208","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B209","v":"Leases expense"},null,null,{"$f":"Cashflow!R209","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C210","v":"Lease expense plant & equipment 1"},null,{"$f":"Cashflow!R210","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C211","v":"Lease expense plant & equipment 2"},null,{"$f":"Cashflow!R211","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C212","v":"Lease expense plant & equipment 3"},null,{"$f":"Cashflow!R212","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C213","v":"Lease expense plant & equipment 4"},null,{"$f":"Cashflow!R213","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C214","v":"Lease expense livestock 1"},null,{"$f":"Cashflow!R214","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C215","v":"Lease expense livestock 2"},null,{"$f":"Cashflow!R215","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C216","v":"Lease expense livestock 3"},null,{"$f":"Cashflow!R216","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C217","v":"Lease expense livestock 4"},null,{"$f":"Cashflow!R217","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C218","v":"Lease expense land & water 1"},null,{"$f":"Cashflow!R218","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C219","v":"Lease expense land & water 2"},null,{"$f":"Cashflow!R219","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C220","v":"Lease expense land & water 3"},null,{"$f":"Cashflow!R220","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C221","v":"Lease expense land & water 4"},null,{"$f":"Cashflow!R221","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C222","v":"Lease expense land & water 5"},null,{"$f":"Cashflow!R222","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B223","v":"Finance costs"},null,null,{"$f":"Cashflow!R223","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B225","v":"Livestock purchases"},null,null,{"$f":"Cashflow!R225","v":0},null,{"$f":"IF(AND(G$17>0,$E232>0),$E232/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E232>0),$E232/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E232>0),$E232/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C226","v":"Milker purchases"},null,{"$f":"Cashflow!R226","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C227","v":"Replacement purchases"},null,{"$f":"Cashflow!R227","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C228","v":"Bulls/other purchases"},null,{"$f":"Cashflow!R228","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B229","v":"Other capital purchases"},null,null,{"$f":"Cashflow!R229","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C230","v":"Asset improvements"},null,{"$f":"Cashflow!R230","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C231","v":"Equipment/machinery purchases"},null,{"$f":"Cashflow!R231","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C232","v":"Asset development"},null,{"$f":"Cashflow!R232","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C233","v":"Land purchases"},null,{"$f":"Cashflow!R233","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C234","v":"Permanent water purchases"},null,{"$f":"Cashflow!R234","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C235","v":"Share purchases"},null,{"$f":"Cashflow!R235","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C236","v":"Other capital purchase"},null,{"$f":"Cashflow!R236","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C237","v":"Farm management deposits"},null,{"$f":"Cashflow!R237","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C238","v":"Farm management deposits - withdrawals"},null,{"$f":"Cashflow!R238","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C239","v":"Capital introduced"},null,{"$f":"Cashflow!R239","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B240","v":"Capital sales"},null,null,{"$f":"Cashflow!R240","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C241","v":"Land sales"},null,{"$f":"Cashflow!R241","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C242","v":"Permanent water sales"},null,{"$f":"Cashflow!R242","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C243","v":"Equipment /machinery sales"},null,{"$f":"Cashflow!R243","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B244","v":"Loan principal repayments"},null,null,{"$f":"Cashflow!R244","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C245","v":"Principal payments  - loans"},null,{"$f":"Cashflow!R245","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C246","v":"Principal payments - HP's or CM's"},null,{"$f":"Cashflow!R246","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B247","v":"Capital transactions"},null,null,{"$f":"Cashflow!R247","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B249","v":"Net farm cashflow"},null,null,{"$f":"Cashflow!R249","v":0},null,{"$f":"IF(G$17>0,$E256/G$17,0)","v":0},{"$f":"IF(H$17>0,$E256/H$17,0)","v":0},{"$f":"IF(I$17>0,$E256/I$17,0)","v":0},{"$f":"IF(E$52>0,$E256/E$52,0)","v":0},{"$f":"IF(K$17>0,$E256/K$17,0)","v":0},{"$f":"IF(L$17>0,$E256/L$17,0)","v":0}]
[]
[null,{"$f":"Cashflow!B251","v":"Non-farm wages"},null,null,{"$f":"Cashflow!R251","v":0},null,{"$f":"IF(AND(G$17>0,$E258>0),$E258/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E258>0),$E258/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E258>0),$E258/K$17,\"-\")","v":"-"},"-"]
[null,{"$f":"Cashflow!B252","v":"Non-farm rent"},null,null,{"$f":"Cashflow!R252","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B253","v":"Funds contributed"},null,null,{"$f":"Cashflow!R253","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B254","v":"Non-farm dividends"},null,null,{"$f":"Cashflow!R254","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B255","v":"Non farm income"},null,null,{"$f":"Cashflow!R255","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B257","v":"Drawings 1"},null,null,{"$f":"Cashflow!R257","v":0},null,{"$f":"IF(AND(G$17>0,$E264>0),$E264/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E264>0),$E264/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E264>0),$E264/K$17,\"-\")","v":"-"},"-"]
[null,null,{"$f":"Cashflow!C258","v":"Drawings - living"},null,{"$f":"Cashflow!R258","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C259","v":"Drawings - education"},null,{"$f":"Cashflow!R259","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C260","v":"Drawings - insurance"},null,{"$f":"Cashflow!R260","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C261","v":"Drawings - medical"},null,{"$f":"Cashflow!R261","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C262","v":"Drawings - income tax paid/refunded"},null,{"$f":"Cashflow!R262","v":0},null,"-","-","-","-","-","-"]
[null,null,{"$f":"Cashflow!C263","v":"Drawings - superannuation contributions (partners)"},null,{"$f":"Cashflow!R263","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B264","v":"Drawings 2"},null,null,{"$f":"Cashflow!R264","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B265","v":"Drawings 3"},null,null,{"$f":"Cashflow!R265","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B266","v":"Other non farm expenses"},null,null,{"$f":"Cashflow!R266","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B267","v":"Non farm personal expenses"},null,null,{"$f":"Cashflow!R267","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B269","v":"GST estimate"},null,null,{"$f":"Cashflow!R269","v":0},null,{"$f":"IF(AND(G$17>0,$E276>0),$E276/G$17,\"-\")","v":"-"},"-","-",{"$f":"IF(AND(E$52>0,$E276>0),$E276/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E276>0),$E276/K$17,\"-\")","v":"-"},"-"]
[null,{"$f":"Cashflow!B270","v":"PAYG instalments estimate"},null,null,{"$f":"Cashflow!R270","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B271","v":"PAYG withheld estimate"},null,null,{"$f":"Cashflow!R271","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B272","v":"Income tax estimate"},null,null,{"$f":"Cashflow!R272","v":0},null,"-","-","-","-","-","-"]
[null,{"$f":"Cashflow!B273","v":"Tax expenses"},null,null,{"$f":"Cashflow!R273","v":0},null,"-","-","-","-","-","-"]
[]
[null,{"$f":"Cashflow!B275","v":"Net non-farm income and tax"},null,null,{"$f":"Cashflow!R275","v":0},null,{"$f":"IF(AND(G$17>0,$E282>0),$E282/G$17,\"-\")","v":"-"},{"$f":"IF(AND(H$17>0,$E282>0),$E282/H$17,\"-\")","v":"-"},{"$f":"IF(AND(I$17>0,$E282>0),$E282/I$17,\"-\")","v":"-"},{"$f":"IF(AND(E$52>0,$E282>0),$E282/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E282>0),$E282/K$17,\"-\")","v":"-"},{"$f":"IF(AND(L$17>0,$E282>0),$E282/L$17,\"-\")","v":"-"}]
[]
[null,{"$f":"Cashflow!B277","v":"Net monthly cash flow total"},null,null,{"$f":"Cashflow!R277","v":0},null,{"$f":"IF(AND(G$17>0,$E284>0),$E284/G$17,\"-\")","v":"-"},{"$f":"IF(AND(H$17>0,$E284>0),$E284/H$17,\"-\")","v":"-"},{"$f":"IF(AND(I$17>0,$E284>0),$E284/I$17,\"-\")","v":"-"},{"$f":"IF(AND(E$52>0,$E284>0),$E284/E$52,\"-\")","v":"-"},{"$f":"IF(AND(K$17>0,$E284>0),$E284/K$17,\"-\")","v":"-"},{"$f":"IF(AND(L$17>0,$E284>0),$E284/L$17,\"-\")","v":"-"}]

{"sheet":"DSCoA","index":4,"n_rows":251,"n_cols":5,"rows_kept":251,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Dairy Standard Chart of Accounts"]
[]
[]
[{"$f":"Cashflow!B44","v":"Income"},null,null,null,"All income associated with dairy farming activities"]
["Milk income",null,null,null,"Gross Milk Income – i.e butterfat and protein income, step-ups, retrospective payments and colostrums sales. Record other items on factory milk statement in appropriate income or expense categories or sub-categories not here under milk income"]
[{"$f":"Cashflow!B21","v":"Livestock sales"},null,null,null,"Sales of stock from normal herd management practices, not from one-off sales such as major reductions as these are considered as CAPITAL INCOME sub SALES-BREEDERS."]
[null,{"$f":"Cashflow!C22","v":"Calf sales"},null,null,"Bull calves, beef cross calves, heifer calves not kept for herd replacements"]
[null,{"$f":"Cashflow!C23","v":"Cull sales"},null,null,"Culled stock, chopper cows, heifers, bulls etc. culled and sold for slaughter"]
[null,{"$f":"Cashflow!C24","v":"Other livestock sales"},null,null,"Beef cattle, horses, bulls, breeding stock e.g. bulls, cows, heifers if they are regularly sold to others for use for breeding, milking, sires not stock from a major reduction sale or dispersal sale as these sales would be under CAPITAL INCOME"]
[{"$f":"Cashflow!B25","v":"Feed sales"},null,null,null,"Sales of feed produced within the dairy business"]
[null,{"$f":"Cashflow!C26","v":"Hay sales"},null,null,"Income from hay sales"]
[null,{"$f":"Cashflow!C27","v":"Silage sales"},null,null,"Income from silage sales"]
[null,{"$f":"Cashflow!C28","v":"Other feed sales"},null,null,"Income from other feed sales such as grain"]
[{"$f":"Cashflow!B29","v":"Water sales"},null,null,null,"Sales of water from normal water management practices, not from one-off sales such as major reductions as these are considered as CAPITAL INCOME"]
[null,{"$f":"Cashflow!C30","v":"Temporary water sales"},null,null,"Sales of temporary water"]
[null,{"$f":"Cashflow!C31","v":"Other water sales"},null,null,"Income from any other water sales"]
[{"$f":"Cashflow!B32","v":"Other farm income"},null,null,null,"Various sources of farm income resulting from farm operations"]
[null,{"$f":"Cashflow!C33","v":"Interest income"},null,null,"Interest received on farm operating bank accounts and short term deposits with bank accounts or factories and any other interest money received because of the operation of the farm business, not interest on off-farm or non-farm investments and personal bank account interest as these go in NON FARM INCOME"]
[null,{"$f":"Cashflow!C34","v":"Contracting income"},null,null,"Income earned off-farm using the business farm machinery, equipment e.g. hay mower, hay roller, hay/silage processing"]
[null,{"$f":"Cashflow!C35","v":"Milk company dividends"},null,null,"Factory, co-op dividends, not dividends from off farm or non-farm investments"]
[null,{"$f":"Cashflow!C36","v":"Incentives"},null,null,"Trade incentives, discounts on purchases, vat purchase incentives"]
[null,{"$f":"Cashflow!C37","v":"Lease income"},null,null,"Cows, farming land, machinery etc. that is leased out to others"]
[null,{"$f":"Cashflow!C38","v":"Rebates - fuel"},null,null,"Fuel rebates"]
[null,{"$f":"Cashflow!C39","v":"Rebates - fertiliser"},null,null,"Fertiliser Rebates"]
[null,{"$f":"Cashflow!C40","v":"Rebates  - other"},null,null,"Other rebates, including semen, factory or volume charge rebates"]
[null,{"$f":"Cashflow!C41","v":"Government payments"},null,null,"Government payments in the form of subsidies and support payments"]
[null,{"$f":"Cashflow!C42","v":"Insurance recoveries"},null,null,"Farm insurance recoveries"]
[null,{"$f":"Cashflow!C43","v":"Other farm income"},null,null,"Any other farm income resulting from farm operations such as farm house rental"]
[]
[{"$f":"Cashflow!B59","v":"Herd costs"},null,null,null,"All expenses relating to maintaining herd quality and assisting herd management"]
[{"$f":"Cashflow!B46","v":"AI and herd test "},null,null,null,"All artificial insemination and herd test expenses"]
[null,{"$f":"Cashflow!C47","v":"AI/semen"},null,null,"Artificial insemination technician, semen, embryo, ET drugs, gloves, nitrogen for semen tank, vet services, fees and drugs associated with ET work, CIDR, PG and induction"]
[null,{"$f":"Cashflow!C48","v":"Herd test"},null,null,"Herd test charges"]
[null,{"$f":"Cashflow!C49","v":"Other breeding costs"},null,null,"Tags for calves, heifers and cow identification, freeze branding of all classes of stock"]
[{"$f":"Cashflow!B50","v":"Animal health"},null,null,null,"All animal health expenses including drugs and veterinary fees but excluding any AI expenses"]
[null,{"$f":"Cashflow!C51","v":"Drugs"},null,null,"Drench, drench guns, lice and parasite treatment and prevention – minerals and vitamins injected to all classes of stock – vaccines, injections (usually preventative) drugs and other treatments not restricted to purchase from vets including teat dip"]
[null,{"$f":"Cashflow!C52","v":"Veterinary fees"},null,null,"Vet visits, operations, drugs restricted to purchase from a veterinary surgeon or requiring veterinary sanction"]
[{"$f":"Cashflow!B53","v":"Calf rearing"},null,null,null,"Any expenses incurred for feeding, treating and maintaining calves up to the time they are weaned"]
[null,{"$f":"Cashflow!C54","v":"Calf feed"},null,null,"Grain, pellets and growth promotants, for calves up to the time they are weaned"]
[null,{"$f":"Cashflow!C55","v":"Milk powder"},null,null,"Milk powder and milk additives for calves up to the time they are weaned"]
[null,{"$f":"Cashflow!C56","v":"Bedding"},null,null,"Rice hulls or other bedding material"]
[null,{"$f":"Cashflow!C57","v":"Other calf rearing costs"},null,null,"Drenching and other calf shed treatments for calves up to the time they are weaned"]
[{"$f":"Cashflow!B58","v":"Other herd costs"},null,null,null,"Short term lease of cows, heifers and bulls for periods of less than 12 months as these have a different tax implication to leases in excess of 12 months.  Registrations, transfers, classifications, photos, show entry fees"]
[]
[{"$f":"Cashflow!B66","v":"Shed costs"},null,null,null,"All expenses relating to milk harvesting"]
[{"$f":"Cashflow!B61","v":"Shed power"},null,null,null,"Electricity, gas fuel for heating, cooling lighting milking"]
[{"$f":"Cashflow!B62","v":"Dairy supplies"},null,null,null,"Chemicals, detergents used for washing, sterilising, cleaning, fly control. Inflations, rubber tubes, filter socks, strainers, vacuum pump oil, isolated purchases of cups, claws and bowls etc."]
[null,{"$f":"Cashflow!C63","v":"Dairy consumables"},null,null,"Chemicals, detergents used for washing, sterilising, cleaning, fly control. Filter socks, strainers, vacuum pump oil, isolated purchases of cups, claws and bowls etc."]
[null,{"$f":"Cashflow!C64","v":"Rubberware"},null,null,"Inflations, rubber tubes"]
[{"$f":"Cashflow!B65","v":"Other shed costs"}]
[]
[{"$f":"Cashflow!B95","v":"Home grown feed costs"},null,null,null,"All costs associated with growing feed on land under control of the business"]
[{"$f":"Cashflow!B68","v":"Fertiliser"},null,null,null,"All NPKS and trace element fertiliser products and compounds including blending, mixing, cartage, bin hire and spreading"]
[null,{"$f":"Cashflow!C69","v":"PKS"},null,null,"All PKS and trace element fertiliser products and compounds including blending, mixing, cartage, bin hire and spreading"]
[null,{"$f":"Cashflow!C70","v":"Urea"},null,null,"All urea including cartage, bin hire and spreading"]
[null,{"$f":"Cashflow!C71","v":"Nitrogen blends"},null,null,"All nitrogen blends including blending, mixing, cartage, bin hire and spreading"]
[null,{"$f":"Cashflow!C72","v":"Lime & gypsum"},null,null,"Lime & Gypsum including blending, mixing, cartage, bin hire and spreading"]
[null,{"$f":"Cashflow!C73","v":"Effluent spreading/disposal"},null,null,"Costs associated with spreading effluent "]
[null,{"$f":"Cashflow!C74","v":"Other fertiliser costs"},null,null,"Other fertiliser products"]
[{"$f":"Cashflow!B75","v":"Irrigation"},null,null,null,"All costs associated with irrigation in the dairy business but not new structures used in new land forming and pasture establishment as these major expenses should be entered into CAPITAL EXPENSES. Maintenance of Irrigation structures and physical channel cleaning should be entered in OVERHEADS sub REPAIRS & MAINTENANCE sub IRRIGATION"]
[null,{"$f":"Cashflow!C76","v":"Water authority rates"},null,null,"Water rates for supply and drainage relating to farm irrigation water"]
[null,{"$f":"Cashflow!C77","v":"TWE purchases"},null,null,"Purchase of temporary water transfers in addition to water right or allocation"]
[null,{"$f":"Cashflow!C78","v":"Pumping costs  - electricity"},null,null,"Electricity costs for pumping irrigation water"]
[null,{"$f":"Cashflow!C79","v":"Pumping costs  - diesel"},null,null,"Diesel costs for pumping irrigation water"]
[null,{"$f":"Cashflow!C80","v":"Other irrigation costs"},null,null,"Any other costs incurred to run the irrigation excluding repairs and maintenance"]
[{"$f":"Cashflow!B81","v":"Hay and silage making"},null,null,null,"Costs for on-farm hay and silage making, including twine, plastic wrap and contractors"]
[null,{"$f":"Cashflow!C82","v":"Hay making"},null,null,"Cutting, twine, net wrap, pressing, baling, hay inoculants, cartage on hay and freight on twine etc"]
[null,{"$f":"Cashflow!C83","v":"Silage making"},null,null,"Harvesting, transport, plastic wrap, pressing, baling, wrapping, chopping, covering, compacting contractors for silage, silage inoculants, cartage of silage purchases and freight on plastic covering etc"]
[null,{"$f":"Cashflow!C84","v":"Crop harvesting"},null,null,"Harvesting and storage of crops including crop purchases and cartage and freight etc"]
[null,{"$f":"Cashflow!C85","v":"Other hay & silage making costs"},null,null,"Any other costs incurred in making hay and silage on farm"]
[{"$f":"Cashflow!B86","v":"Pasture and cropping"},null,null,null,"Costs associated with pasture renovation and cropping such as seed, weed & pest and contractor costs. Not new land forming and the associated new pasture establishment as these major expenses should be entered  under CAPITAL EXPENSE sub DEVELOPMENT"]
[null,{"$f":"Cashflow!C87","v":"Seed"},null,null,"Seed purchases"]
[null,{"$f":"Cashflow!C88","v":"Weed & pest control"},null,null,"Chemicals and contractors for the control of weeds and pests in pastures, roadsides and channels.  Chemicals, baits, ammunition, contractors used to control vermin"]
[null,{"$f":"Cashflow!C89","v":"Other pasture & cropping costs"},null,null,"Ploughing, ripping, discing, power harrowing, seedbed preparation, seed for crop and pasture sowing and pasture renovation, direct drilling contractor, oversowing and planting"]
[{"$f":"Cashflow!B90","v":"Fuel and oil"},null,null,null,"Fuel used for vehicles, equipment, motors used for feed production "]
[null,{"$f":"Cashflow!C91","v":"Diesel"},null,null,"Diesel costs except those for irrigation"]
[null,{"$f":"Cashflow!C92","v":"Unleaded"},null,null,"Unleaded petrol"]
[null,{"$f":"Cashflow!C93","v":"Gas"},null,null,"Gas"]
[null,{"$f":"Cashflow!C94","v":"Oil/Grease"},null,null,"Oil, grease"]
[]
[{"$f":"Cashflow!B127","v":"Purchased feed costs"},null,null,null,"All purchased feeds including cartage, feed additives and agistment"]
[{"$f":"Cashflow!B97","v":"Concentrates"},null,null,null,"Purchased concentrates (pellets, grain mixes etc)"]
[null,{"$f":"Cashflow!C98","v":"Concentrate 1"},null,null,"Grain, grain mixes and pellets"]
[null,{"$f":"Cashflow!C99","v":"Concentrate 2"},null,null,"Legumes and protein meals"]
[null,{"$f":"Cashflow!C100","v":"Concentrate 3"}]
[null,{"$f":"Cashflow!C101","v":"Concentrate 4"}]
[null,{"$f":"Cashflow!C102","v":"Concentrate 5"}]
[null,{"$f":"Cashflow!C103","v":"Concentrate 6"}]
[{"$f":"Cashflow!B104","v":"Purchased fodder"},null,null,null,"Purchased fodder costs inluding hay and silage"]
[null,{"$f":"Cashflow!C105","v":"Purchased fodder 1"},null,null,"Hay purchases"]
[null,{"$f":"Cashflow!C106","v":"Purchased fodder 2"},null,null,"Silage purchases"]
[null,{"$f":"Cashflow!C107","v":"Purchased fodder 3"},null,null,"Haylage purchases"]
[null,{"$f":"Cashflow!C108","v":"Purchased fodder 4"}]
[null,{"$f":"Cashflow!C109","v":"Purchased fodder 5"}]
[null,{"$f":"Cashflow!C110","v":"Purchased fodder 6"}]
[{"$f":"Cashflow!B111","v":"Byproducts"},null,null,null,"Purchased byproducts"]
[null,{"$f":"Cashflow!C112","v":"Byproduct 1"},null,null,"Brewers grain"]
[null,{"$f":"Cashflow!C113","v":"Byproduct 2"},null,null,"Citrus pulp"]
[null,{"$f":"Cashflow!C114","v":"Byproduct 3"},null,null,"Other byproduct"]
[null,{"$f":"Cashflow!C115","v":"Byproduct 4"}]
[{"$f":"Cashflow!B116","v":"Other puchased feeds"},null,null,null,"Any other purchased feed costs"]
[null,{"$f":"Cashflow!C117","v":"Other purchased feed 1"},null,null,"Additives"]
[null,{"$f":"Cashflow!C118","v":"Other purchased feed 2"}]
[null,{"$f":"Cashflow!C119","v":"Other purchased feed 3"}]
[null,{"$f":"Cashflow!C120","v":"Other purchased feed 4"}]
[{"$f":"Cashflow!B121","v":"Agistment"},null,null,null,"Agistment and short term land leases (less than 12 months), contract rearing of all classes of stock after weaning, cartage to and from agistment"]
[null,{"$f":"Cashflow!C122","v":"Milker agistment"},null,null,"Agistment or the purchase of standing feed grazed by the milking herd including cartage to and from the agistment should all be entered in this category"]
[null,{"$f":"Cashflow!C123","v":"Dry cow agistment"},null,null,"Agistment or the purchase of standing feed grazed by dry cows including cartage to and from the agistment should all be entered in this category"]
[null,{"$f":"Cashflow!C124","v":"Replacement agistment"},null,null,"Agistment, contract rearing, contract growing, weight gain agistment  or the purchase of standing feed grazed by the replacements including cartage to and from the agistment should all be entered in this category"]
[null,{"$f":"Cashflow!C125","v":"Other agistment"},null,null,"Agistment, contract rearing, contract growing, weight gain agistment  or the purchase of standing feed grazed by the other livestock including cartage to and from the agistment should all be entered in this category"]
[{"$f":"Cashflow!B126","v":"Other feed costs"},null,null,null,"Includes any other feed costs that have not been included elsewhere here. These may include the cost of washing out or altering grain contracts and cartage costs not already accounted for"]
[]
[{"$f":"Cashflow!B139","v":"Employed labour costs"},null,null,null,"Permanent labour and casual labour. Note: Contractors and contracting should be entered under the category that relates to the work carried out"]
[{"$f":"Cashflow!B131","v":"Wages"},null,null,null,"Permanent farm employees either full-time or part-time and casual farm employees"]
[{"$f":"Cashflow!B132","v":"Sharefarmer"},null,null,null,"Share paid to sharefarmer"]
[{"$f":"Cashflow!B133","v":"Contract labour/relief milker"},null,null,null,"Payments to contract or relief milkers"]
[{"$f":"Cashflow!B134","v":"Protective clothing "},null,null,null,"Apron, gloves, gum boots, waterproof clothes etc"]
[{"$f":"Cashflow!B135","v":"Staff amenities"},null,null,null,"Includes things like tea and coffee and light meals provided to staff"]
[{"$f":"Cashflow!B136","v":"Training & development"},null,null,null,"Fees for courses, seminars, workshops etc. that relate to the farm business (including travel, meals, accommodation, materials) for permanent and casual employees"]
[{"$f":"Cashflow!B137","v":"Superannuation"},null,null,null,"Superannuation contributions for permanent and casual employees"]
[{"$f":"Cashflow!B138","v":"Workcover"},null,null,null,"Workcover for permanent and casual employees"]
[]
[{"$f":"Cashflow!B150","v":"Repairs and maintenance costs"},null,null,null,"Repairs and maintenance on farm improvements and plant and equipment this does not include capital improvements which should be entered under CAPITAL EXPENSES"]
[{"$f":"Cashflow!B141","v":"Repairs & maintenance buildings"},null,null,null,"Maintenance of farm buildings and structures.  The fixtures that would be considered to be part of the farm when/if it is sold"]
[{"$f":"Cashflow!B142","v":"Repairs & maintenance fencing"},null,null,null,"Fencing contractors, yards, gates, insulators, gate tapes, fence reels, posts, wire, yard mesh, hinges, gate chains etc"]
[{"$f":"Cashflow!B143","v":"Repairs & maintenance houses"},null,null,null,"Repairs to farm houses"]
[{"$f":"Cashflow!B144","v":"Repairs & maintenance irrigation"},null,null,null,"Maintenance of irrigation structures and channel cleaning. Note:Structures used in new landforming and pasture establishment should be entered under CAPITAL EXPENSE sub DEVELOPMENT.  "]
[{"$f":"Cashflow!B145","v":"Repairs & maintenance dairy"},null,null,null,"Vat repair, platform repair, sludge pump repair"]
[{"$f":"Cashflow!B146","v":"Repairs & maintenance plant & equipment"},null,null,null,"Repairs and maintenance to farm equipment, plant and  machinery "]
[{"$f":"Cashflow!B147","v":"Repairs & maintenance water supply"},null,null,null,"Repairs and maintenance of water troughs, poly pipe, pipe and trough fittings, pressure pumps for stock water supply"]
[{"$f":"Cashflow!B148","v":"Repairs & maintenance tracks and laneways"},null,null,null,"Repairs and maintenance to tracks and laneways"]
[{"$f":"Cashflow!B149","v":"Repairs & maintenance replacement tools"},null,null,null,"Replacement tool purchases"]
[]
[{"$f":"Cashflow!B188","v":"Other overheads costs"},null,null,null,"Other Overheads Incurred to run the farm business"]
[{"$f":"Cashflow!B152","v":"Administration"},null,null,null,"Administration expenses related to the operation of the farm business including items such as accounting, consulting, phone and office expenses"]
[null,{"$f":"Cashflow!C153","v":"Accounting fees"},null,null,"Professionals used for accounting advice in relation to the farm business"]
[null,{"$f":"Cashflow!C154","v":"Advertising"},null,null,"Advertisting expenses relating to sale of milk, livestock, feed or capital items"]
[null,{"$f":"Cashflow!C155","v":"Bank fees"},null,null,"Bank generated charges, account keeping fees, reference fee, stop cheque fee"]
[null,{"$f":"Cashflow!C156","v":"Borrowing costs"},null,null,"Costs related to borrowing funds for farm use – Fees to establish farm related loans"]
[null,{"$f":"Cashflow!C157","v":"Computer expenses"},null,null,"Computer expenses, including anti-virus software"]
[null,{"$f":"Cashflow!C158","v":"Consultants"},null,null,"Professionals used for financial,business management and production advice in relation to the farm business"]
[null,{"$f":"Cashflow!C159","v":"Donations"},null,null,"Donations"]
[null,{"$f":"Cashflow!C160","v":"Filing fees"},null,null,"Filing fees, including those paid to ASIC"]
[null,{"$f":"Cashflow!C161","v":"Internet costs"},null,null,"Email and internet"]
[null,{"$f":"Cashflow!C162","v":"Legal fees"},null,null,"Legal fees in relation to the farm business"]
[null,{"$f":"Cashflow!C163","v":"Light & power"},null,null,"Light and power for the house and office"]
[null,{"$f":"Cashflow!C164","v":"Printing, postage & stationery "},null,null,"Stationery, postage, printing, stamps, postal charges, post office box rental, envelopes, paper supplies, pens, pencils etc. for use in farm office"]
[null,{"$f":"Cashflow!C165","v":"Subscriptions & journals"},null,null,"Farm journals, rural newspapers and magazines etc"]
[null,{"$f":"Cashflow!C166","v":"Telephone"},null,null,"Office, home and mobile phones"]
[null,{"$f":"Cashflow!C167","v":"Travel & accomodation"},null,null,"Travel and accommodation expenses incurred for the farm business"]
[{"$f":"Cashflow!B168","v":"Milk selling expenses"},null,null,null,"Milk Selling Expenses"]
[null,{"$f":"Cashflow!C169","v":"Milk levies"},null,null,"DA levies"]
[null,{"$f":"Cashflow!C170","v":"Milk volume charge"},null,null,"Volume charges, stop charges, collection charges"]
[{"$f":"Cashflow!B171","v":"Motor vehicle expenses"},null,null,null,"Motor vehicle expenses"]
[null,{"$f":"Cashflow!C172","v":"Motor vehicle fuel & oil"},null,null,"Fuel and oil not directly related to the conservation or feeding of feed"]
[null,{"$f":"Cashflow!C173","v":"Motor vehicle R&M servicing"},null,null,"Repairs and maintenance on vehicles"]
[null,{"$f":"Cashflow!C174","v":"Motor vehicle registrations"},null,null,"Registrations on farm vehicles"]
[null,{"$f":"Cashflow!C175","v":"Motor vehicle insurance"},null,null,"Vehicle insurance"]
[{"$f":"Cashflow!B176","v":"Miscellaneous expenses"},null,null,null,"Miscellaneous Overheads including items such as general freight, industry levies, livestock selling expenses and farm insurance"]
[null,{"$f":"Cashflow!C177","v":"Cleaning & waste disposal"},null,null,"Charges relating to rubbish removal and pickup"]
[null,{"$f":"Cashflow!C178","v":"Dog keep"},null,null,"Food, drugs, veterinary attention, collars, chains for working dogs."]
[null,{"$f":"Cashflow!C179","v":"Farm insurance"},null,null,"Farm insurance package including stock, plant, fodder, buildings, sickness, accident and trauma insurance.  Portion of house insurance as determined by your accountant"]
[null,{"$f":"Cashflow!C180","v":"General expenses (misc.)"},null,null,"General farm expenses that do not fit within another expense code"]
[null,{"$f":"Cashflow!C181","v":"General freight & cartage"},null,null,"General freight & cartage not including to and from agistment which should be entered under agistment"]
[null,{"$f":"Cashflow!C182","v":"Hire of plant & equip"},null,null,"Hire of plant and equipment"]
[null,{"$f":"Cashflow!C183","v":"Industry levies"},null,null,"Other industry levies such as UDV and MLA levies but not DA levies"]
[null,{"$f":"Cashflow!C184","v":"Livestock selling expenses"},null,null,"Government levies, yard dues and cartage"]
[null,{"$f":"Cashflow!C185","v":"Rates"},null,null,"Shire rates and charges, domestic water rates where applicable. Note: Irrigation water rates are entered in FEED sub IRRIGATION sub WATER AUTHORITY RATES"]
[null,{"$f":"Cashflow!C186","v":"Registration & licences"},null,null,"Registration and licences for farm vehicles and machinery"]
[null,{"$f":"Cashflow!C187","v":"Shelter trees"},null,null,"Trees purchased for shelter on the farm"]
[]
[{"$f":"Cashflow!B223","v":"Finance costs"},null,null,null,"Expenses relating to financing the operation of the business"]
[{"$f":"Cashflow!B196","v":"Interest"},null,null,null,"Note: Interest – separate sub-categories should be set up for each loan or hire purchase.  There should be a corresponding sub-category for the Principal portion for each loan or hire purchase under the CAPITAL EXPENSE category"]
[null,{"$f":"Cashflow!C197","v":"Interest on loan 1"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C198","v":"Interest on loan 2"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C199","v":"Interest on loan 3"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C200","v":"Interest on loan 4"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C201","v":"Interest on loan 5"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C202","v":"Interest on loan 6"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C203","v":"Interest on loan 7"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C204","v":"Interest on loan 8"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C205","v":"Interest on loan 9"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C206","v":"Interest on loan 10"},null,null,"Interest on major additions and/or alterations to the land, buildings, livestock, plant and equipment"]
[null,{"$f":"Cashflow!C207","v":"Interest on overdraft"},null,null,"Interest charged for overdraft on farm operating account, often shown as “debit interest” on bank statement and interest on any other bank accounts but not interest on loans as these are entered in their own category under INTEREST ON LOANS"]
[null,{"$f":"Cashflow!C208","v":"Other interest expense"},null,null,"Include any other interest paid here"]
[{"$f":"Cashflow!B209","v":"Leases expense"},null,null,null,"Leases over 12 months on land, water, livestock, plant & equipment"]
[null,{"$f":"Cashflow!C210","v":"Lease expense plant & equipment 1"},null,null,"Leases on plant & equipment"]
[null,{"$f":"Cashflow!C211","v":"Lease expense plant & equipment 2"},null,null,"Leases on plant & equipment"]
[null,{"$f":"Cashflow!C212","v":"Lease expense plant & equipment 3"},null,null,"Leases on plant & equipment"]
[null,{"$f":"Cashflow!C213","v":"Lease expense plant & equipment 4"},null,null,"Leases on plant & equipment"]
[null,{"$f":"Cashflow!C214","v":"Lease expense livestock 1"},null,null,"Leases on livestock"]
[null,{"$f":"Cashflow!C215","v":"Lease expense livestock 2"},null,null,"Leases on livestock"]
[null,{"$f":"Cashflow!C216","v":"Lease expense livestock 3"},null,null,"Leases on livestock"]
[null,{"$f":"Cashflow!C217","v":"Lease expense livestock 4"},null,null,"Leases on livestock"]
[null,{"$f":"Cashflow!C218","v":"Lease expense land & water 1"},null,null,"Leases on land and water"]
[null,{"$f":"Cashflow!C219","v":"Lease expense land & water 2"},null,null,"Leases on land and water"]
[null,{"$f":"Cashflow!C220","v":"Lease expense land & water 3"},null,null,"Leases on land and water"]
[null,{"$f":"Cashflow!C221","v":"Lease expense land & water 4"},null,null,"Leases on land and water"]
[null,{"$f":"Cashflow!C222","v":"Lease expense land & water 5"},null,null,"Leases on land and water"]
[]
[{"$f":"Cashflow!B247","v":"Capital transactions"},null,null,null,"Capital costs on items that are part of the management and development of the farm business"]
[{"$f":"Cashflow!B225","v":"Livestock purchases"},null,null,null,"Livestock purchases "]
[null,{"$f":"Cashflow!C226","v":"Milker purchases"},null,null,"Cow purchases"]
[null,{"$f":"Cashflow!C227","v":"Replacement purchases"},null,null,"Replacement purchases"]
[null,{"$f":"Cashflow!C228","v":"Bulls/other purchases"},null,null,"Bulls or other stock purchases"]
[{"$f":"Cashflow!B229","v":"Other capital purchases"}]
[null,{"$f":"Cashflow!C230","v":"Asset improvements"},null,null,"Improvements: Major additions and/or alterations to the dairy building and dairy plant"]
[null,{"$f":"Cashflow!C231","v":"Equipment/machinery purchases"},null,null,"Plant, equipment & vehicles: Tractor, mower, slasher etc. for use on the farm. Milk vat purchase. Farm related vehicles"]
[null,{"$f":"Cashflow!C232","v":"Asset development"},null,null,"Development: Land forming, recycle systems, pasture establishment and the associated irrigation structures, pumps, motors etc.  Any major farm development or works"]
[null,{"$f":"Cashflow!C233","v":"Land purchases"},null,null,"Land: Land purchased for use by the farm business"]
[null,{"$f":"Cashflow!C234","v":"Permanent water purchases"},null,null,"Water: HRWS, LRWS or bore water purchases"]
[null,{"$f":"Cashflow!C235","v":"Share purchases"},null,null,"Share Equity: Factory share purchases, usually taken directly from milk receipts"]
[null,{"$f":"Cashflow!C236","v":"Other capital purchase"},null,null,"Other capital purchases that relate to the dairy farm business"]
[null,{"$f":"Cashflow!C237","v":"Farm management deposits"},null,null,"Cash amount despoited into FMDs"]
[null,{"$f":"Cashflow!C238","v":"Farm management deposits - withdrawals"},null,null,"FMDs that become available for use"]
[null,{"$f":"Cashflow!C239","v":"Capital introduced"},null,null,"Capital permanently introduced from non farm business activities"]
[{"$f":"Cashflow!B240","v":"Capital sales"},null,null,null,"Sale of items that have a permanent impact on the balance sheet"]
[null,{"$f":"Cashflow!C241","v":"Land sales"},null,null,"Sale of land utilised in the dairy farm business"]
[null,{"$f":"Cashflow!C242","v":"Permanent water sales"},null,null,"Sale of water utilised in the dairy farm business"]
[null,{"$f":"Cashflow!C243","v":"Equipment /machinery sales"},null,null,"Sale of plant and equipment used in the dairy farm business"]
[{"$f":"Cashflow!B244","v":"Loan principal repayments"},null,null,null,"Loan repayments. Note: Loan payments/Hire purchases – if a loan or hire purchase exists on a capital expenditure item below, a separate sub-category should be set up for the principal portion and defined as principal or HP.  e.g. HP DAIRY PLANT or PRINCIPAL LAND.  There should be a corresponding sub-category for the interest portion for each loan or hire purchase under the FINANCE sub INTEREST category.  If a loan, the loan funds received should also similarly be entered in CAPITAL INCOME sub LOANS in a corresponding sub-category name"]
[null,{"$f":"Cashflow!C245","v":"Principal payments  - loans"},null,null,"Principal repayments on loans"]
[null,{"$f":"Cashflow!C246","v":"Principal payments - HP's or CM's"},null,null,"Principal repayments on hire purchase or chattel mortgages"]
[]
[{"$f":"Cashflow!B255","v":"Non farm income"},null,null,null,"Wages, rent, dividends and other income not related to farming activities"]
[{"$f":"Cashflow!B251","v":"Non-farm wages"},null,null,null,"Wages, salaries earned by family members working off-farm."]
[{"$f":"Cashflow!B252","v":"Non-farm rent"},null,null,null,"Rent received"]
[{"$f":"Cashflow!B253","v":"Funds contributed"},null,null,null,"Funds contributed to the business"]
[{"$f":"Cashflow!B254","v":"Non-farm dividends"},null,null,null,"Dividends from off farm investments"]
[]
[{"$f":"Cashflow!B267","v":"Non farm personal expenses"},null,null,null,"Personal expenses that are not tax deductible.  "]
[{"$f":"Cashflow!B257","v":"Drawings 1"}]
[null,{"$f":"Cashflow!C258","v":"Drawings - living"}]
[null,{"$f":"Cashflow!C259","v":"Drawings - education"}]
[null,{"$f":"Cashflow!C260","v":"Drawings - insurance"},null,null,"Including life and income protection insurance"]
[null,{"$f":"Cashflow!C261","v":"Drawings - medical"}]
[null,{"$f":"Cashflow!C262","v":"Drawings - income tax paid/refunded"}]
[null,{"$f":"Cashflow!C263","v":"Drawings - superannuation contributions (partners)"}]
[{"$f":"Cashflow!B264","v":"Drawings 2"}]
[{"$f":"Cashflow!B265","v":"Drawings 3"}]
[{"$f":"Cashflow!B266","v":"Other non farm expenses"}]
[]
[{"$f":"Cashflow!B273","v":"Tax expenses"}]
[{"$f":"Cashflow!B269","v":"GST estimate"},null,null,null,"GST amounts"]
[{"$f":"Cashflow!B270","v":"PAYG instalments estimate"},null,null,null,"Pay as you go tax"]
[{"$f":"Cashflow!B271","v":"PAYG withheld estimate"},null,null,null,"Taxheld PAYG for permanent and casual employees"]
[{"$f":"Cashflow!B272","v":"Income tax estimate"},null,null,null,"End of year tax"]
[]
["For more information regarding the Standard chart of accounts go to"]
[null,"dairybase.com.au/using-dairybase/chart-of-accounts"]

{"sheet":"Working","index":5,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Working sheet - please do not alter anything here"]
[]
["Gotos",2]
["Goto section…"]
["Income"]
["Herd costs"]
["Shed costs"]
["Home grown feed costs"]
["Purchased feed costs"]
["Employed labour costs"]
["Repairs and maintenance costs"]
["Other overhead costs"]
["Finance costs"]
["Capital transactions"]
["Non farm income"]
["Non farm personal expenses"]
["Tax expenses"]
[]
[]
["Quarter"]
["Month","Quarter"]
[1,3]
[2,3]
[3,3]
[4,4]
[5,4]
[6,4]
[7,1]
[8,1]
[9,1]
[10,2]
[11,2]
[12,2]
[]
[]
["Cashflow annual milk production entry units"]
[1,"(1=litres or 2=kg MS)"]