Xero2Odoo
Click here to Start
What comes into Odoo?
We will migrate your client's Xero database into an Odoo database and configure the system to as closely match Xero as we can.
With all the hard work done you can get on with implementing Odoo for your client.
Contacts
Customers
Suppliers
Contact Groups
Employees
Users
Accounts
Chart of accounts
Bank accounts
Taxes
Budgets
Tracking categories
Transactions
Invoices
Bills
Credit Notes
Refunds
Manual journals
Banking
Bank reconciliation
Payments
Bank transactions
Over-payments
Pre-payments
Bank transfers
Spent/Receive funds
Inventory
Products
Current stock levels
Quoting
Sale orders
Purchase Orders
Other
Notes/History
Files
It's in the details
At the end of each migration, you will get the following reports to give you confidence the migration is correct and reliable before you start using Odoo. If you have any questions or require any changes to the migration please reach out to us and we would be happy to help.
Trial balance report
A trial balance is done for each financial year and the balances of each account at the end of each year are compared between Odoo and Xero showing you any differences.
Product report
Every product is compared between Odoo and Xero checking the product type (Service, Inventory tracked, etc), sell price, buy price, quantity on hand, can be purchased, and can be sold values showing any differences.
Invoice report
Every invoice subtotal, amount, tax amount, total and amount due is compared between Odoo and Xero showing you any differences.
Inventory asset account report
The inventory asset accounts are compared between Xero and Odoo showing any difference in the balances. Every tracked inventory item is verified to check that the value of the stock on hand matches the value in the asset account.
Done right
All records created the Odoo way
Every record created in Odoo during the migration is created in Odoo the way it would have been done at the time just the way Odoo wants you to do it. At the end of the migration, your Odoo database will be done just right.
Below are a few examples of how the records are created in Odoo.
Please reach out to us if you have any questions or need any more details about how we migrate your data.
Invoices
Invoices are imported in Odoo as customer invoices and vendor bills. There are differences in the rounding done between Xero and Odoo which have been accounted for to ensure the migration is correct.
During the migration, the following records will be created in Odoo.
Customer Invoice / Vendor Bill - The invoice information is migrated into this record
Payment - Any amount allocated to be returned to the customer/supplier will be migrated into this record
Bank statement line - The reconciliation/payment status is migrated into this record
Bank statement - The reconciliation/payment status is migrated into this record
Payments
A payment in Xero is imported into Odoo as the following record types
Payment - The paid information is migrated into this record
Bank statement line - The reconciliation/payment status is migrated into this record
Bank statement - The reconciliation/payment status is migrated into this record
Inventory levels
When stock levels are imported from Xero into Odoo an inventory adjustment is done and if real-time stock accounting is enabled the migration will track the balance moved from the 'input account' defined on the product category and this is reversed out of the 'asset account' defined on the product category to ensure that the stock that was already present in Odoo does not change the GL when imported.
Special care is taken with which accounting journals are tagged with the product to ensure that the asset GL balance for each product is correct. This balance can be checked in the inventory asset account report generated at the end of the migration
Stock Quant - The stock on hand quantity is migrated into this record
Journal Entry - The value of the stock on hand is migrated and adjusted with an automated journal entry that is then adjusted during the migration
Employees
An employee in Odoo has several records all linked together. All of this is handled during the migration.
During the migration, the following records will be created in Odoo
Employee - The main information about the employee is migrated into this record
User - A user record is created to allow the employee to login if required
Contact - A contact is created and linked to the employee record
Private Contact - Employee home address information is migrated into a private contact and is linked to the employee and shown in the home address field on the employee record
Bank account - A bank account information is migrated into this record and is linked to the employee
Expenses
Expenses are imported into Odoo into several different records to correctly migrate the information about the expense itself but also if it was approved and paid.
An expense in Xero is imported into Odoo as the following record types
Payment - The paid information is migrated into this record
Bank statement line - The reconciliation/payment status is migrated into this record
Bank statement - The reconciliation/payment status is migrated into this record
Bank Transfer
A bank transfer between two bank accounts is migrated into Odoo as an internal bank transfer record in Odoo which will automatically create a linked second bank transfer record for the second bank account. This allows the system to track when the funds leave one account and arrive in the second account with a bank statement reconciliation for each movement.
During the migration, the following records will be created in Odoo
Internal transfer -
The transfer source bank account and value are migrated into this record
Second internal transfer -
The transfer destination bank account and value are migrated into this record
Source Bank statement line -
The reconciliation/payment status is migrated into this record
Source Bank statement -
The reconciliation/payment status is migrated into this record
Destination Bank statement line -
The reconciliation/payment status is migrated into this record
Destination Bank statement -
The reconciliation/payment status is migrated into this record
Credit Note
Credit notes are created in Odoo as a credit note and special care is used to ensure that it is correctly applied to an invoice or returned to the customer/supplier. The correct amount is applied as credit even in complicated cases of partially applied credit notes across several invoices and balances returned to the customer.
During the migration, the following records will be created in Odoo.
Credit Note - The credit information is migrated into this record
Payment - Any amount allocated to be returned to the customer/supplier will be migrated into this record
Bank statement line - The reconciliation/payment status is migrated into this record
Bank statement - The reconciliation/payment status is migrated into this record
