Reconcile a bank transaction

Reconciling a transaction means linking it to the matching customer collection. If the collection does not exist yet, you create it from the transaction, without entering it again.

Suggestions

For each To reconcile money-in transaction, CAPPS offers up to four suggestions, in the branch's currency:

• a collection already entered, not reconciled, with the same amount and a date close to the transaction;
• an open invoice whose number appears in the label, or whose balance due equals the amount.

Each suggestion shows a score (green for the most reliable), its number, the customer and the amount. Hover over it to read the reason, for example “Same amount, 1 day(s) apart, reference quoted”.

Steps: reconcile from a suggestion

1. Open the Accounting operations menu, Bank reconciliation tab.

2. On the row, click the matching suggestion.

3. For a collection, the transaction moves at once to the Reconciled status.

4. For an invoice, a creation panel opens with the customer and invoice already selected: check the payment method, then click Create collection.

Steps: create the collection from the transaction

1. On a To reconcile money-in transaction, click Collect payment.

2. Search for the customer (name or account number, at least 2 characters). CAPPS first suggests the name read in the label. Each result shows the number of open invoices and the balance due. Click Change to choose another customer.

3. Check the method: Bank transfer, Check, Bank card, Bill of exchange or Cash. It is deduced from the label (“REMISE CHEQUE”, “LCN”, “CB”, and so on), otherwise it is a transfer.

4. Leave Allocate to the oldest invoices selected so that the payment settles the customer's oldest invoices first.

5. Click Create collection (the button shows the amount).

The collection takes the transaction's amount and date, its reference (or else its label) and the statement's bank. The transaction moves to the Collection created status. To enter a collection from the customer account, see Collect a customer payment.

Automatic matching

The Automatic matching button reconciles the transactions whose matching collection is certain (score ≥ 90, no ambiguity). It never creates a collection and only processes collections already entered. If a statement is selected in the statement list, only that statement is processed. The same matching runs at each import.

If it finds nothing: “No certain match: use the suggestions line by line.”

What CAPPS refuses