Monthly Budget Report

Overview:

Tyler Menu> Department Functions>  YTD Budget Report
  • Report options save after they have been configured.  The reports options shown in the document display budget amounts for any funds, locations, functions, etc.
  • The first time you open YTD Budget Report Options, you must choose a Format Type on the Print Options Tab (select “Standard Format”) and a Multiyear View on the Additional Options Tab (select “Default View”).
 

Saving Budget Reports:

  • Save Budget Reports to the correct file –see example below– use the current year
     L:\BUS\BUS_BUDGET\Budget\2019 Budget Files\FY19 Board Meetings
  • Create a new folder and name:
    • Date of board meeting Board Meeting (ex: 20190407 Board Meeting
  • **Save all Budget Reports you have run in this folder, for the next board meeting.**
 

YTD Budget Reports:

These monthly budget reports are to be run by the 10th of each month.  All must be run in one day, there are 9 total reports (8 PDF and 1 EXCEL).

  • Click "See More" to the right, to see instructions for each report.

 

ALL FUNDS

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Account Type,” select Expense and click ACCEPT

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

  5. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in ALL FUNDS in the Report Title. MUNIS will remember the settings last used, ensure that the correct information is requested by clicking Report Options each time a report is run.

  6. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  7. At the bottom of your screen this box will appear. Click to open. This will open the ALL FUNDS budget report. EXAMPLE: Save as: BR YTD – P03 All Funds 20190415 (Use period # run and current date)

** Use ALL FUNDS Budget Report to check all other funds- making sure they are balanced.

CAPITAL IMPROVEMENT FUNDS BY PROGRAM

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund” type in the following fund types: 243|244|501|502|503|504|505|506|540
    Use the bar key “|” which is above the “Enter” key on the keyboard.

    In the “Account Type,”select Expense and click Accept.

  3. Click “Report Options”

  4. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in CAPITAL IMPROVEMENT FUNDS BY PROGRAM in the Report Title. MUNIS will remember the settings last used, ensure that the correct information is requested by clicking Report Options each time a report is run.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  6. At the bottom of your screen this box will appear. Click Open. This will open the Capital Improvement Funds by Program budget report. EXAMPLE: Save as: BR YTD – P03 Capital Improvement Funds by Program 20190417 (Use period # run and current date)

** Use ALL Funds Budget Report and Capital Improvement Funds by Program Budget Report to check each funds available balance- making sure they match.

OPERATING FUND BY FUNCTION

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund”, type 100 “Account Type,” select Expense and click Accept.

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

    1. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in OPERATING FUND BY FUNCTION in the Report.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  6. At the bottom of your screen this box will appear. Click Open. This will open the Operating Fund by Function budget report. EXAMPLE: Save as: BR YTD – P03 Operating Fund by Function 20190417 (Use period # run and current date)

** Use ALL Funds Budget Report to check grand total Available Budget and 100 General Fund Available Budget- both should match.

OPERATING FUND BY FUNCTION – OBJECT

This Budget will be run twice (PDF and EXCEL)

Click "See More" to the right, to see instructions for the PDF version

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund”, type 100 “Account Type,” select Expense and click Accept.

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

    1. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in OPERATING FUND BY FUNCTION - OBJECT in the Report.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  6. At the bottom of your screen this box will appear. Click Open. This will open the Operating Fund by Function – Object budget report. EXAMPLE: Save as: BR YTD – P10 Operating Fund by Function - Object 20190417 (Use period # run and current date)

Click "See More" to the right, to see instructions for the EXCEL version

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund”, type 100 “Account Type,” select Expense and click Accept.

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

    1. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in OPERATING FUND BY FUNCTION - OBJECT in the Report.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click Excel and wait.

    1. The screen below will appear – select the boxes as shown below. MUNIS will remember these selections for future reports.

  6. Click Accept and wait. At the bottom of your screen this box will appear. Click Open. This will open the Excel, Operating Fund by Function – Object budget report. EXAMPLE: Save as: BR YTD – P03 Operating Fund by Function - Object 20190417 (Use period # run and current date)

** This report will also need to be emailed to the Business System’s Analysis.

** Use ALL Funds Budget Report to check grand total Available Budget and 100 General Fund Available Budget- both should match.

OPERATING FUND BY LOCATION

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund”, type 100 “Account Type,” select Expense and click Accept.

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

    1. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in OPERATING FUND BY LOCATION in the Report.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  6. At the bottom of your screen this box will appear. Click Open. This will open the Operating Fund by Location budget report. EXAMPLE: Save as: BR YTD – P03 Operating Fund by Location 20190417 (Use period # run and current date)

** Use ALL Funds Budget Report to check grand total Available Budget and 100 General Fund Available Budget- both should match.

OPERATING FUND BY OBJECT

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund”, type 100 “Account Type,” select Expense and click Accept.

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

    1. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in OPERATING FUND BY OBJECT in the Report.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  6. At the bottom of your screen this box will appear. Click Open. This will open the Operating Fund by Object budget report. Save as: BR YTD – P03 Operating Fund by Object 20190417 (Use period # run and current date)

** Use ALL Funds Budget Report to check grand total Available Budget and 100 General Fund Available Budget- both should match.

OPERATING FUND BY TYPE

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund”, type 100 “Account Type,” select Expense and click Accept.

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

    1. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in OPERATING FUND BY TYPE in the Report.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  6. At the bottom of your screen this box will appear. Click Open. This will open the Operating Fund by Type budget report. Save as: BR YTD – P03 Operating Fund by Type 20190417 (Use period # run and current date)

** Use Operating Fund by Type report to check Available Budget 1 Discretionary against Discretionary on Operating Fund Discretionary by Location report which will be run next.

OPERATING FUND DISCRETIONARY BY LOCATION

 

Instructions:

  1. Open YTD Budget Report (Tyler Menu> Financials >YTD Budget Report). Click “Segment Find”

  2. In “Fund,” type 100, “Type” type 1 and “Account Type,” select Expense and click Accept.

  3. You will be prompted to “Confirm Record Set”, click “Yes, Continue”.
  4. Click “Report Options”

    1. Use pull down menus and check boxes to choose the Report Options shown in example below. You will also need to type in OPERATING FUND DISCRETIONARY BY LOCATION in the Report.

  5. Click Accept then click Back. “Confirm Record Set”, click “Yes, Continue”. Click PDF and wait.

  6. At the bottom of your screen this box will appear. Click Open. This will open the Operating Fund Discretionary by Location budget report. EXAMPLE: Save as: BR YTD – P03 Operating Fund Discretionary by Location 20190417 (Use period # run and current date)

** Use Operating Fund Discretionary by Location to check Available Budget 1 Discretionary on the Operating Fund by Type report.

 


If you have further issues not identified above then click the Request Service button below to work with a technician. Choose "MUNIS" in the Other Software dropdown.

Request Service: Other Software Issues

Details

Article ID: 73872
Created
Fri 3/15/19 11:45 AM
Modified
Fri 3/15/19 4:09 PM