AI Party Ledger Reconciliation (Free Preview)

AI Party Ledger Reconciliation (Free Preview)

AI Party Ledger Reconciliation (Free Preview) - User Guide

1. Introduction 🤖🤝

Reconciling your internal accounts with external vendor or customer statements is traditionally one of the most tedious tasks in finance. External parties use different invoice references, varying date formats, and unique accounting descriptions.

The AI Party Ledger Reconciliation module solves this challenge with a universal matching engine. By uploading your internal ERP ledger alongside the external party’s statement in Excel, the AI engine pairs transactions, categorizes match certainty, and computes net ledger variances automatically.

ℹ️

Key Capabilities:

  • Flexible Column Auto-Detection: External statements do not need to follow strict ERP formats; the AI automatically recognizes Date, Reference, Description, Debit, and Credit columns.
  • Multi-Tier Matching: Identifies Exact Matches, Date & Reference Matches, and Fuzzy AI Matches (handling typos, partial reference matches, or combined bills).
  • Interactive Balance Board: Visual T-Ledger view breaking down unmatched debits and credits between your internal books and the external ledger.
  • Audit-Ready Export: One-click download of the comprehensive comparison workbook into Excel.

This feature is ideal for Accounts Payable (AP) Teams, Accounts Receivable (AR) Teams, Credit Controllers, and Auditors.


2. Prerequisites & Access Controls 🔐

  • Module Permissions: User must be authorized for Finance transactions.
  • AI Feature Entitlement: Active company entitlement for AI features.
  • AI Credit Availability: Sufficient AI credits in the organization’s account.

3. Step-by-Step Workflow 🚀

Step 1: Prepare the Files

Prepare two files in Excel (.xlsx) format (max 1 MB each):

  1. System Ledger (Internal Books): Exported from your ERP (e.g., from the Financial Ledger report for the party). Contains standard internal columns (Date, Doc No, Ref No, Debit, Credit).
  2. Party Ledger (External Statement): The statement provided by your supplier or customer.
Preparation Tip: Ensure core numeric values (Debits and Credits) are clean numbers and document dates are clearly legible in standard calendar formats.

Step 2: Upload Files

  1. Navigate to Finance > Transactions > AI Party Ledger Reconciliation (Free Preview).
  2. In the System Ledger card, upload your internal ledger .xlsx file.
  3. In the Party Ledger card, upload the party’s external statement .xlsx file.
  4. Review the uploaded file names and sizes in the green/purple confirmation cards.

Step 3: Run AI Reconciliation

  • Click Perform AI Reconciliation.
  • The system performs automated matching passes:
    1. Deterministic Pass: Pairs exact matches on date, reference number, and opposite amount (your debit vs. their credit).
    2. Heuristic Pass: Accommodates minor date offsets (e.g., invoice date vs. receipt date).
    3. Fuzzy AI Pass: Matches complex descriptions, truncated reference numbers, and combined settlements.

Step 4: Analyze On-Screen Insights

Upon completion, the interactive analysis dashboard appears:

  • Executive KPI Cards:
    • Total Matched Pairs: Number of reconciled transaction pairs.
    • Total Unmatched Records: Count of records requiring human review.
    • Net Unmatched Diff: Net monetary variance between the two ledgers.
    • Overall Confidence Score: Statistical certainty rating of the matching run.
  • Unmatched Records Balance Board (T-Ledger):
    • Shows System Ledger Unmatched Debits (+) vs. Unmatched Credits (-).
    • Shows Party Ledger Unmatched Debits (+) vs. Unmatched Credits (-).
    • Computes the exact net imbalance between both organizations.
  • Matched Pairs Table:
    • Displays paired entries side-by-side with match type and confidence badges.
  • Unmatched Records Table:
    • Tabbed interface separating unmatched internal entries from unmatched external entries.

Step 5: Export Full Report

  • Click Export to Excel at the top right of the results screen.
  • The system downloads AI_Party_Ledger_Reconciliation.xlsx, complete with all reconciled pairs, unmatched entries, and summary sheets for sharing with the vendor or customer.

4. Key Rules and Best Practices 💡

  • Mirror Principle: Remember that your customer’s ledger is the opposite of yours—your Sales Invoice (Debit) appears as a Purchase Bill (Credit) in their books. The engine automatically handles this inversion.
  • File Size Cap: Keep uploads under 1 MB. For large annual accounts, run reconciliations on a quarterly or monthly basis.
  • Resolution Workflow: Send the generated Excel export directly to the party’s accounts team to quickly resolve the highlighted “Unmatched” rows.