How to do a Shopify Vs Odoo Order Reconciliation

The main purpose of this reconciliation is to identify whether the orders in shopify are available in Odoo and vice versa

1. Login to you shopify account and download the shopify order report 

01.Go to Analytics> Reports> Summary> Filter the Month> Total Sales 

02. Once you have click on the Total sales you will have the option to Export

03. Click on Export and select the Full report option and again click Export in this pop up window

04. This is how your exported sheet will look like, now you can select all and generate a pivot table

05. To create the Pivot table in excel, Click on pivot table, click OK on the pop up window (default settings can be used in this window)

06. Select the orders for Rows & Total sales for Values in order to get the order reference and total sales value int he pivot.

07. Now you can create a summary as shown below with the pivot table and find the total variance  through bringing the odoo amounts for each lines (shown in the table at left is reconciliation for Odoo vs shopify)

To bring the odoo report, you have to,

2. Download Odoo order details

01. Go to Odoo Dashboard > click on Shopify Module

02. Click on Sales> Orders

3. Now create a filter for shopify instances of OPC NZ if your in NZ file. 

4. Also you can save the filter under favorites for your future reference 

5. Next you can filter the period by Filter option as show in the image below

6. Now you can select all the orders at once by ticking the box next to Order number and click on Action and Export

7. Then select the "order report template" and click on Export (Please note template is already saved for you)

8. This is how the exported report will look like and you can summarize the sheet and get the total 

9. Next, you can bring the details for a new column in the previous summary sheet we created for the shopify orders by doing a vlookup and create a variance column to find the variances. 

You can create a formula in column D as  =(Column B-Column D) to find the variance, also if there is any variances you may have to do the reconciliation other way around too. Odoo vs shopify as shown in the table on left

10. Finally you can bring the reconciliation part including variance to your reconciliation summary report