Effective Date: 07/01/2017
Best Practice
Because of the wide variety of grants that BWSR disburses to local governments, the accounting systems and structures that are already in place at those local governments, and the many different funding sources that local governments have to deal with and are held accountable to, it is impossible to identify a universal method of accounting for BWSR grants that will work for all. The information below provides a few examples of best practices for program and project accounting that could be adapted for local use. This type of accounting will assist in future reconciliations of the grant by BWSR.
The examples below are not exhaustive or definitive. There may be other data elements that you track in your time, program, or project-based accounting systems, depending on your own capacities and needs.
Example 1: Program Accounting
The first example shows how a grant recipient might summarize the expenditures, including staff time, on a BWSR Conservation Program and Operations Grant—in this case, the Natural Resources Block Grant Wetland Conservation Act (WCA) program.
Grant: BWSR NRBG, WCA, FY 2013 |
||||||||||
Salaries |
||||||||||
|
|
Activity (Grant Hours/ Match Hours) |
|
|
|
|
||||
Employee Name |
Hourly Rate |
Admin./ Coord.
|
Tech./ Eng. Assist. |
Total Hours (Grant/ Match) |
Total Amount Charged to Grant |
Total Amount Contr. in Match |
Total Amount Spent |
|||
Hanna Gray |
$40/hour |
50/50 |
10 |
60/50 |
$2400 |
$2000 |
$4400 |
|||
Ed Levi |
$30/hour |
|
300 |
300 |
$9000 |
|
$9000 |
|||
Subtotal |
|
|
|
|
$11400 |
$2000 |
$13400 |
|||
Expenses |
||||||||||
Expenses |
Activity |
Amount Budgeted |
Amount Spent |
|||||||
Vehicle Expense |
Admin./Coordination |
$400 |
$395 |
|||||||
Field Supplies |
Supplies/Equipment |
$20 |
$20 |
|||||||
Postage |
Admin./Coordination |
$10 |
0 |
|||||||
Subtotal |
|
|
$415 |
|||||||
Transfers: |
||||||||||
To SWCD |
$5000 |
|||||||||
Total |
|
|
$18815 |
|||||||
To save space on the page, the example lists hours charged to the grant by Activity in the same column as hours contributed in match. It may be clearer to list them in separate columns. After summarizing staff time expenditures, the worksheet lists the other direct costs charged to the grant, similarly categorizing them by eLINK Activity.
Note: The staff time listed in this program summary, as well as in the following example, is meant to be a summary only. It should be backed up by a more detailed time tracking system that tracks the time spent on the grant by multiple employees, by grant and activity, and by date. See also “Best Practice: Time Tracking.”
Example 2: Project-based Accounting
Here is an example of accounting for expenditures on a Clean Water Fund project. The example tracks staff time assigned to the Activity of Technical/Engineering Assistance separately from the expenditures assigned to the Activity of Conservation Drainage. In addition, local dollars contributed to the projects in match are separated out from other spending on the project, so that the costs charged to the grant can be totaled separately.
Grant: BWSR CWF Grant, FY 2013 |
|||||||
Salaries |
|||||||
Activity: Administration/Coordination |
|||||||
Employee |
Hourly Rate |
Total Hours Worked |
Total |
||||
Hanna Gray |
$40/hour |
10 |
$400 |
||||
|
|
|
|
||||
Subtotal |
|
|
$400 |
||||
|
|||||||
Activity: Conservation Drainage |
|||||||
Description |
Amount Budgeted |
Amount Spent |
Match |
Amount of Grant Spent |
|||
Jones |
$300 |
$300 |
$50 |
$250 |
|||
Smith |
$400 |
$290 |
$50 |
$240 |
|||
Subtotal |
|
|
|
$490 |
|||
Total |
|
|
|
$1040 |
|||
History
Date |
|
Revised format; minor text changes for clarity. |
7/1/2017 |