S2204

998814

Accountant

Systems Accountant (Advanced)

Staff

UNC Greensboro, located in the Piedmont Triad region of North Carolina, is 1 of only 57 doctoral institutions recognized by the Carnegie Foundation for both higher research activity and community engagement. Founded in 1891 and one of the original three UNC System institutions, UNC Greensboro is one of the most diverse universities in the state with 20,000+ students, and 3,000+ faculty and staff members representing 90+ nationalities. With 17 Division I athletic teams, 85 undergraduate degrees in over 125 areas of study, as well as 74 master’s and 32 doctoral programs, UNC Greensboro is consistently recognized nationally among the top universities for academic excellence and value, with noted strengths in health and wellness, visual and performing arts, nursing, education, and more. For additional information, please visit uncg.edu and follow UNCG on Facebook, Twitter, and Instagram.

The Cashiers and Student Accounts Office is responsible for maintaining accurate accounting of all monies collected at the University. This includes maximizing the collection of delinquent student accounts and loan receivables and ensuring that all monies collected are properly credited to student and loan receivables or appropriate departmental accounts and deposited daily in the State Treasurer’s account with the University depository bank. The office also has responsibility for the accounting of all cash receipts and the reconcilement of the Banner Accounts Receivable system to the Banner Finance financial record system and for the maintenance and operation of the Banner Accounts Receivable system. A high level of knowledge and accuracy is demanded in the processing of all work to ensure a quality of work that will not be found to have exceptions when audited by the State Auditors. The department works directly with students and parents, under expectations of a high level of customer service, to provide: payment alternatives, financial advice, and to perform research to determine if options exist so students can be confirmed for enrollment. The department works with Enrollment Services to complete the financial aspect of the student’s enrollment.

This position provides systems, functional, and technical support and training for the Banner ERP system, TouchNet, and other systems utilized by the Cashiers and Student Accounts Office and the Controller’s Office. This includes being responsible for ongoing upgrades and implementations of new and existing products, maintaining system settings, developing and documenting procedures, performing research and analytical tasks, and testing and troubleshooting when needed.

This position will: ensure integrity and smooth daily operation of the billing, receivable, and cash management systems; work closely with colleagues to recommend and review system enhancements; provide application, system, and technical support for billing, accounting and reconciliations, receivables, and cash management; maintain fee rules, resolve issues as they arise and audit for accuracy; provide requested query data by utilizing appropriate reporting tools, prepare and interpret reports and analyze data output; and work closely with all appropriate campus academic and administrative staff and university system groups.

Bachelor’s degree with 12 credit hours of accounting coursework; or Associate’s degree in accounting; or Associate’s degree in business or related discipline with 12 credit hours of accounting coursework; or equivalent combination of training and experience. all degrees must be received from appropriately accredited institutions.

• CPA Certification or Master’s Degree in Accounting or related business field
• Financial accounting systems report writing/modifications experience
• Ability to write sequel scripts (SQL)
• Advanced Microsoft Excel Skills
• Business Process Analysis and Improvement Experience
• Ellucian Banner Finance/Accounts Receivable ERP experience
• 24 Hours of Accounting Courses.

If no applicants apply who meet the required competency level and training & experience requirements, then management may consider other applicants. Salary would be determined based on competencies, equity, budget, and market considerations.

Applicants are required to upload a list of at least three (3) professional references that includes:

1. Name,
2. Company Name,
3. Type of reference (Professional, Supervisor, Colleague, Academic, or Personal). One (1) of those references will need to be a current or previous supervisor.
4. Email Address
5. Contact Phone Number

$73,859 - $80,000

Cashiers and Student Accounts - 56204

8 am - 5 pm, M-F, with some overtime anticipated

12

Administrative & Managerial

Accountant

07/19/2021

08/04/2021

1.000

Exempt

77

Provide Office Support for Banner and Auxiliary systems

Lead Cashiers Office participation and implementation for Banner upgrades and modifications related to Accounts Receivable, and other Cashiers Office functions. For the Cashiers Office, thoroughly test Banner Accounts Receivable and auxiliary system upgrade releases, patches, local modifications, and ITS written processes prior to implementation, including developing testing methodology and test plans/scripts. Troubleshoot and resolve accounts receivable issues for: the application of payments, internal systems processes, tuition and fee calculations, Banner processes, and coordination with third party systems. This requires understanding baseline Ellucian Banner Accounts Receivable functionality available to meet required functions of the Cashiers Office.

