Accounting Assistant
CurrentEntered invoices into Epicor ERP systemReconciled vendor accountsResponded to vendor payment inquiriesDeveloped and administered a database for tracking problem invoicesTested and implemented automated AP invoice entry systemAnalyzed AP automation data using PivotCharts and PivotTablesDeveloped SOP’s for AP, purchasing, and receivingSimplified payment process through development of Excel macrosPrepared daily shipment report using Excel and PowerBIImproved daily shipment report with XLOOKUPs and other formulas