YTD Expended column includes LTD totals- YTD Budget Report

Owned by Knowledge Assistant
Oct 20, 2021
2 min read





Description of Issue

YTD Expended amounts display life amounts when Multi Year Life-To-Date (MY LTD) funds are included in find-set



Context

YTD Budget Report

Chart of Account Segments



Cause

MY LTD Funds included in find-set have Life-to-date selected for their Default multi-year report view in Chart of Account Segments and Multiyear View set to Default for report options



Resolution

To ensure that your report only included amounts from the fiscal year defined, update the Mutiyyear View option to Fiscal Year.

Munis > Financial > General Ledger Menu > Inquiries and Reports > YTD Budget Report 

  1. Search for your account range

  2. Click Report Options

  3. Click Additional Options

  4. Update the Multiyear View field to Fiscal Year

If the fund(s) should always report based on fiscal year, you can use the steps below to update the Default multi-year report view.

Munis > Financials > General Ledger Menu > Setup Chart of Accounts > Chart of Account Segments 

  1. Select Fund

  2. Click Accept

  3. Locate and select the desired fund

  4. Click Update

  5. Click on the drop-down for Default multi-year report view and select the desired value

    1. Option only available on Multi Year Life to Date funds



Additional Information

Chart of Account Segments field description- Default multi-year report view

  • This is the default value of the Multiyear View boxes for general ledger reports. It can be overridden when running individual report programs.

  • Selecting Fiscal Year causes reports to display fiscal year activity for accounts included in the report.

  • Selecting Life-to-Date causes reports to display activity from the inception of the account forward.

  • Both options can be further refined using report options such as ranges and time frames.

YTD Budget Report field description- Multiyear View

  • This option determines how the report is displayed for multiyear accounts.

  • Selecting Default View directs the program to use the value set for each fund in the Chart of Account Segments program.

  • Selecting either Life-to-Date or Fiscal Year views causes the report to display all data for the selected funds in the same format, which facilitates comparisons between different fund types.