-
Accounting Dashboard
-
General Accounting Set up
-
Analytic Accounts
-
Chart of Accounts
-
Day to Day Transactions
-
Sales
-
Banks & Bank Reconciliations
-
Fixed Assets
-
Year/Month End
-
Reports
-
Purchase Order approval
-
POS
-
POS Reconciliations
-
Purchasing
-
Non stock purchasing
-
Expense Module
-
Shopify Sales
-
Invoice Reminders
-
Customer Statements
-
Tax
-
Supplier Batch Payment
-
Product Categories
-
Inventory Valuation Journals
-
Analytic Accounts
-
Rebates
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. log in to your Shopify account and download the Shopify order report
01.Go to Analytics> Reports> Summary> Filter the Month> Total Sales
02. Once you have clicked 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 the 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 in the pivot.
07. Now you can create a summary as shown below with the pivot table and find the total variance by bringing the odoo amounts for each line (shown in the table at left is the 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 you're in an NZ file.
4. Also you can save the filter under favorites for your future reference
5. Next you can filter the period by the Filter option as shown in the image below
6. Now you can select all the orders at once by ticking the box next to the 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 lookup and creating 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
Views | |
---|---|
106 | Total Views |
1 | Members Views |
105 | Public Views |