Cash Reporting Analyst, Level 2
-
Finance & Banking
-
Accounting
Job Description & How to Apply Below
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 position 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 Cash Reporting Analyst, Level 2 works with banking institutions, City depariments, and the Audlting 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.
JOB FUNCTIONS AND DUTIES
The essential functions or duties listed below are intended only as illustrations of the various type of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position.
- 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 cash payments to the Treasurer's cash book system in MUNIS.
- Coordinate with banking institutions to improve electronic transaction reporting and reconciliation processes and support 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 dai!y 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.
Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
QUALIFICATIONS Education/Experience- Bachelor's degree in business, finance, accounting, or a related field.
- Three (3) to five (5) years of progressively responsible experience in cash management, financial reconciliation, accounting, or a related field, preferably in a municipal or public-sector organization; experience with bank account reconciliation, treasury operations, or investment reporting preferred.
- An equivalent combination of education, training, and experience may be considered.
- Working knowledge of computer-based financial systems, including People Soft Financials, People Soft 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…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction