Skip to the article

Record a Customer Payment

Record from the module rather than from an invoice whenever the payment does not map onto exactly one invoice.

That is more often than you would think, and doing it this way keeps your bank reconciliation matching one line to one payment.

Record it

  1. Open the form

    Go to SalesCustomer PaymentsNew.

    The Create Customer Payment form. Payment Details holds Payment Amount, Bank Charges, Payment Number, Payment Date, Payment Method, Deposit To and Reference Number. An Apply to Invoices panel below reads: Select a customer to load their unpaid invoices.
  2. Pick the customer

    Their open invoices appear below, oldest first, ready to allocate against.

  3. Enter the amount and date

    The date is when the money arrived, which is what your reconciliation and a cash-basis VAT return use.

  4. Choose the deposit account and method

    Which bank or cash account it landed in, and how it was paid. Both appear on your reconciliation.

  5. Allocate across invoices

    Tick the invoices it pays. Allocate less than the full amount and the rest stays unapplied.

  6. Save

    Invoices that reach a zero balance move to Paid automatically.

Field reference

FieldRequiredWhat it does
CustomerYesSets the currency and lists the invoices available to allocate against.
AmountYesWhat arrived. Not what any invoice says.
Payment dateYesWhen money arrived. Used by reconciliation and by a cash-basis VAT return.
Deposit accountYesThe bank or cash account it landed in.
Payment methodNoTransfer, card, cash, cheque. Useful for filtering later.
ReferenceNoTheir transfer reference. The fastest way to match a bank line.
NotesNoInternal. Not shown to the customer.

Bank feeds and imports

If payments arrive as a bank statement rather than one at a time, import the statement and match lines to customers, then allocate. The import creates the payments; allocation is still yours to do, because only you know which invoice a round number was meant for.

  • A matched line becomes a payment with the bank reference already filled in.
  • An unmatched line stays unmatched rather than guessing. Guessing here is worse than doing nothing.
  • Imported payments can be left unapplied and allocated in a single pass later.

Was this document helpful?