The Cash Book Report Odoo Never Built for Your Finance Team
Opening balance to closing balance, live on screen — grouped by journal and account, drillable to every entry, sortable, and exportable to finance-grade PDF and Excel in one click.
The problem
Odoo’s native accounting reports are built for the general ledger and trial balance — not a true cash book. Finance teams end up exporting raw journal data and rebuilding the opening balance, running total and closing balance by hand in Excel every single period. Existing cash book apps make it worse: sorting is missing or broken, drill-down is unexplained, and premium alternatives bury the report inside an 11-report suite nobody asked for.
The solution
Dynamic Cash Book Reports gives you a single, focused, on-screen cash book: opening balance, dated receipts and payments with a running balance, and closing balance — grouped by cash journal and account. Filter, sort and drill down instantly with no wizard and no reload, then export a finance-grade Excel workbook or a branded PDF whenever you need one.
Everything a cash book needs, nothing it doesn’t
Every capability below is implemented in the module.
Purpose-Built Cash Book
A dedicated report built from your cash-journal transactions: opening balance, dated receipts and payments, and closing balance — the exact deliverable auditors and finance managers expect.
Live, Instant Filtering
Change the date range, journal or account and the report updates immediately on the same screen — no modal wizard, no page reload.
Running Balance, Every Line
Every transaction carries its cumulative cash position, so balance movement is visible at a glance without manual calculation.
Two-Level Drill-Down
Expand from journal to account to the underlying journal entries, with clear chevrons and a breadcrumb trail — no guessing where to click.
Real Sorting, Every Column
Sort by date, partner, account or amount with a visible active-sort indicator — the single most requested fix competitors still ship broken.
Grouping by Journal and Account
Review cash activity by source: group movements by cash journal, then by account, for a structured view of every cash position.
Posted vs. All Entries Toggle
Switch between posted-only and all entries (including drafts) to reconcile before and after posting, without leaving the report.
Multi-Company Consolidated Reporting
Consolidate cash book data across companies for groups and accounting firms managing multiple entities from a single view.
Finance-Grade XLSX and Branded PDF Export
Export a formatted Excel workbook with headers, currency formatting and totals, or a company-branded PDF ready for management, auditors or clients.
How it works
Open Cash Book
Go to Accounting > Reporting > Cash Book to launch the interactive report.
Filter and Group
Pick a date range or preset, choose journals, accounts and posted/all status — the report updates instantly.
Sort and Drill Down
Click any column to sort, then expand journal and account rows down to individual entries.
Export and Share
Download a finance-grade Excel workbook or a branded PDF for management, auditors or clients.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
The app works on both Community and Enterprise editions, with builds available for Odoo 19, 18 and 17.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Dynamic Cash Book Reports
A purpose-built cash book with opening balance, running total and closing balance on every line, live filtering, real sorting on every column, two-level drill-down and finance-grade XLSX and branded PDF export.
Buy on Odoo App Store