Dimensions and account schedules for management reporting in Business Central

Most small businesses outgrow their chart of accounts before they outgrow anything else. You want to see margin by location, spend by department, or revenue by project, and the only way to get it from a flat chart of accounts is to add more and more accounts until the list is unmanageable. Business Central, Microsoft's enterprise resource planning (ERP) system for small and mid-sized companies, solves this with dimensions and financial reports. By the end of this guide, you'll have dimensions defined, defaults set so they fill in automatically, and a couple of management reports that compare budget to actual and this year to last, with drill-down to the underlying entries and a one-click export to Excel.

A quick note on names. What older Business Central screens and a lot of blog posts call "account schedules" is now grouped under Financial Reporting. A financial report is a combination of a row definition (what used to be the account schedule) and a column definition (what used to be the column layout). We'll use the current names and point out the old ones where it helps.

Before you start

• You need a user with permission to edit setup, typically the SUPER permission set or an admin-level set.
• Decide on your dimensions before you build anything. Most companies start with two: one for Department (or cost center) and one for Location or Project. Two well-chosen dimensions beat six vague ones.
• Have a budget ready if you want budget-vs-actual, or plan to enter one. Reporting on a budget you haven't loaded won't show anything.

Step 1: Create your dimensions

1. Choose the search icon (the magnifying glass, top right), type Dimensions, and open the Dimensions page.
2. Choose New. In Code, enter a short name like DEPARTMENT. In Name, enter something readable like Department.
3. Repeat for each dimension you decided on, for example PROJECT or LOCATION.
4. For each dimension, select it, then choose Dimension and Dimension Values. Add one row per value: a code (SALES, OPS, ADMIN) and a name. Leave Dimension Value Type as Standard for normal values. Use Begin-Total and End-Total if you want to group values into totals later.

Step 2: Tell Business Central which dimensions matter

1. Search for Dimensions again, but this time you want the setup that flags your global and shortcut dimensions. Search for General Ledger Setup and open it.
2. On the Dimensions FastTab, set Global Dimension 1 Code and Global Dimension 2 Code to your two most important dimensions, for example Department and Location. Global dimensions can be filtered and reported on everywhere, so pick the two you'll use most.
3. Still in setup, you can assign up to six more as Shortcut Dimensions so they appear as quick-entry columns on documents and journals. Search for General Ledger Setup, then look for the shortcut dimension fields, or use Change Global Dimensions if you need to swap a global dimension after data exists.

Step 3: Set default dimension values so they fill themselves in

Defaults are what make dimensions stick. Instead of asking everyone to remember to tag every line, you attach a default to the customer, vendor, item, or G/L account, and Business Central fills it in.

1. Open a record you post against often, for example a Customer or a G/L Account.
2. Choose Navigate or the Related menu, then Dimensions, then Dimensions-Single (for one record) or Dimensions-Multiple (to apply to several selected records at once).
3. Add a row: choose the Dimension Code (for example DEPARTMENT) and the Dimension Value Code (for example SALES).
4. Set Value Posting to control how strict the default is:
   • Leave it blank to suggest the value but allow changes.
   • Same Code forces that exact value.
   • Code Mandatory requires some value but lets the user pick.
   • No Code blocks the dimension on that record.

Step 4: Block the combinations that should never happen

If certain dimension pairings make no sense (a PROJECT value used with the wrong DEPARTMENT, say), you can stop them.

1. Search for Dimension Combinations and open it.
2. Pick the two dimensions in the matrix and set the intersection to Limited or Blocked. Blocked stops the pairing entirely; Limited lets you allow only specific value pairs under Dimension Value Combinations.

Step 5: Build a row definition

Now the reporting. The row definition lists the lines of your report, usually account ranges or totals.

1. Search for Financial Reports and open it. (Searching for Account Schedules redirects here.)
2. Choose New to create a financial report, give it a name like P&L-MGMT, then choose Edit Row Definition.
3. On each row, set a Row No., a Description (for example Revenue), and a Totaling Type with a Totaling value. Use Posting Accounts with an account range like 40000..49999, or Account Category to lean on Business Central's built-in account categories.
4. Add subtotal rows with Totaling Type set to Formula and a totaling expression that references your row numbers, for example 10..50.

Step 6: Build a column definition for the comparison you want

1. Back on the Financial Reports list, with your report selected, choose Edit Column Definition.
2. For budget vs. actual, add a column with Ledger Entry Type = Entries and another with Ledger Entry Type = Budget Entries, then a third Formula column for the variance (for example Net Change minus Budget).
3. For this year vs. last year, add a column for the current period and a second column with a Comparison Date Formula of -1Y so it pulls the same period one year back.
4. Save the column definition with a clear name like BUD-VS-ACT or THIS-VS-LAST so you can reuse it on other reports.

Step 7: Run it, filter by dimension, drill down, and export

1. From Financial Reports, select your report and choose Overview (or Edit Financial Report to set the row and column definitions together, plus a date filter).
2. In the filter area, set Date Filter to your period. Set the Dimension Filters (for example Department = SALES) to slice the report.
3. Click any number to drill into the entries behind it, all the way to the general ledger.
4. Choose Edit in Excel or Send to Excel to export the report with its current filters for sharing or further analysis.

Verify it

Run the report for a closed month you already know the numbers for. The actual column should tie to your trial balance for that period. Switch a dimension filter on and off; the totals should change to match only the filtered slice. If the budget column is blank, you haven't loaded a budget under G/L Budgets, so go set one and re-run.

What to do next

Once one report works, copy its column definition to build variants (monthly, quarterly, year-to-date) without rebuilding rows. Save the reports your leadership looks at every month so they're one click away. If you want these landing in inboxes automatically or feeding a dashboard, that's where a partner can wire up scheduled report delivery or a Power BI connection, and we're happy to help.