Sandra S. Skelly
*********@*****.***
Summary
Professional Experience
Federal Express
**/**/** – 02/25/25 (contract end date)
Payroll Clerk
Responsible for daily payroll replacement check processing for company with 400k employees.
Experienced with Enwisen ticketing system for payroll requests
Microsoft Excel
Peoplesoft
Bank of America.
LGG Industrial (formerly Eriks North America, Inc) 05/01/23 - 02/29/24 (Contract End Date)
AR Specialist
Moved daily remittances into Monday-Friday inboxes.
Generated cash batches from previous days postings and post into Prelude.
Downloaded previous/current day bank statements from JPMorgan Chase account
When complete run a AR report of lockbox/ACH payments &
save as excel reports #1 & #2 then combine into a Combo sheet.
Run report in Prelude (AR.Shipto.BJG) to excel spreadsheet, copy Invoice# and order#, copy & paste onto Combo Worksheet.
Post GL request into Prelude.
Generated letters to be sent to customers to move banking information from one
bank to another bank and completing any forms customers have requested (such
as ACH forms & W-9 forms).
CxLOYALTY 08/06/2021 – 12/31/2022
AR Specialist
Review daily spreadsheet from SE Management software
Review SEPs from travel agencies and agents for issuance of cash refunds via refund checks/Chase points/credit cards
Process credit card payments from travel agencies and agents through Cybersource software
Use Travcom software to work on AR requests for the AR balances
Use Maui software to complete the AR transactions
Daily creation and management of SEP report for AR application team
Use of Microsoft TEAMs or email for communication with travel agencies and agents
Daily tracking of SEPs worked for each day for reporting purposes
PARTIALLY RETIRED 10/3/2020 – 08/06/2021
AECOM 09/05/17-10/2/2020
Cash Applications Specialist
Process checks/wire transfers into Oracle for two different companies
Enter cash receipts from the #62559 (misc) lockbox & researched
Download Daily Unapplied cash to Excel Spreadsheets & updated
Research unapplied cash for application
Research in a billing system (ABC) for project numbers, invoices & contact information
Contact account managers, billers & collectors for verification of unapplied cash by email or phone calls
Make phone calls to clients/vendors to verify payments received
Reverse checks/wire transfers to a general ledger coding
EOM enter CIT into Oracle & reconcile when cash is received
Trained other in the use of Oracle applications
Account Temps- AECOM 04/20/15-09/05/17
Glen Allen, VA
Cash Application Specialist
Process checks/wire transfers into Oracle for two different companies
Download Daily Unapplied cash to Excel Spreadsheets
Update daily excel spreadsheets
Research unapplied cash for application
AP Research-Oracle
Research in a billing system (ABC) for project numbers, invoices & contact information
Contact account managers, billers & collectors for verification of unapplied cash by email or phone calls
Make phone calls to clients/vendors to verify payments received
Reverse checks/wire transfers to a general ledger coding
EOM enter CIT into Oracle & reconcile when cash is received
Enter cash receipts from the #62559 lockbox & research
Trained other associates in the use of Oracle
Account Principals-Century Distribution Systems 02/23/15-03/06/15
Richmond, VA
Contract Ended
Accounts Receivable/Payables
Process AR remittances into Great Plains & TradeTech
Process AP freight invoices into TradeTech
Process AP payments in TradeTech
Generated invoices/BOL’s into PDF files & transmitted through Trans International Freight
Processed weekly & bi-weekly statements through GP and Visibility Management System and emailed to customers
Generated reports from Trans International Freight verifying receipt and payments of existing invoices were being processed for payments
Generated internal invoices & credit memos in Great Plains
Assisted in all departments as needed
Assisted AR manager with financial projects as needed
Account Principals-Century Distribution Systems 09/08/14-10/23/14
Richmond, VA
Contract Ended
Accounts Receivable/Payables
Process AR remittances into Great Plains & TradeTech
Process AP freight invoices into TradeTech
Process AP payments in TradeTech
Generated invoices/BOL’s into PDF files & transmitted through Trans International Freight
Processed weekly & bi-weekly statements through GP and Visibility Management System and emailed to customers
Generated reports from Trans International Freight verifying receipt and payments of existing invoices were being processed for payments
Generated internal invoices & credit memos in Great Plains
Assisted in all departments as needed
Assisted AR manager with financial projects as needed
Radio Systems Corp, Knoxville, TN 09/29/97-03/31/14
Previously Premier Pet Products
Manufacturer & Distributor of Collars, Leashes, Toys and Pet Products
Dedicated and focused individual who reported to CFO in a manufacturing and sourcing facility with annual sales in excess of $100 mil. Expertise working in Accounts Payable and Customer Service for domestic and international accounts. Reconcile reports, including: A/R aging statements, Royalties & Sales Commissions, Credit Card Statements and Wire Transfers. Effectively communicate internally and externally with employees, customers and vendors resolving issues before they become major problems. Highly motivated and committed to quality and accuracy.
Accounts Payable/Receivable Specialist
Work closely with CFO producing general reports to assist with financial reporting and works on various projects as needed.
Intermediate in Excel, Word, Outlook as well as Peachtree, Microsoft Dynamics GP (Great Plains Software) and Winman.
Generate Crystal software reports for royalties, commissions, top twenty customers, and product by SKU
Process AR Cash Receipts, electronic check deposits and daily/monthly bank reconciliation. And Collections
Calculate royalties due to licensors and sales commissions due to independent sales representatives.
Match original invoices and requests for payments with internal purchase orders or check requests and enter accounts payable data in Great Plains.
Run end of the month AR Reports & Statement and AP Reports.
Provide accounting support for other departments.
Resolve any customer/vendor issues on taxes, order fees, freight, pricing issues, etc...
Process all credit applications and debit/credit memos.
Generate wire transfers.
Prepare sales tax reports for six states on a monthly, quarterly and annual basis.
Former responsibilities include Weekly vSyncEDI invoicing, and issuing vendor 1099’s.
Reconciled over 30 monthly credit card statements and employee expense reports for all sales employees, supervisors, managers and executives.
Reconciled Petty Cash.
Applications
Manage Engine Support Center Plus, CyberSource, Vantiv, Maui, Oracle-VPN-Microsoft Teams Excel, Outlook-Winman - Microsoft Dynamics Great Plains – Peachtree AR - vSync EDI Gentran- Director-Logistics Visibility System-Freight Forwarding System-TradeTech-JD Edwards PeopleSoft