Customer Reconciliation

Job Title: Customer Reconciliation Assistant Manager  
Department: Finance / Accounts
Reporting To: Finance Manager / Accounts Manager

Key Responsibilities

• Perform daily/weekly/monthly customer account reconciliation.
• Reconcile customer ledgers with company books and identify differences.
• Match invoices, payments, credit notes, debit notes, and outstanding balances.
• Follow up with customers for payment details, pending invoices, and balance confirmations.
• Investigate and resolve unapplied receipts, short payments, excess payments, and disputed amounts.
• Coordinate with Sales, Dispatch, Billing, Collections, and Finance teams for reconciliation issues.
• Prepare customer-wise outstanding and reconciliation statements.
• Maintain proper records of reconciliation workings and supporting documents.
• Monitor overdue balances and highlight long-pending items to management.
• Ensure timely closure of reconciliation differences.
• Support month-end closing, audit requirements, and customer balance confirmations.
• Prepare MIS reports related to receivables, collections, and reconciliation status.

Required Skills

• Good knowledge of Accounts Receivable and customer ledger reconciliation.
• Strong knowledge of Microsoft Navision Business central
• Strong knowledge of MS Excel (VLOOKUP/XLOOKUP, Pivot Tables, filters, formulas).
• Knowledge of GST, invoices, credit/debit notes is an advantage.
• Good communication and follow-up skills.
• Strong analytical and problem-solving ability.
• Attention to detail and ability to handle large volumes of transactions.

Key Performance Areas (KPIs)

• Timely completion of customer reconciliations.
• Reduction in unreconciled/unapplied amounts.
• Accuracy of customer outstanding balances.
• Timely resolution of customer disputes.
• Timely submission of reconciliation and MIS reports.

Qualifications

• Bachelor's Degree in Commerce (B.Com), Accounting, or Finance.
• CA Inter / CMA Inter / MBA (Finance) preferred.
• 3-5 years of relevant experience in Reconcillation.