Journal Entries Report in PDF and Excel Odoo app icon Accounting/Accounting

Journal Entries Report in PDF and Excel

Journal audit report for Odoo Community: entries per journal with debit, credit, taxes and totals, PDF and Excel

Odoo 19.0 Odoo 20.0
Journal Entries Report in PDF and Excel for Odoo 19.0 & 20.0

Odoo Community shows journal items in a list, but it has no journal document you can print, file or hand to your auditor. This module adds one: choose a period and the journals, and get every entry of each journal with debit and credit, a total per journal, the taxes used in the journal and a grand total. Check it on screen, then print the PDF or export a real Excel file.

Key Features

  • Entries per journal — Entry number, date, account, partner, label, debit and credit of every journal item, journal after journal, each closed by its total.
  • PDF and Excel — A PDF with your company header and an .xlsx workbook with a Summary sheet and one sheet per journal.
  • Tax table per journal — Base amount and tax amount of each tax used in the journal.
  • Live preview with drill-down — Entries, items, debit, credit and tax per journal before you print; one click opens the journal items of a journal.
  • Two levels of detail — Every journal item, or one line per journal entry.
  • Ready periods — This or last month, quarter or financial year, or your own dates.
  • Options that matter — Posted entries only or drafts included, sorting by date or by entry number, a foreign currency column, each journal on a new page.
  • Company defaults — Proposed period, proposed journals, detail, tax table and page break, per company.

Benefits

  • A journal you can print, sign and file at the end of each month or year
  • A workbook your accountant or auditor can open in Excel, one sheet per journal
  • Totals that prove each journal is balanced, without exporting and summing by hand
  • Works right after installation; nothing to configure

Ideal For

  • Companies on Odoo Community that keep a printed sales, purchase, bank or general journal
  • Bookkeepers who review the entries of a period before closing it
  • Accounting firms and auditors who ask for the journals of every client database

Technical Highlights

  • Reads the journal items directly; no report engine, no stored report data
  • Cash-basis taxes follow Odoo's own rule; a group of taxes is one line of the tax table
  • Multi-company and branches; amounts in company currency
  • Excel made with the library Odoo already ships; no extra Python package
  • Depends on the Invoicing app only; does not touch the Enterprise accounting reports
  • Limited to accounting roles; fully translatable

Supported Odoo Versions

  • Odoo 19
  • Odoo 20

Need a custom Odoo module?

We build tailored Odoo apps and customizations for your exact workflow. Tell us what you need and get a free consultation.