Contents
  Support|  Feedback|  Print Page


Working with Payments Import


2020/11/30
With this module you can import and process payment files provided by your bank. The following formats are supported:
  • camt.52
  • camt.53
  • camt.54
  • Custom

Data Structure

Each row in the window NCPI Payments Import can contain several Data entries, which in turn can contain several Transactions. The transactions, in turn, can contain several Remittance Infos. and Charges. Depending on the imported file format, different fields are filled or used. During the transfer, for each NCPI Payments Import Transaction a corresponding entry is created in the Journal or in the Bank Account Reconciliation. If the field Trans. Charges in the Payments Import Setup is set to Yes, a line is also created in the Journal or in the Bank Account Reconciliation for the total expenses per transaction. You can either transfer the entire imported file, or individual Payments Import Data, or just individual Payments Import Transactions.

Note

As long as a line has not been posted, it can be deleted at any time in the General Journal or in the Reconciliation. Click on Transfer if you wish to transfer the deleted line again.

Basic workflow

  1. Select NCP Payments > Import or on the starting page of Business Central: Tasks > Payments Import.
  2. Click on the action Import.
  3. Select which type of file you want to import (e.g. camt.053 statement).

    Tip

    You can import a file by drag and drop, drag the file to the button Choose...
    The import is executed. If not all bank accounts have been detected automatically, click on Data and select the Bank Account manually.
  4. As long as there is no journal/reconciliation line for an import entry, you can still delete the line. Click Import to re-import deleted data.
  5. Click on the action Transfer.
  6. Open the Journal to clear open entries or the Bank Account Reconciliation to match the data with your bank account.
  7. You can then post the imported entries.
  1. Import payment files

    To import a payment file provided by the bank
    1. Select NCP Payments > Import or on the starting page of Business Central: Tasks > Payments Import.
    2. Click on the action Import.
    3. Select which type of file you want to import (e.g. camt.053 statement). The import is executed. If not all bank accounts have been detected automatically, click on Data and select the Bank Account manually.
    4. As long as there is no journal/reconciliation line for an import entry, you can still delete the line. Click Import to re-import deleted data.
    For more information, see Import Tasks, Import Payment File.
  2. Transfer

    During the transfer, for each Payments Import Transaction a corresponding line is created in the Journal or in the Bank Account Reconciliation. If the field Trans. Charges in the Payments Import Setup is set to Yes, a line is also created in the Journal or in the Bank Account Reconciliation for the total of the Charges per transaction. You can either transfer the entire imported file, or individual Payments Import Data, or just individual Payments Import Transactions.

    Note

    As long as a line has not been posted, it can be deleted at any time in the General Journal or in the Reconciliation. Click on Transfer if you wish to transfer the deleted line again.
    • Journal

      In the Journals you can apply and close Open Entries on the basis of the imported data. Once the data has been transferred, click on Navigieren > Electronic Payments > Payments Import > Import Suggest Application - All Lines in the General Journal to create an automatic application suggestion. The suggestion attempts to determine the Account No. and the corresponding open entries, based on various criteria. The suggestion only considers lines for which no application has been defined. For lines that contain a value in the field Account No., this value is used as a filter for the entry search. The field Import Source Code on the journal lines views if the line has been created from a transaction, from expenses, or indirectly through a bank account reconciliation line. Click on Import Deviation - Set Filter to view only the entries that have not yet been completely cleared. Import Deviation - Remove Filter removes the filter. For more information, see Import Tasks, Applying Open Entries.
    • Bank Account Reconciliation

      Bank account reconciliation enables customers to reconcile their Business Central bank account with the imported statement files. After the data has been transferred, the imported statement lines are displayed in the left part of the window. The right pane views the bank account entries. Click on Automatic Match to perform an automatic matching of the two sides. If there are statement lines that cannot be fully reconciled with the Bank Account Ledger Entries (automatically or manually), the reason may be that the corresponding payments have not yet been posted. Use the action Transfer to General Journal to transfer the unreconciled amount, viewed in the Difference field, to an journal for posting. The field Import Source Code in the bank statement lines views that the line was created from a transaction or from charges. For more information, see Import Tasks, Bank Account Reconciliation.
Contents
Next Topic: Import Payment File
  Support|  Feedback|  Print Page
DE|EN Imprint