Migrating to Odoo Accounting Process



  1. Map and Upload Clients Chart of Accounts
    1. Make sure to create a new "opening entry clearing account" that can be marked as an asset and need to have "can be reconciled" as true
    2. See Video: https://somup.com/cTVrniKVMm
  2. Create a new product called "Opening Entry". 
    1. Make sure it is a service, and map the income and expense accounts to the Opening Entry Clearing Account
  3. Create the Opening Entry Mapping file and Upload see: https://somup.com/cTVub9KDvu
    1. Export final Chart of Account list on page 2 to use for mapping
    2. Enter the Opening balance values from the trial balance on Page 1
    3. Map the Old Chart of Accounts to the new Chart of Accounts
      1. The following accounts should be mapped to the Opening Entry Clearing Account.
        1. Any bank/savings/cc account that will be managed by bank statements
        2. AR/AP values
        3. Inventory Values
    4. Once every open entry line has a matching chart of account, upload to Odoo and post it.
  4. Use the AR/AP mapping file to upload all open AR and AP as of the transfer date. Make sure to use the name of the Opening Entry product already created.
  5. Have the Customer connect their bank accounts as of the opening date. 
  6. Match all opening clearing entries to check for any discrepancies.
  7. Run a BS report to ensure everything matches

If the customer has inventory, additional steps must be taken to prepare inventory numbers and matching.

  1. When working with inventory, we want to make sure to setup the special location accounts. If not, we can do it afterwards, but then you have to remap any entries done before this as setup. See: https://somup.com/cTVre0KVRl