How to import customer payments

  • 14/12/2025
  • 10 minutes to read

When your customers pay an invoice with a FIK, GIK, KID, or OCR reference, the bank can provide a payment file with detailed information about these payments. The file can be imported into Continia Payment Management's cash receipt journal and then posted. You do not have to enter and apply every single payment in the cash receipt journal.

Note

In order to use the function for importing FIK, GIK, KID, or OCR payments in Payment Management, it is necessary that you enclose a payment slip or OCR reference when you send invoices, reminders, interest notes, or customer statements to your customers. Read more about how to set up FIK/GIK/KID and OCR with Payment Management in the section Setting up reports for printing FIK/GIK payment slips.

How to import customer payments

  1. Select the icon Søg efter side eller rapport or enter Ctrl-F3, enter Cash Receipt Journals, and select the related link.
  2. This opens the Cash Receipt Journals window.
  3. If you have not already created a cash receipt journal, do so now. The bank account on which your customer payment is posted must be stated as a balance account on the cash receipt journal that is to be used for importing customer payments and the balance account type must be Bank.
  4. Select the journal you want to use in the field Batch Name.
  5. Depending on which file format your bank delivers, select:
    1. PBS (DK), OCR (SE), TotalIn (SE), BG Max (SE), OCR Giro (NO): Select Import inpayments from file.
    2. CAMT-054C: Select Import CREMUL.
  6. Below you will find descriptions of the individual fields and functions in the window Import inpayments from file, and what consequences this has for the use of Payment Management. If you select Import CREMUL, the dialog box appears only for manual communication and only with the option of specifying the file name.
  7. Select OK to start the import.
  8. Once the payments have been imported and any adjustments have been made, the journal is ready for posting. Select the action Post or Post and print if you want to print the journal.
  9. Select OK to close the window.

Fields on the dialog box when importing payments from file

When you import payments from file, you will see a dialog box that needs to be filled out. The fields are described in the table below:

FieldDescription
File NameEnter the path and file name of the FIK or GIK file imported from the bank.
Journal DateSelect the date that the entry should use in the journal; it can be either the payment date or the posting date of the payment.
DescriptionIf necessary, insert a general description for the journal text. If no description is provided, the program will insert the customer's name.
Start Document No..Specify which document number the first line should start with. The remaining lines are automatically counted up by one document number per. line.
New Document No. Per.Choose whether you want to change the new document number each time a new Payment journal is created (i.e. keep the same document number for all lines), or whether you want to change the document number for each Line in the journal.
Direct CommunicationOnly used for customers using Danske Banks' old API.
Collection of Bal. Acc. per DayMarked if a total balance-entry is required on the bank account per. day, otherwise a bank entry will be created per. line.

Supported formats for importing payments from file

Payment Management supports the following file formats:

  • Det fælles indbetalingsformat PBS FIK (DK)
  • Indbetalingsservice OCR (SE)
  • TotalIn (SE)
  • OCR-Giro (NO)
  • BG Max (SE)

What happens during import of payments from file

  1. Depending on whether you have chosen to collect a balance account per. day, either a bank entry will be created per. line or a bank entry will be created per. day.
  2. The document number is filled in automatically with the next available number in the number series for the journal that belongs to the payment journal. The document number is the number that appears on the first payment journal line. The following journal lines are numbered consecutively. However, you can also fill in the field manually.
  3. All payments where Customer No. or Invoice No. found will be closed with an Applied ID when imported into the cash receipt journal. The only cases where Applied ID is not inserted are:
    • If the customer has an application method = manual, and it has been chosen in the dialog box these do not have to be closed.
    • If the customer has an application method = manual, and paid amount does not equal the invoice remaining amount.
    • If the invoice already has been closed.
  4. In the latter case, it may be necessary to set the applied ID manually.

How to import CREMUL

CREMUL files contain more data than the slightly older FIK payment files. In addition to the FIK payment, a CREMUL file also contains account transfers to the bank account, which can also be seen in the account statement. They will also be visible in the bank statement the next day.

When you import payments from a CREMUL file, you will see a dialog box that needs to be filled out. The fields are described in the table below.

FieldDescription
File NameEnter the path and file name of the CREMUL file imported from the bank.

If you use direct communication, the file is automatically downloaded from the bank, which is why the field is locked for entry.
Journal DateSelect the date that the entry should use in the journal; it can be either the payment date or the posting date of the payment.
DescriptionIf necessary, insert a general description for the journal text. If no description is provided, the program will insert the customer's name.
Start Document No..Specify which document number the first line should start with. The remaining lines are automatically counted up by one document number per. line.
New Document No. Per.Choose whether you want to change the new document number each time a new Payment journal is created (ie keep the same document number for all lines), or whether you want to change the document number for each Line in the journal.
Collection of Bal. Acc. per DayMarked if a total balance-entry is required on the bank account per. day, otherwise a bank entry will be created per. line.

Supported formats for importing CREMUL

Payment Management supports the following file formats:

  • CAMT-054C

    Note that the file must contain details of each payment (called specified or detailed when you order the file in the bank). Sump files are not supported as a simple sum does not indicate who paid what.

What happens during import of CREMUL

Importing CREMUL files is done in the same way as the FIK payment files. Since the CREMUL files contain the same data, it is advantageous to only use the CREMUL importing, if your bank offers this option.

  1. The document number is filled in automatically with the next available number in the number series for the journal that belongs to the payment journal. The document number is the number that appears on the first payment journal line. The following journal lines are numbered consecutively. However, you can also fill in the field manually.
  2. All payments where Customer No. or Invoice No. is found will be closed with an Applies To ID when imported into the cash receipt journal. The only cases where Applies To ID is not inserted are:
    • If the invoice already has been closed.
  3. In the latter case, it may be necessary to set the Applies To ID manually.