Financial Reporting – Account Schedule

In Dynamics NAV, account schedule is a standard out of the box  tool for financial reporting. In fact, it is not a replacement, but another powerful tool through which you can build customized financial reports by creating both; customized row and column definition to fulfill financial reporting requirements of the organization.

Let’s take for example the “Revenues” account schedule, which represents a row set of Sales Accounts. Theoretically speaking, you may want to represent several different values for the sales accounts, for that you can create one row definition and multiple column definition.

The primary parts of an account schedule are:

• Row Number
• Description
• Totaling Type
• Totaling
• Row Type
• Account Type
• Show
• New Page

It is important to point out that rows can be configured either as Accounts to retrieve account balances from the general ledger module or can be configured as Formulas in order to handle specific simple/complex calculations.

The other part of the Account Schedule is the column definition, which represents the periods of time to be included either from the ledger or the budget entry. The column definition could have multiple columns considering the following parts:

• Column Number
• Column Header
• Column Type
• Ledger Entry: which determines the source of financial balances; either GL actual balances or Budget ledger entries.
• Amount Type: Balance, Debit or Credit
• Formula
• Show opposite sign
• Comparison Date Formula
• Rounding Factor

A financial report is now represented by selecting a combination of a row definition and a column definition. The date filter is applied on the account schedule preview window, through which you can determine the representation of the column (day, week, month ..etc)  and any required date filter.

Best Regards,
Mahmoud M. AlSaadi