The Accounting Coordinator will support the ICAP Cash Management Team with the monthly examination and review of each field office's Field Finance Report (FFR), supporting documentation and payment receipts from the field office locations and within Columbia University's ARC system to ensure compliance with regulations and generally accepted accounting principles (GAAP). Prepare written reports of findings and recommendations for improvement. The Accounting Coordinator will assist the ICAP Cash Management team with audit and other special project requests.
This position is temporary.
Supports the Cash Management Team with the monthly examination, review and monitoring of each field office's Field Finance Report (FFR), transactions, supporting documentation and payment receipts to ensure accuracy, legitimacy, allowability and allocability of expenses as dictated by donor, Columbia University and ICAP guidelines and regulations and to ensure that the accounting is in accordance with generally accepted accounting principles (GAAP). 10%
Performs monthly review of the Field Finance Report submitted by the local country office to ensure that the information recorded into the country offices' financial accounting books is in conjunction with the relevant supporting documentation. Monthly review will cover payroll, bank reconciliations, advance registers, balance sheet and profit and loss statement. 10%
Confirms that expenditures are allocated to the correct sponsored projects and budget code. Reviews transactions for proper approvals, supporting documentation and compliance with donor rules and regulations, and Columbia University accounting policies.10%
Supports the Cash Management Team with the preparation of the monthly issue reports that summarizes the audit findings and recommendations for improvement which are shared with the local offices for review and corrective action. 10%
Monitors the status of responses to the issues reports ensuring all issues are addressed and resolved in a timely manner and subsequent errors are avoided. 20%
Interfaces with field office locations for requests for supporting documentation relating to expenditures and the monthly reporting. 5%
Responds to audit requests from field office locations, Finance Teams and Mailman School of Public Health, including the review of transactions in QuickBooks for donor and university compliance on posted transaction ensuring that supporting documentation exists for audited transaction and is in compliance with generally accepted accounting principles (GAAP). 20%
Supports the Cash Management Team in responding to other auditor requests. 10%
Performs other related duties and projects as assigned. 5%
Bachelors Degree in Accounting or Finance or equivalent in education and experience.
Minimum three (3) years of related experience
Strong analytical and organizational skills
Strong interpersonal skills in order to deal effectively with varied internal clients
Excellent customer service skills
Experience in auditing strongly preferred
Knowledge of US Government Rules and Regulations on Reporting and Expenses
Demonstrated experience working in a fast paced environment, coupled with experience with international protocols, non-profit organizations or academic institutions is highly desirable
Knowledge of Columbia University systems, ARC, ERP
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 503731
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.