CASH RECONCILIATION DECEMBER 31, 2022

On smaller screens, table values wrap within their columns so all columns remain available.

Cash Less Checks
Outstanding
Cash Book
Balance
*On Hand On Deposit
Current 162,905.29 17,131,493.80 70,142.65 17,224,256.44
Grant Fund 2,326.39 2,289,769.79 851.37 2,291,244.81
Trust - Animal Control 32,982.64 406.46 32,576.18
Trust - Assessment 10,467.52 10,467.52
Trust - Municipal Open Space -
Trust - LOSAP -
Trust - CDBG -
Trust - Other 44,640.00 7,033,722.06 396,154.75 6,682,207.31
Trust - Arts and Culture -
General Capital 9,383,201.82 51,976.03 9,331,225.79
  -
UTILITIES:
Sewer Operating 9,862.51 3,384,842.24 3,394,704.75
Sewer Capital 684,801.57 145.39 684,656.18
Parking Operating 5,785.44 1,295,932.55 5,008.95 1,296,709.04
Parking Capital 78,648.89 16.70 78,632.19
  -
  -
  -
  -
  -
  -
  -
  -
  -
  -
  -
  -
  -
Total 225,519.63 41,325,862.88 524,702.30 41,026,680.21

* Include Deposits In Transit

** Be sure to include a Public Assistance Account reconciliation and trial balance if the municipality maintains such a bank account.

REQUIRED CERTIFICATION

        I hereby certify that all amounts shown in the "Cash on Deposit" column on Sheet 9 and 9(a) have been verified with the applicable bank statements, certificates, agreements or passbooks at December 31, 2022.

        I also certify that all amounts, if any, shown for Investments in Savings and Loan Associations on any trial balance have been verified with the applicable passbook at December 31, 2022.

        All "Certificates of Deposits", Repurchase Agreements" and other investments must be reported as cash and included in this certification.

        (THIS MUST BE SIGNED BY THE REGISTERED MUNICIPAL ACCOUNTANT (STATUTORY AUDITOR) OR
CHIEF FINANCIAL OFFICER) depending on who prepared this Annual Financial Statement as certified to on Sheet 1 or 1(a).
Signature:
pelster@somervillenj.org
Title:
CFO
Sheet 9