Import payments and verify matching to customer invoices

Objective. Import bank payments reliably, match them to the correct customers and invoices, resolve differences and preserve usable data for reminders, reporting and accounting exports.

Estimated duration55 min

What you will learn

  • Prepare a payment file with the required dates, amounts, references and payment methods.
  • Use identifiers and references to match payments to the correct customer and invoice.
  • Handle partial payments, grouped payments, differences and unmatched entries.

Recommended workflow

  1. Confirm the bank account, company, period, file format and whether the period has already been imported.
  2. Preview the import and review recognised, ambiguous and rejected rows before validation.
  3. Import the controlled file, then match each payment to one or more invoices.
  4. Reconcile imported totals with the bank source and review the remaining unmatched balance.

Checks before continuing

  • The number and total value of imported payments match the source file.
  • Duplicate detection covers previous imports as well as manual payment entries.
  • Unmatched or partially matched amounts remain visible until they are resolved.

Related training :