JOANNIE BURTOFT

o Completed the following ACFR (Annual Comprehensive Financial Report) compilations during my 8-year tenure as Financial Specialist I with the OSC Statewide Accounting Financial Reporting Team: Special Revenue Budget to Actuals, Permanent Fund Statements and Permanent Fund Budget to Actuals, Investment Trust Fund Statements, Private Purpose Trust Statements, Community College Fund Statements and Community College Foundations, Note 6 Short Term Debt, Note 15 Risk Management and Insurance; Statistical Sections: Table 3 Fund Balances of Governmental Funds, Table 8 Taxable Sales by Business Group, Table 12 Schedule of General Obligation Bonds Payable, Table 13 Schedule of Special Indebtedness Debt, Table 15 Schedule of Demographic Data, Table 19 Capital Asset Statistics by Function, and Table 20 Ten Year Claims Development Information. In FY2020, I completed the ACFR compilation segments 100% virtually due to the pandemic. in FY2021, I started completing my ACFR compilation segments using the FBR Release 2 new reporting tools (FCCS -Smart View, Journal Input, Data Forms, and Narrative Reporting).

• o Revised ACFR compilation procedures to include new FBR Release 2.
• o Exhibited team work by covering co-analyst’s assigned agencies/universities when he/she is out of the office.
• o Completed training classes for the FBR Release 1, 2 & 3 modules.
• o Used the NCFS FBR Release 1 Cash Management Module to run reports to verify month-end balancing of NCAS to NCFS during my access to verify month-end for A9 Electrolysis Board up until December 2022
• o Prepared presentations and presented for the Financial Reporting Update (FRU) Class using Power Point on GASB Standard 96 SBITAs (Subscription-Based IT Arrangements), and in May 2024, on GASB 100 Compensated Absences.
• o Used SharePoint to update the ACFR Packages list, to update ACFR compilation time, and used to save ACFR packages to the appropriate folder when I was responsible for the Community College Packages.
• o Responsible for EAGLE (Enhancing Accountability in Government through Leadership and Education) Program.
• o Assisted agencies with month-end closing differences by consulting with agency contact and researching variances by using Systemware (XTND, XPTR) reports before suggesting a resolution.
• o Taught NCAS training classes: (1) SM01 – Agency System Management twice per year and (2) CI01 – Capital Improvement once per year via in-person and online instruction methods (GOTO Training Webinar and WebEx). The CI01 course was an inter-agency training forum that was co-taught with the lead Budget Analyst from OSBM Mark Bondo.
• o Established new fund and budget codes in NCAS for agencies and universities per OSBM requests, prior to FBR Release 3. Under NCFS, reviewed/researched necessary reports before forwarding new fund request for approval to the senior Financial Specialist, and then onto the NCFS Functional Team for actual set-up Onto the system.
• o Provided NCAS – Accounts Payable and Budgetary Control functions for the NC Electrolysis Board, prior to FBR Release 3.
• o Participated in continuing professional education provided by OSC FRU (Financial Reporting Update), GASB Update, Financial Conference, Technology Update, and various LMS on-going trainings.
• o Assisted with the implementation of GASB Standards by reviewing the FRU before the Advanced Analyst posts to the OSC website and suggesting edits, if necessary. I assisted the Statewide Accounting Standards & Procedures Manager with the implementation of GASB 100 Compensated Absences. We collaborated with the OSC Payroll Functional Team and OSC Business Systems Manager for required updates to reports needed for the Compensated Absences Compilation.
• o Assisted agency/university managers and staff with their year-end governmental accounting and reporting issues.
• o Member of the Chart of Accounts Committee where I have researched new account and subaccount requests from Agencies before approval (or disapproval). I was responsible for the actual set-up in NCAS and posting to the OSC Website prior to FBR Release 3.
• o Requested job mods for year-end reporting from the OSC Technical Team by using SharePoint prior to FBR Release 3.
• o Prepared and presented at the annual SADFR (Statewide Accounting Division Financial Reporting) class on changes to the ACFR (Annual Comprehensive Financial Report) package worksheets in anticipation of the upcoming ACFR Planning Conferences that are held with agencies and universities.
• o Updated the assigned sections of the year-end close ACFR packages to meet end of April deadline before posting to the OSC website.
• o Scheduled and conducted yearly ACFR planning conferences with assigned agencies: NCSU, NCCU, DOJ, DOL, OAH, and NC Economic Development Partnership to provide updates to the annual ACFR package. Notified entities of problems/errors made with their prior year's package, new GASB Standards, and necessary due dates.
• o Reviewed and analyzed the completed agency/university ACFR packages to ensure accuracy before the files freeze in early September.
• o Participated in parallel testing of FBR Release 2 (FCCS, Smart View, Narrative Reporting).
• o Assisted the FBR Release 2 Lead with UAT (User Acceptance Testing).

o The first two years at the NC State Health Plan, I assisted in the preparation of EAGLE (Enhancing Accountability in Government Leadership and Education) statewide internal control auditing program by preparing narratives, walk-throughs, risk and control matrix (RACM), test plans, test leadsheets, and issue summary logs.

o Preparing and analyzing the monthly Financial Status Report for the upper management financial reporting team. This is a multi-layered report that shows the financial position of the State Health Plan (SHP). It compares the fiscal and calendar years against the budgetary projections (provided by actuaries) and determines a variance to help management determine the economic performance of the division. I also had to reference audit-type support documentation for SHP's revenues and expenses for the PPO, Reserve, and Administrative Expense accounts. Finally, I summarized my findings in a written report to the DST-Investment Accounting Manager.

