Skip to main content

​
Check Items to Import first

On the Import screen, under Items to Import, select only the transaction types you are uploading in this file (Timesheets, Leave, Payslips, and Projects when available). Those choices determine which fields are required and how each row is classified. Selecting a type you are not using can make the expected layout stricter than your file, which often leads to Unable to determine transaction type on every line. See Import Options for the full list of options and how they interact with column mapping.

​
Check your file and mapping

After Items to Import matches your data:
  • Ensure required columns for the selected types are present and mapped on the Validate screen (for example Type when File contains Earnings Rate is selected for timesheets).
  • Use a sample file from the Import screen so column headings align with what UpSheets expects for your organisation and country.
  • If you combine multiple transaction types in one file, include the columns for all selected types and leave unused fields blank where the format guide allows—see Multiple Types (NZ/UK) or Multiple Types (Australia).
Use the Select or Map links next to the message in the app to set or map the type for specific rows when the automatic detection is wrong.