Sales Accountant

Edward Fowler

**** ****** ***

St Paul MN

*********@***.***

I am looking for a position within a dynamic company that can utilize my wide array of diversified accounting skills I have developed through my career. Though I have been working as a temporary, my goal is to become a permanent member of an accounting team. One of my strengths is the ability to remain focused and prioritize; however, I am flexible to change priorities in middle of a project because priorities can change quickly. I am a very detail, deadline-oriented team player. I have participated in several system conversions. I have analyzed, developed and documented models/procedures to streamline work for inter-company transactions, capitol/expense determination, cash flow, self-insured premiums and budgeting, for exempt and non-exempt purchases to reduce the probability of a discovery Sales Tax audit escalating into a full audit. My current assignment I use SAP my prior assignment at Cargill I used JDE.

While at CHS have streamlined some aspects of the position examples are - Upload journal entries, quick reference documents for invoice coding, implementation of the Ariba system replacing e-sign approving invoices for payments are examples. Conducted training of cost center owners in the use of some T-codes in SAP – for invoice investigation /OPT/VIM_analytics, FBL1N; Purchase Orders ME23N, ME2K. Other T-codes I am familiar with are for cost center spend analysis and Capital Project spending. With Cargill streamlined the Inter Company billing process by standardizing the access database upload process. Cross trained several people that could step in and assist with questions and month-end close billing. As a financial statement preparer at Spartan Nash I discovered that an accrual was made for and reversed in the amount of $4,950.00; the deposit that was recorded was for $49.50; actual amount was $4,950.00 – bank corrected deposit to $4,950.00. As a tax analyst I have amended numerous 941 returns to have in excess $100,000.00 refunded due prior incorrect taxes filed and penalties assessed. Streamlined Wage and Tax form filing by working with IT to get wage report files correctly formatted so upload is possible verse manual key entry of quarterly wage earning for unemployment tax filing.

My accounting experience includes balance sheet account reconciliations with integrated and non-integrated subsidiary ledgers/modules; fixed assets, payroll with deductions (cafeteria, health, garnishments) using both internal and external services (ADP, PayChex, RitePay) and applicable tax forms (940, 941, 5500, UCT-6,W-2, W-3, 1099); sales and use, personal property, occupational licenses and city business taxes in various states; inter-company entries and reconciliations; consolidation with corresponding eliminating journal entries; budgeting and variance investigation; cash projections; month, quarterly and year end closing; planning, conducting and reconciling physical inventory, costing, LIFO, FIFO, weighted average pricing. During system conversions have revamped G/L account numbers. I assisted external auditors as a liaison during year-end closing, led full and discovery state sales and use tax audits gaining favorable settlements. I have a strong understanding of GAAP, SOX and Six Sigma.

My computer skills include but not limited to an in-depth knowledge of Microsoft Office (all modules), Business Objects, PeopleSoft, SAP, ACCPAC, Lawson, Great Plains, SAP, Oracle, AS400, MAS50, Charterhouse, RealTime, QuickBooks, Peachtree, Creative Solutions and the ability to produce Ad Hoc reports. I have used many DOS based accounting packages. I have been a system administrator/co-administrator for Windows NT and Novel networks. I can fluently translate from Computerese to English.

Summary:

Sr. Accountant with 20 years of experience.

Experience in Balance Sheet Account Reconciliations, Month End close journal entries and Process documentation.

Verified company compliance of GAAP standards for capital asset, lease and leasehold improvement expenditures

Extensive experience in SOX testing.

Experience with Oracle- G/L, A/P, Fixed Assets; Hyperion Financial Management, Hyperion Financial Data Quality Management, Access, Excel, Essbase.

Skill Matrix:

Accountant Expert - 15+ Years Primary Skill 2016

SOX Expert – 10+ Years Primary Skill 2015

General Ledger Expert - 10+ Years Primary Skill 2016

Computer Skills:

Windows, Network systems, MSOffice, MSWord, Excel, Lotus, PowerPoint, Access, AccPac, ACT, AS400, Charterhouse, C.P.A.S., Creative Solutions, Fund Ware, Great Plains, Lawson, Oracle, JDE, Peachtree, PeopleSoft, Quicken, QuickBooks, QuickBooks Pro, Real-world, SAP, Fast Tax, Turbo Tax, Rational robot, Business Objects, strong knowledge of hardware and software configurations, set-ups and trouble shooting.

