Salaries & Wages Worksheets

Use the Salaries & Wages Fixed Cost worksheet to track staff costs across your business. Enter a summary for the staff who works in your business if the person’s employment costs have not been entered into a specific enterprise. If you have already entered an employee working with your sheep enterprise, do not enter that employee here. 


1.    Particulars


Type the staff member’s name (recommended) or role such as “Farm Manager”.

2.    Employment Basis


Type the employment type such as full time, part time or casual.

3.    Number Work Periods


Type the number of weeks or months the staff member receives pay.

  • For example, 1 year of full time employee is 52 weeks.

4.    Cost per Work Period


Type the amount of money paid to this staff member per period.

  • In this example, 700 per week.

5.    Total Cost


Agrimaster calculates the total payments for the year to this staff member (before superannuation) by multiplying:

  • Number Work Periods x Cost per Work Period

6.    % Tax Deducted


Look at the ATO website for the tax withholding rate for this staff member. Type the percentage as a 2 digit number (not as a decimal).

  • For example, 20% is typed as 20.

7.    Tax Deducted


Agrimaster calculates the total amount of tax withheld from this staff member’s pay for the year.

8.    Month F5


Press F5 and select the details for paying the tax withholding to the ATO:

·         Frequency of your BAS (Business Activity Statement) payments.

·         First month payment will be sent to the ATO.

·         Cost Code and Bank Account.

In this example, a Quarterly BAS with the first payment being sent in April. The Costs are booked to Wages Tax Deducted and paid from the Farm Cheque Account (more below).

9.    Net After Tax


Agrimaster calculates the total pay for the year to the staff member after taxes have been withheld.

10.  Month F5


Press F5 and select monthly (recommended) and the first month this person gets paid. If your staff are paid weekly or bi-weekly, use monthly.

11.  % Superannuation


Type the superannuation guarantee percentage rate for this year as a number with decimal places.

  • An example would be to type 10 for 10%.

12.  Total Superannuation


Agrimaster calculates the total superannuation to be paid for the year by multiplying the Total Cost x % Superannuation. 

13.  Superannuation Months


Press F5 and choose the details for the payment of the superannuation:

·         How often the superannuation payment(s) are made?

·         First month of payment.

·         Cost Code and bank account. 


F5 Quarterly Payment of Withholding Tax

  1. Click in the Month F5 box after Tax Deducted. 
  2. Press F5 and select the following: 
    • Distribute - select Quarterly.
    • First Month - click on the first month of your first BAS and payment to the ATO. 
    • Select Code - choose Wages Tax Deducted.
    • Select Bank - click on the Bank Account. 
  3. Click on green tick. 

F5 Payment of Weekly, Bi-Weekly or Monthly Wages

Choose monthly distribution for staff who are paid weekly, bi-weekly or monthly. The smallest measurement and comparison for the worksheets and budgets is monthly. 

  1. Click in the Month F5 box after Net After Tax. 
  2. Press F5 and select the following: 
    • Distribute – select Monthly.
    • First Month – click on the month after the start of your budget year.
    • Select Code – choose Sala­ries / Wages.
    • Select Bank - choose the Bank Account that the pay is made from. 
  3. Choose the first month after your budget year starts for full time staff. In this example, the worksheet starts in February, so the first month will be March. 
  4. After all the data is entered, click on the green tick to save the worksheets. 
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request