Auto Reconcile & Contra Settlement

Matching many payments to many open invoices by hand is slow, and partners that are both customer and vendor need their opposing balances netted. This module provides an auto-reconcile wizard that allocates payments to invoices with limits, runs it immediately or as a tracked run, and a contra settlement wizard that previews and settles partners with both receivable and payable balances. It plugs into Accounting and Accountant and is used by accountants and accounting managers.

1. 1

   Open Auto Reconcile Invoices

   Go to the Auto Reconcile Invoices menu. The wizard asks for company, partners and criteria for the scope. Only accounting managers may override the entry limit.

   • Company and partner scope
   • Entry limit guard
2. 2

   Allocate now or schedule

   Use Allocate to reconcile immediately or Schedule to queue a run. If nothing matches the criteria the wizard says so. The scope is checked against the configured limit before anything runs.

   • Allocate
   • Schedule
   • Nothing-to-allocate message
3. 3

   Follow the allocation runs

   Under Allocation Runs each run can be started, cancelled or reset. A finished or running run cannot be started again and must be cancelled before reset. This gives control over long batches.

   • Start / Cancel / Reset
   • Run status tracking
4. 4

   Run allocation from selected payments

   A button on payments launches allocation for the selected payments. If there is nothing left to allocate the system stops with a message. Posting a payment can also trigger the flow according to company settings.

   • Payment button
   • Company settings
5. 5

   Preview contra settlement

   Open Customer / Vendor Contra Settlement, choose scope and journal, and press Preview. The wizard lists partners that have both an open customer balance and an open vendor balance. It stops if none qualify.

   • Preview
   • Scope and journal
   • Partner lines
6. 6

   Settle the selected partners

   Tick the partners to settle and press Settle. The system creates the netting entries and reconciles both sides. Partners already settled are reported so nothing is done twice; Back returns to the scope.

   • Tick partners
   • Settle
   • Back

Back to version applications