Education:

Rutgers University, B.S. Accounting 1989

C.P.A. (inactive)

Professional Experience:

University of Minnesota / Hunter Hamilton Minneapolis MN 4/19 to 8/19

Sr. Accountant (Contract-temporary)

Compile annual statement

Account Reconciliations

Account analysis

Mortenson Construction / Dahl Golden Valley MN 9/18 to 3/19

Sr. Financial Analyst (Contract-temporary)

Union Compliance reporting

G/L Reconciliations

Process streamling & documentation

Deluxe / Dahl Shoreview MN 5/18 to 9/18

Sr. Financial Analyst (Contract-temporary)

Scrubbed the General Ledgers of all the business units to update lease schedule to confirm to new FASB standards. Many units did trial balance uploads, needed to co-ordinate with various people to obtain the information. Reconcile payments to lease agreements and General ledge and discovered many miscoding and inconsistent/late payments.

CHS / Entero Inver Grove Hts MN 5/17 to 5/18

Accountant (Contract-temporary)

The Finance person for the IT departamnt. All month, quarter and year end closing journal entries including accruals, prepaid amortization and reclassifications.

Implemented and trained requestors and cost center managers in the use SAP and ARIBA Purchase Order system to process invoices and use as a budgeting/forecasting tool.

IT Capital project costing and timely closing

A/P invoice processing

Inter Company billling

St. Paul School District / Humera St Paul MN 1/17 – 5/17

Accountant (Contract-temporary)

Responsible for tracking Construction Project spending with the Grant and/or Bond funds. Verify the invoices are coded in accordance of UFARS.

Land O’Lakes / Incomn Shoreview MN 11/16-1/17

Sr. Accountant (Contract-temporary)

Short-term assignment to properly close approximately 500 capital projects that had been completed during the Calander year but not yet closed and transferred from CIP to the asset account and start depreciation.

Thunderbird Aviation / Expertise Bloomington MN 9/16 – 11/16

Sr. Accountant

Bank Reconciliations

Cargill / Kelly Mitchel, Hokins MN 4/15-8/16

Sr. Accountant (Contract-temporary)

Balance sheet Account Reconciliations

Process documentation

Data Base administrator

Inter-company reconciliation

Month End close journal entries

Stratasys Direct Mfg. / Top Echlon, Eden Prairie MN 10/14-3/15

Accountant (Contract-temporary)

Balance sheet Account Reconciliations

Month End close journal entries

SOX testing

Sales/Use Tax preparation

Process documentation

A/R collections

A/P processing/coding

External audit Liaison

System conversion

SpartanNash / Dougerty, Edina MN 2/14-11/14

