|
Report of the
<br /> Treasurer/ Collector
<br /> To the Honorable Board of Selectmen and Citizens i
<br /> of the Town of Mashpee, h
<br /> I would like to thank the Board of Selectmen, •
<br /> Town Administrator,an th m l f all h other
<br /> i +o d e employees oyees o the of e
<br /> Town Departments for their assistance and cooperation
<br /> throughout the past year. I would like to especially
<br /> thank my staff,Jennifer Coy,Kathy Cadoret,Stephanie ! !
<br /> Coleman,and Celine Wills for their dedication,support
<br /> and hard work,which is greatly appreciated.
<br /> Part I Treasurer's Cash Activity
<br /> Beginning Cash Balance 07/O1/2016 $34,563,996.60
<br /> Receipts 07/01/2016 thru 06/30/2017 $66,719,568.41
<br /> A/P Expenditures 07/01/2016 thru 06/30/2017 $(34,162,588.91)
<br /> P/R Expenditures 07/01/2016 thru 06/30/2017 $(29,453,131.16)
<br /> Ending Cash Balance 06/30/2017 $37,667,844.94
<br /> Cash on Hand $391.00
<br /> Cooperative Bank of Cape Cod $2,615,265.91
<br /> Cape Cod 5 $211,830.59
<br /> Century Bank&Trust Company $2,436,785.20
<br /> Citizen's Bank $433,546.42
<br /> MMDT $7,418,241.58
<br /> Rockland Trust Company $4,124,200.69
<br /> Rockland Trust Company Investment Group $12,376,883.91
<br /> Harbor One - CD $3,500,000.00
<br /> COOP Bank of CC - CD $4,000,000.00
<br /> Unibank $550,699.64
<br /> Total of All Cash & Investments at 06/30/2017 $37,667,844.94
<br /> Part II Reconciliation of Cash
<br /> Town Town
<br /> Treasurer Accountant
<br /> Balance at 06/30/2017 $37,667,844.94 $37,409,748.19
<br /> Batch Timing differences on Deposit batches $(51,624.32)
<br /> $37,358,123.87
<br /> Vendor& Payroll warrant timing differences $309,721.07
<br /> $37,667,844.94
<br /> Reconciled Balance at 06/30/2017 $37,667,844.94 $37,667,844.94
<br /> 32
<br />
|