Design and implement processes to ensure timely and accurate reporting of university revenue and daily reconciliation between Banner Accounts Receivable and Finance, NC Office of State Controller, and North Carolina Financial System (NCFS).

Coordinate with external departments and stakeholders to troubleshoot Banner-specific issues and help identify areas of training that are needed for stakeholders and other special projects and duties as assigned. Review key work processes regularly to identify opportunities to automate or streamline work to improve accuracy and timeliness of services delivered to students, parents, and UNCG colleagues.

For the Cashiers Office, ensure Banner Accounts Receivable and other modules and systems data is accurately and completely handled and integrated in Banner to the extent feasible. When routine or unprecedented system problems occur, this position is responsible for analyzing large sets of complex data and for developing, testing, and implementing appropriate entries or other corrective action.

Understand and document Cashiers Office operational needs and how these needs function in conjunction with other UNCG business unit needs. Design creative, integrated, and sustainable business solutions that provide for cost-effective cross-functional business processes.

Design and develop techniques to address business problems, use professional experience and analytical techniques to identify feasible course of action and design and test practical solutions and assist with the implementation. Document procedures for the training and development of CASAO staff pertaining to these procedures.

Provide functional, training, and technical support for the unit and serve as functional expert and liaison in the administration of installed Ellucian Banner Accounts Receivable/Finance modules, TouchNet, partial payment plans, MS Excel, Box-folder environment, 1098-T reporting, and other systems. Serve as a technical resource for answering accounting questions.

Serve as the Cashiers Office representative on various workgroups, cross-functional teams, and committees to address complex business or systems issues.

Communicate and collaborate with departmental staff, Cashier Office Director, IT personnel, University Controller, and other management to efficiently and accurately resolve problems and support Cashiers Office in: project planning and system testing, end-user interfaces for system implementations, system maintenance, enhancements, UC4/Automic Application Manager job scheduling, and production fixes.

Financial Reporting

Collaborate with end-users in the Controller’s Office, Financial Planning and Budgets, UNCG Technology Planning & Operations, and other areas as needed to understand reporting needs and requirements and develop reports from a variety of data sources using multiple reporting tools based on business needs. Prepare complex analyses and detailed schedules to support reported amounts. Demonstrate knowledge of reporting tools, NCFS, Core Banking, Microsoft Excel, and Microsoft Word. Modify procedures, processes, and reporting as necessary.

Create reports, including SQL reports, for internal tracking, analysis, and reconciliation of accounts receivable to finance ledgers. Prepare and/or modify reports for university and outside users as requested. This requires knowledge of Banner Finance and Accounts Receivable structures, understanding of relationships to when specific tables and fields are updated, and various methods of analyzing and extracting data to ensure reporting needs, management needs, auditor needs, and external needs are met.

Write detailed specifications for reports to be written by IT Analyst or self as applicable. This includes identification of specific Banner tables, Banner object access views, as well as the applicable fields, selection criteria, and sort criteria. From report testing, determine any problems with the report and document detailed changes that need to be made, and convey them to the appropriate analyst.

Generate and deliver accurate and timely 1098-T tax reports each calendar year. Proactively review reportable transactions to verify accuracy. Work closely with the Director to remain up-to-date on reporting standards to ensure compliance with prevailing IRS regulations.

Ensure that all internal, external, state government, and federal government reports are completed accurately and submitted in a timely manner.

Data Control

The position is responsible for the building and maintenance of Banner Accounts Receivable tables and accounting rules. These tables and rules provide for the assessment of tuition and fees and determine the posting of all revenues and ledger accounting entries related to student registration and the posting of all cash receipts to the appropriate Finance fund/accounts. This position verifies that all daily transactions correctly process to Banner Finance, including revenues, payments, financial aid disbursements, and student refunds.

Oversee data integrity, best practices, process streamlining, and interface changes to Banner Applications. Ensures the integrity of financial data recorded in the accounting system.

