William Truby
Accountant/Data Analyst · NetRevamp
Lakewood, CAWork Experience
Accountant/Data Analyst
NetRevamp2014 – 2015
• Provided customer support for web integration, which included: troubleshooting issues with import or export of flat files, resolving transactional errors, and coordinating modifications of the integration program • Used knowledge of Full Circle (ERP) and business processes to assist programmer with Ecommerce/Web integration project • Performed reconciliations of credit card statements and bank accounts • Posted transactions (invoices, payments, purchases etc.) to Quickbooks • Performed A/R duties: sent out invoices and made sure they were paid timely • Loaded product and images into Magento • Assisted network administrator with remote app configurations, Powershell and vb scripts
Accounting Analyst
Alpinestars2008 – 2014
• Furnished reports to Upper Management: Weekly sales reports by department, actual sales vs budgeted sales and style availability Reports • Created and presented margin analysis for deep discounts, SMU buys, production buys, and product pricing for CEO’s approval • Supplied parent company (Alpinestars SPA) monthly Auto department reports: Sales Reports, style availability reports (stock, open orders, WIP) • Provided daily pickticket spreadsheet to Warehouse Manager and sales department to ensure picktickets were accounted for and product was shipped timely • Ran pickticket allocation • Provided data used to prepare the sales and use tax • Regularly, sent backorder and past-cancel reports to customer service reps • Created schedules used to pay royalties • Calculated independent sales rep commissions • Furnished ad hoc reports to various departments • Performed Stock Adjustments • Prepared inventory valuation for financial statements • Coordinated inventory cycle counts • Uploaded inventory counts into system • Imported EAN’s into system • Acted as liaison between upper management and IT • Assisted with training new employees in Aims(ERP) • Performed regular Aims Backups • Ran Aims maintenance utility’s regularly • Created users and user access in Aims • Worked with Aims programmers to create custom modules • Setup EDI Trading partners with a 3rd Party Provider • Maintained 832 GXS catalogue • Imported EDI 850’s into system for integrated Trading Partners
A/R Accountant
Alpinestars2005 – 2008
• Reconciled the A/R subledger balance (AIMS) to General Ledger A/R balance (Peachtree) • Reconciled General Ledger Factor balance to balance at the factor • Assisted Controller with creating the amount for Allowance for Doubtful Accounts • Posted Cash Applications, A/R adjustments, and Credit Memos to AIMS • Posted Sales, Credit Memos, A/R adjustments to Peachtree • Prepared A/R reports for management • Prepared Bank deposits • Managed factor process which included submitting accounts for credit approval, submitting invoices for factoring, and resolving unapplied cash reports sent from factor. • Managed A/R collections person to ensure collection calls were made, and statements/invoices were sent out in a timely fashion • Collaborated with Customers and Sales Dept (when needed) to resolve chargebacks and disputes • Set Up payment plans with customers in order clear past due balances • Submitted past due accounts to collection agency
Education
Bachelor of Science
Florida A&M2000 – 2002
Bachelor of Science