Financial report: balance sheet row definition in Dynamics 365 Business Central

When setting up the chart of accounts I like to structure it with the same format that I like my balance sheet row definition to look like. In the example below you can see that I have things grouped together with begin and end totals. This is going to help me when I go to create the balance sheet row definition. 


Financial Reporting

Row Definition

Let's start with creating a row definition. Follow these simple steps to complete this task. 
  1. Search for Row Definitions and select (Financial Report) Row Definitions 



  2. We're going to create a new row definition now so go ahead and click on +New



  3. Add the name and description for the new row



  4. Open the new record. From here we're going to select insert > Insert G/L Accounts and select only the balance sheet accounts. 


  5. Once you have the rows added now, we're going to work on cleaning up. There are several things here we're going to focus on. 

    a. Update the Total Type from Total Accounts to Formula

    b.  Add Totaling for new Row Numbers

    c. Update Show from Yes to If Any Column Not Zero

    d. Update Show Opposite Sign for the liability accounts  

     


  6. Next we're going to test this. Search for Financial Reports and select from the reports and analysis section.



  7. Add a new row with the correct information for what you'd like to reference this report as. In this example I am using the out of the box Column Definition M-BALANCE.



  8. Select the new report to open the Financial Report. Update the Options to the correct information to run the report. 


    I like to export to Excel to review easier. Export to Excel/Print > Create new Excel template. 



    Verification completed and report ties out. 


------

Kristen Hosman is a Microsoft MVP in Denver. She works with Dynamics 365 Business Central and related technologies. You can also connect with her through this link: Kristen Hosman | Linktree

Comments

Popular posts from this blog

Applying posted credit memos to posted invoices in Microsoft Dynamics 365 Business Central

Send Remittance Advice in Microsoft Dynamics 365 Business Central

Received not invoiced report in Dynamics 365 Business Central