Importing bank payments

Menu Invoicing2 min read

Rather than entering each payment, import your bank's file: GestiClub recognises the paid invoices from their QR reference, reserved for Swiss accounts, or RF.

The "Import" menu
  1. Importin the toolbar.
  2. The formatsthey depend on the country of the bank account. For Switzerland: CAMT54 statement (the bank's XML file) and CSV statement.
  3. Import protocolsthe list of past imports.

Choose the format, then the file: the report opens.

The "Import a bank statement" window
  1. The countersthe number of lines per status.
  2. Invoice and Referencethe invoice recognised from the payment's reference.
  3. StatusPayment: the amount matches. Partial payment: less than the balance. Amount too high: more than the balance, or an invoice already paid. No match: no invoice recognised.
  4. Importrecords the payments.

Import records the Payments and the Partial payments; an invoice paid in part stays open. The Amount too high and No match lines create nothing: handle them by hand with Record payment.

A payment with no reference is recognised if it matches the amount of a single open invoice in the payer's name.

The "Import protocols" window
  1. Date, Type and Filethe import and the file's name.
  2. Lines and Collectedthe number of lines in the file, and those recorded as payments.
  3. Show report and Download filethe import's report, to print, and the original file.