Day Book Report Pro
The classic accountant's day book, rebuilt for Odoo 19. One wizard, three outputs: a professional PDF, a fully formatted Excel workbook, and a live preview grouped by day - with opening balances, daily totals and a journal summary built in.
See it in action
One wizard, three outputs
Real screenshots from a running Odoo 19 database - nothing mocked up.
The wizard. Pick a date range, target moves (posted or all), and optionally narrow by journals, accounts or partners - leave any filter empty to include everything. Then choose your output: Print PDF, Export to Excel, or Preview Entries.
The PDF. A4 landscape with your company header, a shaded header row for every day showing that day's debit, credit and net, a running balance column, grand totals, and a journal summary on the last page. The column header repeats on every page.
The Excel. Not a CSV dump: frozen header row, autofilter on every column, real date cells you can sort and pivot on, styled day and total rows, wrapped labels, and A4-landscape print setup with the header repeating on each printed page.
The live preview. One click opens the exact filtered journal items grouped by day, each group with its own debit/credit subtotal. Expand a day to drill into the lines, or switch to pivot and graph views - all before printing anything.
What's inside
Key features
Everything a day book should do, without configuration.
Professional PDF
A4 landscape QWeb report with day headers, daily totals, grand totals and your company branding - ready to file or share.
Real Excel, not a dump
Frozen panes, autofilter, true date cells, currency formats and print-ready page setup. Open it and start working.
Live preview
Filtered journal items grouped by day with subtotals - list, pivot and graph views, read-only and safe.
Opening balance
Select accounts and the report computes the balance brought forward before your start date, plus the closing balance.
Powerful filters
Date range, journals, accounts, partners and target moves (posted or all) - combine them freely.
Journal summary
A per-journal recap of entries, debit and credit at the end of both the PDF and the Excel for a quick sanity check.
Getting started
How it works
Go to Accounting - Reporting - Day Book.
Pick the date range, journals, accounts, partners and target moves. Leave a filter empty to include everything.
Print PDF, Export to Excel, or Preview Entries to explore the data live inside Odoo.
Under the hood
Technical notes
- Depends only on the standard account module - no other apps required.
- Works on Odoo 19 Community and Enterprise, On-Premise and Odoo.sh.
- Respects accounting access rights - available from Billing level up.
- Multi-company safe: the report always runs in the selected company only.
- Clean code, no core overrides - installs and uninstalls without side effects.
MM Solutions
Odoo technical-functional consulting - custom development, localization, migrations and App Store modules. Built by a senior Odoo consultant with 10 years of experience across Odoo 16 to 19.
Need a custom report, a localization, or support on this module? Write to us - we usually reply within one business day.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 564 |
| Technical Name |
mm_day_book_report |
| License | LGPL-3 |
| Website | mailto:midhunmmkmr@gmail.com |
Please log in to comment on this module