Financial Reporting
General Ledger Account Inquiry
G/L Account Inquiry, already a powerful tool in MUNIS®, can be downloaded to Excel. While you get more fields than you probably want, custom reporting can be created through this option.
In many places in the G/L Account Inquiry, you can click on a folder for immediate access to detail information-very nice!
When doing G/L Account Inquiry, under the Detail option, Help is available in the "Source Journal" field.
When selecting "Detail", you can select a range of periods within a year. Also, after "Find" and "Detail", you can select "Detail" again. Standard invoice information can then be viewed including vendor address and invoice comments.
Object Code Guide
Ever wonder which object code you should use to record a specific transaction? The OBJECT CODE GUIDE should make that task easier. The GUIDE provides descriptions, examples and cross-references for revenue and expenditure object codes. To have an object code attached to an org, or to have a new object code established, contact Financial Reporting in the Auditor's Office.
Month-End Close
At the end of each month, we manually adjust the period for every Accounts Payable invoice that has been keyed but not yet cash-disbursed. To facilitate this process, MUNIS® will be unavailable for general use after 3:30 p.m. on the last business day of each month. Please keep this in mind when planning your work. The pop-up box will carry a reminder message a couple of days in advance.
Financial Reports
Historical Actuals Comparison compares actuals for current and past three fiscal years against current year revised budget.
Flexible Period Report allows selection of periods in the past three years as well as the current year. It also allows reporting of years other than the current year. This should be beneficial to agencies that need to report to grantor agencies on a fiscal year rather than a calendar year.
Try the Account Detail History Report in the General Ledger Inquiries and Reports menu. While the report is not as visually appealing as the Account Trial Balance Report, fields such as receipt number and check number are included and can be helpful.
Printouts from G/L Inquiry Screen
Want to get a printout of "live" information from the G/L? You can do it, but the process is not too obvious. Once you have selected the account or range of accounts you are interested in, select "browse" from the ring menu, and then do an output.
You may find this feature helpful when looking for information within a particular budget level. For example, to look at materials and supplies, put your ORG range in and select 53* under object. Your output will give you totals by object, then a total for all materials and supplies, including available budget.
Purchase Order History
Some of the "canned" reports from MUNIS®, including Purchase Orders by GL Segments, can print zero balance purchase orders, but will not print closed purchase orders.
"Posted" Vs. "Live" Information
Keep in mind that the reports generated by the system give "posted" information (Invoice by G/L Account, Trial Balances, Subsidiary Ledgers, Balance Sheet). On-line inquiries and the reports created through the IQ report writer present "live" information (G/L Account Inquiry, PO Inquiry, Vendor Invoice Lists).
The Balance Sheet
Non-general fund agencies may find the system-generated Balance Sheet to be useful when trying to view general information at a glance.
New Funds and New Orgs
Unless specifically established by Ohio statute, new funds can only be created upon approval of the Auditor of State's Office and subsequent resolution by the appropriate board. Please submit written requests for new funds on the Fund Applications form to the attention of Robert Caldwell at [email protected], who will then submit the request to the Auditor of State.
New organizations or departments can be set up through written request from an agency. The request should indicate to which fund the org will belong, and whether it is a budget level or a low-level org. A board resolution is not needed to create the new org.