top of page

Building Financial Reports in Dynamics 365 Business Central

Writer: Ben Cole
Ben Cole
Oct 20
13 min read

You do not have to start with an external reporting tool to get a useful Income Statement or Balance Sheet out of Dynamics 365 Business Central. The built-in financial reports can do quite a bit, and getting the basics in place is more straightforward than you might expect.


In a poll I ran with Kristen Hosman at Dynamics Community Summit 2026 in Nashville, TN, more than half of the respondents already using Business Central were not using its built-in financial statements. That surprised me. I suspect part of the problem is that the reports supplied with the system do not always feel particularly useful right out of the box.



My approach is to build a simple report first, get the numbers and presentation working, and then reuse those building blocks. Start with a detailed 12-month income statement, add a summary version and a balance sheet, and then turn up the heat with things like rolling periods and dimensions.


So with that - let's go ahead and get started with a step by step tutorial


What You'll Learn

  • How to build Financial Reports inside of Business Central

  • Combine reusable row and column definitions

  • Create detailed and summary Income Statements and Balance Sheets

  • Use Net Change for Income Statements

  • Balance at Date for Balance Sheets.

  • Build static or rolling monthly columns, checking date filters to ensure the intended reporting period.

  • Apply dimension filters to rows or columns for departmental financial reporting.




Table of Contents


Step 1: Understand the Two Building Blocks: Rows and Columns


The easiest way to think about a financial report is this:

  • Rows are what you are reporting on. These run down the left side and can contain G/L accounts, account categories, totals, and formulas.

  • Columns are how you are looking at that information. These run across the top and can represent periods, actuals, budgets, or dimension breakdowns.



For a detailed monthly income statement, your rows might be individual revenue and expense accounts, while your columns represent January through December. For a departmental income statement, the same rows can remain in place while the columns change from months to departments.


You do not need to rebuild both definitions every time you create a report. A financial report combines a row definition and a column definition, which means you can reuse either one.


For additional reference while working through the setup, Microsoft documents the underlying functionality in its financial reporting guidance.


Step 2: Create a Detailed Income Statement


1. Create the report and its row definition


Search for Financial Reports in Business Central. You will find a selection of existing reports, but for this exercise, create a new one.


Give it a Name of IS-12MTH-D and a Display name of 12-Month Income Statement Detail. Then create a row definition called IS DETAIL, with a description such as Income Statement Detail.


The definition can remain in Draft while you build it. The status field provides an internal label for organizing definitions, with options such as Draft, Active, and Retired. It is not a substitute for reviewing the report's calculations.


Creating the row definition only creates the container. You still need to populate it. From the report, open Definitions and choose Edit Row Definition.


2. Insert the income statement G/L accounts


In the blank row definition, use Insert G/L Accounts and select the accounts you want to include.


In my example chart of accounts, the income statement section begins at 40000 and runs through the net income account. Your account numbers may differ, so select the relevant revenue, cost of goods sold, and expense accounts from your own chart.


If the chart of accounts is set up well, this is a quick way to build a detailed statement. Business Central brings the account structure into the row definition, including formatting such as bold text and totals.


You may notice that some heading rows have blank row numbers. I prefer to populate those for consistency. At a minimum, make sure the posting and totaling rows have row numbers.


3. Check the totaling logic


Inserting accounts is convenient, but it does not eliminate the need to check their setup.

For example, the totaling account 49999 in my chart uses the range 40001..49999. The financial report relies on that underlying totaling setup being correct.


For a quick first build, keeping the imported totaling accounts is fine. Just verify the ranges in the chart of accounts rather than assuming they include exactly what you need.





Formulas (as seen below) can be a better alternative when you want to define the report's totals more explicitly. Although the range looks like the GL accounts, they are actually totaling what is in the rows.



You could also do something like this (to better illustrate) and it would also work, although I wouldnt necessarily recommend it - just for illustrative purpoes. I personally like the rows matching the GL account numbers when doing this in detail.



4. Set the row type and signs


Two settings deserve particular attention:

  • Row Type: Net Change. An income statement normally reports activity during a period, rather than the accumulated balance as of a date. This is the setting I would recommend for our example today.

  • Show Opposite Sign: enabled for revenue. Revenue normally has a credit balance, so reversing the displayed sign presents it as a positive amount. If you do not do this, assuming you have revenue, it will all show as negative. This just flips the sign for you to make it more visually appealing.


