Related topics
- About the Imported bank statement functionality
- Setting up the Imported bank statement functionality
This is the workbench for imported bank statements. If the Automatic transfer flag is set to NO in Work with Cash Management schemes/Bank accounts, you can analyse the imported payments before you manually transfer them to Work with open batches. To transfer them further you select the Transfer or Reload/Transfer option here.
If the number of saved days from creation date has not passed you can keep them here as a history log after the transfer to Work with open batches is completed.
Options
| Transfer | This option is only applicable if the imported bank statement has not been transferred. Select this option to transfer the selected imported bank statement in status 20 (Reloading completed) without reloading any data to be further processed in the Work with open batches routine. After the payments are transferred to Work with open batches, the Stop after loading parameter in Work with batch import options controls the processing further. |
| Delete | Select this option to delete the selected imported bank statement. If the bank statement has been transferred (status 30) you are able to delete the bank statement if the number of saved days, (defined on Work with Cash Management schemes/Bank accounts level), from the imported XML file’s creation date has passed. |
| Display | Select this option to view the details for the selected imported bank statement. |
| Reload | This option is only applicable if the status code for the selected imported bank statement is 10 (Import completed) or 20 (Reloading completed). If you have changed the setup of the Cash Management scheme to which the imported bank statement is connected, select this option to reload data (complement data) for the selected bank statement to get any effect of the new set up without transferring to Work with open batches. |
| Reload and transfer | This option is only applicable if the status code for the selected imported bank statement is 10 (Import completed) or 20 (Reloading completed). If you have changed the setup of the Cash Management scheme to which the imported bank statement is connected, select this option to reload data (complement data) for the selected bank statement to get any effect of the new set up, and transfer to Work with open batches. |
| A/R payments | This option is only applicable if the status code for the selected imported bank statement is 20 (Reloading completed) or 30 (Transfer completed). Select this option to access the Work with imported bank statements, A/R payments panel where you can view A/R payments for the selected imported bank statement. From there you can drill down to view the payment details, the text data and the reference (settlement) data for the selected payment. |
| A/R references | This option is only applicable if the status code for the selected imported bank statement is 20 (Reloading completed) or 30 (Transfer completed). Select this option to access the Work with imported bank statements, A/R references panel where you can view the A/R payments and related reference (settlement) data on the same panel for the selected imported bank statement. From there you can drill down further to view payment details, text data and found A/R document to settle. |
| Rejected transactions | This option is only applicable if the status code for the selected bank statement is 20 (Reloading completed) or 30 (Transfer completed). Select this option to access the Work with imported bank statements, Rejected transactions panel where you can view the rejected transactions for the selected imported bank statement. From there you can drill down to view the payment details. |
| Unlock | This option is only displayed if you have system administrator authority. Select this option to unlock the locked imported bank statement. |
| Lock | This option is only displayed if you have system administrator authority. Select this option to lock the selected imported bank statement. |
Function keys
| All bank statements | Display transactions for all imported bank statements in status 20 (Reloading completed) or 30 (Transfer completed). From here you can drill down to view the payment details, the imported bank statement transactions, the reference (settlement) data, the text data and the imported bank statement details. |
Selection fields
- Stmt
- This column displays the imported bank statement number.
- Bank account number
- This column displays the bank account number.
- Crt date
- This column displays the date that the bank created the file.
- Crt time
- This column displays the time that the bank created the file.
- St
- This column displays the status code of the imported bank statement.
Code Description 01 Import in progress 10 Import completed 20 Reloading completed 30 Transfer completed 90 Deletion in progress
- Scheme ID
- This column displays the Cash Management scheme ID to which the imported bank statement is connected.
- Msg Identification
- Only shown if this column has been activated through the Edit columns feature. This column displays the ISO 20022 Message identification assigned by the bank.
For field details for description, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the file name is displayed.
- Description
- Only shown if this column has been activated through the Edit columns feature. This column displays the ISO 20022 Message identification assigned by the bank.
For field details for description, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the Card Acceptor Details info/Acquirer Information.
- Status description
- Only shown if this column has been activated through the Edit columns feature. This column displays the description for the status code.
- E-connection seq no
- Only shown if this column has been activated through the Edit columns feature. This column displays the e-connection sequence number which is an internal number denoting the ID of the xml file for the bank statement.
- Bank account no description
- Only shown if this column has been activated through the Edit columns feature. This column displays the description of the bank account number.
- Bank account no curr
- Only shown if this column has been activated through the Edit columns feature. This column displays the currency for the bank account number.
- Bank statement ID
- Only shown if this column has been activated through the Edit columns feature. This column displays a unique identification to identify the bank account statement assigned by the bank.
- Electronic seq no
- Only shown if this column has been activated through the Edit columns feature. This column displays a unique electronic sequence number of the bank account statement assigned by the bank.
- Transferred by
- Only shown if this column has been activated through the Edit columns feature. This column displays the ID of the user who transferred the imported bank statement number to Work with open batches.
- Transferred date
- Only shown if this column has been activated through the Edit columns feature. This column displays the date when the user transferred the imported bank statement number to Work with open batches.
- Transferred time
- Only shown if this column has been activated through the Edit columns feature. This column displays the time when the user transferred the imported bank statement number to Work with open batches.
- Rejected transactions
- Only shown if this column has been activated through the Edit columns feature. This column displays the user’s language code for A/R, A/P and G/L. If a question mark is displayed it denotes that the bank transaction code is missing in Work with Cash Management schemes/bank accounts details.
Work with imported bank statements, Deletion (FSR42008)
Work with imported bank statements, Reload data (FSR42011)
If you have changed the setup of the Cash Management scheme to which the imported bank statement is connected, click OK to confirm the reloading of data.
Work with imported bank statements, Transfer or Reload and transfer (FSR42014)
The sub-title of this panel differs depending on the option selected to access this panel, i.e. Transfer or Reload and transfer. This panel displays the information for the selected imported bank statement.
- Imported bank stmt
- Displays the imported bank statement number and Message Identification.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the file name is displayed.
- Description
- Displays the description.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the Card Acceptor Details info/Acquirer Information is displayed.
- Creation date/time
- Displays the date and time that the bank created the file.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the date from the file name and time when the XML was imported to DC1 is displayed.
- ISO message ID
- Displays the ISO message identification.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
- E-connection seq no
- Displays the e-connection sequence number which is an internal number denoting the ID of the xml file for the bank statement.
- Bank account no/curr
- Displays the bank account number and currency.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement (Account) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (Account).
For the Netstore/Teller Settlement Report, the Card Acceptor Details info/Agreement Card Acceptor Num is displayed. Currency code is not applicable.
- Bank statement ID
- Displays a unique identification to identify the bank account statement assigned by the bank.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement (Identification) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (Identification).
- Electronic seq no
- Displays the unique electronic sequence number of the bank account statement assigned by the bank.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification.
For Netstore/Teller Settlement Report, the Payments info/Settlement number is displayed.
- Scheme ID
- Displays the Cash Management scheme ID to which the imported bank statement is connected.
- Actual printer data
- Set this field to YES to use actual printer data, defined below, when printing lists in Work with open batches lists. Set it to NO to use the printer data for the selected Batch import option when printing lists in Work with open batches lists.