Data Export Instructions for QuickBooks Online

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 Contact List

1. Navigate to the Reports tab in the left-hand navigation menu.

    

2. From the drop-down menu to the right, search for Customer Contact List. Select Reports

   

3. You may need to switch to Classic View.

   

4. Select the Gear icon and select all boxes. You may need to select Show More in order to select all of the checkboxes.

1. Click on the report screen. This will refresh the report and add all of the selected columns to the report.

2. Select the drop-down arrow next to the square icon. Select Export to Excel. The report will be generated and available from your downloads.

   

Sales by Customer Detail

1. Return to Reports from the left-hand navigation menu.

2. Search for and select the Sales by Customer Detail report.

   

3. You may need to switch to Classic View again.

4. From the Report Period drop-down menu, select your date range. (All Dates or Custom - from the time their data began to the end of the current month).

5. Set the Accounting Method to Cash.

   

6. Select the Gear icon. Select Show More, and check all of the boxes.

7. Select Run Report.

8. Select the drop-down arrow next to the square icon. Select Export to Excel. The report will be generated and available from your downloads.