Grants Accounting

Covenant House is the largest, primarily privately funded charity in North and Central America providing immediate and long-term support for young people facing homelessness and survivors of trafficking. We provide housing and support services to youth facing homelessness. We help young people transform their lives and put them on a path to independence.

We are open 24/7 in cities across North and Central America. Our strengths-based programs are designed to empower young people to rise.

1. Grant Administration:

Collaborate with the development department to create and analyze grant budget for proposals.

Maintain a comprehensive database of all grant-related information, including deadlines, compliance requirements, and reporting schedules.

2. Budget Management:

Develop and maintain grant budgets in collaboration with program managers, utilizing advanced Excel functions for budget modeling and analysis.

Monitor grant expenditures to ensure they align with approved budgets.

Prepare budget modifications as needed and seek approvals as necessary.

Forecast grant-related expenses and revenue using Excel for accurate financial projections.

3. Financial Reporting:

Prepare and submit financial reports to grantors in accordance with grant agreements, utilizing Excel for data analysis and reporting automation.

Generate financial statements and analysis reports for internal stakeholders and senior management, leveraging advanced Excel functions for financial data analysis.

Ensure accuracy and compliance with Generally Accepted Accounting Principles (GAAP) and grant-specific regulations, using Excel for precise calculations and data validation.

4. General Ledger Analysis and Excel Expertise:

Perform detailed analysis of the general ledger, identifying discrepancies, trends, and anomalies using Excel's advanced data analysis tools.

Reconcile grant-related transactions with the general ledger, ensuring accuracy and consistency.

Utilize Excel to create pivot tables, graphs, and other data visualization tools for clear and insightful financial presentations.

5. Compliance and Auditing:

Ensure compliance with all grant-related regulations, including tracking programmatic and financial performance indicators.

Prepare for and participate in audits related to grant funding, providing Excel-based documentation and analysis as needed.

Address audit findings and implement corrective actions as required, using Excel for tracking and monitoring progress.

6. Documentation and Record Keeping:

Maintain organized and accurate documentation of all grant-related billing.

Manage grant files and records, ensuring they are readily accessible for reporting and auditing purposes, with Excel-based indexing and tracking.

Communication and Collaboration:

Collaborate effectively with cross-functional teams, including directors, finance, and external grantors.

Provide guidance and support to program managers and directors regarding grant compliance and financial matters, using Excel for data-driven insights.

Communicate financial information to non-financial staff in a clear and understandable manner, with Excel-based visual aids and reports.

Minimum 2 years accounting experience in non-profit accounting and grant/contracts billings.

Must possess very high analytical skills, capable of producing timely and accurate work. Can work with minimum supervision from supervisor. Must be able to follow instructions, highly organized and must be able to plan ahead on work assignments to meet deadlines. Must be able to multitask, be proactive and have strong initiative to make follow-ups to complete work assignments on due dates. Must have excellent skills in Microsoft Excel and working with accounting worksheets and formulas; willing to learn for advancement opportunity.