Setup The default behaviour when using smart formulas is to treat all lines as smart formulas. This is shown in the smart formla settings as Allow Types: https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/8jCYN3OMxx/allow%20types.png (allow types) If you wish to upload nother earnings types along with this, select the option Allow All Types and Save Types For this feature to work, you must supply a Type column in your file to match against your Xero pay items. Any Types that match this column (or have been mapped to one) will be treated normally and not processed as a Smart Formula. https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/KoSXHAVvpw/type%20selection.png (type selection) Hours You can optionally select an Hours column to use values from another column than the start/end times. If a value is present in the hours column, this will be used for the non smart formula types. If no value is present, the start/end times will be used to calulate it. If they are missing an error will be given.