Account Schedules in Business Central for Financial Reporting

By Eugene Akanegbu | January 18, 2022

Do you want to get an insight into the financial data stored in your chart of accounts in Business central (BC)?

If so, Account Schedule (AS) is the tool to use.

AS will analyze the figures in GL and compare GL entries with GL Budget entries. The result of this comparison will then be displayed as charts in the Role Center or as reports such as Income Statements and Balance Sheets. BC has some sample account schedules that you can use right away. This allows users to set up their own rows and columns to specify the figures to compare.

How to Use Account Schedule

  • A major function of AS is that it provides a place for calculations that cannot be made directly in the chart of accounts, such as creating subtotals for groups of accounts.
  • AS provides capability for general ledger entries and general ledger budget entries to be filtered by parameters like debit amount and net change.
  • You can also compare two or more account schedules and column layouts by using formulas which allows you to:
    • Create customized financial reports
    • Create as many account schedules as needed, and
    • Set up various report layouts and print the reports with the current figures

Create a New Account Schedule

  1. Choose the search icon, enter Account Schedules, and then choose the related link.

ACCOUNT SCHEDULE PICTURE 1
Note: Ensure to open the one under "List", not under "Report and Analysis." 

2. On the Account Schedules page, choose the New action to create a new account schedule name.

Alternatively, you can choose the Copy Account Schedule from the "Process" menu, fill in the two fields, and choose the OK button.

ACCOUNT SCHEDULE PICTURE 3

ACCOUNT SCHEDULE PICTURE 4

3. Fill in the fields as necessary. In the Default Column Layout field, select an existing layout. You can edit it later if you want.

4. Choose the Edit Account Schedule from the process menu.

ACCOUNT SCHEDULE PICTURE 5

5. Create a row for each financial element you want to appear in the report, such as one row for current assets and another for fixed assets. For inspiration, see existing account schedules in the CRONUS demonstration company.

6. Choose the Overview action to see the resulting financial report.

ACCOUNT SCHEDULE PICTURE 6

7. On the Acc. Schedule Overview page, in the Column Layout Name field, select another column layout to see the financial data by other parameters.

ACCOUNT SCHEDULE PICTURE 7

8. Finally, click on the OK button.

Questions?

Stoneridge Software is here to help! Please get in touch with us if you have any questions.

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X