Fund 1 Major Fund Administrator

Wake County Public Schools; United States; Hybrid; USD 85,000 - 100,000; Full time

Job summary

Wake County Public Schools seeks an experienced Fund 1 Major Fund Administrator to manage complex financial records and assist in budget reporting within the Accounting department.

The role requires strong GAAP knowledge, advanced Excel skills, and attention to detail to ensure accurate financial records and timely reporting.

Qualifications

• Bachelor's degree in accounting or related field and/or four years of accounting experience.
• Knowledge of GAAP and ability to maintain financial records and prepare fiscal reports.
• Proficiency with Microsoft Office (Word/Excel/PowerPoint) and Google Apps.

Responsibilities

• Prepares periodic financial and budgetary reports and analyses for management and external agencies.
• Maintains and reconciles general ledger accounts for assigned funds.
• Prepares and records journal entries for various financial activities.
• Performs monthly balance sheet analysis and reconciliation.

Skills

GAAP knowledge

Advanced Excel

Financial analysis

Communication skills

Attention to detail

Internal controls

Team collaboration

Education

Bachelor's degree in accounting or related field

Four years of accounting experience

Equivalent combination of education/experience considered

Tools

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

Google Apps

General Ledger software

Job description

Overview

POSITION TITLE (Oracle title)

ADMINISTRATOR

WORKING TITLE

Fund 1 Major Fund Administrator

SCHOOL/DEPARTMENT

Accounting

LOCATION

Crossroads III, Cary, NC

PAY GRADE

Administrator Band 4

FLSA STATUS

Exempt

ELIGIBILITY FOR EMPLOYMENT CONTRACT

No

WORK WEEK SCHEDULE

Monday-Friday (occasional evenings and weekends) Position is available for a hybrid telework workweek

POSITION PURPOSE:

Performs complex and specialized tasks in the maintenance of financial and budgetary records. Assists in the preparation of various financial reports and performs clerical activities related to the accounting cycle.

MINIMUM QUALIFICATIONS:

KNOWLEDGE, SKILLS, AND ABILITIES (KSAs)

• Considerable knowledge of generally accepted accounting principles;
• Considerable knowledge of Microsoft Office, specifically Word, Excel, and PowerPoint; Google Apps;
• Ability to complete complex tasks and minimize errors with attention to detail;
• Ability to communicate clearly and concisely both in oral and written form using a variety of communication techniques and tools to ensure the appropriate flow of information, collaborative efforts, and feedback;
• Ability to understand, interpret and apply specific rules and regulations governing the processing of fiscal documents, maintenance of financial records and preparation of fiscal records;
• Ability to establish and maintain effective working relationships with school system staff, employees of funding agencies, and community members.

EDUCATION, TRAINING, AND EXPERIENCE

• Bachelor's degree in accounting or related field; AND
• Four years of experience in accounting or related experience; OR

An equivalent combination of relevant education, training, and experience which provides the knowledge, skills, and abilities necessary to successfully meet the essential duties of the position may be considered.

CERTIFICATION AND LICENSE REQUIREMENTS

None

PREFERRED QUALIFICATIONS:

• Knowledge of generally accepted governmental accounting principles;
• Intermediate skills with Microsoft Access and Excel;
• Knowledge of Oracle financial applications.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

1. Prepares periodic financial and budgetary reports and analyses for management, departments, and external funding agencies.
2. Maintains and reconciles general ledger accounts for assigned funds.
3. Prepares and records journal entries for receivables, deposits, transfers, interest income, accruals, and other required adjustments.
4. Performs monthly analysis and reconciliation of balance sheet accounts to ensure accuracy and completeness.
5. Reconciles the general ledger to internal and external records and resolve discrepancies.
6. Monitors cash balances and liquidity levels to ensure proper fund management.
7. Prepares and reconciles monthly bank statements and bank account activity.
8. Completes monthly bank reconciliations and prepare related adjusting journal entries.
9. Prepares, balances, and processes bank deposits while ensuring proper account distribution of funds received.
10. Performs daily balancing and monitoring of transfer accounts.
11. Verifies and reconciles all monthly payroll transactions for accuracy.
12. Processes monthly payroll coding changes and account distribution updates.
13. Records annual journal entries related to escheatment and sales tax refunds.
14. Administers the escheatment process, including transitioning operations from an annual to a monthly cycle to improve liability management and remittance compliance.
15. Assists in preparing schedules, supporting documentation, and financial information required for the annual audit and Annual Comprehensive Financial Report (ACFR).
16. Ensures compliance with applicable accounting standards, financial policies, and reporting requirements.
17. Conducts financial system testing and validation to ensure system functionality and data integrity.
18. Identifies and implements process improvements to enhance efficiency, accuracy, and internal controls within financial operations.
19. Performs other related duties, as assigned.

WORK ENVIRONMENT/PHYSICAL REQUIREMENTS:

This position operates in a professional office environment and has a noise level of mostly low to moderate. This role routinely uses standard office equipment such as computers, scanners, and copiers. The position, at times, must be able to come into direct contact with school system staff, staff members of external agencies, and the community. Work is considered light physical work, requiring the exertion of up to ten pounds of force.

EFFECTIVE DATE: 8/2026

DISCLAIMER: The above statements are intended to describe the general purpose and responsibilities assigned to this position. They are not intended to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and skills required by the employees assigned to this position. This description may be revised by HR and approved at any time.