Accounts Payable, Reconciliation

Scott M. Brown

**** *. ***** **. #***

Las Vegas, NV 89115

Phone: 847-***-****

Email: *************@*****.***

Career Objective:

Enter a company with a chance to grow by proving myself to the organization through hard work and dedication.

Education:

University of Illinois at Chicago: Bachelor of Science in Accounting

Computer Experience:

Keyboard: 45+ WPM with high accuracy, Numeric: 8000+ KSPM with accuracy.

Languages: Basic, Visual Basic, C, C++, & HTML

Environments: Microsoft Windows, Lotus

Applications: Excel, Access, Word, PowerPoint, FrontPage, QuickBooks, TaxCut, TurboTax, JD Edwards, SAP, Lawson

Work Experience:

Accounts Payable Clerk, Access Assignment, Account Reconciliation, Budgeting

Performed account reconciliation using Excel and SAP to find billing discrepancies over a six month period between by comparing SAP invoices to Proctor and Gamble weekly totals to find billing discrepancies due to aging, incorrect prices, and transpositions.

Reconciled general ledger accounts by checking monthly SAP totals to monthly Excel totals.

Updated budget reports for the year 2008 in Excel by using various Excel functions such as v-lookup, h-lookup, index, linking, pivot tables, etc.

Allocated the projected yearly totals to each month of the remaining 2007 year and upcoming 2008 season for budget forecasting.

Performed check clearing, entered invoices with multiple line items, and organized manufacturing projects.

Organized invoices for the weekly accounts payable check run, processed checks to be mailed.

Entered invoices into the accounts payable system for payment by finding vendor numbers, contract numbers, & purchase dates.

Batched accounts payable invoices by closing batches and making sure they were correct before they were released for payment.

Forwarded company accounts payable invoices that needed supervisor approval for payment because the invoices were not received in or had significant discrepancies with regard to price or quantity.

Performed miscellaneous Excel assignments for my supervisor that included updating spreadsheets and account reconciliation.

Performed MS Access project that included making tables, queries, forms, and reports.

Interacted with vendors regarding account discrepancies as result of unpaid invoices by pulling invoices to check correctness.

Reconciled accounts from major vendors that had issues with the automatic electronic payment where the printed invoice differed from the invoice received electronically.

Closed out year end accounts payable.

Contact this candidate