Federal Accounting - Everett, United States - The Commonwealth of Massachusetts
Description
Job DescriptionAre you the right applicant for this opportunity Find out by reading through the role overview below.
The Education Secretariat is committed to equity and valuing the unique and diverse characteristics and experiences of every member of its workforce.
We encourage an authentic workplace where colleagues show up as their full selves, where collaboration, innovation, and connections are key to realizing our mission that all children, youth, and families thrive socially, academically, and economically.
We seek teammates who are committed to promoting a diverse and inclusive work environment, where everyone is valued and engaged.
We encourage you to apply and identify your strengths in these areas.
The Federal Accounting and Reporting Unit is responsible for working with the State Comptroller and the State Treasurer to ensure that federal funds are received in a timely manner and in compliance with all federal and state regulations.
This includes managing all fiscal matters associated with the account establishment, tracking draw down of funds from the Federal Government, reconciliation and reporting requirements of expenses and revenues for federal grants.
This office provides reports and gathers data for units within DESE's Administration and Finance Center and areas throughout the agency.
Key Responsibilities:
Set up of grants into the Reimbursable Grant Structure of the state accounting system (MMARS)
Review Continuing and New Grant Awards received by the United States Department of Education (USED, the United States Department of Agriculture (USDA) and the United States Department of Health and Human Services Grants (USHHS).
Enter set-up tables into the state accounting system detailing grant data, including CFDA#, UEI number, Award Identification, specific drawdown system used, $ Amount, period of the grant including AP period, Name and FAIN number.
Prepare set-up document (BGRG) into the state accounting system creating the award in the Reimbursable Grant Structure of MMARS via DocuSign attaching appropriate backup.
Follow up, as necessary.
2.
Reconciliation of MMARS disbursements to the Federal Payment Systems
Reconcile 495W Report to Federal Payment Systems; the US Department of Education's Grants Management System (G5), the Automated Standard Application for Payments (ASAP), and the Payment Management Services (PMS) on a weekly basis.
Reconcile at the end of each month the available balances on the Federal Systems G5, ASAP, and PMS to the Revenue balances in MMARS.
Draw Rejects should be resolved immediately working with the State Comptroller's Office, the Federal Funds Auditor and Program Staff preparing necessary documents as needed.
Maintain accurate paperless records for the Unit needed by internal staff as well as for the Single Audit and Federal and State Reviews.
Participate in ISA (Interdepartmental Service Agreement) and EX (Expenditure Correction) oversight and set up.
Follow up, as necessary.
Review EX's for accuracy, ensuring funds are available to move, Expense Budgets have been entered and then enter Document into MMARS.
4.
Prepare Commonwealth Information Warehouse (CIW) queries and reports for the unit as well as ad hoc reports for other units within the A&F Center and DESE program staff.
5.
Assist in the Federal Funding Accountability and Transaction Act (FFATA) Reporting
Gather data from the grants management subsystem (GEM$) to be uploaded into the FFATA Subaward Reporting System (FSRS) meeting all timelines.
6.
Track State and Federal Return of funds
Participate in monthly updating of state grant return spreadsheets for use by program and budget staff, and ensure refunds in sub-systems agree to MMARS.
7.
Return of Funds to the Federal Government
Work with unit to create a list of USED, USDA and USHHS federal funds that need to be returned to the federal government.
Determine if there is enough revenue in the current fiscal year as an RF1 document is processed, if current fiscal year revenue supports the transaction, otherwise it needs to be returned via a GAX with object T04.
Closeout of the State Fiscal year
Prepare pushback documents if necessary.
9.
Closeout of Federal Fiscal year
Work with the Budget Unit to determine any fringe and indirect that may post after the last day to draw.
10.
Reconcile subsystem activity to the state accounting system
Preferred Qualifications:
Questions regarding this posting or the application process should be referred to Dawn DeRoche in Human Resources at .
Please include a resume and cover letter with your submission.
Please note:
In December, 2023 our office will move to:
135 Santilli Highway, Everett, MA
Qualifications
First consideration will be given to those applicants that apply within the first 14 days.
Minimum Entrance Requirements:
Applicants must have at least (A) four years of full-time, or equivalent part-time, professional experience in accounting or auditing, of which at least (B) two years must have been in a supervisory, administrative or managerial capacity, or (C) any equivalent combination of the required experience and the substitutions below.
Substitutions:
I.
An Associate's degree with a major in accounting, business administration or business management may be substituted for a maximum of one year of the required (A) experience.
II.A Bachelor's degree with a major in accounting, business administration or business management may be substituted for a maximum of two years of the required (A) experience.
III.A Graduate degree with a major in accounting, business administration or business management may be substituted for a maximum of two years of the required (A) experience and one year of the required (B) experience.
*Education toward such a degree will be prorated on the basis of the proportion of the requirements actually completed.NOTE:
Educational substitutions will only be permitted for a maximum of one year of the required (B) experience.
Comprehensive Benefits
When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package.
Want the specifics? Explore our Employee Benefits and Rewards
An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.
The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.
Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements.
We encourage individuals who believe they have the skills necessary to thrive to apply for this role.