Accounting Reconciliation Analyst
Bank of America
This job at a glance
- Who can apply
- New grads, no experience needed
- Must know
- OperationsExcel
- Nice to have
- Accounting
- Work
- On-site in Charlotte
- Pay
- Not stated by the employer.
- Skill demand
- Accounting97%Excel63%Operations53%of 99 similar entry-level jobs posted in the US this week
- Listed
- Nov 6, 2026 · still open
Sign in free to see which of these skills your resume already shows.
Job Title: Loan Accounting & Reconciliation Analyst
About the Role
Insight Global is seeking a Loan Accounting & Reconciliation Analyst to support the commercial mortgage loan operations team at a large financial client. The role involves cleaning up over 500 open items before a system migration to Loan IQ. The position is on-site in Charlotte, NC, for a duration of 6 months with potential for extension.
Key Responsibilities
- Recalculate accrued interest in Excel.
- Allocate interest to the correct cost centers.
- Review debits and credits.
- Reconcile balances.
- Research and resolve variances.
- Support daily Business As Usual (BAU) activity.
- Perform high-volume cleanup work (500+ items).
Requirements & Tech Stack
- Accounting background with a strong grasp of debits and credits and journal entries.
- Experience with calculating, reviewing, or reconciling accrued interest.
- Reconciliation and variance research experience (cash, ledger, or subledger).
- Expert-level Excel: VLOOKUP/XLOOKUP, pivots, building calculations across large datasets.
- Comfortable with high-volume cleanup work alongside BAU.
- Strong attention to detail and knowledge of when to escalate issues.
Qualifications
- Accounting degree is a plus.
- Loan, mortgage, or fund accounting experience is a plus.
- Financial services or banking background is a plus.
- Experience with Alteryx or other automation tools is a plus.
- Cost center allocation or cost accounting experience is a plus.