Chart of Accounts Super Hero: Saved Views in Action
When a company is acquired and needs to migrate to Business Central in just 30 days, there’s no room for a bloated, inconsistent Chart of Accounts. In this video, Kerry Peters walks through how one international organization slashed its Chart of Accounts from 600+ accounts to just 120 and used saved views to give every accountant a clear, controlled window into their financials. Whether you’re managing a single entity or a multi-company consolidation, these practical BC tips are built to reduce complexity and boost data confidence.
Key Takeaways
- Standardize and simplify your Chart of Accounts: This company reduced the number of accounts per entity from 600+ to a shared set of ~120 accounts across all companies, eliminating unused accounts and visual clutter that slows teams down.
- Use saved views to filter blocked vs. active accounts: By blocking accounts irrelevant to a specific legal entity and saving that filter as a view, accountants can focus on only the 50 or so accounts they actually use โ visible in just two screens.
- Control direct posting to protect sub-ledger reconciliation: Accounts like AP, AR, bank, inventory, and intercompany are marked as “no direct posting,” preventing manual entries from slipping in and breaking reconciliation between the sub-ledger and general ledger.
- Enforce dimension requirements at the Chart of Accounts level: With four dimensions (product, intercompany, cost center, and travel), the company set mandatory dimension codes on specific accounts, so the system prevents users from posting without the required data tag โ ensuring 100% consistent financial reporting.
- Create period-based saved views for fast month-end review: By setting filter totals with date filters for each period of the current year and saving them as named views, accountants can flip between months instantly without manually resetting date filters each time.
