Accounting Reconciliation Analyst

Bank of America Corporation; Charlotte (NC); On-site; USD 52,000 - 74,000; Full time

Job summary

Insight Global is seeking a Loan Accounting & Reconciliation Analyst to support the commercial mortgage loan operations team for a large financial client. The role focuses on recalculating accrued interest and ensuring accurate cost-center allocations.

The successful candidate will work on-site in Charlotte, handle high-volume Excel work, reconcile balances, and resolve variances, with a backlog of 500+ items to clean up before the move to Loan IQ. Monday–Friday, business hours.

Qualifications

• Accounting background with debits/credits and journal entries
• Experience calculating, reviewing or reconciling accrued interest
• Excel VLOOKUP/XLOOKUP, pivots, large datasets

Responsibilities

• Recalculate accrued interest in Excel and allocate to correct cost centers
• Review debits and credits, reconcile balances, and research variances
• Support daily BAU activities; backlog cleanup of 500+ items
• On-site in Charlotte, Monday–Friday

Skills

Debits & credits knowledge

Accrued interest reconciliation

Reconciliation & variance research

Advanced Excel

High-volume data cleanup

Education

Accounting degree

Tools

Excel

Alteryx

Job description

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 elevate

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.