Objectives
- Data entry
- Financial reconciliation
- Maintain open orders records/logs and follow up with requestors
- Maintain program administrative files (electronic and hard copies)
- Other administrative/financial tasks needed during period of performance
Tasks
-Consultant will enter records in Access database or Excel file (purchase orders, travel advances and vouchers, local vouchers, inter-unit reimbursements, SI Unit expenses, payroll, etc.) daily in which to reconcile against.
-Consultant shall provide financial reconciliation for both/or unit funds and grant funds; Consultant shall reconcile SI financial records against Department records. Consultant shall run financial reports from both systems and show monthly balancing (available balances and accounting income and expense class and account code balances match in both systems).
-Consultant will be responsible for running Open Orders financial query report on a monthly basis, from the SI financial system, compiling the information and follow up monthly, with department requestors, to ensure orders are paid and closed in timely fashion, keeping an Excel spreadsheet of tracking information.
-Consultant will maintain administrative files (electronic and hard copies), by scanning in PO packages and saving to shared drive, filing hard copies, helping to archive hard copies, destroy hard copies, etc.
Deliverables
-Consultant shall provide monthly funds reconciliation status report to the Assistant Director for Science.
-Consultant shall provide monthly report of open purchase order status to Assistant Director for Science.
-Consultant shall meet with Assistant Director for Science on bi-weekly basis to give status of all administrative activity and tasks.
Qualifications
-Consultant shall have a minimum of 5 years of Accounting reconciliation experience.
-Consultant MUST have a minimum of 5 years Excel experience (working with Excel at least 30 hours per week) and having familiarity with Pivot tables and other advanced functions.
-Consultant shall have a minimum of 10 years of general administrative and financial experience in an office setting.