When setting up your OdooCloud, you will likely have data to migrate over from your existing system, whether this is another accounting system, a set of spreadsheets, or paper records.

Your existing data can be imported to OdooCloud Accounting by uploading a set of spreadsheets or CSV files.

If you have an OdooCloud Plus or OdooCloud Premium package, we can help you move your data across. Contact support to find out more.

Customers and suppliers

Before you import customer and supplier records, we highly recommend performing a data cleanse exercise to remove any unneeded or duplicate records.

Stock

Accounting entries related to stock are dealt with as part of the general nominal transactions.

Details of owned stock can be migrated via a spreadsheet import. Stock loaded from a spreadsheet will need to be reconciled to the nominal balance.

Bank statement reconciliation

At the point of migration the nominal bank account in the old system should be reconciled to the bank statement prior to the TB export.

The opening nominal balance for the bank accounts will be included in the opening TB.

The balance of the nominal bank accounts in OdooCloud after migration should therefore agree to the bank statement as at the point of migration.

Opening balances

Opening nominal balances are migrated via a spreadsheet import.

Balances from the old system nominal codes will need to be mapped to the new chart of accounts before the TB is imported.

Sales ledger open items import

The opening nominal balance of the sales ledger will be included in the opening TB.

The balance of the sales ledger at the point of migration will be journalled to a suspense account. All open sales ledger items will also be journalled between the sales ledger control account and the sales ledger suspense account. The sales ledger suspense account can then be reconciled.

Unreconcilied items may relate to customer deposits.

Purchase ledger open items import

The balance of the purchase ledger at the point of migration will be journalled to a suspense account.

All open purchase ledger items will also be journalled between the purchase ledger control account and the purchase ledger suspense account. The purchase ledger suspense account can then be reconciled.

Migration reconciliations

Reconciliation:

  • Stock reconciliation
  • Sales ledger suspense account reconciliation
  • Deposits reconciliation
  • Purchase ledger suspense account reconciliation