Financial Coordinator (not remote work)

EDUCATIONAL SERVICE UNIT #3

JOB DESCRIPTION 

Job Title:  Financial Coordinator                  

Job Title Code:  1501

Number of Days Worked:  260 days per year

Department:  Business Services

FLSA Status:  Exempt 

Immediate Supervisor: Chief Financial Officer (CFO)

Staff Supervised:  None

Essential Requirements: (Education, Certification, Extended Experience and Technical Skills)

1. No history of child abuse or negligence.
2. BS degree with accounting emphasis is preferred but not required.
3. Five years of accounting experience is preferred but not required.
4. Experience with grants preferred but not required.
5. Possess good oral & written communication skills.
6. Possess professional customer service skills.
7. Regular and in person attendance is required and is a condition of employment.
8. The assigned duties of this position may allow consideration of occasional/infrequent remote work with the approval of the supervisor.  Remote work is subject to the remote work guidelines and conditions outlined in the job description.  The supervisor may withdraw the remote work option at any time.

Essential Responsibilities:  

1. Overall Grant Coordination
1. Develop and maintain a departmental grant summary for current grants (Student Services, Professional Learning Department, and Title I).
2. Develop and maintain a timeline for filing grant “claim for reimbursement.”
3. Complete “claim for reimbursement” forms for ESU #3 for federal and state grants according to the award notification or the scheduled timeline.
4. Prepare monthly grant summary information for ESU #3 grants and provide reports to Department Directors. 
5. Prepare a monthly Flow Through (Income to Spend) account report and provide reports to appropriate Directors.
6. Calculate indirect costs for grants. 
7. Work with Grant Program Coordinator for financial requirements of grants. 
8. Develop grant budgets with Grant Program Coordinator. 
9. Review grant budgets for accuracy before submission of application to NDE. 
10. Extensive knowledge of NDE’s guidelines and regulations for grants. 
11. Extensive knowledge of NDE’s portal grants management system. 
12. Record grant information in NDE’s portal (when required).
13. Prepare and post budget adjustments to maintain current budget information in EFinancePlus.
14. Prepare and post journal entries to eFinancePlus as needed.
15. Prepare requested work papers, schedules, and report for external auditors.
16. Prepare School Nutrition Program reimbursement for the months school is in session.
2. Building Manager & Drivers Education Manager – Prepare and review monthly financial statements with the Building Coordinator & Drivers Education Coordinator.
3. Bank Accounts - Reconcile the Main Account, the ESU 3 petty cash and Gifford Farm petty cash accounts, the Lunch Account and the Foundation account monthly. Maintain daily deposit and check activity for all bank accounts.
4. Prepare Board packet information for the CEO, CFO and the ESU 3 Board monthly which includes the Treasurer’s report, the Budget Summary and the Check Explanation report.
5. Reconcile the due to/due from account between ESU #3 Educational Foundation and ESU #3.  Provide the Accounts Payable Accountant with detailed reports supporting amounts to be paid in the board check run.
6. Weekly – Check eFinancePlus to assure the records are in balance.
1. Check Ledger Balance function 
2. Check balance sheet to ensure that DR = CR
3. Check pledged collateral
7. Review / maintain payroll database for consistency.  Accurate data is needed when generating COGNOS reports.  Work on setting up COGNOS reports to assist with keeping the data cleaned up.
8. Understand COGNOS, the eFinancePlus report writing tool, and develop necessary reports.
9. Record journal entries into the eFinancePlus system. Scan journal General Fund and Foundation journal entries into Laserfiche.
10. Invoicing – invoice as requested by the CEO or CFO.
11. Payroll - Assist with tasks when necessary and only when the Payroll Accountant and Accounts Payable Accountant are unavailable to do the requested work.
12. Prepare required audit work papers and assist auditors during audit engagement with necessary information for both the ESU #3 and ESU #3 Educational Foundation audit.  Stay current on requirements necessary to be compliant with generally accepted auditing principles (GAAP).
13. Preparation of departmental budgets as assigned by the CFO for both ESU #3 and the ESU#3 Educational Foundation.  Assist Directors with budgets as requested.
14. Laserfiche/Workflow/Quickfields
1. Obtain a basic understanding and the ability to use Laserfiche in the day to day process: including scanning, storing, and retrieving documents.
2. Scan General Fund and Foundation journal entries into Laserfiche.
15. Duties as assigned for the ESU #3 Educational Foundation.
16. Maintain and review applications for the Lunch Program for eligibility. Keep student and family information current by running the Data Bridge as needed. Serve a backup to close the Lunch lines daily. Enter deposits received by ESU into Wordware as needed. Prepare student account balance and student ID reports as requested. Prepare the monthly Edit Check Worksheet and submit SNP Claim for Reimbursement.
17. Preparation of the Salary Spreadsheet for the upcoming budget year. Update the spreadsheet for the Directors as requested.
18. Monitor the PORTAL/NDE Bulletins for reporting requirements and deadlines.
19. Prepare and submit the financial portion of the NDEMAC request for reimbursement quarterly.
20. Prepare Invoice Adjustment Journal Report monthly for the CFO to review and sign.
21. Prepare Non-Certificated Staff Report, Title I, Part A:  Annual Participation Report and the Substitute Teachers Report on the NDE Consolidated Data Collection (CDC) website.
22. Prepare Workers’ Compensation Exposure Information and the Payroll Audit Report for NASB ALICAP.
23. Provide research and recommendations for budgeting, coding, and reporting to various department staff.
24. Work and collaborate with the Accountant to serve as backup for each other.
25. Quarterly Review-Prepare, coordinate and schedule a summary for quarterly financial reviews.
26. Other Duties as Assigned

At Will Employment: Employment with ESU #3 is not for any period of time, and employment may be terminated at any time at the convenience of the terminating party, with or without cause, and with or without notice.  Employment with ESU #3 is not governed by any express or implied contract of employment containing terms different from or inconsistent with those stated in this job description.  The terms of this job description may not be modified except in a writing signed by the ESU #3 CEO.

Salary : $70,000 - $100,000