Why Opening Balance Dashboard?
Migration opening balances should not live in scattered spreadsheets and manual journal entries. Manage every account from one screen, edit inline like a spreadsheet, import from Excel in bulk, and let the module automatically synchronize your opening balance journal entry â balanced, auditable, and ready to post.
Spreadsheet Experience
Inline debit & credit editing with instant save
Excel Import / Export
Professional workbook with filters & formulas
Journal Sync
One entry per company, always in sync
Powerful Migration Controls
Modern Owl Dashboard
Summary cards, grouped accounts, search, filters, and pagination for thousands of lines.
Instant Auto-Save
No page reloads. Values persist immediately and sync when totals are balanced.
Balance Validation
Live difference indicator turns green when debits equal credits â ready to post.
Smart Journal Entry
One opening balance move per company, dated on migration date, with full line sync.
Role-Based Security
Managers edit and post. Accountants view. Accounting Managers can reset posted entries.
Full Audit Trail
Chatter logs balance changes, posting, imports, and migration date updates.
Manage every account from one screen
All active balance-sheet and profit-and-loss accounts load automatically. Collapsible groups by account type, sticky headers, color-coded debits and credits, and modified-row highlighting keep large migrations organized.
- Migration date & journal controls in the header
- Summary cards: totals, difference, entry status
- Smart buttons: view entry, journal items, post, reset
- Recompute totals on demand
Bulk load with Excel templates
Export a formatted workbook with frozen headers, auto-filters, SUM formulas, difference indicators, and a live Summary tab. Fill offline and import everything back in one click.
- Wide account name column for easy editing
- Match accounts by code on import
- CSV import supported as fallback
- Validation with clear error messages
Dashboard Overview
Inline Balance Editing
Excel Export Template
Import & Bulk Update
Post Opening Balance Entry
Quick Setup Guide
Install the module
Update the apps list and install Opening Balance Dashboard.
Assign security groups
Grant Opening Balance Manager to users who will edit, import, and post balances.
Open the dashboard
Navigate to Accounting â Accounting â Opening Balance Dashboard.
Configure & enter balances
Set migration date and journal. Enter amounts in the grid or import from Excel.
Post when balanced
When difference is zero, click Post Opening Entry to create the journal entry.
Menu path: Accounting â Accounting â Opening Balance Dashboard
Yes. The module works on Odoo 18 Community and Enterprise editions.
The opening balance journal entry is synchronized automatically once total debits equal total credits. You post it explicitly using the Post Opening Entry button.
No. Enter either a debit or a credit per account. Entering one automatically clears the other.
The system prompts for confirmation, resets the entry to draft if needed, updates journal lines, and maintains accounting integrity.
Rows are matched by Account Code. Do not change account codes in the exported template. Summary and totals rows are ignored automatically.
Your Migration Control Center
One dashboard. Every account. Balanced opening entries â ready for day one accounting.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module