Accountant (Contract-temporary

State Unemployment Wage and Contribution filing

Local Withholding Tax filing

Re-file corrected 941 (941X) P/R Tax

Investigate Tax deposit discrepancies reported from the IRS

Reconcile clearing accounts

SOX testing

Universal Hospital Services / CFS, Minneapolis MN 12/13-2/14

Accountant (Contract-temporary)

Reconcile Wage Reports to W-2’s, tax returns

Refile corrected 941 (941X) P/R Tax

Investigate Tax deposit discrepancies reported from the IRS and state agencies

Reconcile clearing accounts

Verify integration of software conversion to ADP

SpartanNash, Edina MN 09/13-10/13

Accountant (Contract-temporary)

Reconcile Wage Reports to W-2’s, tax returns

Refile corrected 941 (941X) P/R Tax

Investigate Tax deposit discrepancies reported from the IRS

SOX testing

Reconcile clearing accounts

SpartanNash / CSI, Edina MN 05/13-07/13

Accountant (Contract-temporary)

Month end journal entries and reconciliations

weekly inventory and sales

SOX testing

Budget variance analysis

Sales/Use Tax preparation

inter-company

Lawson, Oracle- G/L, A/P, AS400; Excel; Hyperion Data Management (Essbase)

Gander Mountain St Paul MN 12/12-04/13

Accountant (Contract-temporary)

Month end entries

Account reconciliations

Fixed Assets

A/R receipts, invoicing and statements

weekly expense account checks

Process documentation

Oracle- G/L, A/P, Fixed Assets; Hyperion Financial Management, Hyperion Financial Data Quality Management, Access, Excel, Essbase

Liberty Tax, St Paul MN 01/13-4/13

Tax Preparer (Seasonal)

Federal & State Personal 1040, schedule - A, B, C, D, E, SE, EIC, 1099(R, SSA, RRB) and supporting forms

American Craft Council 11/11-12/11

Accountant (Contract-temporary)

A/P entry and check runs

Cash receipts and bank deposits

A/R receipts, invoicing and statements

Fund Ware-A/P, A/R, G/L; Excel

3M Maplewood, MN 5/05-9/09

Accounting Coordinator

Review of capital projects/activities with engineers for correct tax planning (capital vs expense)

Journal entry any invoice coding discrepancies associated with project/activity using business object quarries

Verify company compliance of GAAP standards for capital asset, lease and leasehold improvement expenditures

Assisted with the conversion of PeopleSoft 7.5 (dos) to PeopleSoft 8.0 (windows)

Assisted with global procedures for fixed assets

SOX testing

Train Engineers in the use of PeopleSoft modules – requisitions, purchase orders, invoice receipt and payment, projects and actives

Process documentation

Journal entries for asset additions/disposal/transfers/cost and name corrections

Assisted A/P with identifying and closing open old blanket P.O.’s being misused

Six Sigma

Kelly Computer Supplies, Inc./ White Bear 8/03-8/05

Accounting Manager

Prepare and analyze monthly, year-end financial statements

Tax preparation and reconciliation – Sales and Use, 940, 941 and UCT-6

Review G/L accounts A/P, A/R, sales, cost goods

Process Payroll

Implement effective and efficient interface with accounting, shipping and sales

Peachtree- A/R, A/P, G/L; Excel

Management Team American Huts, Inc. franchisee for Pizza Huts, Palm Beach, FL 1/99 - 3/01

Lead Accountant

Prepare, analyze and reconcile monthly, quarterly, year-end consolidated financial statements

Monthly accruals on all recurring monthly expenses and payroll (13 period year)

Prepare royalty, franchise and advertising fees due to corporate Pizza hut

Tax preparation, file and reconcile monthly, quarterly and year-end Sales and Use tax (5 states 104 locations electronically), 940, 941, UCT-6, city, county occupational/business licenses/tax, intangible and personal property taxes

Approve A/P invoice coding

Process documentation

Verify leasehold improvements and disposal for tax planning

General Ledger – A/R, A/P, G/L; Excel

S. Barrie Godown C.P.A. Jupiter FL 10/96 - 4/98

Senior Accountant

Prepare and analyze monthly, quarterly and year-end financial statements,

Prepare and analyze year-end tax work papers for non-monthly clients

Prepare, analyze and reconcile quarterly and year-end tax returns: 940, 941, UCT-6, Sales and Use tax, Tangible and Intangible Personal Property

Assisted clients in the conversion from their in house financial program to Creative Solutions to streamline monthly processing

Bank reconciliation

Management Team Historical Tours of America, Inc., Key West FL 10/93-5/96

Lead Accountant

Prepare and analyze financial documentation verifying loan covenants are being adhered to consisting of: consolidated quarterly financial statement with eliminating inter-company entries, fixed asset, depreciation, debt and lease schedules, quarterly net income, working capital projections for the remaining year

Document, review, streamline and train accounting policies and procedures

Chart of account conversion/renumbering/naming to help streamline the consolidation process

Liaison external auditors with year-end audits and for 2 IPO’s

Financial statements, A/P, P/R and detailed WIP schedule for the manufacturing concern

Weekly statement of cash position

U.S. Economic Censuses filing

K.W.R. Management Inc. Key West, FL 9/90 - 5/93

Controller

Prepare and analyze monthly and year to date stand alone and consolidated financial statements

Journal entries

Bank reconciliation's

Prepare payroll

Weekly statement of cash position

A/P entry and check writing

A/R billing and collections

Prepare and analyze tax - 940,941, UCT-6 and Sales and Use tax filing

Liaison to external and bank auditors

Maintain GAAP and FASB guidelines

Military:

USNR Honorable discharge, Rank E-5, Rating Quartermaster (navigation)

Contact this candidate