We know the images you are seeing in this article do not match the current version of Ministry Brands Accounting! Our team is working hard to ensure that all our Knowledge Base content is up to date. We are sorry for the inconvenience! Thank you for your patience and understanding!
The Budgeted Financial Statement report allows you to view a side-by-side comparison of the proposed budget for each account and the actual activity for each account. Using Modify Budgeted Financial Formats, you can create custom statement formats to show only the information you want to see in the report (More Information).
Filters
Complete the following filters as needed:
-
Account Type:
- All Income and Expense Accounts
- Fixed Budget Accounts Only
- Variable Budget Accounts Only
- Account Number: This filter lets you further narrow which accounts you want to display in the report. Selecting any option other than Show All displays fields so you can input the numbers.
- Account Structure: Select the levels you want to include on the report.
Note: If you see companies listed in the Account Structure filter, see General Ledger Plus for information on running reports.
Options
Complete the following options as needed:
- Change Appearance?: Check the box to change the font type and size. There is also a drop-down option to control the white space between the columns by a percentage.
- Banded Rows?
- Report Name
- Report Template: You can set up and edit new templates under Modify Budgeted Financial Formats (More Information).
- Select a Different Starting Period for the Fiscal Year?: Check this box if you would like to generate a report starting with a period from last year.
- Reporting Period: The report uses the ending period specified in Current Financial Settings.
Note: Select a Different Starting Period for the Fiscal Year? The option does not appear if the user has the company's first year selected under the Current Financial Settings. Inactive accounts and accounts that don't exist in the current year but had data in any period within the selected range appear on the report. This option is also available on Special Reports.
-
Report Type:
- Detail
- Summary
-
Adjust Variable Budgets:
- Yes: Enter a percentage to increase or decrease the report budget only. This does not change the current budget; only accounts marked as Variable Budgets are affected.
Note: The option to Adjust Variable Budgets is typically used when you wish to run the Budgeted Financial Statement against a scenario in which the budget amounts in the variable accounts are adjusted up or down.
-
Report Options:
- Show Missing Budget as (-) Value? Select this option to make the amounts on the report more understandable to non-accounting individuals. It displays income accounts under budget and expense accounts over budget as negative amounts.
- Suppress Zero Balances?
- Print Percent Of Year Completed In Heading?
- Show Sub Accounts?
- Print Whole Dollars?
- Print In Landscape?
- Show Totals for Each Level?: This option causes a Net total line to display for each level above the department.
- Line Spacing
- # Decimals for Percents
-
Account Description:
- Do not wrap the account description
- Wrap account description
- Print the account description on the second line
-
Page Break Options:
- none
- Department Name
-
Include Options:
- Include Encumbrances (from Purchasing Management).
- Include Opening and Ending Balance for Each Department
-
Export:
- CSV
- Excel
Note: The option to Include Opening and Ending Balance for Each Department should only be used for departments that each have unique closing account references on the balance sheet. When this option is selected, the program pulls the Opening Balance for all closing accounts referenced in the department, adds the Actual YTD column, and then calculates an ending balance.
Report
- Click the Run Report button to generate a preview of the report. Refer to the Report Preview help page for more information. Click the Clear Preferences link to reset all of your report preferences to their default values if needed.
- Click the Close Report button to return to the dashboard.
Note: Click any total on the report to drill down. This displays the Posted Journals page in a new browser tab, showing all the journal detail that comprises the total you click.
Note: The Drill Down functionality only applies to "Actual" columns. In addition, percentage-based columns do not have this feature.
Updated