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) and supporting documentation and the processing of field office wire packages and expense journal entries relating to them. The Accounting Coordinator will assist the ICAP Cash Management team with audit and other special project requests.
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). (20%)
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. (20%)
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. (15%)
Records the summarized version of the local office expenditures into the Columbia University accounting system by project account numbers and budget categories after review of Field Finance Report (FFR). Monitors the approval process of wire packages and expense journal entries up to final approval. (10%)
Interfaces with field office locations for requests for supporting documentation relating to expenditures and the monthly reporting. (10%)
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 transactions ensuring that supporting documentation exists for audited transactions and is in compliance with generally accepted accounting principles (GAAP). (10%)
Supports the Cash Management Team in responding to other auditor requests. (10%)
Performs other related duties and projects as assigned. (5%)
Bachelor's degree of equivalent in education and experience.
3+ years of experience
Strong analytical and organizational skills
Strong interpersonal skills in order to deal effectively with varied internal clients
Excellent customer service skills
Proficient with Microsoft Office Suite (e.g., Excel, Word, Outlook)
Experience in accounting, finance, and/or 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: 513267
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.