Visual Match Off (Bulk Settlement)

Visual Match Off (Bulk Settlement)

Visual Match Off Module - User Guide

1. Introduction 📝

The Visual Match Off module is a high-efficiency settlement engine designed for bulk reconciliation of outstanding trade documents. It is especially useful for organizations dealing with high-volume accounts where matching customer receipts against dozens of invoices—or offsetting vendor payables against receivable debits—would be too tedious via individual vouchers or journals.

ℹ️

In the overall business flow:

  1. Facilitates Bulk Settlement that would be time-consuming via individual vouchers.
  2. Automates balanced matching using either AI/FIFO Auto-Prefill or spreadsheet-based manual mapping.
  3. Posts self-balancing adjustment Journal Vouchers (JvType == 'V') into the general ledger.
  4. Ensures every settlement batch achieves an exact Net Zero Balance.

Typically, this module is used by Accounts Receivable (AR) Specialists, Accounts Payable (AP) Specialists, and Credit Controllers.


2. Getting Started with Visual Match Off 🚀

Core Concept: The 11-Column Settlement Template

The module operates through a standardized 11-column Excel model containing the complete accounting identity of every transaction:

  1. Party Id
  2. Party Name
  3. Party Branch Code
  4. Doc Type (e.g., SI, PB, OA, AD)
  5. Doc No
  6. Doc Date
  7. Ref Doc
  8. Ref No
  9. Ref Date
  10. Amount
  11. Net Amount

3. Key Features & Modes ✨

🤖 Auto-Prefill Model (Party-Wise FIFO Matching)

  • Instead of typing Excel records manually, select a customer or supplier in the Select Party to Prefill Model dropdown.
  • The system fetches all open invoices, bills, debit/credit notes, and on-account receipts for that party.
  • Using a FIFO net boundary algorithm, the engine automatically pairs opposite open debits and credits up to the matching ceiling and downloads a ready-to-upload, pre-balanced Excel file.

⚡ Mass Settlement via Excel

  • Prepare hundreds of document settlements in a single spreadsheet.
  • Cross-settles across diverse document types: Sales Invoices (SI), Purchase Bills (PB), Advances (AD), and On-Account (OA) records.

⚖️ Net-Zero Batch Integrity

  • The sum of all Net amounts in the uploaded batch must equal exactly zero. If there is even a 1-paisa discrepancy, the entire batch is rejected to prevent ledger corruption.

4. Complete Step-by-Step Flow 🔄

Step 1: Generate Settlement Model

  • Option A (Auto-Prefill): Select the Party & Branch from the dropdown and click Download Model. The system auto-generates a balanced match-off file.
  • Option B (Blank Template): Click Download Blank Model to obtain the clean 11-column structure.

Step 2: Prepare the Excel Sheet

  • Ensure that the file is strictly saved with the exact required file name: ImportVisualMatchOff.xlsx.
  • Verify that each paired document reference is active and unpaid.
  • Confirm that the final sum of the Net column is zero.

Step 3: Upload and Execute Match-Off

  • In the Upload File section, select ImportVisualMatchOff.xlsx.
  • Click Upload.
  • The system performs character-level structural checks (Z-Codes) and accounting logic checks (Codes A–F).
  • Upon success, the system automatically creates a Visual Match-off Journal Voucher (JvType = 'V'), updating the status of all matched documents to settled.

5. Validations and Business Rules ⚠️

Strict File and Period Constraints

  • Exact File Name: The uploaded workbook must strictly be named ImportVisualMatchOff.xlsx. Uploading any other file name will fail.
  • Active Financial Year Only: Visual match-off can only be executed in the current, open financial year. If books for the year are closed, the operation is blocked.
  • Batch Balance (Code B): The net sum of the Net column across all rows must equal zero.
  • Document Existence (Code A & Code D): All referenced documents must exist in the database with outstanding balances matching or exceeding the settlement amounts.

6. Best Practices / Tips 💡

  • Use the Auto-Prefill Tool: Always use the Party Prefill option first. It eliminates 95% of manual typing errors by fetching accurate document numbers and dates directly from the database.
  • Do Not Rename Template: Keep the file name as ImportVisualMatchOff.xlsx.
  • Audit Traceability: Visual match-off generates system JVs tagged with type V. In the Journal Register report, you can filter by V to audit all visual match-off entries independently.