top of page
Microsoft Business Central

How to use and create Account Schedules

This document helps you understand how to create and use Accounts Schedules. They are used to arrange listed accounts in the chart of accounts into groups that provide information to company management. You can use these arranged groups of accounts for analysis of your business such as cash flow, profit calculation, the profitability of departments etc.

Join On Point Academy to view all content

Account Schedules

  • To create a new Account schedule: type Financial Reports in the Search Box and click on the related link

In the Home tab, click on New

Fill in Name, Description and Row Definition

If there is no predefined Row Definition or if you want to create a new one, on the Home tab in the Process action group click on Edit Column Definition.

Click on the dropdown next to the Name of Column Layout

On the Home tab click on New and fill in the Name and Description

To edit information choose the Column Layout you want to edit and click on Edit Column Definition in the Process action group.

To continue in the Financial Reports setting navigate back to Financial Report Names. On the Home tab, in the Process action group click on Edit Financial Report to start defining rows of Financial Report.

Fill in the rows with accounts you want to group, they are listed in the chart of accounts

Example of completed Financial report for Cashflow

To print a completed Financial report, on the Home in the Report action group click on Print

On the top row, you can choose if you want to print it or save it to your computer

Get trained
the On Point way

From self paced online courses to private training sessions.
Become industry ready.
bottom of page