Skip to main content

Import Bank Payment Files

Provet supports importing bank payment files to automatically mark finalized invoices as paid. This reduces manual payment processing by matching incoming bank transactions to the correct invoices using reference numbers. Bank payment file imports can also be used to process insurance compensation payments.

The ability to view and upload bank payment files depends on your user permissions.

Note: The availability of this feature depends on whether your bank supports one of the file formats listed below. If you cannot see Bank payment processing in Provet, contact your Provet account manager or support@provet.com.

Supported file formats

Contact your bank to confirm which format they use for bank statement exports. Provet accepts the following file formats:

  • CAMT.053 and CAMT.054 (ISO 20022 XML format, widely used in Europe)

  • BGMax (used primarily in Sweden)

  • SEK and SEK2 (used primarily in Denmark)

How automatic invoice matching works

When you upload a bank payment file, Provet tries to match each payment to a finalized invoice using the reference number included in the payment.

  • If a match is found, the row is marked as Targeted.

  • If no match is found, the row is marked as Untargeted. You can assign the invoice manually — see step 5 below.

Note: Rows that are automatically matched to invoices with a due sum of 0 are ignored by default and will not be processed.

Reference numbers

Reference numbers are unique identifiers generated when an invoice is finalized. They are printed on the invoice alongside the bank account details. When a client includes the reference number in a payment, Provet can match the bank transaction to the correct invoice automatically.

Provet supports the following reference number formats:

  • Finnish reference number (viitenumero)

  • Norwegian reference number (KID)

  • Swedish reference number (OCR)

  • International Structured Creditor Reference (ISO 11649 / SEPA)

The reference number format used by your clinic is configured in Settings. To view or update the settings, go to Settings > General > Organization > Organization settings and select Create reference numbers for invoices.

Note: These settings are usually configured during implementation. Changes may affect workflows and compliance. Contact your system administrator before making any changes.

Import a bank payment file

To import a bank payment file and approve payments in Provet:

  1. Go to Reporting > Reports, select the Finances filter, and open Bank payment processing.

    Previously uploaded files are listed in the Recently uploaded files table at the bottom of the page. The table shows the file name, date, status, and the number of transactions processed. You can filter files by status, or manually change the status of a file by selecting the edit icon next to the status.

    • Unprocessed: the file has been uploaded but not yet reviewed.

    • Uncompleted: the file has been partially processed. This status also appears if the file contains payments that do not relate to any invoice in Provet. If you have finished processing the file, you can manually change the status to Completed using the edit icon.

    • Completed: all applicable payments have been processed.

  2. Select Choose File and select your bank payment file.

    • Make sure the file is in a supported format before uploading. See Supported file formats above. Some banks export payment files in a different format by default. If needed, open the file and save it in a supported format before uploading.

  3. Select Next. Provet uploads the file and displays the transaction list.

  4. Review the transaction list. Untargeted rows are highlighted in red. Each row shows one of the following statuses:

    • Targeted: a matching invoice was found.

    • Untargeted: no matching invoice was found. You must assign the invoice manually.

    You can also manually ignore or unignore individual rows. Only rows with the status Targeted are processed.

  5. For each Untargeted row, select the action button at the end of the row to open the Target invoice to payment dialog. The dialog shows the payment details and raw bank data. Search for the correct invoice using one of the following fields:

    • Invoice search : search by payer name or invoice number.

    • Customer number: search by customer number.

    • Insurance search: search by claim ID, case number, or claim reference.

    • Due sum: search by the outstanding amount on the invoice.

    • To be paid by customer: filter by the amount to be paid by the client.

    • To be paid by insurance company: filter by the amount to be paid by an insurance company.

    The search results show only finalized invoices.

  6. Select the correct invoice from the results to highlight it, then select Target selected. The row status changes to Targeted.

    Note: If a payment row does not relate to any invoice, leave it as Untargeted. You can close the dialog without targeting by selecting Close.

  7. If the file contains insurance compensation payments, make sure the correct payment type is selected for those rows.

  8. Select Accept to confirm the import. Provet marks the matched invoices as paid and displays a summary of the processed payments. The file status changes to Completed. If any payments could not be applied, check the Errors column for details.

    • If the file contains payments that do not relate to any invoice, the file status may remain Uncompleted. Once you have finished processing, you can manually change the file status to Completed using the edit icon.

Troubleshooting

Why is my file not being recognized?

If your bank provides a BGMax file as a .txt file, rename the file extension to .bgi before uploading. This allows Provet to recognize the file correctly.

Why is my file uploading slowly?

Remove any spaces from the filename and try uploading again.

Why are insurance payments showing as bank payments?

Payments from insurance companies may sometimes be categorized as Bank payments instead of Insurance claims. If this happens, select the correct payment type manually during the targeting step.

Why am I getting matching errors when uploading my file?

Combining different file formats, such as FI and CAMT, in a single file can cause matching errors. Use separate files or separate bank accounts for different payment formats.

Why is an insurance payment matched to the wrong invoice?

Provet may not always be able to determine automatically whether a payment should be applied as a client payment or an insurance payment. If this happens, select the correct invoice manually during the targeting step.

Why did an insurance payment fail to match automatically?

Some insurance integrations do not use a structured reference number. Provet searches for identifiers in the payment message text instead. If the message contains a typo or does not follow the expected format, the automatic match may fail. Select the correct invoice manually during the targeting step.

Did this answer your question?