Smart Formulas
How to use Smart Formulas to calculate earnings rates from dates and times worked (overtime, penalties, public holidays, breaks).
Uploading Smart Formulas with other Types (Earnings Rates)
How to upload smart formulas together with other earnings types by using Allow All Types and a Type column.
Smart Formula Allowances (from Xero)
How to set up allowance Pay Items in Xero for use with Smart Formulas in UpSheets.
Using Smart Formulas with RDO / Rostered Days Off
How to set up Smart Formula rules to deduct RDO time from shifts and optionally accrue leave.
Using Ignore Types with Smart Formulas
Exclude specific type values from CSV imports so those rows are not imported, validated, or uploaded to Xero.
Using Public Holidays with Smart Formulas
Configure public holidays in UpSheets so Smart Formulas can select different earnings rates on those days.
Smart Formula Pay Item Defaults
How default values for new Pay Items (PAYG withholding and superannuation) are set when UpSheets is the Smart Formula source.