Configure fee assessment rules in Banner and coordinate the testing and review of billable transactions with each major tuition calculation assessment. Verify and sign-off on accuracy of this assessment with each term. Collaborate with school academic and financial staff to stay informed of changes planned for programs and fee structures to ensure these proposals and expectations align with Banner functionality.

The position is responsible for design, implementation, and maintenance of baseline Applications of Payments process and General Ledger interface, including: detail code setup with priority codes and accounting General Ledger interface values, rule code setup and maintenance. The position will work with the Controller’s Office to understand and coordinate impacts of Banner rule codes and Accounts Receivable transactions to the Banner Finance Chart of Accounts and ledgers, year-end accounting, 13th-month reporting, and entries to allocate funding to auxiliary departments.

Develop and maintain data control business procedures, guidelines, and documentation. Perform assessments of financial systems and processes and develop improvement strategies for reporting, analysis, and internal controls.

Design, implement and support effective and efficient cashiering processes including the processing of cash receipts and deposits, third-party billing, and collection of past due accounts.

Perform Accounting and Reconciliation Responsibilities

Ensure all student accounts receivable and cash receipt transactions are appropriately posted and classified in operating and general ledger. Support reconciling all accounts receivable and cash receipts data to the general ledger and work with appropriate university staff to reconcile differences. Analyze complex data for the purpose of creating journal entries, insert journal entries, and verify posting as assigned.

Develop and maintain knowledge of federal and state statutes and policies governing cash receipts and accounts receivable, university and state policies and procedures, UNC System Standards, generally accepted accounting principles as promulgated by AICPA, NACUBO, and GASB, and the sections of the United States Tax code which are applicable to universities. Maintain strong internal controls to ensure compliance with these standards.

Take advantage of Banner systems, features, and options to the extent feasible to support the performance of daily, monthly, quarterly, and year-end reconciliation, closing, and reporting requirements and procedures and for general ledger account reconciliations. Establish procedures to achieve operational efficiency.

Knowledge - Professional

In-depth knowledge of accounting theories and principles and systems design. Ability to recognize complex and unique issues and develop resolution and/or consult with leadership in order to achieve resolution. Knowledge to consistently serve as a technical resource.

Ability to identify problems and changing requirements regarding management needs, auditing, fiscal procedures, account structures or reports, and accounting systems. Ability to make necessary modifications

Advanced

Financial Monitoring & Analysis

Ability to independently resolve complex problems for which no clear precedent exists within the current system or ability to implement new accounting structures. Ability to supervise resolution and/or implementation. May require the ability to design and implement organization and program-specific accounting procedures/systems. Ability to examine and analyze complex financial statements. Ability to institute changes based on findings.

Ability to research, analyze, and ensure implementation of new and/or changing accounting and reporting systems. Ability to provide training and consultation related to new systems and/or reporting methodology. Ability to ensure the development of related policies and procedures.

Ability to recommend actions or alternatives to be taken by management when accounting data discloses unfavorable trends or deviations or financial mismanagement.

Ability to make risk assessment of systems of internal control. May require the ability to approve improvements/changes to internal control systems.

Advanced

Decision Making and Problem Solving

Ability to independently resolve and/or develop recommendations for unprecedented, complex issues and problems. Ability to serve as a resource for others in resolving unprecedented, non-standard issues and problems. Ability to anticipate problems and develop recommendations for management resolution.

Advanced

Communication and Interpersonal Skills

Ability to convey concise, comprehensive, and accurate findings on matters of a complex nature in written form. Ability to provide conclusions and recommendations that are based on extensive professional knowledge and judgment.

Ability to convey issues of a complex nature in a clear, concise, and organized manner. May require the ability to consult and/or negotiate with senior management/external entities regarding funding levels, cost allocations, or related financial issues.

Advanced

Hand Movement-Repetitive Motions - C, Hand Movement-Grasping - O, Holding - O, Finger Dexterity - C, Reading - F, Writing - O, Vision-Preparing/Analyzing figures - C, Hearing - F, Talking - F, Standing - R, Sitting - C, Walking - R, Lifting-0-30 lbs. - R, Climbing-Stairs - R, Reaching - R

Inside - C, Overtime - O