User can use Financial Reports to create Balance Sheet and Profit & Loss Statement that fit their use.
To create new Financial Report | ||
---|---|---|
1 | Search "Financial Report", then click "New" to create a new one. | |
2 | Enter the report name, description, row definition & column definiation. User can edit the row definition and column definition for each report name. For default Column Layout, user can use system's sample layout. Choose M-BALANCE for Balance Sheet and choose M-NETCHANGE for Profit & Loss Statement. | |
3 | Choose Edit the financial report. | |
4 | To edit the row definition, chick Insert > Insert G/L Accounts | |
5 | Select the G/L Accounts to be inserted, then click OK. For example, Balance Sheet only includes Balance Sheet G/L Accounts. | |
6 | For Balance Sheet, user will need to add a row to include current year's Profit & Loss figures. For Totaling Type column, choose Posting Accounts. Under Totaling column, input Profit & Loss G/L Accounts. | |
7 | For Totaling Type most commonly use are:
|
To run Account Schedule, highlight the report user want to run, then click "View Financial Report"
Input related Date Filter and the results will show at the bottom. E.g. Income Statement
Column Definition Formula:
Reference: Column definitions in Financial Reporting - Business Central | Microsoft Learn