Atlanta, GA 30303
Ability to review and interpret vendor reports, source documents, bank statements and financial reports.
Ability to provide support and respond to requests from auditors, management, and team members.
Ability to evaluate financial documents received to ensure the information is accurate prior to submitting the documents to the audit team for review.
Maintains financial records an ensures that the financial transactions are properly recorded to the general ledger.
Analyze current revenues and expenses incurred and ensure agency revenues match expenses by account and fund source on account and fund source reconciliations.
Ability to exercise independent discretion and judgement for work procedures and methods.
Experience identifying and analyzing problems, gathering, interpreting, and evaluating information to determine its accuracy and relevance, and uses sound judgment to generate and evaluate alternatives and recommend a solution.
Review prior day activity for CTAS accounts in TeamWorks to ensure the automatic reconciliation for revenue deposits are being applied properly.
Review CTAS bank error reports weekly and provide documentation to the revenue department to have the transactions recorded or corrected in the financial system to ensure all bank errors are resolved by the end of the month.
Reconcile the CTAS bank accounts in the TeamWorks database monthly and ensure reconciling items are cleared timely.
Create or update account reconciliation templates to ensure all pertinent information is being recorded on the monthly reconciliation.
Respond to all requests for assistance from business owners and program managers within 4 hours and provide a response or solution to all requests or queries within 48 hours.
Prepare desktop manuals to document processes and procedures.
Reconcile bank accounts and fund sources monthly to the general ledger and bank statements.
Monitor stale dated checks and voids monthly and submit the information to the Accounts Payable department for processing.
Prepare daily cash activity reconciliations for management for the following accounts: Federal Funds Holding, OTFS Holding, and Admin AP.
Research bank discrepancies, notify management, and ensure that the issues are resolved.
Serve as the job expert for bank and applicable fund source reconciliations.
Perform other additional job duties as assigned.
Knowledge and experience of general accounting principles and standards.
Attention to detail, organizational skills, and time management are required.
Excellent oral, written, presentation and interpersonal communication skills.
Ability to work effectively at multiple levels of the organization with multiple project teams.
Demonstrates ability to effectively plan work and manage multiple tasks simultaneously.
Demonstrates the ability to work independently with limited supervision and to work effectively with a team.
Master s degree in accounting from an accredited college or university OR Bachelor' s degree in accounting from an accredited college or university AND One year of professional accounting experience OR Bachelor' s degree in a business curriculum which included completion of introductory and intermediate accounting sequence from an accredited college or university AND One year of professional accounting experience.
Experience running queries with the State s TeamWorks Enterprise Financial System (PeopleSoft).
Two (2) years of professional accounting experience which includes reconciling bank accounts and analyzing and interpreting financial transactions.
Intermediate Microsoft Excel experience - knowledge of working with queries, creating pivot tables, importing and exporting data, and performing V-Lookup.
Proficient in Microsoft Office Suite which is typically used in an office environment.
Possess strong analytical, critical thinking, and problem-solving skills.
Knowledge of the relationship of general ledger balances and its subsidiary ledger balances and reconciliation of source data to accounting modules.
State government accounting experience.