Bulk update Award Position Meal Allowance Rates

Manage your position meal allowance rates in bulk

Depending on your Award or Agreement, your positions might trigger specific meal allowances for your employees based on the amount of overtime worked. 

As these allowances are set within your Award's pay rules for each position. Managing them one by one could become tedious, using our CSV Import, you can manage your meal allowance rates quickly and in bulk. 

In this guide, we will cover:

• How to manage and update your position meal allowances in bulk
• The data validation required for a successful update

  Permission Reminder: To action this, you will need to have "Access CSV Import" enabled in your user permissions.

Bulk update Meal Allowance rates

To simplify the process, you might want to update your position meal allowance rates in bulk. This can be accomplished through our CSV Import page. 

Here are some key reasons to consider using this import:

• • To revise the allowance charge rate billed to your clients (Operations)
  • To obtain a comprehensive view of the allowance rate across all your positions and awards 
  • The allowance pay rate has risen due to the Fair Work annual wage increase, and needs to be updated. 

  Please note: If you are updating your meal allowance due to the new financial year rate increase, it is recommended to do this via our Rate Rise tool, where you can also update all your classifications and position rates. 

To use the CSV import:

1. From your main menu, navigate to Import/ Export and select CSV Import.
   
   

   

2. From the drop-down menu, select Award Position Meal Allowance Rates (From Export).
3. Select Export All Award Position Meal Allowance Rates to download the CSV file with the complete list of rates.
   
   

   

4. Within that downloaded file, update your rates and/or charge rates and save the file. Please do not close the file until it has been uploaded to your platform. 
5. Select Choose File and find your file with the updates saved. Then, Import CSV to load your changes back into the platform. 
   • If uploaded successfully, a green bar will appear.

Data Validation

When importing data into your platform, the data must be provided in the correct format. Below, you will find all the information required about the included columns of this import and the accepted formats for editable data. 

 Please note: The bold rows in the below table denote editable columns in your export. 

Column Name	Column definition	Editable	Accepted format
Award ID	The unique ID number for the award.	N	N/A
Award Name	The name of the award.	N	N/A
Classification	The classification level of the position.	N	N/A
Position Name	The name of the position.	N	N/A
Day	The day type on which the meal allowance is set. E.g. Weekday, Saturday, Sunday or Public Holiday	N	N/A
Type	What triggers the allowance. E.g. Total hours worked or Overtime hours worked.	N	N/A
Hours	The total hours worked that are needed to trigger the allowance.	N	N/A
Pay	The rate at which the allowance is paid.	Y	Numerical No symbols E.g. 20.50
Charge	The rate at which the allowance is invoiced to clients.	Y	Numerical No symbols E.g. 20.50
Record ID	ID number for the allowance.	N	N/A