Financial Report Menus
On this page:
Fund Accounting's Financial Reports menus include option for generating reports in a variety of formats. The reporting formats include balance sheets, status and comparison reports, and other statements relating to expenditures, revenues, projects, cash accounts, and enterprise funds. An option is also available for running a trial balance.
Menu Path: Fund Accounting > Reports > select a menu, and then select an option.
Financial Reports Menus
Report Menu | Details |
|---|---|
Accounts Payable Reports | Some options also allow you to choose a report's sort order or format. More details on each report listed in the menu can be found on the Accounts Payable Reports page. |
Audit Trails | The Audit Trails menu provides options you can use to audit additions and changes to your ledgers. More details can be found on the Audit Trails page. |
Balance Sheets | Provides options for generating either a separate balance sheet for each fund, a consolidated balance sheet, or a balance sheet combined by fund group. |
Budget Control Reports | Provides options for monitoring budgets for a specified period and year. |
Daily Transaction Listings | Use the options on the Daily Transaction Listings menu to generate reports of daily posting activities. These reports are used to balance and verify entries. |
Expenditure Comparison Reports | Provides options for comparing the budgets, expenditures, and balances from the current year with those from the previous year. You can include or exclude encumbrances. The reports can be by account, budget unit (detail), or fund (summary). |
Expenditure Status Reports | Provides options for generating expenditure reports either by account, budget unit (detail), or fund (summary). In addition, an option is provided for generating a set of Governmental Accounting Standards Board (GASB) reports on the status of expenditure accounts. |
Financial Statements | Provides options for verifying cash receipts, encumbrance and cash activities, and receivables. Options are also provided for generating an enterprise fund income statement as well as a trial balance. |
Project Status Reports | Provides expenditure and revenue data for projects or project/accounts in a specified period and year. |
Revenue Comparison Reports | Provides options for comparing current and past year revenue budgets. The reports can be by account, budget unit (detail), or fund (summary). |
Revenue Status Reports | Provides options for generating revenue reports either by account, budget unit (detail), or fund (summary). In addition, an option is provided for generating a detailed Governmental Accounting Standards Board (GASB) report on the status of revenue accounts. |
System Maintenance | Use to generate reports to verify that your ledgers are in balance. |
Sort Item
The Action Bar on some Financial Statements pages provides a Sort item for displaying a Sort Order page, where you can define a report's sort order, totals, and page breaks. The page includes the following columns. You can enter or change settings in the first three columns, while the fourth is display only.
Order | Defines the sort order for a report, using the distribution levels in the Title column. Enter the numbers 1-8, depending on how many levels are set up in your Organization Chart and how many sort levels you want to use. |
Total | Defines the totals for distribution levels. Totals can only be applied to levels used for sorting. Enter an asterisk to indicate that you want to include a total for a particular level. |
Page | Defines additional page breaks. Page breaks can only be applied to levels used for sorting. To add a page break for a distribution level, enter an asterisk. |
Title | Lists the distribution levels set up in your Organization Chart. The titles enclosed in asterisks were defined in the Fund Accounting Profile, while the titles shown in all capital letters are system-defined in the Account List. |
When you enter a number in the first column and tab through the other two fields (with or without entering asterisks), the system re-orders the list accordingly. Also, if you skip a number, the system maintains the proper sequence by changing the next number to the one that is missing.
Click OK to close the page when you finish. Your settings remain as the defaults until you change them again or close the current report option.
Following is the standard procedure for generating reports from the Financial Reports menus.
Generating a report
Select Fund Accounting > Reports to display the Reports menu.
Select the desired report option to display a report page.
If the page has a Sort Options section, select the appropriate radio button to set the sort order to use for the report.
or
If the page's Action Bar displays Sort item, click the item to display the Sort Order page, which you can use to customize the report's sort order. You also can specify additional totals and page breaks. For additional details on using this page, refer to the section above, Sort Item.In the page's Report Criteria section, identify the records to include in your report.
If the page has an Additional Criteria section, enter the Year and Period, and then select the desired checkboxes (if available).
Click OK.
In the Print window, specify how you want to generate the report, and then click OK.