Skip to main content

Onboard employees in bulk

Goal​

Import multiple employees and their portal logins at once, typically during initial go-live or after a reorganization.

Option A - Employees already exist in Business Central​

Use this when employees have existing Business Central Employee cards and just need TEM enabled.

  1. From Truvio Expense Management - Overview, select Employees
  2. Click Add Multiple from the Expense Management tab in the page header
  3. In the Select Users to Add to TEM window, for each employee:
    • Confirm or set the Email
    • Confirm or create the AppsForDynamics365 login
    • Assign an Approver
    • Check the Selected checkbox
  4. Click Add TEM to Selected and confirm

Option B - Employees do not yet exist in Business Central​

Use the Copilot import to create employees from a payroll export or CSV file.

  1. From Truvio Expense Management - Overview, select Employees
  2. Click Copilot (or the import action) and attach your Excel or CSV file
  3. Copilot analyzes the file and maps columns to employee fields - review the suggested mapping
  4. If the mapping is wrong, type a correction prompt (e.g. "use the first two letters of first name + last name as employee number") and click Regenerate
  5. Review the proposed employee records and click Add Employees

Copilot accepts a simple payroll export. For example:

Employee No;Name;Email;Bank reg. No;Bank Account
1;John P. Doe;john@company.com;1233;87119212
9;Mary Poppins;mary@company.com;8211;721231

Portal logins can also be bulk-imported independently of employees - see Login list page.

After import​

Run the additional employee setup for each imported employee to set reimbursement fields (Alt. No. or Vendor No.) where required. See Add a new employee.