How to do a Odoo Sales Order Vs Invoice Reconciliation

We are doing this reconciliation to make sure that all the orders have a related invoice created inside the Odoo

To do this,

1. Download the Odoo invoice report

01. Go to shopify module and Click on Sales > Invoices


02. Create a filter as sales team & OPC NZ Live to filter the orders of NZ live site 


We are selecting the Sales team to filter because, if you click on one of the invoice and check under the other info, Sales team is the field where odoo has mapped the related shopify site in invoices. 


03.  Next you can filter the period using  Filter  option as show in the image below  


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


05.  Then select the  "Invoice rec template"  and click on  Export (Please note template is already saved for you)



06.   This is how the exported sheet will look like, and now you have to create a pivot table by selecting all the data

07.   Select the origin for Rows & Total signed for Values in order to get the order reference and total sales value in the pivot.

08. Now you can bring the odoo order details to the next column, through doing a vlookup to the odoo order report which you downloaded for previous reconciliation and bring the totals for both columns separately.

09. Then you have to take the invoice number to the Reconciliation summary sheet through doing a vlookup for the invoice report which you downloaded. (You can use the order reference as the vlookup field)

10. Now, you have to bring the odoo invoice amount for each invoices through another vlookup to the sheet which we created the pivot table above.(invoice report)

11. Then you have to get the total and see whether Rec summary  total and odoo invoice report total are tallying, if its not tallying you have to do the reconciliation other way around to find the error. That is,

You have to use the vlookup for invoice report to identify invoices in invoice report but not in sales order report.