Last updated: August 17, 2020
Importing employee data from MS Excel allows you to quickly and easily add employee budget lines to your budget. You can build a budget and import employee data from Excel, or you can import data from Excel at a later time.
💡 Download the Employees Excel CSV file to assist you with preparing the employee data you intend to import to SIP from Excel.
Employee budget lines can be added to any Salary & Wages budget groups under Cost of Revenues or Operational Expenses. (See Getting started with employees for more information.)
📝 If a Salary & Wages budget line does not exist, you must add one before you can import employees.
To import employees from an MS Excel file:
1. In the Salary & Wages group, click on the + icon to the right of the Salary & Wages budget line, or click on the ellipses and select Import.
2. Click Import from the Salary & Wages window to add employees using the Import tool.
3. Locate the Excel file from which you want to import employees and drag the file to the upload window, or click on the link to browse for the file you want to import.
4. Select the relevant sheet from the Excel file, the header row which serves as the column names and the main column which serves as the employee names. These selections are made automatically by Sage Intacct Planning (SIP) but may be incorrect, so you can change them manually. Click Next.
5. From the Data tab, select the row data to import or you can select all. The selected rows appear as employee budget lines in SIP. Click Next.
6. Select the columns from which you want to import data. Click on the dropdown to select from the options where you want to map the data in SIP. The dropdown options include the fields that you can find in the Employee template, such as: Role, Start date, Base salary, Currency, Dimensions data and more.
For example, let’s say you want to import the employee base salary. From the Map to dropdown, you can choose Base Salary (Monthly) if you want the base salary amount to represent the monthly salary, or you can choose Base Salary (Annual) if you want the base salary amount to represent the yearly salary.
You can also import salary data for a date range. For example, if your Excel file contains monthly salary information according to a date range, SIP recognizes this as a date column and gives you the option to automatically select additional date columns.
If you click Yes, all of the date columns are selected, and SIP automatically maps each column to the relevant date. You can also shift the dates, and SIP automatically adjusts to the change.
7. Click Next to preview the data before you import it into your budget.
8. Click Import and the employees appear in your budget. For those budget lines that require some form of calculation or attention, a No data label may appear next to the budget line.
You can run the import process as many times as needed. If you’d like to import data again, click on the ellipses and select Import.