Reconciliation

The Reconciliation page lets you apply unapplied payment receipts to open A/R invoices for a specific customer. Select a customer to see their unapplied receipt balance alongside their open invoices, enter the allocation amounts manually or use Auto Assign, then confirm to post the allocations.

Accessing the Page

Navigate to Finance → Banking → Reconciliation in the sidebar, or go to /finance/banking/reconciliation.

Accessing the Page

• Route: /finance/banking/reconciliation
• Menu Path: Finance → Banking → Reconciliation

How the page works

graph LR
    A[Select Customer] --> B[View Unapplied Receipts]
    A --> C[View Open Invoices]
    B --> D[Enter Allocation Amounts]
    C --> D
    D -->|Auto Assign| E[System fills amounts oldest-first]
    D -->|Manual| F[Enter amounts per invoice]
    E --> G[Confirm Reconciliation]
    F --> G
    G --> H[Allocations posted; invoice balances updated]

Summary Metric Cards

After selecting a customer, three metric cards appear:

Card	Description
Available	Total unapplied receipt balance for the customer
Outstanding	Total open invoice balance for the customer
Allocated	Amount you have entered in the allocation fields (updates in real-time)

Unapplied Receipts Panel

Lists all Posted receipts for the customer that have an unapplied balance:

Column	Description
Receipt #	Document number
Date	Receipt date
Total Amount	Full receipt amount
Unapplied Amount	Amount not yet applied to invoices

The footer shows the total unapplied amount available to allocate.

Open Invoices Panel

Lists all open invoices (Posted, Partially Paid) for the customer:

Column	Description
Invoice #	Document number
Date	Invoice date
Balance Due	Remaining balance on the invoice
Allocate	Editable amount to apply from receipts (max = balance due)

Auto Assign button: fills in the Allocate amounts automatically, distributing the total unapplied balance across invoices oldest-first until the available balance is exhausted.

Action Bar

Shows running totals and the Reconcile button:

Field	Description
Available	Total unapplied receipt balance
Total to Reconcile	Sum of all entered allocation amounts
Remaining	Available minus Total to Reconcile

The Reconcile button is enabled only when:

• At least one allocation amount is entered (> 0)
• Total to Reconcile ≤ Available (no over-allocation)
• The user has canWriteReconciliation permission

If total to reconcile exceeds available, an over-allocation warning appears and the button is disabled.

Confirmation Dialog

Before posting, a confirmation dialog summarizes:

• Business partner name
• Number of invoices being reconciled
• Total amount being reconciled

Click Reconcile in the dialog to confirm and post all allocations.

Post-Reconciliation Effects

After successful reconciliation:

• Each allocated invoice has its balance reduced by the allocation amount
• If an invoice is fully paid, its status transitions to Paid
• Receipts that are fully applied have their unapplied balance set to zero
• The page resets allocation amounts and reloads the lists

Validation Rules

Rule	Behavior
Customer required	Cannot proceed without selecting a customer
At least one allocation	Cannot reconcile with all allocation amounts at zero
Total ≤ available	Allocation total cannot exceed the unapplied receipt balance; over-allocation is shown as an error
Per-invoice ≤ balance due	Each invoice allocation cannot exceed its balance due

Common tasks

1. Select the customer from the Business Partner selector.
2. Review the unapplied receipts and open invoices panels.
3. Click Auto Assign to pre-fill amounts, or enter amounts manually.
4. Click Reconcile and confirm in the dialog.

Permissions & system behavior

• Posting reconciliation requires the canWriteReconciliation permission.
• Receipts and invoices are sorted by date (oldest first) for auto-assignment.
• The page uses both receipt and invoice data — if either service is unavailable, the panels show a loading state.

Related Pages

• Payment Receipts — Source receipts for reconciliation
• A/R Invoices — Open invoices being settled
• Receipt Detail — View individual receipt allocations