Somerville Public Schools
Employment Opportunities


SPS Administrative Office
Somerville Public Schools
Somerville, Massachusetts

Job Details
Job ID: 3511318 Application Deadline: Posted until Filled
Posted: April 29, 2021 Starting Date: May 31, 2021

Job Description

Principal Account Clerk/Payroll Administrator

Job Goal: Organize, coordinate, schedule and perform office functions to support the Principal/Assistant Principal/Director and/or Supervisor. Coordinate communications between administrators, District and site personnel, parents, students and the general public.

Responsibilities & Qualifications: Please refer to Job Description below

Position Reports to: Director and Assistant Director of Finance and Payroll Manager

Rate of Compensation: In accordance with AFSCME Clerical Collective Bargaining Agreement

Should you need assistance with the online application process, please email Jean Cabral,


The Principal Account Clerk / Payroll Specialist supports District strategies, goals and objectives by preparing and processing accurate and timely payroll complying with all established District, municipal, DESE and general accounting principles and procedures, state and federal tax agencies, pension systems and a wide range of corporate compensation and benefit vendors. The position supports the integrity of the District Finance Department expending more than 85% of District and other budget in an accurate manner. It supports staff morale and confidence by accurately applying the terms of District collective bargaining agreements, individual salary and benefits agreements and employee contracts, District staff policies and procedures. The position plays a critical role in enabling District staff to focus without negative distractions on the District goals, objectives and strategies associated with the education of the Somerville student by effectively managing benefits and compensation best practice.

