Sales Accounting

Baoqin Li

***-** ******* ****** #**, Flushing, NY 11355

631-***-****, **********@*****.***

SKILLS:

Computer Advanced in Microsoft Excel (VBA, Macros, Pivot Tables, Solver, Lookups, Microsoft Query);

Microsoft PowerPoint, Word; C Programming; Visual FoxPro

Language Fluent in English and Chinese

EDUCATION:

St. John’s University, Queens, NY

Master of Science in Accounting May 2014

GPA: 3.27 / 4.0

Qufu Normal University, China

Bachelor of Management July 2012

Major: Business Administration

Awards: University Scholarship 2008-2009

RELATED COURSEWORK:

Financial Reporting Concepts & Problems, Business Combinations & Consolidations, Advanced Managerial

Accounting, Statistics, Macroeconomics, Econometrics, Money and Banking, Investments, Managerial

Operations Research, Management Information Systems, International Trade Theories and Practice, Market

Research and Forecasting

EXPERIENCE:

JLM Couture, Inc., New York, NY June 2014-Present

Accounting Intern

Reconcile more than one hundred paid invoices to bank statements for fiscal year 2012

Input the daily totals in sales and credit registers of different divisions into Excel spreadsheets

Get the daily, weekly and monthly totals with functions, and link them to the summary worksheet

Reconcile invoices to receipts and classify them into paid invoices and open invoices for current fiscal year

Update sales and payment records with invoices and receipts for current fiscal year

Compare spreadsheet records with bank statements to find out the uncleared checks

Order checks, invoices and other materials by vendor or employee’s name and file them

Prepare a customer list

Future Creation International Corp., Flushing, NY February 2014-April 2014

Tax Intern

Prepare tax returns for clients with W-2 or 1099 forms and UltraTax CS

Took appointments for clients and checked clients’ materials

Greeted clients and answered phone calls

ACTIVITIES:

Association of Student Organizations, Qufu Normal University, China 2008-2009

Haishun community residents' committee, China

Volunteer for ‘Build National Civilized City’ Summer 2010

Volunteer for ‘Olympic Games Qingdao Olympic Sailing Competitions’ Summer 2008

Contact this candidate