Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
166x Filetype XLSX File size 0.03 MB Source: psc.wi.gov
Sheet 1: Instructions
| Instructions | ||||||||||||||
| Please add as many rows as necessary to any field in the spreadsheet. | ||||||||||||||
| Keep all documentation on file and submit with Final Report and Reimbursement Request. | ||||||||||||||
| For the Final Report and Reimbursement Request all expense items must be supported by sufficient documentation. | ||||||||||||||
| Supporting documents must be submitted at the time the spreadsheet is submitted. Reimbursements will not be issued until proper support is received. |
||||||||||||||
| Green Boxes | must be filled in by the grant recipient before the Budget Tracking Spreadsheet is submitted. |
|||||||||||||
| The information should come from the grant award agreement, Commission Order and the ERF system. | ||||||||||||||
| Use the following Budget Line Items in the Details tab | ||||||||||||||
| Personnel | ||||||||||||||
| Fringe | ||||||||||||||
| Equipment | ||||||||||||||
| Supplies | ||||||||||||||
| Travel | ||||||||||||||
| Contractual | ||||||||||||||
| Other | ||||||||||||||
| Indirect | ||||||||||||||
| For each Budget Line Item, enter the total amount (found in Attachment B- Budget in the grant award agreement) in the Green Box at the top. | ||||||||||||||
| Divide amount between Grant Funded and Match Contributed columns as appropriate | ||||||||||||||
| For each expense item enter the amount spent per quarter. | ||||||||||||||
| Identify the quarter during which expenditures were made for that item. | ||||||||||||||
| Start date - 12/31/2018 | ||||||||||||||
| 01/2019 - 03/2019 | ||||||||||||||
| 04/2019 - 06/2019 | ||||||||||||||
| 07/2019 - 09/2019 | ||||||||||||||
| 10/2019 - 12/2019 | ||||||||||||||
| List each expense item separately on the Detail tab. Do not include summarized amounts. | ||||||||||||||
| There can be multiple expense items attributes to a budget line item. | ||||||||||||||
| Formulas in the Detail spreadsheet will subtract actual expenses from the budget amount and keep a running balance. | ||||||||||||||
| Provide explanation for any budget adjustments under ten percent of the Total Project Cost. Contact your program manager if you expect to transfer funds between Budget Line Items in excess of ten percent of the Total Project Cost. Budget adjustments of ten percent of higher require prior approval provided in an agreement amendment. |
||||||||||||||
| Add all expenditures for each quarter from the Details tab and enter in the Summary tab. | ||||||||||||||
| Please ensure that the total expenses on the detail tab agrees with the Expenditures to Date amount on the Summary tab. | ||||||||||||||
| Energy Innovation Grant Program Budget Tracking Spreadsheet Docket Number: 9709-FG-2018 |
||||
| Expenditure | Total | Grant Funded | Match Contributed | |
| Budget Line Item 1 | Personnel | |||
| Quarter (MM/YYYY-MM/YYYY) | Description | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | $- | $- | |
| Budget Line Item 2 | Fringe | |||
| Quarter (MM/YYYY-MM/YYYY) | Description | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | $- | $- | |
| Budget Line Item 3 | Equipment | |||
| Quarter (MM/YYYY-MM/YYYY) | Description (i.e. Invoice Number) | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | 0.00 | 0.00 | |
| Budget Line Item 4 | Supplies | |||
| Quarter (MM/YYYY-MM/YYYY) | Description | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | 0.00 | 0.00 | |
| Budget Line Item 5 | Travel | |||
| Quarter (MM/YYYY-MM/YYYY) | Description | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | 0.00 | 0.00 | |
| Budget Line Item 6 | Contractual | |||
| Quarter (MM/YYYY-MM/YYYY) | Description | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | 0.00 | 0.00 | |
| Budget Line Item 7 | Other | |||
| Quarter (MM/YYYY-MM/YYYY) | Description | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | 0.00 | 0.00 | |
| Budget Line Item 8 | Indirect | |||
| Quarter (MM/YYYY-MM/YYYY) | Description | Total Expense Amount | ||
| Please Add Rows As Necessary | ||||
| Remaining Budget | $- | 0.00 | 0.00 | |
no reviews yet
Please Login to review.