•Prepares payroll for all District staff;
•Plans, manages and administers all staff voluntary and mandatory payroll deductions including but not limited to insurances, union dues, deferred compensation, retirement, loans, etc.;
•Manages and processes electronic payroll deposit files;
•Processes and applies to payroll all staff appointments, salary adjustments, promotions, resignations, terminations, leaves of absence, and any other changes affecting the payroll;
•Plans work program to adhere to payroll schedules;
•Sorts and distributes pay checks;
•Prepares employer quarterly and year-end tax agency reports (forms 940, 941, W2, etc.);
•Responds to all inquiries related to employee benefits and compensation (i.e. credit inquiries, disability and workmen’s compensation, IRS, MA DOR, etc.;
•Manages and utilizes MUNIS payroll software and all related databases utilizing MS Office, FileMaker Pro in the performance of the job;
•Assists in the maintenance of the human resources employee database;
•Maintains and applies effective working knowledge of benefits and compensation best practices, tax entity forms, methodology, processes and procedures;
•Applies working knowledge of Social Security and Retirement Laws, federal, state and local tax laws, rules and regulations with respect to payroll preparation and maintenance of records;
•Prepares simple and complex payroll accounting to accurately calculate employee compensation and benefits;
•Communicates with all District stakeholders relative to the payroll process including employees, administrators, department heads and municipal and state officials;
•Reconciles expenditures recorded in the Substitute Teacher database to ensure accurate application to payroll file;
•Manages multiple complex tasks simultaneously and under pressure with a high degree of accuracy and accountability;
•Exercises good judgment and common sense;
•Demonstrates the highest level of customer service skills when addressing employee questions, concerns, and successfully reconciles employee compensation and benefits issues;
•Analyzes staff function so as to accurately assign appropriate payroll expense accounts to the General Ledger; creates new GL accounts as needed;
•Manages payroll deduction codes for all employee records to ensure highest level of accuracy;
•Creates and manages MUNIS Job Classifications and Position Control Records for all District position;
•Creates and manages salary/longevity/stipend schedule table as defined by union CBA’s / individual employment agreements for all employees to ensure accuracy of payment;
•Creates and maintains location codes to ensure that every employee is appropriately attached to the correct location and assignment for each fiscal year;
•Maintains group/union codes to ensure that all employees are attached to the appropriate unit as appropriate;
•Manages all ABA routing data to ensure accuracy of employee electronic pay deposits;
•Maintains a working knowledge and understanding of MUNIS payroll software / functionality through the entire payroll process;
•Establishes and manages Payroll Control settings to ensure each payroll type (i.e. weekly, bi-weekly, teachers) generates and processes correctly;
•Performs system validation through MUNIS “train” mode of payroll configuration changes;
•Configures Excel timesheets from district departments and prepares them for import into the payroll;
•Prepares and calculates manual paychecks as needed;
•Balances each payroll to the general ledger;
•Prints paychecks and notices of electronic deposit;
•Generates pay files for employees and vendors, assigns payroll file paths for transmitting to Municipal Auditor and Treasurer;
•Generates a wide range of payroll reports required for Municipal Treasurer including payroll registers, bank reports, child support and garnishment reports, vendor reports;
•Generates and analyzes data reports to ensure accuracy of employee payroll deduction, salary, tax, demographic files and records;
•Analyzes and assigns GL entries for accounting accruals;
•Receives, researches and addresses questions from employees through MUNIS requiring knowledge of MUNIS modules and report writing;
•Updates all salary tables each new collective bargaining unit and applies batch salary changes; applies terms of CBA’s, MOA’s, Salary and Benefits Agreements and Employee Contracts to the MUNIS file;
•Processes a wide range of reports as required;
•Reconciles, processes and transmits the monthly retirement report to Massachusetts Teachers Retirement system utilizing MyTRS pension software;
•Assists with the preparation of accounting audit materials;
•Reconciles financial statements and reports as appropriate;
•Performs other duties consistent with the scope and responsibility of the position as assigned, as may be required, and as may be requested by the Department Head or their designee.

•Knowledge and understanding of MUNIS payroll software to successfully prepare, transmit and manage employee benefits and compensation;
•Excellent technology skills including MS Office, FileMaker Pro and other appropriate applications as needed;
•Ability to communicate effectively and successfully address questions from staff and other stakeholders;
•Excellent analytical skills; ability to perform complex mathematical calculations to apply and manage employee compensation, benefits and related;
•Ability to maintain regular and consistent job attendance to support multiple payroll cycles; highest level of job commitment and work ethic;
•Excellent customer service skills and related professional characteristics including but not limited to the exercise and demonstration of tact, courtesy, respect under stressful circumstances;
•Ability to multi-task and meet stringent deadlines;
•Analytical skills to review, analyze and apply terms of multiple employee collective bargaining agreements, salary and benefits agreements and individual employee contracts;
•Knowledge of municipal, DESE and general payroll accounting procedures; knowledge of MA state pension law and regulations relative to payroll process;
•Knowledge of MTRS MyTRS reporting requirements and process.

•Five years of senior-level administrative support experience preferably incorporating payroll and or general accounting with progressive responsibility;
•Appropriate level of post-secondary studies in an applicable field (i.e. accounting, finance, management) preferred;
•Acceptable combination of experience and education.

Position Type: Full-time
Positions Available: 1

Welcome to Somerville Public Schools!

Education - Inspiration - Excellence are the themes that characterize the instructional services, departments and programs of the Somerville Public Schools. Our Mission: The Somerville Public Schools is dedicated to the realization of the full intellectual, physical, social, and emotional potential of all students. Our talented team of teachers and other professionals provides every student with the knowledge, skills and attitudes needed to be successful throughout their lives. This is accomplished through the delivery of innovative instruction guided by the Massachusetts Curriculum and Somerville Curriculum Frameworks, and supported through partnerships with organizations such as Primary Source, and the Center for Engineering Education and Outreach at Tufts University.

Equal Opportunity Employer
Somerville Public Schools is committed to maintaining a work and learning environment free from discrimination on the basis of race, color, religion, national origin, pregnancy, gender, sexual orientation, marital/civil union status, ancestry, place of birth, age, citizenship status, veteran status, political affiliation or disability, as defined and required by state and federal laws.

Job Requirements
  • Citizenship, residency or work VISA in United States required

  • Application Questions
    There are no application questions required for this job posting.

    Contact Information
    Joan White
    8 Bonair St
    Somerville, Massachusetts 02145
    Phone: 617-625-6600