In the editable grid, the spacebar and down arrow provide a quick way to move through checkbox fields such as Show Opposite Sign as seen in the video below.



5. Keep the initial display settings simple


The Show field lets you display rows conditionally. For example, you can show a row only when a column contains a nonzero amount, or based on whether its balance is positive or negative.


For the first pass, I leave the rows set to Yes so everything appears (even if blank / zero). Get the report working first. You can clean up empty rows and refine the formatting afterward. This at least ensures everything is pulling in.



Step 3: Build a Static 12-Month Column Definition


Now that the Rows (accounts) run down the left side, you need periods across the top.


Create a column definition called 12-MONTH, then open Edit Column Definition. Like a new row definition, it starts blank.

  1. Create 12 numbered columns, one for each fiscal period.

  2. For a calendar-year setup, enter fixed headings from January through December.

  3. Add a thirteenth column for the annual total.

  4. Populate the Comparison Period Formula for each monthly column.


Use FY[1] for the first fiscal period, FY[2] for the second, and continue through FY[12].


For the final total column, use FY[1..12] to cover all 12 fiscal periods.



In this example, fiscal period 1 is January, period 2 is February, and so on. That is why fixed month headings work here. If your fiscal year starts in a different month, your headings need to reflect that setup.


Be precise about the final column's label. A formula covering periods 1 through 12 defines a full fiscal-year total. Although it can look like a year-to-date figure when later periods have no activity, it is not explicitly limited to the current period, and absolutely can include deferrals or entries posted to future periods.


The distinction between the two comparison fields is important:

  • Comparison Period Formula selects fiscal periods, which works well for a fixed fiscal-year layout. The FY[1], FY[2], etc. type formula above as an example.

  • Comparison Date Formula shifts the report's date filter, which is useful for a rolling layout. Example would be -11M, -10M, -9M, etc - shown below.

Similarly - You can create a column definition called 12-MTH-ROLL, then open Edit Column Definition.

  1. Create 12 numbered columns, one for each fiscal period.

  2. For a rolling setup, use the Include Date in Column Header Function and select Month and Year in this example.

  3. If you would like, you can also add a totaling column for the last 12 months rolling total.

  4. Populate the Comparison Date Formula for each monthly column.


Use -11M for the first fiscal period, -10M for the second, and continue through the current period, which can be left blank.


For the final total column, use 1+2+3+4+5+6+7+8+9+10+11+12 to cover all 12 fiscal periods. Strange, I know. If anyone knows a better way to do this let me know, as it seems like the formula does not work for whatever reason in this scenario.



Run the completed income statement - 12 month static

Return to the report and select View Financial Report. Set the appropriate date filter, expand the page if needed, and hide the options to give the statement more room.

You should now have your selected G/L accounts down the left side, January through December across the top, and the annual total at the end.


One of the useful parts of keeping this inside Business Central is the ability to drill into amounts and investigate the underlying entries. There are plenty of good external and embedded reporting tools, but this built-in functionality is worth using for the basics.


Step 4: Create a Summary Income Statement Without Rebuilding the Columns

Once you have a working 12-month column definition, creating a summary report becomes much easier.

  1. Create another financial report called IS-12MTH-S

  2. Create a new summary row definition called IS SUMMARY.

  3. Assign the existing 12-MONTH column definition.

  4. Open the report and review the output.


A summary row definition can use account categories rather than listing every G/L account. In my example, an existing definition already contains lines for income, cost of goods sold, expenses, and net income.


The important part is the reuse: change the rows to change the level of detail, while keeping the same monthly columns.


Step 5: Build a Detailed Balance Sheet

The balance sheet follows much the same process, with two important differences: which accounts you include and how you calculate their balances.


1. Create and populate the balance sheet rows

Create a new financial report called BAL SHT - Balance Sheet, then create a row definition called BS DETAIL.


Open the row definition and use Insert G/L Accounts again. This time, select your asset, liability, and equity accounts. In my example chart, the balance sheet accounts run through 39999.



