-
Accounting Dashboard
-
General Accounting Set up
-
Chart of Accounts
-
Day to Day Transactions
-
Sales
-
Banks & Bank Reconciliations
-
Fixed Assets
-
Year/Month End
-
Reports
-
Purchase Order approval
-
POS
-
Purchasing
-
Non stock purchasing
-
Expense Module
-
Shopify Sales
-
Invoice Reminders
-
Customer Statements
-
Tax
-
Supplier Batch Payment
-
Product Categories
-
Inventory Valuation Journals
-
Analytic Accounts
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.
Views | |
---|---|
98 | Total Views |
1 | Members Views |
97 | Public Views |