Cheyenne Coleman-Lyons Email & Phone Number

Mableton, Ga, Us

Atlanta, Georgia, United States

Senior Associate working on the COVID-19 CA Emergency Rental Assistance Program (ERAP) Program and LA County Rent Relief Program, both administered by the Housing Community and Development Department of California (HCD)- Conducted a weekly audit of 100-150+ rent assistance applications containing payment discrepancies by comparing payment breakdowns to invoice support documentation and identified $100+ million dollars in potentially misspent ERAP funds.- Researched, confirmed, and delivered payment receipts and payment confirmation details using Microsoft Powerbi and Bill.com, in an effort to resolve payment disputes from clients.- Prepared clear and concise audit reports detailing findings, recommendations, and corrections actions for overpaid and underpaid applications using Microsoft Word and Adobe Acrobat.- Utilized Atlassian JIRA to track, monitor, respond, escalate, and/or resolve customer issues; provide canned responses, reassigned, and escalated tickets to other support teams; generated reports to monitor ticket processing time.- Assisted in the preparation and implementation of Standard Operating Procedure documents as well as hosted Zoom trainings with 100+ plus members to transmit updated or revised policies, procedures, and documentation

Atlanta, Georgia, United States

- Utilized Oracle to carry out month-end closing duties, such as analyzing financial transactions in general ledgers, submitting adjusting journal entries, and preparing account reconciliation and detailed account analysis.- Performed month-end reconciliations to reclass non-asset expenditures out of asset accounts into other expense accounts.- Prepared the quarterly non-major and major governmental fund roll forwards for fixed assets.- Reviewed and confirmed funding availability for purchase order requests using the Requisition module and Grants Management module.- Conducted monthly research and analysis of departmental expenditure accounts by reviewing and comparing the trial balance to monthly expenditure detail reports.- Researched current and forthcoming city contracts and/or purchase orders that fall under GASB 96 and GASB 87 and prepare adjusting entries to incorporate expenditures into subsequent financial statements.- Gathered audit samples by conferring and interacting with City personnel and other governmental entities to retrieve invoices and other necessary support documentation for audit partners to review.- Assisted in the preparation of the Annual Comprehensive Financial Report by gathering, analyzing, and compiling financial data from non-governmental funds and capital asset funds into complex excel spreadsheets to reconcile any discrepancies found between the trial balance versus the quarterly statements.- Reviewed pre-legislative contracts by verifying available fund balance, setting up projects and award numbers as well as assigning contract numbers in Grants Management module.- Oversaw and maintained the recordkeeping of capital assets by recording assets on a live Microsoft-excel sheet as well as entering relevant asset data such as costs, serial numbers, tag numbers, funding source, asset number, DPIS etc. into the Fixed Asset module.

Greater Los Angeles Area

- Executed full-cycle accounts payable process including invoice receipt, verification and approval, accurate recording and posting in financial system, check disbursement verification, payment reconciliation, and recurring vendor maintenance or vendor set up.- Recorded 20-30 daily financial transactions in an Oracle software called Financial Management System. Entries included invoice payments, capital budget adjustments, fund transfers, purchase orders, end-of-the-year transactions/close-out procedures etc.; provided level 1 or 2 approval for various transactions in accordance with the accounting policies. - Monitored financial status of capital improvement projects and their associated fund; monitored expenditures and encumbrances throughout the fiscal year; maintained project documents and files; coordinated with project managers to assist with project close-out procedures.- Managed up to 50, 1-to-10-year Capital Improvement Projects of $100k to $10M or more, and their associated expenses and encumbrances across multiple fiscal years using complex Microsoft Excel spreadsheets including v-lookup, formulas, and pivot tables. - Verified the details of contractor invoices, such as the invoice amount, payment terms, change orders, discounts, account and project designation etc., and performed 3-way matching with purchase orders and other support documentations. - Regularly monitored and updated a live google-sheet called the Daily Invoice Monitoring System, used to track invoice payments from 5 bureaus, with processing and disbursement information as invoices were processed and paid. - Conferred with City personnel via phone, zoom, and email to research and resolve issues relating to invoicing, payment adjustments or allocations, and account or contract discrepancies. - Utilized the lump-sum and/or the percentage-of-completion method to recognize revenues and expense expenditures for contract payment processing

Bachelor'S Degree, Accounting

Associate'S Degree, Accounting