Contents Show
The Fund Budget Spreadsheet (Output) provides information similar to what is reported on a Flexible Budget Performance Report. Only journal entries allocated to the specified Budget Operating Codes are included. The report is generated when the OK button is clicked on the Generate Fund Budget Spreadsheet screen.
A PostPeriodInd flag on the JournalEntry table will indicate post period charges. Actual postings incurred for September and posted in subsequent months will be adjusted to have an accounting period of September. The PostPeriodInd flag on the JournalEntry table will be set to "Y" for these transactions.
The Post Period column will be a hidden column that is merged into the last federal month. It will be placed after the September column. The data derived for the September column will include journal transactions that have a September accounting period. The data derived for the Post Period column will include journal transactions that have a September accounting period and a PostPeriodInd value of "Y".
Travel and Extra Hours and Total Local Agency will be hidden rows.
Selected cells are populated for the start of the spreadsheet. The user may update cells as needed. The spreadsheet is as of the day the spreadsheet is requested. The spreadsheet template will be protected and is not is not intended to be modified by the user. Changes to the template may require programming changes.
Origin of Data Element
The user supplies this value when the report is submitted.
Format
This is formatted as CCYY.
Origin of Data Element
The user supplies this value when the report is submitted.
Format
This is a fifty-character value.
Origin of Data Element
This value is part of the spreadsheet definition.
Format
This is a fifty-character value.
Origin of Data Element
This value is the account number(s) that represent the item description and is part of the spreadsheet definition. This column is a hidden column. The column can be expanded and maintained by the user.
Format
This is a nine-digit number.
Origin of Data Element
This value is the sum budgeted award for Federal WIC program NSA funds for the federal fiscal year. It is the total of the TranAmt column of the JournalEntry table for budget journal entry transactions for the selected fund and item for the federal fiscal year.
Format
This is a nine-digit number.
Origin of Data Element
This value is the sum of the actual expense for each accounting period for Federal WIC program NSA funds for the federal fiscal year. It is the total of the TranAmt column of the JournalEntry table for actual expense journal entry transactions for the selected fund and item for the accounting period.
Format
This is a nine-digit number.
Origin of Data Element
This value is sum of the actual expense for the last accounting period for Federal WIC program nutrition services/administration funds for the federal fiscal year with a transaction date later than the last accounting month. This is the total of the TranAmt column for September journal entries with a PostPeriodInd column valued with "Y". This column is a hidden column.
Format
This is a nine-digit number.
Origin of Data Element
This value is the sum of the actual expenditures for all months for Federal WIC program nutrition services/administration funds for the federal fiscal year. The Post Period (hidden) column is not included.
Format
This is a nine-digit number.
Origin of Data Element
This value is the result of the Budget amount minus the Total To Date amount. It may be manually overridden by typing an adjusted value into the spreadsheet after it is generated.
This value is the projected amount for the accounts for the Federal WIC program nutrition services/administration funds for the federal fiscal year (Budget Variance).
Format
This is a nine-digit number.
Origin of Data Element
This value is the sum of the Total To Date plus Projected.
Format
This is a nine-digit number.
Origin of Data Element
This value is the result of Total Projected divided by Budget. The result is then multiplied by 100 and rounded to the nearest tenth.
Format
This is a three-digit number plus one decimal point.
Origin of Data Element
This value is the result of the Budget minus Total Projected.
Format
This is a nine-digit number.
Origin of Data Element
This value is the sum of the columns from Budget through Surplus/Deficit Budget. Percent of Budget for this row is recalculated using values from this row.
Format
The format follows the same definition as defined the columns.
Origin of Data Element
These values are generated the same manner as the above values.
Format
The format follows the same definition as defined the columns.
Origin of Data Element
The Total Local Agency row will be hidden in the spreadsheet. This value is the sum of the columns for local agency expenditures from Budget through Surplus/Deficit Budget. Percent of Budget for this row is recalculated using values from this row.
Format
The format follows the same definition as defined the columns.
Origin of Data Element
This value is the sum of the rows for Total State and Total Local Agency columns from Budget through Surplus/Deficit. Percent of Budget for this row is recalculated using values from this row.
Format
The format follows the same definition as defined the columns.
The report includes all budget and actual journal entries for the selected fund with an accounting period date that falls between the period beginning and the report's ending accounting period selected by the user.
This spreadsheet will be sorted by the StmtPageNbr column of the StatementLineAccount table. The statement page number controls which page within the spreadsheet the item detail is printed.
This spreadsheet will be sorted by StmtRowID within StmtPageNbr of the StatementLineAccount table. The statement row ID controls the sequence that the items are displayed within the page.
Totals will be calculated.
|
Software Version: 2.40.00