Contents Show
The FNS-798 Statement Spreadsheet (Output) consists of multiple worksheets. All worksheets within the spreadsheet are generated. Click the links below for additional information:
The report is generated when the OK button is clicked on the Generate FNS-798 Statement Spreadsheet screen.
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.
Page two of the FNS-798 report includes columns of information for Food, NSA and Total. Unless otherwise noted the following definitions apply to both the Food and NSA columns. Unless otherwise noted, the definition for the Total column is the addition of the Food value and the NSA value for the line.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
This value is calculated by adding line 29 (Formula Grant) plus line 30a (Prior Year Spending - Spend Forward) plus line 30b (Prior Year Spending - Back Spend).
Format
This is a nine-digit number.
Origin of Data Element
For the Food column, this value is the same as the value in line 14 of page 1 (Annual Net Federal Cost) for the reported month. For the NSA column, this value is the same as line 28 of page 1 (Annual Net Federal Cost).
Format
This is a nine-digit number.
Origin of Data Element
This value is calculated by subtracting line 32 (Annual Net Federal Cost) from line 31 (Prior Year Spending - Subtotal).
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
This value is calculated by adding line 33 (Balance Before Application of Pre-payment Vendor Collections) and line 34 (Pre-payment Vendor Collections Applied to NSA).
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
This value is calculated by adding line 35 (Balance Before Conversion) plus line 36a (Conversion Food to NSA) plus line 36b (Conversion NSA to Food).
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
This value is calculated by adding line 37 (Balance After Conversion) plus line 38a (Current Year Spending Options - Spend Forward) plus line 37b(Current Year Spending Options - Back Spend).
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
This value is calculated by adding Preliminary Recoveries/Cash Transfers line 40a (Preliminary Recoveries) and line 40b (Cash Transfers In (Out)).
Format
This is a nine-digit number.
Origin of Data Element
This value is calculated by adding line 39 (Results of Report Year Program Operations) and line 40c (Preliminary Recoveries/Cash Transfers - Total).
Format
This is a nine-digit number.
Origin of Data Element
This value is the total of the TotalReceived column of the BreastPumpReceived table by ReceivedDate. Months up to and including the requested months are calculated and include in the total.
Format
This is a nine-digit number.
Origin of Data Element
The user manually enters this value.
Format
This is a nine-digit number.
Origin of Data Element
The system will place the federal unduplicated migrant enrollment count in the Remarks cell in this format: "Federal Unduplicated Migrant Enrollment = 99,999".
This value is the count of WIC participants with a migrant status. Participants are counted in the first month of the federal fiscal year in which they were certified. Unduplicated means the participant is counted only once during the specified year type.
Format
This is a text value.
Each cell in the spreadsheet has its own definition of how to collect the data.
|
Transaction |
(A) Food |
(B) NSA |
(C) Total |
|
29. Formula Grant |
Manual Entry - New Total (Federal WIC Food Funding) Grant Account (excluding rebates) |
Manual Entry - New Total Federal WIC Admin Grant Account (Base and Supplemental and Allocation Adjustments) |
Columns A + B |
|
30. Prior Year Spending Options a. Spend-forward from Prior Year |
N/A |
Manual Entry - New Spend Forward Account |
Columns A + B |
|
b. Back-spend to Prior Year |
Manual Entry - New Back-spend Account |
Manual Entry - New Back-spend Account |
Columns A + B |
|
31. Subtotal |
Line 29 + Line 30a + Line 30b |
Line 29 + Line 30a + Line 30b |
Line 29 + Line 30a + Line 30b |
|
32. Annual Net Federal Cost |
Line 14 |
Line 28 |
Columns A + B |
|
33. Balance Before Application of Pre-payment Vendor Collections |
Line 31 - Line 32 |
Line 31 - Line 32 |
Line 31 - Line 32 |
|
34. Pre-payment Vendor Collections Applied to NSA |
Manual Entry - New Account that contains value of (Total Rejected + Reprocessed Presented - Reprocessed Authorized (inclusive of handling fee)) (Total Value of Rejected FIs and Reprocessed with Net Change $.00 and Reprocessing Fees for Force Pay and Full Value of Outstanding Unredeemed FIs) |
Manual Entry - Reversal of column A Value (Unexpected food funds to Admin. - Reduces food allotment available and increases the Admin. Allotment) This is the positive amount to the reduction on the food column to convert funds from food to administration. |
Columns A + B (always zero value) |
|
35. Balance Before Conversion |
Line 33 + Line 34 |
Line 33 + Line 34 |
Line 33 + Line 34 |
|
36. Conversion: a. Food to NSA |
Manual Entry - *** See Note |
Manual Entry - Reversal of column A |
Columns A + B (always zero value) |
|
b. NSA to Food |
Manual Entry |
Manual Entry |
Columns A + B (always zero value) |
|
37. Balance After Conversion |
Line 35 + Line 36a + Line 36b |
Line 35 + Line 36a + Line 36b |
Line 35 + Line 36a + Line 36b |
|
38. Current Year Spending Options: a. Spend-forward to Following Year |
N/A |
Manual Entry - New Financial Account - Current Year Spend Forward |
Columns A + B |
|
b. Back-spend from Following Year |
Manual Entry - New Financial Account - Following Year Backspend |
Manual Entry - New Financial Account - Following Year Backspend |
Columns A + B |
|
39. Results of Report Year Program Operations |
Line 37 + Line 38a + Line 38b |
Line 37 + Line 38a + Line 38b |
Line 37 + Line 38a + Line 38b |
|
40. Preliminary Recoveries/Cash Transfers a. Preliminary Recoveries |
Manual Entry |
Manual Entry |
Columns A + B |
|
b. Cash Transfers In (Out) |
Manual Entry |
Manual Entry |
Columns A + B |
|
c. Total Recoveries/Cash Transfers |
Line 40a + Line 40b |
Line 40a + Line 40b |
Line 40a + Line 40b |
|
41. Federal Funds to be Recovered (Restored) |
Line 39 + Line 40c |
Line 39 + Line 40c |
Line 39 + Line 40c |
|
Explanatory Notes: |
· |
· |
· |
|
42. Funds Spent for Breast Pumps |
Breast Pump Total |
Manual Entry |
Columns A + B |
|
43. Portion of Spend-forward to Following Year Attributable to Vendor/Part. Collections |
N/A |
Manual Entry |
Columns A + B |
|
|
NOTE: Calculation of Food to NSA Conversion: |
Two methods of Food to NSA Conversion:
Formula Method: If Actual Participant Total > Annual Target à Amount Moved from Food to NSA = The lesser of (Actual Participant Total - (Administrative Grant per Person * 12 * Annual Target)) and Actual Overexpenditure of NSA Funds (Line 35b))
Request Method: Manual Calculation (This requires FNS approval)
|
Software Version: 2.40.00