2. Change the row type to Balance at Date

A balance sheet needs Balance at Date, not Net Change. You want the account balance as of the reporting date, not just the movement during the selected period.

Update the relevant rows accordingly. You can edit through the grid, use copy and paste, or use Edit in Excel to make the repetitive changes easier.


3. Reverse the display sign for liabilities and equity

Enable Show Opposite Sign for the liability and equity rows because these normally carry credit balances. Assets normally retain their existing sign.

That gives you the two main balance sheet settings:

  • Balance at Date for the row type.

  • Show Opposite Sign for liabilities and equity.


4. Assign a single balance column

For a straightforward balance sheet, one column is enough.


In my environment, the supplied M-BALANCE column definition provides a useful starting point. Its setup is essentially a Balance heading, Balance at Date, and G/L Entries with Net Amount.


Review that definition, assign it to the report, and choose View Financial Report. Enter the date you want to report as of and hide the options if you want more space.

You now have a detailed balance sheet based on the selected reporting date.



Step 6: Change the Income Statement to a Rolling 12-Month Report

A static January-through-December report is useful, but sometimes you want the latest 12 months regardless of where you are in the fiscal year.


Create a new report called IS-12MTH-ROLL. Reuse IS DETAIL for the rows, as well as the 12-MTH-ROL column definition we created earlier.


Use dynamic headings and comparison date formulas

Create 12 columns. Instead of typing fixed month names, use the Month and Year heading option so each heading changes with the reporting period.

This time, populate Comparison Date Formula, not Comparison Period Formula:

  • First column: -11M.

  • Second column: -10M.

  • Continue with -9M, -8M, -7M, -6M, -5M, -4M, -3M, -2M, and -1M.

  • Final column: leave the comparison date formula blank for the current reporting period.


If October is the current reporting month, the rightmost column will represent October, with the preceding months extending back to November of the prior year.



Check the base date filter carefully

This is where you need to be a little careful. A comparison date formula shifts the date filter you give the report. It does not automatically turn a single date into an entire month.


For example, entering October 7 as a single date can cause the shifted columns to report corresponding individual dates in earlier months, rather than complete monthly activity. That can produce some odd-looking results.


For monthly reporting, use an explicit monthly date range and verify the resulting amounts. 


If the results look sparse or unexpected, check the base date filter before assuming the formulas are wrong.



Step 7: Add Department Dimensions Across the Columns

Periods are not your only option for columns. If you use dimensions, you can compare them side by side using the same income statement rows. Popular examples include departments and cost centers. For today, I will be looking at my customer dimension.


Create a new financial report called IS-DIM, reuse IS DETAIL for the rows, and create a column definition called IS-DIM for the dimension breakdown.

  1. Open Edit Column Definition.

  2. If the customer dimension filter field is not visible, use Personalize to add it.

  3. Create four columns and assign the appropriate customer dimension value to each.

  4. Give the columns clear headings.

  5. Run the financial report for the period you want to analyze, in my case all of 2026.


This is now a four-column departmental report, not a 12-month report. The report's date filter determines the period, while each column's dimension filter determines the customer dimension.



Include entries without a department

If you want to see entries with no department dimension, add a fifth column called Blanks. In the department filter, enter '', two single quotation marks, to select a blank value.



Step 8: Put Dimensions in the Rows Instead

You can also use dimensions in row definitions. Some people prefer dimensions across the top (like we just showed with columns); while others need to more granularly build our their row definitions by using dimensions


For example, you might want to show G/L account 50200 separately for Ben, Carlie, and Matt to break out their individual costs of labor.


To build that layout:

  1. Create a new report and row definition, both called ROW DIM

  2. Open the row definition and expose the employee dimension filter field, using personalization if necessary.

  3. Add separate rows that reference the same G/L account (50200) three times.

  4. Assign a different employee filter to each row.

  5. Use descriptions that make the departmental split clear.


The G/L account stays the same, but each row selects a different slice of its activity. You can then use a period-based column definition to show those employee rows over time.


There is not one universally better layout. Choose the one that makes your financial data easiest to understand.





Financial Report Best Practices to Keep in Mind

