Account schedules are tools we can use to arrange accounts listed in the chart of accounts in ways suited for presenting information about those accounts. You can set up various layouts to define the information you want to extract from the chart of accounts.
Business Central allows users to export their account schedules into Excel quickly as a Microsoft product. In addition, exporting them directly into PDF to attach to an email as a report pack is also possible.
Account categories can be used to alter the appearance of your financial statements. The underlying account schedules for the key economic reports are updated once you set up your account categories in the G/L Account Categories box and choose the Generate Account Schedules action. New totals and subentries are added based on your changes the next time you run one of these reports, such as the Balance Statement report.
We use Account Schedules to get visibility into the financial chart of accounts data stored in Business Central. As a result, reports like income statements, balance sheets, and cash flows are generated. Account Schedules aren’t quite as old as Business Central. Because Business Central is based on Microsoft Dynamics NAV, those familiar with or have worked with NAV may already be familiar with Account Schedules. Because Account Schedules are accessed and used directly within the Business Central program, report creation relies on proprietary code, layout, and formulas.
You can use the sample account schedules provided by Business Central or create your rows and columns. Account schedules, for example, can be used to compute profit margins based on dimensions such as departments or customer groups. Unfortunately, while you can construct as many account schedule financial statements as you desire, they are only available within Business Central unless and until they are manually exported to Excel using an export option.