Specialist, Financial Reporting, Planning and Analysis

Job Title: Specialist, Financial Reporting, Planning and Analysis

Job Summary: The Specialist, Financial Reporting, Planning and Analysis will utilize accounting knowledge, research and analytical skills to ensure that the highest level of service is being provided to our customers. This position interacts on a regular basis with internal departmental staff throughout the company. The ideal candidate will be responsible for preparing and updating payroll files, passthrough expense files, and financial statements, as well as assisting with bank reconciliations, preparing journal entries, and monthly reporting. This role requires collaboration with various departments to ensure accurate and timely financial reporting.

Key Responsibilities:

• Payroll File Preparation:
  • Prepare and update monthly payroll files, including rolling forward payroll files, updating tabs, and reconciling payroll files with invoices.
  • Record monthly payroll expenses and update employee lists in accordance with changes per Census.
  • Prepare staffing forecasts based on current and open positions for each school.
  • Create appropriate journal entries in Sage Intacct.
• Passthrough Expense File Preparation:
  • Prepare and update passthrough files, including coding passthrough expenses and updating tabs.
  • Review and reconcile passthrough files with invoices.
  • Record monthly miscellaneous expense transactions and accruals.
  • Create appropriate journal entries in Sage Intacct.
• Financial Statement Preparation:
  • Prepare monthly financial statement close files.
  • Update grant tracking spreadsheets and perform roll forward of SFS working papers.
  • Maintain support documentation
• Bank Reconciliation:
  • Assist in bank reconciliation tasks, including preparing Cash Receipts Journal (CRJ) and Cash Disbursements Journal (CDJ) templates.
  • Analyze and record cash receipts and disbursements for the month.
• Monthly Reporting:
  • Prepare and compile monthly reports for School Leaders and Board Treasurers, including saving detailed transaction support.
  • Update monthly sub-schedules for balance sheet accounts.
• Other Tasks:
  • Assist in updating state regulatory reports.

  • Prepare website postings, State required entries, and AFR support - if applicable.

Qualifications:

• Bachelor's degree in Accounting, Finance, or a related field.
• Proven 3 years of experience in accounting or a similar role.
• Proficiency in accounting software (e.g., Sage Intacct) and Microsoft Office Suite.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and organizational skills.

• Ability to work independently and as part of a team.

Preferred Qualifications:

• Experience with payroll preparation.
• Familiarity with grant tracking and financial statement preparation.