QIYING BAO

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

INDIANAPOLIS, IN *6250

acpyqc@r.postjobfree.com

PHONE: 317-***-****

SKILLS:

Payroll, Accounts Payable, Accounts Receivable, Kuali Time System, Kuali Financial System, IU Purchasing

System, Indiana University Information Environment System, Human Resource Management Service, Payroll

PeopleSoft, Microsoft Office Suite, Income Tax Preparation

WORK EXPERIENCE:

Indiana University Purdue University 2005 - Present

Indianapolis, Indiana

Accounts Clerk (Lilly Family School of Philanthropy)

• Processed payroll vouchers (online hourly, biweekly and monthly) and PAE/PAO professional staff

payroll in a timely and accurate manner, including adjustment vouchers and termination payment

vouchers

• Fielded questions regarding TIME and resolved timesheet issues as required by payroll policies and

TIME functions

• Researched and solved all payroll questions

• Processed credit card payments and refunds. Compared, reconciled and balanced IUIE credit card

reports to KFS daily transaction amounts, then transferred funds from the clearing accounts to the

corresponding accounts.

• Processed disbursement vouchers and created invoices, and sent all invoices and travel

reimbursements to obtain payments on time

• Processed a broader range of purchase requisitions and managed payment data for the finance

accounts book, as well as all files.

• Created new vendor and new customer files.

• Used KFS to deposit checks and confirmed the check has been processed by the accounting office

• Assisted the finance department in a variety of accounting functions

• Supported office supply function by ordering supplies for the school through EPIC

• Organize, updated, and maintained all payroll files, HR personnel files, account files and vendors

files, ensuring confidentiality and in compliance with University policies and procedures

H & R Block (part time seasonal) 2002-2013

Indianapolis, Indiana

Tax Specialist

• Used strong client relations skills to consult and prepare income tax returns for customers

• Reviewed financial records, including prior tax return forms, income statements, and documentation

of expenditures to determine the appropriate forms and the best approach to filing each individual’s

tax return

QIYING BAO PAGE 2

Indiana University Purdue University 2003-2005

Indianapolis, Indiana

Administrative Payroll Clerk (Payroll Department)

• Processed on-cycle, off-cycle and online checks for hourly, biweekly and monthly payroll

• Researched and analyzed paycheck data

• Calculated overpayments and leave accrual balances

• Answered questions regarding payroll taxes and deductions and resolved outstanding issues

• Ran payroll reports and TIME system reports

Conseco Insurance Group/Ajilon Finance 2000-2003

Carmel, Indiana

Staff Accountant on Contract

• Researched, analyzed and reconciled suspended items in cycling and non-cycling accounts across

several years, systems and companies for CIG

Raymond Wong D.D.S., M.S.D 1997-2000

Indianapolis, Indiana

Accountant

• Prepared biweekly payroll and year-end W-2, W-3 and 1099 tax statements

• Filed all monthly, quarterly and yearly taxes

• Processed accounts receivable, accounts payable and weekly deposits

• Prepared quarterly financial statements and monthly bank reconciliations

Chinese School at Chinese Community Church 1999 - 2001

Carmel, Indiana

Treasurer (Volunteer)

• Responsible for all payroll preparation, accounts payable/receivable processing, and funds handling

EDUCATION:

H & R Block Certificate of Completion 2001-2013

Indianapolis, Indiana Professional Tax Course (Annually updates)

Ivy Tech State College AAS – Accounting Tech 1997

Indianapolis, IN

Shanghai Industry Education Certificate of Completion 1986

Center Business Training Program

Contact this candidate