Edit

The Payments and Reconciliations (DK) Extension

  • Article

Make fast, error-free payments by exporting files that are formatted specifically for exchanges with your vendor or bank. These files speed up the payment and reconciliation processes, and eliminate errors that can happen when you manually enter the information on a bank website.

This extension supports file formats for several Danish banks. When you export payment information to a file, the extension packages the data into the format that your bank requires. For example, the formats include Bankdata-V3, BEC, SDC, and FIK, which many different banks use, and some that are more specialized for certain banks, for example, Danske Bank and Nordea. The extension also includes some formats for importing and reconciling bank statements.

Note

To use the extension, you must know the format that your bank or vendor requires. Some banks or vendors provide this information on their websites; however, you might need to contact their customer service to get the information.

Supported Bank Formats

This extension can apply the following file formats for payment files:

  • BANKDATA-V3
  • BEC-INDLAND
  • BEC-CSV
  • DANSKEBANK-CMKV
  • DANSKEBANK-CMKXKSX
  • DANSKEBANK
  • FIK71
  • NORDEA-ERHVERV-CSV
  • NORDEA
  • NORDEA-UNITEL-V3
  • SDC
  • SDC-CSV

To set up the extension

There are a few steps to get started.

  • Allow payment data exports. To help protect your data, this is not readily available.
  • Set up purchase and payables so that you do not require external document numbers on invoices. If needed, you can use the reference number to refer to a specific invoice.
  • Specify the payment method for each vendor. Payment methods define how you pay invoices from the vendor. For example, Bank, Cash, Cheque, or Account.
  • Specify the type of format to use for each of your bank accounts. For example, NORDEA, DANSKEBANK, SDC, and so on.

Additionally, you must assign vendors to a domestic Gen. Bus. Posting Group and a Vendor Posting Group. The Country/Region setting for the vendor must be Denmark (DK). For more information, see Setting Up Posting Groups.

To allow Business Central to export payment data

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Payment Journal, and then choose the related link.
  2. On the Edit Payment Journal page, choose the Bank batch.
  3. Choose the Allow Payment Export check box.

To specify a payment method for a vendor

The following table shows the combinations of FIK and GIRO payment methods that Business Central supports.

Combination Type 01 Type 04 Type 71 Type 73
Giro Account No. or FIK Creditor No.? Giro Account No. Giro Account No. FIK Creditor No. FIK Creditor No.
Allows Message to Recipient? Yes No No Yes
Contains Payment Reference number? No Yes, 16 digits. Yes, 15 digits. No
  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Vendors, and then choose the related link.
  2. Open the card, expand the Payments tab, in the Payment Method field choose the payment method.
  3. Depending on your selection, you must complete other fields. See the table above for a description of the combinations.

To specify the format to use for a bank account

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Bank Accounts, and then choose the related link.
  2. Open the card for the bank account.
  3. In the Payment Export Format field, choose the format for your export file.

Choosing the FIK or Giro payment information for vendor invoices

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Purchase Invoices, and then choose the related link.

  2. Choose the vendor. Remember, this must be a Danish vendor with an address in Denmark.

  3. Create an invoice. The Payment Method and Vendor Number fields are filled in based on settings on the Vendor card. You can change them if you want.

  4. In the Payment Reference field, enter the 15-digit number from the vendor invoice.

    Tip

    You only have to add the last 11 digits of the number. Business Central will add four zeros to the beginning of the number.

  5. Post the invoice.

To use the extension to export payment data

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Payment Journals, and then choose the related link.

  2. Choose the Suggest Vendor Payment Journals action.

    Tip

    If you want to export only specific payments, use the options for filtering the data.

  3. If needed, you can add filters to export only specific payments.

  4. In the Bank Payment Type field, choose Electronic Payment.

  5. Choose the Export action.

See also

Customizing Business Central for Business Central Using Extensions
Collect Payments with SEPA Direct Debit
Work with General Journals

Find free e-learning modules for Business Central here