Revised 10/13/2025
CUSTOMIZING FINANCIAL REPORTS
This guide will outline customizing financial reports in Business Central.
FINANCIAL REPORTs Overview
There are three types of reports in Business Central for akoyaGO:
- Standard reports (not customizable)
- Financial Reports (customizable)
- akoyaGO Reports (Fund Statement, Auditor Report)
The most commonly used reports are in the Actions menu under Reports
- Balance Sheet by Account – (Financial Report) Rows by G/L Account, columns include beginning balance, net change, ending balance
- Revenue and Expenditures – (Financial Report) Rows by G/L Account, one column for net change
- Fund Statement – Customized for each client using the Fund Statement Layout tool. Rows can include G/L accounts or account groups, as well as transactional data
- Auditor Report – Customized for each clients, presenting data with rows by fund and columns by account/account groupings as requested by your auditor. There are three columnar sections in the report: Income, Expenses, and Balances.
- Trial Balance reports - Standard reports with multiple filter options. These cannot be customized.
- Trial Balance - . User can select columns such as Net Change, Balance, etc. and optional comparisons against prior year or budget entries
- Trial Balance Detail/Summary - Beginning Balance, Total Debits, Total Credits and Ending Balance, with option to include transactional detail
- Trial Balance, per Global Dimension - Similar to the Trial Balance, with the option to generate one report per dimension (Fund, Department, etc.)
- Trial Balance Spread Global Dimension - Excel report with one tab per dimension (Fund, Department, etc.)
- Aged Accounts Payable - Aging report for all payable transactions posted against a Vendor record. This report cannot be customized.
- Aged Accounts Receivable - Aging report all receivable transactions posted against a Customer (Donor) record. This report cannot be customized.
For instructions on how to modify the Fund Statement or Auditor Report, see the specific Knowledge Articles for those items.
Editing FINANCIAL REPORTS
Financial Reports allow users to design the account groupings and totals/formulas, to be displayed as rows and columns in financial reports.
Some Financial Reports have been configured specifically for akoyaGO clients using Business Central. These take into special consideration structural factors such as the standard chart of account number ranges, dimensions (Fund, Department) and other features (Net Assets) programmed for akoyaGO.
To view/modify financial reports, navigate to Reports, then Report Setup, then select Financial Reports
Each Financial Report has the following properties:
- Name: Shorthand name for the report
- Display Title: Name displayed in the report header
- Row Definition: Default row set to be displayed in the report
- Row Analysis View Name: (Optional) The analysis view to be used in generating this row set
- Column Definition: Default option for the columns to be displayed in the report
- Column Analysis View Name: (Optional) The analysis view to be used in generating this column set
- Row/Column Analysis View Name: If you link an analysis view to an Financial Report you can use the dimensions assigned to that view in the Financial Report lines. (Fund and Department are available by default)
- Internal Description: (Optional) An internal description of the Financial Report
To modify one of these properties, choose Edit List.
To create a new Financial Report select + New, or select an existing report and choose Copy/Export/Import, then select Copy Report Definition
Note: “akoyaGO” Financial Reports (AK-BALACCT - akoyaGO Balance Sheet by Account, AK-BALFUND - akoyaGO Balance Sheet by Fund, and AK-REVEXP - akoyaGO Revenue and Expenditures) use a specific, predefined layout, and should not be modified directly as changes may be overwritten. Instead, make a copy of these reports to customize them.
Row Definition
To edit the Row Definition for a Financial Report select the relevant Financial Report, then select Edit definitions, then select Edit Row Definition
- Row No: Reference number for the row; can be any number; used in building formulas
- Description: The label displayed on financial statements.
- Totaling Type: You can select Posting Accounts (references g/l or budget accounts), Formula (references other rows in the report), or Account Category to reference any g/l account assigned to a particular g/l account category.
- Totaling: For Posting Accounts, the account, or group of accounts to be included in this row. For Formulas, the formula to be used for this row. For The G/L Account Category, the Category/ies included in this row.
- Row Type: Choose: Net Change, Balance at Date, or Beginning Balance.
- Amount Types: Choose: Net Amount, Debit Amount, or Credit Amount
- Show Opposite Sign: Mark to display debits as credits, or vice versa
- Show: Determines when the row is displayed: Yes (always), No (never), If any column not zero, When positive balance, or when negative balance
- Formatting options: Bold, Italic, Underline, Double Underline, New Page
- Fund Totaling: Use to limit the row to a particular fund, or group of funds.
- Department Totaling: Use to limit the row to a particular department, or group of departments.
Column Definition
Column definitions are used to define the columns that should be included in the resulting report. For example, you can design a layout to compare net change and balance for the same period this year and last year.
To edit column definitions:
- On the Financial Reports page, select the relevant report, select Edit definitions, then select Edit Row Definition.
- On the Column Definition page, create a row for each column by which financial data is shown in the financial report.
- Column No.: Reference number for the column; can be any number; used in building formulas
- Column Header: Column label displayed on the report
- Column Type: Choose from: Formula, Net Change, Balance at Date, Beginning Balance, Year to Date, Rest of Fiscal Year, Entire Fiscal Year
- Ledger Entry Type: Choose either Entries (general ledger) or Budget Entries
- Amount Type: Choose from: Net Amount, Debit Amount, Credit Amount
- Formula: Used for Column Type: Formula (Based on Column No’s)
- Fund/Department Totaling: Limit column results to particular Fund/Department
- Show Opposite Sign: Mark to display debits as credits, or vice versa
- Comparison Date Formula: Specifies which dates should be used to calculate this column
- Comparison Period Formula: Specifies which accounting periods should be used to calculate this column
- Show: Determines when the column data is displayed: Yes (always), No (never), When positive, or When negative
- Rounding Factor: Choose from: 1, 1000, 1000000
- Choose the OK button.
Comparison Dates/Periods
The comparison period is based on the period of the start date of the date filter. Accounting periods must be set up in Business Central for accounting period comparisons to display accurately.
COMPARING ACCOUNTING PERIODS USING PERIOD FORMULAS | |
Abbreviation | Description |
P | Period |
LP | Last period of a fiscal year, half-year, or quarter. |
CP | Current period of a fiscal year, half-year, or quarter. Use CP in formulas to set the period that starts or ends the formula. For example, FY[1..CP] denotes the time from the beginning of the current fiscal year to the current period. |
FY | Fiscal year. For example, FY[1..3] denotes first quarter of the current fiscal year |
Examples of formulas:
Formula | Description |
<Blank> | Current period |
-1P | Previous period |
-1FY[1..LP] | Entire previous fiscal year |
-1FY | Current period in previous fiscal year |
-1FY[1..3] | First quarter of previous fiscal year |
-1FY[1..CP] | From the beginning of previous fiscal year to current period in previous fiscal year, including both periods |
-1FY[CP..LP] | From current period in previous fiscal year to last period of previous fiscal year, including both periods |
If you want to calculate by regular time periods, you must enter a formula in the Comparison Date Formula field instead. For example, if the field is set to -1Y, Business Central compares to the same period 1 year earlier.
Running Custom FINANCIAL REPORTS
Financial Reports can be printed as well as viewed in an interactive preview mode where users can drill down into the report values displayed.
View Printable Financial Reports
From the Reports menu select Run Financial Reports
In the report prompt window, select the Financial Report layout to be viewed/printed. Enter any additional desired report filters and choose Print or Preview & Close.
View Interactive Financial Reports (Preview)
The Financial Report Overview page is where you preview the financial report. Open the overview by highlighting the desired report and selecting View Financial Report.
From the preview, users can apply filters and drill down into the data by clicking on the currency values.
Updating akoyaGO Financial Reports
“akoyaGO” Financial Reports (AK-BALACCT - akoyaGO Balance Sheet by Account, AK-BALFUND - akoyaGO Balance Sheet by Fund, and AK-REVEXP - akoyaGO Revenue and Expenditures) use a specific, predefined layout, and should not be modified directly as changes may be overwritten. Whenever the chart of accounts is modified, these reports should be updated to reflect any changes that have been made. This can be done by selecting Home, then Auto Generated akoyaGO Financial Report
Then select the Report Type, and whether to include account numbers in the row labels. Click OK to run the update process.
Confirm the action by clicking Yes
Standard Financial Reports
Business Central provides four standard templates in financial reports. The name on these templates begins with “M”: M-BALANCE, M-CASHFLOW, M-INCOME, M-RETAIND.
Like other financial reports, these templates must be configured for your unique Chart of Accounts. This can be done manually, or automatically based on G/L Account Categories. For instructions on how to do this, see https://gosupport.akoyago.com/knowledgebase/article/KA-01869