o Analyzed the weekly claims net disbursements support documents provided by Blue Cross and Blue Shield of North Carolina (BCBSNC), Cobra Guard (iTedium) and Medcost before requisitioning up to $50 million to cover the weekly medical claims payment through the Cash Management Control System (CMCS) and wiring electronic transfers through the Core Banking System (CB$) to cover the EFT payments. Created journal entries to properly record in the North Carolina Accounting System (NCAS) - Budgetary Control Module.

o Analyzed and reconciled the bank reconciliations for multiple bank accounts for the trades payable disbursing vendors, claims disbursing, and depository accounts. These bank accounts are reconciled by the 15th of each month where documentation is provided to support my findings to my manager for review.

o Reconciled the State Health Plan Division's premium receipts and medical and pharmacy claims which are reported by the Third Party Administrators (TPAs), such as BCBSNC, Cobra Guard (iTedium), and Medcost. Schedules and reports received from the TPA, the North Carolina Accounting System (NCAS) - General Ledger module, and XTND reports are analyzed to provide a reconciliation of the monthly and total year-to-date premium receipts and claims funding.

o Reconciled the Special Fund report at month-end closing for SHP's three budget codes to the NCAS - General Ledger and Cash Management Control System (CMCS). Responsible for running the BD701, BD702, and BD800 reports from XTND and/or NCXPTR to ensure balancing of month-end. Regularly checking to determine if accounts are in suspense, and taking corrective action as needed.

o Reconciled and prepared the Quarterly Accounts Receivable (A/R) report to meet the Office of the State Controller state government reporting requirements. Analyzed the A/R figures provided by BCBSNC before reporting the financial data to the Office of the State Controller'.

o Monitored the daily cash management report and reported weekly to DST upper management and the NC legislative representative. This report shows the daily revenues and expenses and compares it to the Cash Management Control System's (CMCS) running balance.

o Created an invoice tracking spreadsheet to monitor SHP invoices being paid or outstanding. The spreadsheet is monitored now by the current accounts payable accountant.

o Applies Generally Accepted Accounting Principles (GAAP) and interprets Office of the State Controller (OSC) policies and regulations for completing all financial reporting.

o Maintained the fixed asset records, schedules and performed the Plan's annual physical inventory of the fixed assets for two years by recording capital assets purchased over $5,000 in the NCAS - Fixed Asset System. Responsible for originally writing the Fixed Asset Policy for the Plan in order to be in compliance with OSC requirements for reporting and documenting the fixed assets for state government agencies.

o Participated in the preparation and completion of the State Health Plan Division Comprehensive Annual Financial Report (CAFR) for the year-end closing procedures by running the year-end reports using DSS (Cognos). Analyzed and accrued the following information at year-end by the journal (voucher) entry method: compensated absences, the Pharmacy Rebates reported by the Pharmacy Benefit Manager, the interest receivables, notes payable (current and long-term), recorded the manual accruals for expense items, and reclassed journal entries to new accounts per request from the DST-Investment Accounting Manager.

o Completed the Cash Flow Statement during CAFR Year 2014 because the Accounting Manager position was vacant.

o Complied with the Plan's internal control policies and procedures, and completed various assignments for OSC's EAGLE Internal Control processes annually. This involves writing process and account risk assessments, work flow narratives, flowcharts, walk-through processes, testing, and summaries for my first three years under SHP.

o Wrote the policies and procedures and desk-top guides for multiple work duties that I was responsible for. Reviewed these procedures annually to see if updates were needed to reflect changes in job functions.

o Utilized the Budgetary Control and General Ledger modules in the North Carolina Accounting System (NCAS).

o Responsible for operating the SHP Accounting section alone for four months in 2015 and for five months in 2016, when the secondary position was vacant. Normally this is a two person responsibility. During this time, all tasks were completed in a timely manner.

o Monthly recording of metrics for various duties to insure that DST goals are met.

o Completed a one year long DST professional program called Leadership First where two members from each department were chosen to participate based on their growth potential. We learned about the functions of each department, and we were taught Program Management Skills. Our final was the preparation and delivery of a public speech using Power Point and distributing hand-outs.

o Bank Reconciliations: Analyzed and reconciled bank statements to general ledger within ten days of receipt for the Mechanics & Farmers (M&F) Bank payroll bank statements and M&F Parks and Recreation bank statements on a monthly basis. Communicated any differences or errors in bank statements to the Treasury Division. Made adjusting journal entries as required to the general ledger.

o Sub System Reconciliation: Analyzed and reconciled the Accounting Sub Systems to the general ledger monthly. Made correcting adjustments to the sub-systems and adjusting journal entries to the general ledger as required. The sub-systems used were: Assessments Receivable, Encumbrances, and Mail and Printing Charge Systems. Performed Internal Service Fund Accounting with the Mail Service Department.

o Quarterly completed the Federal and NC State tax forms for timely submission.

o Annually completed the statistical section of the Comprehensive Annual Financial Report (CAFR).

o Maintained lines of communication with other City of Durham employees to identify problems and to correct processes or deficiencies in systems.

o Knew current requirements for position and took effort to learn new methods to improving the quality and quantity of work performed. Took the initiative to learn the requirements of other job classifications in the division so that help can be offered in times of extra or peak work loads.