Journal Entries Report in PDF and Excel
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
----------------------------------------
Keywords
journal entries report, journal audit report odoo community, print journal entries pdf,
journal report excel, sales journal report, purchase journal report, bank journal report,
general journal print, journal items report by journal, debit credit totals per journal,
accounting journal report xlsx