Reconcile receipts, invoices and accounting

Reconciliation follows the same real receipt through evidence, the payment record, allocations and invoice balances. It is not simply checking that a green status appears.

A practical daily checklist

1. Match actual receipt evidence to the payment's reference, date, method, customer, unit and amount.
2. Check no duplicate was recorded through both the order-specific Sales flow and generic Payments.
3. Check the receipt is Posted or in allocation progress before treating it as posted money.
4. Reconcile Amount = Allocated + Available for the receipt.
5. Inspect every allocation's actual Invoice ID and amount.
6. Open the invoices and reconcile current due with all their receipts and effective credits.
7. Review available money awaiting instructions and missing/failed actions.
8. Compare the appropriate Accounting entries/statement with the same scope, dates and currencies.

Example: two receipts settle one bill

Record	Amount	Allocated	Available
Receipt A	200.00	200.00 to invoice 501	0
Receipt B	127.60	127.60 to invoice 501	0
Recorded receipts combined	327.60	327.60	0

Invoice 501 totals 327.60 and is Paid with Due 0. Check two real receipt evidence references. If the bank evidence has only one 200 transfer, two records for that transfer are a duplicate, even if one is not yet allocated.

Example: settlement includes a credit

Source	Contribution to invoice settlement
Cash receipts allocated	200.00
Existing effective credit	27.60
Invoice Paid / credited	227.60
Original invoice total	327.60
Invoice Amount due	100.00

Cash received is 200, not 227.60. The credit is not another bank transfer. Invoicing currently supports reading existing credit notes but disables their browser write actions; follow its guide for interpretation.

Accounting effects

Posting records the receipt's posting event. Allocation updates the sales invoice and triggers receivable/journal integration for the allocated amount. Do not assume that merely saving a Draft, or posting unallocated money, has already produced the invoice-linked settlement journal you expect.

For an invoice-specific history, the Sales order's Invoice Payment page includes payment allocation and journal context when available. The generic Payment detail does not supply a journal link from its record ID; do not guess a journal URL using the payment or allocation ID.

Simple training journal illustration for an allocation of 200: bank/cash debit 200 and receivables credit 200. Actual account choices, currency differences and timing must follow your configured Accounting process; this guide is not a chart-of-accounts or tax policy.

Choose the right report/view

Question	Use
What receipts are recorded?	Payments register, scoped by receipt date/customer/unit
Which bills did one receipt settle?	Receipt allocation table
What remains on one bill?	Current invoice detail
How much customer debt is outstanding at a date?	Accounting AR aging/customer statement with correct scope/as-of
What were monthly sales?	Sales by customer report, not receipt totals
Did money clear the bank?	Actual banking evidence/reconciliation procedure

There is no dedicated Payments analytics/export or bank-statement import/matching control on the current register. Report exports elsewhere are different operations.

Common reasons totals differ

• Draft or Cancelled receipts included in a manual total.
• Posted receipts still unallocated, or money on account after overpayment.
• Different customer Partner/unit scope.
• Receipt dates versus invoice dates versus report as-of date.
• Effective credits included in invoice Paid / credited.
• Mixed transaction currencies summed without conversion.
• Different saved invoice/receipt rates or rounding.
• An uncertain write that actually succeeded, followed by duplicate manual entry.

Investigate the individual records before adding balancing receipts or manual stock/accounting entries. Record references and exact amounts for support.