Using Budgets in Financial Reports

QAD 2017 Enterprise Edition > User Guides > Financials > Financial Report Writer > Using Budgets in Financial Reports

Many organizations are interested in reports that not only allow you to compare financial results over periods of time, but also enable you to compare results to budgeted amounts.

To facilitate this requirement, you can create a budget specifically for use in Financial Report Writer, and link your budget structure to your financial reports, You can create the budget in Budget Create (25.5.5.1), or you can import a prepared budget from Excel. You can add budget totals as a column in your financial reports.

Note: This section describes how to define a budget for use in financial reports. Defining budget structures and all other budget-related topics are described in detail in Budgeting.

Before you create a budget structure, it is important to have a clear vision of what you want to achieve and then select the best data model for your needs. See Designing Budget Structures with Report Analysis Codes and Designing Budget Structures with Detailed COA Dimensions.

The system provides two ways of defining an FRW enabled budget.

• Use report analysis codes

• Use detailed individual COA items

Important: The FRW enabled budget must use one approach only. An FRW budget cannot have a mixture of report analysis codes and COA dimensions.

In reporting, Financial Report Run retrieves the budget amounts according to the report analysis code and budget definition.