Calculate Leave Hours Automatically

Let UpSheets calculate leave hours based on employee setup in Xero and working days in the period.

Using Ignore Types with Smart Formulas

Exclude specific type values from CSV imports so those rows are not imported, validated, or uploaded to Xero.

Can I upload Draft Timesheets or Approve them after upload?

How to upload timesheets as draft or approved to Xero, and how to approve all after upload.

Can I add comments to my file or have UpSheets ignore certain rows?

UpSheets ignores rows where the first cell is empty or starts with #, so you can add comments or calculations.

Load earnings for payslips as timesheets in the same file

How to have UpSheets treat earnings lines as timesheets instead of payslips when both are in one file.

Automatically Calculate Start and End Times Using Hours

Use a default start time so UpSheets generates start_time and end_time from an hours column when using Smart Formulas.