Sample Spreadsheet: Tracking the Use of Funds
[Pages:2]Tool III-2, Sample Spreadsheet
Sample Spreadsheet: Tracking the Use of Funds
ACQUISITION (PROJECT) FUNDS
ADMINISTRATIVE FUNDS
Date
07/01/96 07/01/96 07/01/96 07/02/96 07/06/96 07/06/96 07/06/96 07/07/96 07/07/96 07/07/96 07/12/96 07/15/96 07/16/96 07/16/96 07/22/96 07/23/96 07/25/96 08/01/96 08/01/96 08/05/96 08/15/96 08/16/96 08/16/96 08/16/96 08/16/96 08/16/96 08/17/96 08/22/96 08/22/96 09/01/96
Transaction
Check #
RFF No. 1 Roy Jones 1 Pamela Erzfeld 2 Astern Bell 3 R.M. Garcia Consulting 4 Office 1 Superstore 5 Worldwide Products 6 The Daily Post 7 Adversity County Inquirer 8 Community Center 9 P.W. Electric 101 Astern Bell 102 Pamela Erzfeld 103 Michael Lauder 104 LEON Title 105 Superior Office Supplies 106
Checks RFF No. 2 Pamela Erzfeld 107 LEON Title 108 Astern Bell 109 Adversity County Inquirer 110 R.M. Garcia Consulting 111 Community Center 112 Mitchell Realtor 113 Giselle Moldenhauer 114 Lamb Appraisal 115 Christopher Savage 116 Mr. and Mrs. Henry Smith 117 D'Lorch Locks and Alarms 118
RFF = request for funds
Purpose
Disbursed
Reimbursement Payroll Phone
Equip Rental/Service Supplies Supplies
Bid Advertisements Bid Advertisements
Rent Lights Telephone Payroll Payroll Title Work Supplies
$240.00
Payroll Title Work Telephone Bid Advertisements Equip Rental/Service
Rent Appraisals
Payroll Appraisals Acquisition Acquisition
Locks
$1,440.00
$200.00 $4,900.00 $33,366.32 $23,988.16
Deposit
$0.00
$350,000.00
BALANCE
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($240.00) ($240.00) ($240.00) $349,760.00 $349,760.00 $348,320.00 $348,320.00 $348,320.00 $348,320.00 $348,320.00 $348,120.00 $348,120.00 $343,220.00 $309,853.68 $285,865.52 $285,865.52
Disbursed
$18.37 $825.00 $266.16 $100.00 $242.65 $16.23 $414.00 $126.00 $100.00 $139.16 $155.59 $825.00 $625.00
$275.19 $37.15
$825.00
$112.34 $90.00 $100.00 $100.00
$370.00
$45.00
Deposit
$5,000.00
$0.00
BALANCE
$5,000.00 $4,981.63 $4,156.63 $3,890.47 $3,790.47 $3,547.82 $3,531.59 $3,117.59 $2,991.59 $2,891.59 $2,752.43 $2,596.84 $1,771.84 $1,146.84 $1,146.84
$871.65 $834.50 $834.50
$9.50 $9.50 ($102.84) ($192.84) ($292.84) ($392.84) ($392.84) ($762.84) ($762.84) ($762.84) ($762.84) ($807.84)
Page 1 of 1
This page intentionally left blank.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.