Quick facts
- Price
- $249.00 USD
- Odoo versions
- 17, 18, 19
- Setup time
- 30 min
- License
- One-time perpetual
- Languages
- 11 languages
One-time Purchase
Opening Balance Dashboard
A spreadsheet-style dashboard for entering, validating, and posting accounting opening balances in Odoo. Built to order by ECOSIRE for your chart of accounts, companies, and go-live cutover.
$249.00USD
No payment now. This sends a quote request to our team — we'll follow up by email with pricing and next steps.
Key Features
Spreadsheet-style editable grid (OWL/list view) for opening lines: account, partner, analytic distribution, debit, credit — bulk entry without opening a separate move form per line
Live `@api.depends` compute fields for total debit, total credit, and the running debit-minus-credit difference, so imbalance is visible as you type
Per-account and per-journal subtotals shown inline, pinpointing exactly which account is causing the gap
Trial-balance importer that maps spreadsheet columns to `account.account` records matched on account code, with a preview and per-row validation before commit
Validation layer that rejects lines against inactive accounts, wrong company, or missing currency before anything is posted
Reconcilable-account expansion: receivable/payable rows broken into per-invoice or per-partner detail so aged AR/AP reports tie out from go-live
Draft staging model — everything is held as a working set and only materialised into a real `account.move` on explicit confirmation
Generates one balanced opening journal entry per company/journal against a configurable opening/equity offset account
Multi-company support with per-company grids honouring each company's currency, fiscal position, and chart of accounts
Multi-currency opening balances with company-currency and foreign-currency amount columns where required
`ir.model.access.csv` plus record rules restricting who can view, edit, and post opening balances
QWeb reconciliation report comparing staged vs. posted trial balance for an auditable before/after handover
JSON-RPC/XML-RPC endpoints so legacy-migration scripts can push opening balances programmatically
Automated-action and re-run safe design: re-importing a corrected trial balance replaces the draft set instead of duplicating posted entries
Compatible with Odoo 17.0, 18.0, and 19.0 on both Community and Enterprise editions
About this Product
Every Odoo go-live or new fiscal-year setup hits the same wall: loading opening balances. In Odoo core the only honest path is a manual journal entry against a temporary opening/equity account, line by line, in an account.move form that was never designed for bulk balance entry. Accountants keep a trial balance in a spreadsheet, retype dozens or hundreds of GL lines into Odoo, and then fight to make total debits equal total credits. Partner-level detail is worse: every open customer invoice and vendor bill needs its own reconcilable line so the aged receivable and payable reports tie out. When the numbers don't balance, Odoo blocks the post and there is no single screen that shows you where the gap is.
Why Choose Opening Balance Dashboard
Spreadsheet-style editable grid (OWL/list view) for opening lines: account, partner, analytic distribution, debit, credit — bulk entry without opening a separate move form per line
Live `@api.depends` compute fields for total debit, total credit, and the running debit-minus-credit difference, so imbalance is visible as you type
Per-account and per-journal subtotals shown inline, pinpointing exactly which account is causing the gap
Trial-balance importer that maps spreadsheet columns to `account.account` records matched on account code, with a preview and per-row validation before commit
Validation layer that rejects lines against inactive accounts, wrong company, or missing currency before anything is posted
Reconcilable-account expansion: receivable/payable rows broken into per-invoice or per-partner detail so aged AR/AP reports tie out from go-live
The Opening Balance Dashboard replaces that with a spreadsheet-style grid inside Odoo. We build a dedicated model extending models.Model that holds an editable list/OWL grid of opening lines — account, partner, analytic distribution, debit, credit — with live @api.depends compute fields for running totals, the debit-minus-credit difference, and per-account subtotals, so the imbalance is visible while you type instead of only at post time. A guided importer maps your trial-balance columns to accounts (matched on account.account code), and the dashboard validates every line against the active chart of accounts, company, and currency before anything touches the ledger. Reconcilable accounts (receivable/payable) can be expanded into per-invoice or per-partner detail so aged reports and follow-ups are correct from day one.
Technically, the dashboard stages everything as a draft working set and only generates the real account.move when you confirm — one balanced opening entry per company and journal, posted against the opening/equity offset account you nominate. We add ir.model.access.csv rules plus record rules so only the finance team sees and posts opening balances, and QWeb reconciliation reports (staged trial balance vs. posted trial balance) give you an auditable before/after. Multi-company setups get per-company grids with the correct currency and fiscal position, and the importer is exposed over the JSON-RPC/XML-RPC API so a migration script can push balances programmatically from your legacy system. It runs on Odoo 17.0, 18.0, and 19.0, on Community or Enterprise — nothing here depends on Enterprise-only accounting features, so the same build works on either edition.
Because this is a build-to-order product, ECOSIRE develops your version against your actual chart of accounts, company structure, and cutover date, then installs it, runs it on a staging database with your real trial balance, and hands over the source. Typical delivery is 2–4 weeks from confirmed scope, sequenced so the dashboard is ready and rehearsed before your go-live weekend. Pricing starts from $249 (indicative, single-company base scope); additional companies, multi-currency opening balances, deep partner-level receivable/payable migration, and the volume of historical data to migrate increase the quoted scope.
What you get
- Installable source code for your version of the module, pinned to your Odoo major version (17.0 / 18.0 / 19.0)
- Installation and configuration on your environment, including the opening/equity offset account and journal setup
- Technical documentation: model/field reference, security rules, import mapping, and the JSON-RPC/XML-RPC import contract
- End-user guide plus a live training session for your finance team on entering, balancing, and posting opening balances
- UAT run on a staging database using your real trial balance, with a documented rollback plan before touching production
- Post-go-live support window for defect fixes and questions during your first close
- Git repository handover with full commit history and tagged release
- Reconciliation report pack (staged vs. posted trial balance) for your auditor/sign-off
Who this is for
Finance / Migration Lead at go-live
Owns the Odoo cutover and needs to load a full trial balance — GL plus open AR/AP — into a balanced opening entry without hand-typing hundreds of journal lines. Wants validation and a rehearsed staging run before the go-live weekend.
Accountant running fiscal-year setup
Enters opening balances each new fiscal year or when onboarding a new company. Wants a spreadsheet-like screen that shows the debit/credit difference live and won't let an unbalanced entry slip through.
Odoo implementation partner / consultant
Delivers multiple client go-lives and wants a reusable, per-company dashboard with an API import path so opening-balance loading stops being a manual, error-prone bottleneck on every project.
Group controller in a multi-company setup
Manages opening balances across several companies and currencies, and needs per-company grids, correct fiscal positions, and an auditable staged-vs-posted reconciliation report for sign-off.
Installation overview
Download from ECOSIRE
Buy the license on ecosire.com and download the Opening Balance Dashboard module ZIP from your account dashboard.
Upload to Odoo
Extract the ZIP into your Odoo custom addons folder on the server (or upload via Apps > Install from file on Odoo.sh / runbot).
Install the module
Activate Developer Mode, open Apps, click Update Apps List, search for Opening Balance Dashboard, and press Install.
Configure settings
Open the new menu, paste your ECOSIRE license key, connect any external credentials (Shopify, Amazon, Stripe, etc.), and save.
Verify & go live
Run the built-in connection test, sync your first 10 records, and schedule the recurring cron. Contact support if anything fails.
How Opening Balance Dashboard Compares
| Criterion | ECOSIRE | Custom Build | Competitor | Odoo Native |
|---|---|---|---|---|
| Bulk balance entry | Spreadsheet-style grid built for hundreds of lines | Whatever you spec and pay to build | Generic grid, not fit to your accounts | |
| Live balance check | Running debit/credit difference computed as you type | Possible if explicitly requested | Often only validated at post time | |
| Open AR/AP detail | Per-invoice/per-partner reconcilable lines | Depends on developer scope | Frequently lump-sum only | |
| Trial-balance import | Guided mapping + JSON-RPC/XML-RPC API path | Built if budgeted | Basic CSV import, limited mapping | |
| Fit to your setup | Built to your CoA, companies, currencies | Fully bespoke but from scratch | Configurable within its own assumptions | |
| Multi-company / currency | Per-company grids, correct currency & fiscal position | If included in scope | Varies by module | |
| Support & ownership | Source, git handover, support window | You maintain it | Vendor support, no source | |
| Time to value | 2–4 weeks, rehearsed on staging | Longer; full build cycle | Fast install but generic fit |
Frequently Asked Questions about Opening Balance Dashboard
Is this an existing app I can download and install right now?
No. The Opening Balance Dashboard is build-to-order. ECOSIRE develops your version against your chart of accounts, company structure, and cutover, then installs and supports it. It is not an instant-download module from the public app store.
How long does delivery take?
Typical delivery is 2–4 weeks from confirmed scope. After a short scoping call we agree the exact requirements, then build, test on a staging database with your real trial balance, and schedule the handover so the dashboard is rehearsed before your go-live.
How does pricing and scoping work?
Pricing starts from $249 as an indicative figure for a single-company base scope. After a scoping call we send a fixed written quote. Additional companies, multi-currency opening balances, deep partner-level AR/AP migration, and the volume of historical data to migrate increase the quoted scope.
Which Odoo versions and editions does it support?
We build for Odoo 17.0, 18.0, and 19.0, on both Community and Enterprise. The dashboard doesn't rely on Enterprise-only accounting features, so the same functionality works on either edition. We pin your build to your specific major version.
What about support and updates after go-live?
Every engagement includes a post-go-live support window for defect fixes and questions during your first close. Because you receive the full source and git repository, you own the code. We also offer ongoing support and version-upgrade engagements separately if you later move to a newer Odoo major version.
Will it keep open invoices reconcilable?
Yes. Receivable and payable opening balances can be expanded into per-invoice or per-partner detail so the lines stay reconcilable and your aged AR/AP reports and follow-ups are correct from day one, rather than sitting as a single lump-sum balance.
Can we import balances from our old system automatically?
Yes. Besides the guided spreadsheet importer, the dashboard exposes its import over the JSON-RPC/XML-RPC API, so a migration script can push opening balances programmatically from your legacy system. Re-importing a corrected trial balance replaces the draft set rather than duplicating posted entries.
Related Modules
Request a quote
Opening Balance Dashboard
A spreadsheet-style dashboard for entering, validating, and posting accounting opening balances in Odoo. Built to order by ECOSIRE for your chart of accounts, companies, and go-live cutover.
- Spreadsheet-style editable grid (OWL/list view) for opening lines: account, partner, analytic distribution, debit, credit — bulk entry without opening a separate move form per line
- Live `@api.depends` compute fields for total debit, total credit, and the running debit-minus-credit difference, so imbalance is visible as you type
- Per-account and per-journal subtotals shown inline, pinpointing exactly which account is causing the gap
- Trial-balance importer that maps spreadsheet columns to `account.account` records matched on account code, with a preview and per-row validation before commit