Follow

Creating An Enterprise Worksheet In Full Budgets

  1. Start in the Worksheet menu mceclip1.png
  2. Click Standard Setup mceclip2.png
  3. Enter the Name of the Worksheet Group (e.g. Sheep March 19 - Feb 20) 
  4. Enter the Enterprise Type (e.g. Stock)
  5. Select the Worksheet Group (e.g. Sheep) 
  6. Select First Month (e.g. March 2019) 
  7. Click mceclip3.png tick or press F10 to save 
  8. Refer to the example below on how to create a Standard Worksheet: 
    mceclip4.png
  9. Using the same method as above and whilst in the setup area, create all worksheets that will be required for your budget e.g. Crop, Cattle, Fixed Costs etc. 
    • Name: Crop Mar 19 - Feb 20
      Enterprise Type: Crop  
      Worksheet Group:
      Crop - All Sales: Multi: GIC 
      First Month:
      March 2019
    • Name: Fixed Costs Mar 19 - Feb 20 
      Enterprise Type:
      Fixed Costs
      Worksheet Group:
      Fixed Costs
      First Month:
      March 2019

  •  Custom Setup allows you to design your own worksheet group. It is recommended that you only use this function if your consultant uses a specific set of worksheets.
  • To see more standard worksheet groups than those listed, uncheck the Show Standard Groups Only box.
  • If you do not have a Wheat Loan or use the Grain Income Calculator, you can still select these worksheet groups and omit that GIC or wheat loan information or you can use Custom Setup to remove the two Grain Income sheet worksheets not required. 

mceclip0.png

Entering Worksheet Group Data 

All projected receipts and payments must be entered into the worksheets Excluding GST, Agrimaster will then calculate the GST for you.

The key to accurate worksheets is to fully complete each page before progressing onto the next. This ensures all information is included.

It is worth the effort to setup worksheets correctly for the first time. In future years, all budgets and worksheets can be copied and altered where required.

To open your first worksheet, start from the Home Page: 

  1. Click on Budget mceclip5.png
  2. Click on Full Budget mceclip6.png
  3. Click on Worksheets mceclip7.png
  4. Click on Open mceclip8.png
    mceclip10.png

  5. Select required Worksheet from list 

mceclip0.png

Please Note:

  • When entering data into worksheets, ensure doubling up of data does not occur. (e.g. if you record your Stock Valuations in the Sheep/Cattle worksheets, don't enter this data in the Assets & Liabilities worksheets as well. 
  • Ensure you click the green tick or press F10 to save every 5-minutes or data may be lost. 
Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments