Account Day, Bank Book ,Cash Book Excel Reports
by SprintERP Technologies https://sprinterp.com$ 4.96
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 371 |
| Technical Name |
se_account_book_excel_report |
| License | LGPL-3 |
| Website | https://sprinterp.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 371 |
| Technical Name |
se_account_book_excel_report |
| License | LGPL-3 |
| Website | https://sprinterp.com |
Account Day, Bank Book & Cash Book Excel Reports
Generate Day Book, Cash Book, and Bank Book Reports in Excel and PDF format natively with advanced grid layouts.
Key Module Highlights
Account Day, Bank Book & Cash Book Excel Reports
Access Daily Accounting Reports
Navigate to the Odoo Invoicing / Accounting application, click on the top Reporting main menu navbar, and look under the dedicated Daily Reports section panel. From there, select your desired workflow action shortcut: Cash Book, Bank Book, or Day Book to initiate the processing wizard.
Key Logic: These dynamic daily ledger menus are systematically inherited and placed natively inside the default accounting structures under the standard **`account.menu_finance_reports`** parent node path for fluid structural visibility.
Define Filtering Parameters on Reporting Wizard Overlay
The transient "Account Book Wizard" popup framework provides precise operational controls to segment records. Configure target ledger entries via Select Target Moves (Posted vs All), choose sorting layouts under Sort By, specify absolute timeframes through Start Date / End Date fields, and filter using deep relational multi-tag fields for specific Accounts or Journals.
Key Logic: The wizard executes structured ORM search criteria over account.move.line
models, dynamically pre-populating target operational ledger cash/bank parameters using
smart model contextual default functions (_get_default_journals).
Generate and Audit Professional QWeb PDF Reports
Clicking the primary "Print" action button instantly renders a presentation-ready QWeb PDF Document. The document inherits corporate branding metrics from the company master file and dynamically renders precise data grids comprising essential ledger points: transaction Date, Partner, source journal Move, Debit, Credit, and an accurate, automated mathematical Running Balance column ending with aggregate summaries.
Key Logic: The reporting template processes mathematical iterations securely using an
abstract report backend model (report.se_account_book_excel_report.report_account_book_tmpl)
that pre-computes balance matrices line-by-line before injection.
Instant Spreadsheet Generation & Native Inline Download Panel
When clicking on the secondary primary action button "Print Excel", the background
controller instantly triggers the advanced xlsxwriter engine to build a structural
spreadsheet asset. Instead of forcing heavy screen reloads, the module utilizes an inline "File
To Download" binary action widget panel on the current view state with an automatically
computed localized name string pattern.
Key Logic: The file object is converted into standard base64 formats inside system
memory, safely written to transient fields, and returned back via a targeted window
framework refresh context overlay action (ir.actions.act_window).
Audit Analytical Ledgers inside Tailored Excel Layouts
Open the downloaded spreadsheet to inspect a beautifully structured corporate template grid. The top section incorporates a dedicated metadata workspace mapping Start Date, Sorted By parameters, End Date blocks, target Journals string matrix, and active Target Moves criteria. Below it, data records line up matching exact column alignments with numeric precision cells for Debit, Credit, and dynamic Balance summaries.
Key Logic: The template structure maps to your custom backend workbook parameters:
institutional dark headers (#595959), secondary accent bands
(#bfbfbf), automated floating decimal structures (#,##0.00), and
hardcoded row-span total metrics.
Isolated Bank Book Mode Processing Workspace
When triggering the "Bank Book" action menu link, the wizard automatically switches its interface mode. It dynamically executes a backend filter pre-populating institutional banking assets under the Accounts many2many tag block (e.g., Bank and Bank Suspense Accounts) alongside corporate institutional banking codes inside the Journals filtering matrix.
Key Logic: The system utilizes dynamic environment dictionary checking functions
(self.env.context.get('default_report_type') == 'bank_book') inside Python data
models to separate liquid asset structures from regular ledger entries.
Audit Institutional Transactions via Account Bank Book PDF Layout
The rendered Account Bank Book QWeb Document cleanly compiles all bank-related journal entries within the specified parameters. It displays structured data lists that automatically break down bank fees, prepayments, interests, and corporate invoices into granular line-by-line debit and credit listings, allowing auditors to verify balancing totals at a single glance.
Key Logic: Balance allocations automatically adjust line-by-line using your internal
math parser (running_balance += (line.debit - line.credit)), evaluating overall
structural company balances at the bottom row.
Generate Institutional Account Bank Reports in Spreadsheet Formats
Triggering the "Print Excel" primary button from the bank context wizard instantly
creates an optimized, formula-ready .xlsx workbook asset. The engine dynamically
sets a structural download filename string incorporating the active report classification
alongside user-defined time bounds (e.g., Account_Bank_Report_2026-05-01_to_2026-06-11.xlsx)
within an inline downloader panel.
Key Logic: The underlying print_excel_report controller reads contextual
parameters, maps institutional banking data blocks, packages them into an in-memory byte
stream (io.BytesIO), and surfaces the binary object for effortless asset
compilation.
Analyze Bank Ledgers inside Custom Excel Spreadsheet Formats
Open the exported workbook to analyze a highly polished corporate Account Bank Report sheet layout. The template features institutional headers grouping your dynamic parameters: selected Start Date / End Date blocks, active Sorted By logic (Partners & Journals), target filtering Journals, and entry state modes. The row parameters auto-scale to display banking entries, transaction references, partner identities, precise decimals, and line-by-line Balance totals ending with matched aggregates.
Key Logic: The layout uses automated cell alignment frameworks matching custom xlsxwriter
workbook configurations: auto-fitting columns (worksheet.set_column),
highlighted totals (total_format), and structured cell boundaries for flawless
structural compliance.
Comprehensive Chronological Day Book Processing Dashboard
When launching the core "Day Book" workflow action, the reporting overlay aggregates a broader analytical spectrum. By default, it spans across multiple standard operational journal categoriesâincluding Customer Invoices, Vendor Bills, Bank, Cash, Miscellaneous Operations, and Exchange Differencesâto construct an extensive everyday audit trail worksheet.
Key Logic: If no specific manual journals are highlighted within the many2many
selection framework, the backend reporting python method defaults to a fallback listing
("INV, BILL, BNK1, MISC, CSH1...") ensuring full ledger structural
completeness.
Audit Chronological Operations via Account Day Book PDF Layout
The rendered Account Day Book QWeb Document provides an extensively combined overview of everyday operations. It brings together multi-journal activitiesâincluding Miscellaneous Operations, bank transaction adjustments, vendor listings, and corporate bill distributionsâinto a single chronological dataset. This layout calculates rolling adjustments fluidly, enabling accounting managers to oversee total daily movements effortlessly.
Key Logic: The underlying abstract report framework parses structural move records
seamlessly, executing aggregate balance computations across diverse account lines (total_debit
and total_credit) to ensure maximum ledger auditability.
Generate Comprehensive Account Day Reports in Spreadsheet Formats
Triggering the "Print Excel" primary button from the day report context wizard instantly
processes an extensive operational ledger asset. The underlying engine aggregates multi-journal
information blocks and maps them into an active download naming template containing structural
bounds (e.g., Account_Day_Report_2026-03-01_to_2026-06-11.xlsx) available for
immediate extraction right from your current screen.
Key Logic: The wizard executes localized data grouping pipelines, calling the central
xlsxwriter memory layout to write broad transactional streams securely,
avoiding background query bottlenecks or duplicate execution parameters.
Audit Full Chronological Ledgers inside Day Book Excel Formats
Open the exported spreadsheet to analyze a highly granular corporate Account Day Report worksheet. The top metadata table clearly maps your dynamic parameters: selected Start Date / End Date bounds, active Sorted By configurations (Dates vs Partners/Journals), fallback journal lists, and entry targets. The central grid populates comprehensive transaction linesâcalculating precise rolling adjustments line-by-line across multi-journal debit/credit streams and wrapping up with unified group summaries.
Key Logic: The reporting framework structures text cell wraps
(data_wrap_format) alongside strict double-decimal configurations (num_format)
dynamically driven by the backend python engine to ensure zero alignment breaks across
thousands of ledger line rows.
Key Features & Capabilities
Empower your financial auditing workflows with automated ledger classifications and native multi-format spreadsheet generation tools in Odoo.
Tri-Book Reporting Architecture
Isolate accounting workflows natively with automated sub-ledgers supporting chronological Day Books, liquidity Cash Books, and verified Bank Books.
Advanced XLSX Grid Formatting
Utilizes spreadsheet frameworks with structured metadata grids, custom cell borders, corporate accent headers, and automatic column widths.
Dynamic Running Balances
Computes immediate mathematical running balances line-by-line across all debit and credit journal entries directly inside the sheet.
Granular Analytical Filters
Drill down into financial statements instantly by selecting flexible Date Ranges, Target Entry States (Posted vs All), specific GL Accounts, or Journals.
Strict Validation Controls
Built-in system alerts prevent empty ledger prints and display clean technical user error validations when data matching rules fail.
Fluid Wizard UI & Downloads
Modernized transient overlay framework supporting instantaneous inline base64 spreadsheet downloads directly within the active screen panel.
Need Any Help?
Installation, Configuration & Bug Fixing support from our experts.
© 2017 SprintERP Technologies. All Rights Reserved.
Please log in to comment on this module