• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Salary Range: commensurate with experience

Position Summary

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.

Responsibilities

• 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%)

Minimum Qualifications

• Bachelor's degree of equivalent in education and experience
• A minimum of three 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)           

Preferred Qualifications

• 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.