QIYING BAO
INDIANAPOLIS, IN *6250
********@***.***
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