How to check the integrity of certified documents
What is it for?
Each certified document carries a signature that depends on the signature of the previous document in the same series. If a document were changed or deleted outside the program, the chain would break. These two screens confirm that this has not happened:
- The Certification integrity report checks, series by series, the signature, numbering and chain of the certified documents.
- The Integrity and completeness controls check the journal entries of a period: balance, totals, series consistency, signature chain and numbering, including the unjustified gaps in series imported from the previous program (see How to justify a gap in a series' numbering).
When to use it?
- Before submitting the SAF-T for a period or closing the fiscal year.
- Before and after a migration, a backup restore or a program update.
- When an auditor or the AT asks for proof that documents have not been changed.
Where to find it?
- Audit › Integrity › Check document integrity (opens the Certification integrity report).
- Audit › Integrity › Integrity and completeness controls.
The administrator also finds the first one in Settings › fiscaldoo · Certification, group Configure the certification: series and keys, line Verify integrity.
Before you start
- Your profile has the Audit app. The steps were done with Certified Accountant / Fiscal Manager with Fiscal officer. The Accountant and Billing profiles do not have the Audit app.
- You are in the right company (top right corner).
- Neither screen changes data: you can run them whenever you like.
How to use it
- Open Audit › Integrity › Check document integrity. The Certification integrity report window opens, already showing the company's result.
- To narrow the check, fill in From and Up to, choose Journals or a Series, and click Run. If left empty, all the company's certified documents are checked. Include the native hash chain? adds Odoo's own check.
- Read the sentence at the top and the table. Each line is a Series / journal, with Documents, Checked, Problems, Open gaps, Result and Detail. Series with documents also have the Documents button.
- To keep the proof, click Print PDF or Export XLSX. Click Close.
- Open Audit › Integrity › Integrity and completeness controls. Check the Company, From and Up to (they default to the start of the year up to today) and click Check again if you change the dates.
Expected result
- In the report: “All good: the 63 documents checked have their signature, numbering and chain intact.” In the demo, the series
FT D26(35 documents),NC D26(1),FR D26(2),FS D26(3),ND D26(1),FS POS26(1) andRG D26(20), each with “Chain verified”. - In the controls: Entries checked 332, Differences 0, and the sentence “No differences: the 332 entries of Empresa Demonstração, Lda from 01/01/2026 to 29/10/2026 are balanced, their totals add up, their series are consistent and the signature chain and the numbering are intact.”
- When there are problems, each screen's table gives the Control, the Document, the Series, What is wrong and What to do. Pending on-screen validation: causing a break requires changing the database outside the program, which is not done; so a result with problems has not been seen.
Important notes
- The report only sees the certified documents of the chosen company, in series that already have documents. It does not see drafts, documents from another company or documents that never entered the program (for example, manual invoices not yet recorded). A table with no problems does not prove that all the company's documents are in the program.
- The series are those in the article How to create a series and communicate it to the AT.
Common problems
The report shows fewer documents than expected
- Cause: the From/Up to, Journals or Series filter is filled in, or you are in another company.
- What to do: clear the filters, check the company in the top right corner and click Run.