Cash Reporting Analyst, Level 2

City Of Cambridge Massachusetts•Cambridge, MA

About The Position

The Cash Reporting Analyst, Level 2 performs advanced cash management, reconciliation, and financial reporting work for the City of Cambridge Finance Department. Reporting to the Manager of Revenue and Treasury Operations, the analyst monitors and reconciles daily cash activity across City bank accounts; supports accurate posting of cash receipts and payments to the Treasurer's cash book system; coordinates payroll, vendor payment, debt service, and wire transfer funding activities; and reconciles the Treasurer's cash book to the General Ledger cash balance. The role works with banking institutions, City departments, and the Auditing Department to improve electronic transaction reporting, ensure timely and accurate revenue reporting, prepare cash flow analyses and audit schedules, administer Massachusetts Municipal Depository Trust activity for bond-funded projects, and support accurate cash reporting, liquidity management, and compliance with financial controls. Work is performed primarily in a standard office environment and involves frequent use of financial systems and office equipment, detailed reconciliation work, and regular interaction with internal and external stakeholders. The position has no formal supervisory responsibilities, though it may provide functional guidance, cross-training, and operational support to staff, interns, or temporary employees as assigned.

Requirements

  • Bachelor's degree in business, finance, accounting, or a related field.
  • Three to five years of progressively responsible experience in cash management, financial reconciliation, accounting, or a related field.
  • Working knowledge of computer-based financial systems, including PeopleSoft Financials, PeopleSoft HRMS, MUNIS, or similar enterprise financial systems.
  • Knowledge of cash management, bank reconciliation, liquidity management, debt service payment coordination, wire transfers, audit schedules, and financial controls.
  • Knowledge of revenue reporting, electronic receipts, account reconciliation, financial transaction processing, and year-end close practices.
  • Proficiency with Microsoft Office, particularly Word and Excel.
  • Strong analytical, reconciliation, documentation, troubleshooting, organizational, and problem-solving skills, with a high degree of accuracy and attention to detail.
  • Strong interpersonal, written, and verbal communication skills.
  • Ability to monitor cash activity, research and resolve discrepancies, prepare cash flow analyses, support audit requirements, and communicate clearly with City departments, banking institutions, auditors, and other stakeholders.
  • Ability to manage multiple priorities and work effectively in a fast-paced, demanding environment.
  • Ability to work independently with minimal supervision and collaboratively as part of a team.
  • Ability to work and interact effectively with individuals and groups across diverse identities, cultures, backgrounds, and ideologies.

Nice To Haves

  • Experience in a municipal or public-sector organization is preferred.
  • Experience with bank account reconciliation, treasury operations, or investment reporting is preferred.
  • An equivalent combination of education, training, and experience may be considered.

Responsibilities

  • Monitor and reconcile daily cash transactions for City bank accounts to support accurate cash reporting, liquidity management, and compliance with financial controls.
  • Post City cash receipts and payments to the Treasurer's cash book system in MUNIS.
  • Coordinate with banking institutions to improve electronic transaction reporting and reconciliation processes and support the use of available banking technology.
  • Collaborate with the Auditing Department to reconcile the Treasurer's cash book to the General Ledger cash balance.
  • Monitor the City's cash position and review reported bank account balances to support daily cash flow management and funding decisions.
  • Coordinate and oversee funding activities for weekly payroll and vendor disbursements to ensure accounts are appropriately funded.
  • Reconcile warrants from the Auditing and Payroll Departments to proposed funding schedules and resolve discrepancies in a timely manner.
  • Perform monthly reconciliation of City bank accounts to the Treasurer's ledger and related financial records.
  • Coordinate with City departments regarding electronic receipts posted to the City's Concentration Account to ensure timely and accurate revenue reporting and account reconciliation.
  • Prepare cash flow analyses and related financial reports to support investment planning, liquidity management, and maximization of interest income opportunities.
  • Manage the City's debt service payment schedule and coordinate related wire transfers to ensure timely and accurate payments.
  • Administer Massachusetts Municipal Depository Trust accounts and coordinate timely, accurate transfers for bond-funded projects.
  • Prepare audit schedules, reconciliations, and supporting documentation for the annual independent audit.
  • Perform related duties as required.
  • May provide functional guidance, cross-training, and operational support to staff, interns, or temporary employees as assigned.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service