Specialist, Financial Reporting, Planning and Analysis

Overview

This role utilizes accounting knowledge, research, and analytical skills to help ensure accurate, timely financial reporting. The position regularly partners with internal departmental staff and supports month-end close and reporting activities, including payroll and passthrough expense preparation, bank reconciliation assistance, journal entries, and monthly reporting.

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 according to 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 with 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 with updates to state regulatory reports.
• Prepare website postings, State required entries, and AFR support—if applicable.

Requirements

• Bachelor’s degree in Accounting, Finance, or a related field.
• 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.

Location

Not specified.