Loan Administrator/Accountant

San Francisco / Oakland
November 2022

WHO WE ARE

Communities on the margins of opportunity deserve a trusted partner on their journey toward financial growth and stability. As a locally invested, collaborative partner in social justice and financial equity, Community Vision provides nonprofits, small businesses, and social enterprises with strategic investment and guidance, to deepen work, scale impact, and strengthen our communities.

We know that supporting community-owned and community-governed projects creates shared prosperity and builds collective, and self-directed, economic and political power. This position will put you at the forefront of exciting organizational growth and the re-envisioning of how we carry out our work; creating greater efficiency internally and deeper impact externally.

Community Vision is dedicated to anti-racist practices and to building an anti-racist organization. This includes treating colleagues with respect, supporting the vision of the organization, and acting as ambassadors of our values.

THE OPPORTUNITY

The Loan Administrator/Accountant is pivotal to the onboarding of all loans to the
organization’s loan management system TEA (The Exceptional Assistant), performs the
ongoing monitoring of our outstanding loan portfolio, and assists the accounting department with the various portfolio reporting needed by upper management, compliance, and external stakeholders. This opportunity is responsible for ensuring the accuracy of loan documents match and support the final onboarding of all loan closing processes. The Loan Administrator/Accountant will also assist the accounting team with monthly transactions as it relates to the loan portfolio, NMTCs, financial statements, and overall reporting.

WHAT WE VALUE

Community Vision is dedicated to anti-racist practices and to building an anti-racist organization. This includes treating colleagues with respect, supporting the vision of the organization and demonstrating the professional practices of the organization which are community centered, patient, communication, work-ethic, responsiveness, conscious of difference, humility and curiosity, humor, creativity, practical, accountability and data driven. Staff members attend to the culture of the organization by being ambassadors of Community Vision’s values and participating in internally focused work groups.

WHO WE ARE LOOKING FOR

Ideal qualifications

  • Bachelor’s degree in accounting, finance, or economics.
  • Minimum 8 years of accounting working experience.
  • Knowledge of/experience with Generally Accepted Accounting Principles.
  • Knowledge of/experience with nonprofit and Fund Accounting Principles.
  • Knowledge of/experience with loan amortization schedules and loan servicing preferred.
  • Knowledge of loan terms and loan documents to understand the impact of rate adjustment,​ ​other modifications, re-amortization, etc.
  • Knowledge of/experience with MS Office, Excel, and Google Suites.
  • Knowledge of/experience with Abila MIP, Bill.com, and Salesforce preferred.
  • Ability to analyze problems, find discrepancies, and resolve issues.
  • Ability to perform detailed work with a high degree of accuracy.
  • Ability to work independently and respond quickly to a changing environment.
  • Able to remain professional, multi-task, and flexible under pressure.
  • Excellent written and verbal communication/presentation skills.
  • Experience in documenting commercial loans and/or asset management, preferably in the​ ​fields of either community development or small business lending.
  • Experience with New Markets Tax Credit programs.
  • Experience in post-closing monitoring is a plus.

WHAT YOU WILL DO

Loan Portfolio
• Manages all loan boarding and servicing activities in coordination with the loan administration team.
• Monitors borrower payments for delinquencies.
• Manages and tracks all participation loan balances, draw requests, payments, and other
loan portfolio adjustments, including reconciling interest accruals and principal balances.
• Prepares monthly interest/principal payments for loan participants.
• Generates monthly reports and conducts data reconcilement-LLRs, loan portfolios,
maturities, rates, etc. for upper management.
• Communicates with Loan Officers and loan closing administrators to ensure proper handoff and transition of responsibilities promptly.
• Uploads and Processes funding disbursements and draws requests for a line of credit, pre-development, and construction loans, ensuring proper documentation and compliance with loan conditions.
• Maintains the loan portfolio management system (TEA) and related databases, through
disbursement, including updates to the Salesforce database.
• Works collaboratively with other departments to manage information, reporting, and
document preparation for various internal and external needs, and compliance with investor covenants.
• Must be willing to be backup TEA trainer for future staff.

New Market Tax Credit Portfolio
• Assist with setting up all-new NMTC deals in the accounting system
• Review transaction documents and work with the loan administration team to onboard new deals.
• Prepare invoices and work with the loan administration team to insure receipt of payments.
• Coordinate and communicate with investor asset management staff.
• Post all loan payments and other transactions in Portfolio Management software in MIP.
• Prepare documentation for distributions and other payments in the structure.
• Generate reports and reconcile data with an accounting system.
• Monitor QALICB payments for delinquencies.
• Prepare schedules and other materials for audits and tax returns.
• Monitor completion of work by external CPAs to meet investor deadlines.
• Arrange for all required state, federal, and local tax payments.
• Work with administrative staff as needed to file all required statements of information and other legal documents for these entities.

Agency Accounting
• Has backup responsibility for general ledger and journal entries.
• Will work with the staff accountant to review and assist with accounts payable and
accounts receivable as necessary.
• Prepare all appropriate accounting transactions in MIP Nonprofit Series software.
• Work with program staff to correctly invoice clients each month and to post accurate fee income.
• Assist with monthly bank reconciliations.
• Monitor cash balances and other accounts and make recommendations to the Director of Finance (CFO) and Controller.
• Manage all accounting related to subsidiary entities for New Markets Tax Credits and Credit Enhancement.

Budget
• Assist with preparing CV, CE1, and RPF monthly financial statements
• Assist in the preparation of the annual budget
• Assist with preparing the organization’s cash flow
• Assist in the ongoing monitoring of budget variances

Other
• Periodic tracking, reporting, and analysis of grants disbursed, funds held in trust, and other special program reporting.
• Collect and review data for federal, state, and local reports, registrations, tax returns, and property taxes to ensure timely filing.
• Train other accounting staff on systems and procedures as it relates to TEA.
• Other relevant duties and special projects as assigned.

MORE ABOUT THE POSITION

The Loan Administrator/Accountant is a full-time exempt position. This position reports to the VP of Finance (CFO) but works closely with the organization’s Controller and other staff accountants. The salary for this position is between $75,000 – $90,000 annually, depending on experience. Benefits include 100% health insurance premium coverage for employees and a contribution towards dependent coverage, dental insurance, long-term disability and life insurance, cell phone subsidies, employer contributions towards retirement savings, three weeks’ vacation, and a commitment to work/life balance. Occasional evenings and out-of-area travel may be necessary. The position involves a regular computer and telephone use plus some minimal lifting. The position can be based at either Community Vision’s offices in San Francisco or Oakland. All staff are working remotely until further notice.

Send resume and cover letter via email to hr@communityvisionca.org. Subject line to read: Community Real Estate Consultant. Letters should discuss your interest in the position and in working at Community Vision. Resumes without cover letters will not be considered. 

Position is open until filled. For more information on our programs and services, please visit our website at: communityvisionca.org