Once the basic report is working, these are the checks I would keep coming back to:

  • Start with a well-organized chart of accounts. The example uses 10000-series accounts for assets, 20000-series for liabilities, 30000-series for equity, 40000-series for revenue, 50000-series for cost of goods sold, and higher ranges for SG&A, other income, depreciation, and other expenses. Treat those as an example structure, not a required numbering scheme.

  • Validate imported totals. A report built from G/L totaling accounts depends on their ranges being correct.

  • Use Net Change for the income statement. It should report activity for the selected period.

  • Use Balance at Date for the balance sheet. It should report accumulated balances as of the selected date.

  • Review the signs. Revenue, liabilities, and equity normally need Show Opposite Sign for the presentation used here.

  • Match formulas to the intended layout. Fiscal period formulas suit a static fiscal-year report; date formulas suit relative, rolling periods.

  • Reuse definitions. A new report does not need an entirely new set of rows and columns.


The goal is not to make the first version fancy. Get a detailed income statement and balance sheet working, check the numbers, and then refine the layout. Once you understand rows as what you report on and columns as how you analyze it, you have the framework to build reports that fit your business.




Frequently Asked Questions


What is the difference between row and column definitions in Business Central?

Row definitions specify what you are reporting on, such as G/L accounts, categories, totals, and formulas. Column definitions specify how those amounts are presented, such as by month, dimension, actuals, or budgets.


Why does my rolling 12-month report show unexpected amounts?

Check the base date filter. Comparison date formulas shift that filter, so a single reporting date can produce single-day comparisons instead of complete monthly activity. Use an explicit monthly range when you need monthly amounts.


Can I reuse the same monthly columns for detailed and summary income statements?

Yes. Assign the same 12-month column definition to both reports, then use different row definitions to control the level of detail.


How do I include entries with a blank department dimension?

Add a separate column and enter two single quotation marks, '', in its department dimension filter. This selects entries where that dimension value is blank.


Why are my revenue amounts showing as negative?

Out of box, the G/L Balances follow standard debit and credit conventions. Because your revenue accounts typically carry a credit balance, they will show negative by default. If you utilize the show opposite sign in the row definition, this will resolve your issue.


What is the difference between Financial Reports and Account Schedules?

Account Schedules and Financial Reports are virtually the same. In October 2022 Microsoft renamed the Account Schedules to Financial Reports. If you are reviewing older documentation it is safe to be assumed these can be used interchangably, but keep in mind that there have been a lot of enhancements to the Financial Reports since 2022 so it would be wise to review up to date documentation when building these out.


When should I use the built-in Financial Reports vs. Power BI?

The Native Financial Reports are good for your basics, like the Income Statement and Balance Sheet. As the name entails, they are tailored to financial data. Power BI is typically better for interactive dashboards and operational reports that will likely have a greater audience than simply finance. There are also many good 3rd party reporting rools like RUX Software and Cosmos that are worth exploring.


Why doesn't my financial report balance to my G/L?

This could be a multitude of things. The first I would check is if you have direct posting turned on for any G/L Accounts that are tied to subledgers. You can quickly do this with the FREE Business Central Health Check App. I would also check the totaling rows vs. totaling formulas. If you have added new G/L accounts since the report was first built, those are not automatically brought in to your financial reports and could also cause gaps in previously build reports.





Ready to optimize your Business Central environment with guidance from a BC expert?


Contact Ben Cole at Ben@BenColeBC.com or (214) 433-0923.


Don't forget to subscribe so that you never miss a weekly tip.


Ben Cole on Business Central

Ben Cole is passionate about making Microsoft Dynamics 365 Business Central work smarter for real people—users and partners alike. With roots in public accounting, Ben’s seen firsthand how automation and clever solutions can transform the Business Central experience. He’s known for breaking down complex topics with a dash of wit and plenty of practical advice. If you want to get more out of Business Central (and maybe even enjoy the process), Ben’s your go-to guide.


Ben@BenColeBC.com 

(214) 433-0923


Comments


Subscribe for Business Central Updates from Ben Cole

Contact

End User, Partner, or ISV?

Questions?
Contact Me
Any Time

Ben Cole on BC Transparent - Character Only Updated.png
  • Ben Cole on Business Central

©2025 Ben Cole on Business Central

bottom of page