An account schedule is a user-defined report layout in Business Central that turns G/L balances into rows and columns, for example a balance sheet.
An account schedule is a reporting layout that groups and calculates general ledger figures without posting anything. A row definition says which accounts or totals each line contains, and a column definition says which values are shown, for example net change, balance at date, a budget amount or a comparison period. Since Business Central 2022 release wave 2 the same feature is presented under the name Financial Reports, where a report is the pairing of one row definition and one column definition.
Press Alt+Q and search for Financial Reports. On older versions the same list is found by searching for Account Schedules. From the list you open the row definition to enter the lines and their totalling logic, choose or edit a column definition, and preview or print the result from the same page.
A simple income statement uses a row for the account range 4000 to 4999 for revenue, a row for 5000 to 5999 for cost of goods, and a total row whose formula subtracts the second from the first. With a column definition showing net change for the period next to the budget, the January 2026 report can read revenue CHF 248,500, cost of goods CHF 141,200 and a gross margin line of CHF 107,300 against a budgeted CHF 100,000.
The most common defect is double counting: one row totals an account range while another row totals a parent total account that already contains the same postings. A second classic is a row built from a hand typed list of single accounts, so a G/L account created later never appears and nobody notices. Lines also come back empty when the totalling type does not match what the row points to, or when a comparison date formula in the column definition resolves outside the fiscal year.
Keep one row definition per statement and vary only the column definition when you need a new comparison, otherwise you end up maintaining several near identical layouts that slowly diverge. If you report by dimension, store the dimension filter on the report itself rather than applying it by hand each month, so two people running the same statement get the same figures.
Check the totalling type on the row and the date basis in the column definition. A row pointing at a posting account with the wrong totalling type, or a column asking for a period outside the fiscal year, returns zero without an error.
It is the same feature under a newer name. A financial report is simply a saved combination of a row definition and a column definition.
Zentriq's AI tools automate many of the manual processes around account schedule in Business Central. Learn about the Zentriq Agent or try Zentriq PunchOut to see how AI simplifies procurement in BC.