Automatic Leave Hours Calculation

UpSheets can calculate leave hours using the employee setup in Xero and the working days in the given period. The hours column becomes optional – if included, it will override the calculated value.

Setup

To enable this feature, go to Settings and enable Leave > Calculate Leave Hours Automatically.

Note: For this feature to work, the Pay Item for Annual Leave must be named "Annual Leave". If you have modified this value, please contact us for advice.

How It Works

When importing a file that includes Leave, the Hours column on the validation screen will display as Hours* and be optional.

• Hours provided – UpSheets uses the value you supply
• Hours empty – UpSheets calculates the hours automatically

When the file is validated, the number of hours is calculated using the employee setup in Xero and the number of working days between the date and end_date of the imported line.

If the dates cover multiple pay periods, the calculation includes the appropriate amounts based on the number of days in each period (these will often differ for monthly employees).