How to confirm the migration is correct

What is it for?

After each import, the import log says who imported, when, which file and how many records went in. With it and with the trial balance, you confirm that what is in Odoo is what came out of the previous software, before you start working on top of the balances.

When to use it?

• Right after importing the opening balances or the open documents.
• When someone asks “has this file already been imported?” or “who imported this?”.
• Before you consider the migration finished and post the first month of movements.

Where to find it?

Accounting › Configure › Migration and imports › Data import log and, for the trial balance, Accounting › Review › Books and trial balances › Trial balance.

Before you start

• Your profile is Fiscal officer or Administrator: with the Accountant profile, the Migration and imports menu does not appear (the trial balance is still available).
• The log shows only the company you are working in. If you migrated more than one company, switch company and open the log again.
• Have the previous software's trial balance for the same date at hand.

How to use it

1. Open Data import log. Each import is a line, with Date/time, User, Import type, Target model, File, Records created, Records rejected, State and Company. Confirm that the State is Done and that the file is the one you expected.
2. Open the line. The form shows the company, type, state, file, the File SHA-256, the Records created, the Records rejected and the Note, for example “Pending documents import (01/01/2026)”. The SHA-256 identifies the exact content of the file: two files with the same name and different contents have different SHA-256 values.
3. Open the journal entry created and confirm that it is Posted. A draft entry does not count in the trial balance.
4. Open Trial balance, choose Year and the opening year, and compare each class with the trial balance of the previous software. The message Debits = credits next to the title must appear. With the opening dated on the first day of the fiscal year, the imported amounts appear in Movements of the period, not in Opening balance, which stays at zero.
5. If a total does not match, go back to the source file, work out the difference per account and fix the cause (see “Common problems”).

Expected result

• All imports have the state Done, with Records rejected at 0.
• Each total in the Odoo trial balance equals that of the previous software on the same date.
• Each opening entry is Posted.

Important notes

• Records created counts journal entries, not file rows: the example file with 3 open documents gives Records created 1, because the 3 documents go into a single entry.
• The log only shows imports that ran. A check that failed (“N problem(s) found in the file. Nothing was saved.”) leaves no line: if the file never got past the check, there is nothing in the log.
• The log does not see what was posted by hand after the import. Use the trial balance for that.

Common problems

The trial balance is empty, or without the opening

• Cause: the opening entry is in Draft, or the selected company is not the one that imported.
• What to do: open the entry and click Publish; confirm the company in the top-right corner.

I do not see the “Migration and imports” menu

• Cause: the Accountant profile does not have it.
• What to do: ask someone with the Fiscal officer or Administrator profile.

The same file appears imported twice

• Cause: the import was repeated after the warning “This exact file was already imported on …”. The log has one line per import: two lines with the same File SHA-256 are the same file imported twice.
• What to do: open the two journal entries and deal with the duplicate before continuing; the balances would be doubled.