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.
Select NCP Payments > Import or on the starting page of Business Central: Tasks > Payments Import.
Click on the action Import.
Select the file you want to import.
The import is executed. If not all bank accounts have been detected automatically, click on Data and select the Bank Account manually.
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.
Click on the action Transfer.
Open the Journal to clear open entries or the Bank Account Reconciliation to match the data with your bank account.
You can then post the imported entries.
Import payment files
To import a payment file provided by the bank
Select NCP Payments > Import or on the starting page of Business Central: Tasks > Payments Import.
Click on the action Import.
Select file you want to import.
Tip
Files can also be imported over the NCPI Dropzone for Bank Files by Drag & Drop.
For more information, see Import Tasks, Import Payment File.
The import is executed. If not all bank accounts have been detected automatically, click on Data and select the Bank Account manually.
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.
Transfer Transactions
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 closeOpen 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.
//HELP: note dass beim rüberschieben der Zeilen Debitor/Kreditor automatisch anhand des Vorzeichens ermittelt wird
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.
