Users must provide the Sera Team with a copy of their data entered in our Data Templates to import data into Sera. To obtain the templates, contact your account manager at Sera or email help@sera.tech
Follow the instructions below to extract data from your old system, and use the information to populate the templates given to you by your account manager.
Customer Export - need two reports: Customer List and Service Location List
Customer List
Click Reports in the header. Select Reports Dashboard from the dropdown menu.
Scroll down to find List Reports. Click Custom under Customer List.
Enter Start Date and End Date in Customers Created Between field. You can use 01/01/1901 as start date to be sure to capture all data.
Client should decide if they would like to include Inactive Customers in their Sera account.
Select Columns to Include In The Report — Move all Available Options to the Selected Options column by using the >> button. You may have to click on the first option (Account Number) then click the >> button.
Scroll down to select Report Type as Excel.
Click Generate Report.
The Report will generate and automatically download.
Service Location List
-
Remain on the Reports Dashboard.
-
Under List Reports, click Custom under Customer Service Locations.
- Enter Start Date and End Date in Customers Created Between field. You can use 01/01/1901 as start date to be sure to capture all data.
- Client should decide if they would like to include Inactive Customers in their Sera account.
- Select Columns to Include In The Report — Move all Available Options to the Selected Options column by using the >> button. You may have to click on the first option (Address 1) then click the >> button.
- Scroll down to select Report Type as Excel.
- The Report will generate and automatically download.
Jobs/Invoice
All Sales Ungrouped
-
Remain on the Reports Dashboard.
-
Under the Sales Revenue Header (should be the first one), select Custom under All Sales Ungrouped.
-
Enter Start Date and End Date in Date Range field. You can use 01/01/1901 as start date to be sure to capture all data.
-
Make sure the Itemize Job Charge box is checked.
-
Click ALL checkboxes in “Where Status Is” section.
-
Select Generate Excel.
-
The report will generate and automatically download.