Accounts Receivable Office Admin
Resume:
Sandy Steward
Cincinnati, OH
**********@***.***
Professional Summary:
Hands on experience in accountabilities, Fixed Asset, GL posting, Reon, Credit Specialist AR/AP, Business Expense Admin, Office Admin.
Strong knowledge with Microsoft applications and import/exporting data from various databases and communicate resolution.
Time management enhancements are displayed at month end with improving and organizing report data with explanation.
Computer Database Skills:
MS Office, Epicor, Doclink, Peachtree, QuickBooks, SAP, AS 400, Coda, Colbert, Concur, Citrix, Express5 on-base online, FAS, Frontier, Gelco, ACE, Lotus Notes Database, PeopleSoft, Prism, Maximo, MSA, Quicken, Enterprise Journal, SharePoint, Oracle, Business Objects, Content Manager, Apple IIe, CRT, Delta Data, Schwab Fund link.
Education:
Accounting - AIU College Online - Attended 2007/2009
Accounting Technology Cincinnati State Technical and Community College Cincinnati, Ohio
Degree: Associate of Applied Business - AAB
Certificate:
Northwest Senior High School Computer Application - CAPC.CTL Graduation Date: 06/06
Professional Experience:
Work Experience
Kao USA
AR Analyst present-12-2021
Apply payments from PNC wires, check remits per open revenue.
Allocate deductions per 10 reasons codes resolve and clear direct GL deductions penalties, freight, fairshare charges.
Export deductions aging per accounts from SAP to analyze trends and investigate shortages and returns.
Interact with internal/external customers, Brokers, Sales, to resolve outstanding issues with disputing deductions.
Process accounts receivable information concerning deductions, related to deals and store offers discounts, discontinued items.
Perform regular analysis of Key Performance Indicators (KPI’s) and to take steps required to attain service goals and objectives.
Compile monthly reports and communicate results to the appropriate personnel & Supply Chain.
Maintain desk manual including update contacts, process per account assigned every 6 months with treads on deductions.
Support Team members with applying cash on account while assisting with training and navigation knowledge.
Engage continues communication with Hybrid base skills meetings & team chats while attending workshops per corporate webbase.
Investigations Specialist (Contract role)
Citi Bank via Mindlance 2/21 - 2022
Scan all checks for investigations.
Verify aba, routing numbers, amounts, legal lines etc. in conjunction with rescans (imaging)
Administrative work related to check scans and investigations.
Meier’s Wine Cellar Cincinnati OH 2/20-12/20
Government Reporting
Maintain monthly inventory reconciliation prep excel spreadsheet shipments, receiving, adjustment.
Reported monthly 7 forms to TTB Wine and Spirit activity with several computation and conversion.
Reconciled both monthly for adjustment to report proofs per physical inventory balancing.
Retrieved data support for reports submitted from various system sources, Access, Doclink, Epicor
Communicate inventory negative balances on all products for adjustment.
Insight Global Staffing - Fifth Third Bank Cincinnati OH 12/18 – 06/19
Investment Ops - Reconciliation
Monitored investment activities (exchanges, trades, buy, sell, transfers)
Conduct audits to resolve variance between main frame and holding system software.
Completed adjustments to balance general ledger accounting with holding system software.
Reconciled investment accounts/subs per share activities
Prepared workbook/excel spreadsheets from PDF data for merger.
CDK Global Cincinnati, Ohio 02/17 – 12/18
Account Specialist
Define, design and work on continual improvement of the AR process, customer billing & credit.
notes, service contract management and write-offs
Assist in the process of researching and resolving customer disputes and issues, providing support and service excellence to our customers, and securing payment of disputed debt process is implemented and continually improved.
Maintain accurate records of all AR activities.
Assist in producing accurate reports for management on a daily/weekly/monthly basis with attention to detail.
Jacobson Ins. Staffing – Great American Ins Cincinnati, Ohio. 10/16 – 12/16
Accounting Assistant
Processes daily transactions for department, journal entries into PeopleSoft
Resolve and post customer payments per PNC bank expectation daily per deadline.
Process daily deposits per the PNC check scanner
Disburse all department checks daily with required process for MPCI loss checks per PC.
Record all PeopleSoft checks per tracking/log on excel workbook for auditing.
A-line Staffing-Omnicare Cincinnati, Ohio 8/16- 9/16
Contract Pricing
Navigate between multiple excel workbooks and systems to obtain current pricing information.
Develop standard pricing templates utilizing Microsoft Excel
Pinpoint cost within an account/facilities contracts form PDF documents
Populate excel template with appropriate cost or equation per contract agreement.
Review pricing requests and ensure that all fields are properly completed per facility type.
(Assistant living facility- ALF, Skilled living facility- SNF, and other)
Analyze and input current pricing within the company’s operations systems (DX)
Macys Corporation Cincinnati, Ohio 8/15 – 7/16
Account specialists
Submitted invoices for project director approval through a database.
Initiated invoice posting procedures for vendor payment, check run.
Performed daily reconciliation of general ledger, internal DDA.
Monitored exception report and resolve with appropriate personnel.
Accounts receivable cash issues
Reconciled offshore remittance processing, Cash Balancing/ Accounts Receivable, Daily and monthly cash balancing.
Recruiting Agencies Cincinnati, Ohio 2012-2014
Accounts Payable
Daily invoice data entries into FDM4 an AS400 system 200+
Monthly operating expenses entries direct to GL coding
Twice a month match invoices to check copy and file.
Monitor A/P entry for efficiency.
Ensure all “Drop Ships” invoices are entered at month end.
EXTENDED EXPERIENCE
BASF, Formerly Cognis Corporation Cincinnati, Ohio 1999 – 2011
Fixed Asset Accountant- 2006 to 2011
BASF
Created project structure outline for project request/proposal (WBS element-SAP)
Processed release procedures for project structure outline per budget approval
Calculated monthly Capex project spending activity WIP, CIP on linked excel spreadsheet.
Created assets to begin depreciation life from the project structure outline.
Allocate assets to project structure outline.
Settle Capex spending balance
Prepare fixed asset depreciation accrual monthly.
Reconcile Capex spending by location, asset.
Close project structure outline
Report CIP monthly to Engineers
Accounting Assistant
Administrate check runs twice a week, estimated weekly volume of 800 checks.
Conduct PC allocate by Percentage.
Created customer credit/debit memos per request.
Responsible for preparing the month end journal entries consisting of over 1500 transactions.
Administrator of the corporate Visa card accounts and maintains daily applications.
Compare the income statement report against the accumulated cost center report for month end.
Complete year-ends audits tax schedules on expense accounts and provide information on the Senior Management Team (SMT) spousal travel yearly.
Conduct routine audits on random employee's expense reports.
(Detailed Resume Upon Request)
Contact this candidate