Financial reporting in Business Central for statements that tie to the ledger
Business Central financial reporting turns the general ledger into statements. These include the income statement, balance sheet, cash flow and any view you define with rows and columns. We build them with the Financial Reports feature, G/L account categories and dimensions. So month-end numbers come straight from the ledger. Nobody has to reshape an export by hand.
Last updated
The tools behind Business Central financial reporting
The main tool is Financial Reports. Earlier versions called it account schedules. A report pairs a row definition with a column definition. The rows list the lines of the statement and the accounts or formulas behind each. The columns set what is compared. That may be this period, last period, budget, variance or one column per department.
Several helpers sit around it. G/L account categories drive the default statements. Dimension filters slice the same ledger by department, project or region. G/L budgets feed the budget columns. A group can add a consolidation company that brings each entity together first.
Discuss your reports →
- ✓Row and column definitions
- ✓G/L account categories
- ✓Dimension filters
- ✓G/L budgets
- ✓Consolidation company
Signs your Business Central financial reporting needs work
The clearest sign is a spreadsheet pack that takes finance a long time to build at every close. Staff export trial balances and paste them into tabs. Lookup formulas map them to statement lines, and people adjust them by hand. When the chart of accounts changes, the pack breaks.
Other signs are quieter. Department heads receive numbers they cannot drill into. Budget comparisons live outside the system. Two people produce slightly different profit figures because they filtered differently. Each of these points to reports that you should define once inside Business Central. Then every figure opens to the entries behind it.
Send us your statements →- ✓Manual spreadsheet packs
- ✓Broken lookups after changes
- ✓No drill-down for managers
- ✓Budgets kept off system
- ✓Conflicting profit figures
How we build Business Central financial reporting
We ask for the statements you issue today and the ones you wish you had. For each, we agree the line structure, the comparisons and the audience. Then we check the foundations. Can the chart of accounts and dimensions support those lines? Or should a few accounts be split or re-categorized first?
Row definitions use totaling ranges and formulas, not fixed account lists, where possible. So new accounts fall into place on their own. Column definitions are reusable across reports. Each statement ties back to the trial balance for several periods. Any difference is explained before anyone relies on the result.
Ask about report design →- ✓Statement lines agreed
- ✓Chart and dimensions checked
- ✓Range-based row definitions
- ✓Reusable column sets
- ✓Tie-out to trial balance
What the finished financial reporting pack contains
A typical pack holds an income statement with budget and prior-period comparisons. It also holds a balance sheet and a cash flow statement. Departmental or project profit views use dimensions. You can view each on screen with drill-down, print it, save it as a document or send it to Excel with the layout kept.
For a group, we set up a consolidation company. It pulls in each entity's ledger, with eliminations and currency translation. The same reports then run on the group figures. We train your finance team to edit row and column definitions. We also leave notes on how each report is built. So you can maintain it without us.
See a sample statement →- ✓Income statement with budget
- ✓Balance sheet
- ✓Cash flow statement
- ✓Department profit views
- ✓Notes on each report
Common Business Central financial reporting mistakes
A weak chart of accounts is the root of most trouble. Suppose departments sit in account numbers instead of dimensions. Then every statement needs long account lists, and every new department means new accounts. Fixing the structure first makes the reports far simpler.
The second mistake is skipping the tie-out. A row that misses one account can sit unnoticed. Then the balance sheet fails to balance in front of the board. We add check rows that should always equal zero. We also test with closed periods, where the right answer is already known.
Plan your reporting pack →- ✓Departments coded in accounts
- ✓Hard-coded account lists
- ✓No zero-check rows
- ✓Blank dimension values
- ✓Untested prior periods
Business Central financial reporting questions
What happened to account schedules?
Microsoft renamed them. The feature is now called Financial Reports. Each account schedule is split into a row definition and a column definition, and you can combine them freely. Existing schedules carried forward. So nothing built in earlier versions was lost in the change.
Can we report by department or location?
Yes, through dimensions. Each posting can carry values such as department, location or project. A financial report can filter by a dimension value or show one column per value. This is the standard way to produce a profit statement for each part of the business.
Can budgets be compared with actuals?
Yes. You enter G/L budgets in Business Central or import them from Excel, by account, period and dimension. A column definition can then show actual, budget and variance side by side for any period. You can also keep several budget versions for comparison.
Can financial statements be exported or printed?
Yes. Each statement opens on screen with drill-down, and it prints, saves as a PDF or exports to Excel. The job queue can also run a financial report on a schedule. So the monthly pack reaches the people who need it without manual copying.
Can several companies be reported together?
Yes. Business Central can consolidate companies into a consolidation company, with elimination entries and currency translation. You then run financial reports there. For simpler needs, Power BI can combine data from several companies. We help you choose based on your group structure.
Book a discovery call
Let's talk through your move to Business Central.
A focused call with a senior consultant. We learn how your business runs today, give you an honest view on whether Business Central fits, and outline scope and next steps before you commit to anything.
What happens after you send the form