# Business Central Financial Reports: Setup, Account Schedules and Export > Source: https://netray.co/erp-help/business-central-financial-reports-account-schedules-export > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Business Central financial reports are built from a row definition (the lines, historically an account schedule) and a column definition (the periods and amounts), combined in a financial report you can run, filter by dimension and export to Excel or PDF. Standard reports such as balance sheet and income statement are included and can be copied and modified. ## Kind how-to ## System dynamics ## Erp Microsoft Dynamics 365 Business Central ## Module Financial Management / Financial Reports / Account Schedules ## Query business central financial reports ## Alternate Queries - business central account schedule - business central financial report export to excel - business central row definition column definition ## Applies To Dynamics 365 Business Central online and on-premises; the pages were renamed from Account Schedules and Column Layouts to Financial Reports, Row Definitions and Column Definitions in recent releases ## Steps ### How to create and run a financial report **Items:** - Search for Financial Reports, and open one of the standard reports to see how it is built. - Open Row Definitions (formerly Account Schedule Names) and create a new definition; add lines with a Row No., Description, Type and Totaling. - Use type Posting Accounts with a totaling range such as 40000..49999 for income, and type Total or Formula for subtotals. - Open Column Definitions (formerly Column Layouts) and add columns: Net Change or Balance at Date, with a comparison period or budget column. - Create a Financial Report that combines the row definition and column definition, and set the default dimension filters and date filter. - Choose View or Run, set the date filter and dimension filters, and review the result. - Export to Excel or PDF, or use an Excel layout to keep a formatted workbook that refreshes on the live data. ## Sections ### Rows, columns and what each controls **Body:** Rows control what is measured. A row can sum a range of G/L accounts, reference another row through a formula such as total minus cost, or pull from cost types or cash flow accounts. Setting Show Opposite Sign flips the sign for presentation, which is often needed for income lines. Columns control the time and amount. Typical columns are the period Net Change, Year to Date, Balance at Date, and a comparison column such as Same Period Last Year or Budget. Each column has its own comparison date formula, for example -1Y, so the same report works every month. ### Dimensions and filters **Body:** Financial reports can filter by Global Dimension 1 and 2 and by additional dimensions. This is how cost center, department or project reports are produced without building a new report for each. Dimension totaling can also be defined on the row, restricting a line to a specific dimension value. If a number does not match the trial balance, check the date filter, the dimension filter on the report, the totaling ranges and whether the account is set to a posting type. Missing accounts outside the totaling range are the most common cause. ### Export and distribution **Body:** Export to Excel creates a workbook with the values. For repeatable board packs, use Excel layouts on the financial report so the workbook design is kept and the data is refreshed on each run. Reports can also be scheduled and sent by email through report scheduling features. For analysis beyond what rows and columns can express, use Power BI reports over the finance data, or the trial balance and general ledger entries pages with Edit in Excel. Keep the official statements in financial reports so accountants have one controlled definition. ## Pitfalls - Overlapping totaling ranges in rows, which double count accounts. - Forgetting to update the row definition when new G/L accounts are added outside the range. - Applying sign conventions inconsistently with Show Opposite Sign. - Comparing a report run with a dimension filter to the unfiltered trial balance. - Editing the standard report instead of copying it, then losing changes on upgrade. ## Ai Angle ERPray can answer finance questions such as what drove the change in an expense line this month, by reading the G/L entries behind a row and showing the query. It complements financial reports rather than replacing them; the controlled statements stay in Business Central. On-premises, the model and retrieval layer run on your own hardware. ## Faq ### What is an account schedule in Business Central? **Answer:** It is the older name for a financial report row definition: a set of lines that total G/L accounts or formulas. In newer versions the pages are called Row Definitions, Column Definitions and Financial Reports. ### How do I export a financial report to Excel? **Answer:** Open the financial report, choose View or Run, set the filters, then use Export to Excel. You can also use an Excel layout so the workbook keeps its formatting and refreshes with new data. ### Can I filter a financial report by department? **Answer:** Yes, if department is a dimension. Set the dimension filter on the report or define dimension totaling on the row. ### Why does my report not match the trial balance? **Answer:** Check the date filter, dimension filters and totaling ranges, and confirm that every posting account is included once. Formula rows that reference the wrong row number are another frequent cause. ## Search terms business central financial reports, business central account schedule, business central row definition, business central column definition, business central export financial report to excel, business central income statement setup, business central balance sheet report, business central financial report dimension filter --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json