Position: Loan Accounting & Reconciliation Analyst
Location: Charlotte, NC
Duration: 6 months – extending
Rate: $46hr
Required Skills & Experience
Accounting background with a strong grasp of debits and credits and journal entries Experience 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 (500+ items) alongside BAU
Strong attention to detail and knows when to escalate
Nice to Have Skills & Experience
Cost center allocation or cost accounting experience Loan, mortgage or fund accounting experience
Financial services or banking background
Alteryx or other automation tools Accounting degree
Job Description
Insight Global is looking for a Loan Accounting & Reconciliation Analyst to support the commercial mortgage loan operations team at one of our large financial clients. The team's current loan system books interest to a single cost center, which has created a backlog of 500+ open items to clean up before the move to Loan IQ. This person will recalculate accrued interest in Excel, allocate it to the correct cost centers, review debits and credits, reconcile balances, and research and resolve variances, while also supporting daily BAU activity. The work is heavily Excel-based and suits someone who enjoys detail-oriented cleanup work. Loan experience is a plus but not required. On-site in Charlotte, Monday–Friday.
Accounting Reconciliation Analyst in Charlotte at Bank of America
This position is listed as full time and onsite. It was posted 5 days ago.