Accounts Payable Clerk
Responsibilities:• Preparation and posting of all payable documents.• Code and then Reconcile AMEX purchases to A/P sub-ledger• Prepare the sales commission reports• Prepare import landed cost worksheets, and then submit the duty drawback claims on a quarterly basis • Prepare customer rebate reports on a quarterly basis• Consolidate sales by product ID in order to generate the quarterly reports for the college and university licensing bodies• Reconcile the year-end physical inventory counts to the Sage Business Vision records• Reconcile our website product counts to our Sage Business Vision records• Work with our partners in India to resolve technical issues with our website• Work with our partners in India to set-up the API modules for PromoStandards Accomplishments: • Wrote VBA programs in Excel to automate the generation of upload files for the PromoStandards API• Generated VBA program in Excel that generated sales commission reports from the monthly sales data