Coley Wilson, Cpa Email & Phone Number

Auburn Hills, Michigan, United States

Troy, Mi

• Entered daily Amazon orders into company’s software. Incorporated Excel macro which shortened task by 50%.• Took initiative to create macros for various tasks performed by various employees. Increased efficiency and employee productivity.• Constructed reports using pivot tables for specific inventory items. Helped management keep track of specific items manually since inventory numbers in company’s software were inaccurate.• Helped implement multi-state sales tax collection procedures. Created/updated state tax codes. Follow sales tax law changes to ensure company was charging correctly. • Responsible for notifying salespeople of changes with tax codes for sales to follow tax laws.• Ran monthly reports to oversee salespeople were charging sales tax correctly. Communicate with salespeople when amounts were incorrect.• Controlled check payments from customers. Notify customers when overpayments existed.• Gained experience with bank reconciliation by reconciling Amazon and PayPal bank accounts every month.

Southfeild, Mi

• Organized and updated Excel spreadsheets for employees allowing them to move on to other tasks.• Assist accountants by entered client data in QuickBooks or company’s write up software.• Scanned old paper documents into company’s online file cabinet created easier access to documents for employees. Help organize electronic files.

Master Of Accounting, Taxation

Accounting