Retrieve Universal transactions
How to import a CSV transaction file into the payment reconciliation journal in 365 business Banking and apply the transactions.
Applies to: Universal (CSV transaction file)
Retrieve transactions
In the payment reconciliation journal of the bank account, or in the list of payment reconciliation journals, choose Retrieve Bank Transactions and select the transaction file. Business Central reads it the way you described it in the Universal Banking Provider Setup. Transactions whose transaction ID is already in a payment reconciliation journal or a posted payment reconciliation are not created again.
Because a user must select the file, the import cannot be automated. The Retrieve Bank Transactions report in the job queue skips accounts with the Universal connection and retrieves the other bank accounts.
Check the setup first
Check a new or changed setup first with Validate Setup and Import Test File on the Universal Banking Provider Setup page. The Transaction Preview (First 50) shows how amounts, fees and references would be imported, without creating any data. See Set up Universal.
Apply
You apply the imported transactions in the payment reconciliation journal. See Apply bank transactions. In automatic matching, 365 business Banking treats an account with the Universal connection like the account of a payment service provider: the business partner's IBAN and name are not checked, and document numbers are not recognized as part of a longer text. Direct matching by transaction ID or payment reference is available instead.
Troubleshooting
| Message | Cause and remedy |
|---|---|
| "The Universal Banking Provider setup for this bank account is incomplete. Please complete the setup before retrieving transactions." | Settings are missing in the Universal Banking Provider Setup. Choose Validate Setup there and add the reported settings. See Set up Universal. |
| "A Universal Banking Provider file can only be imported by a user who selects it. Import it from the payment reconciliation journal, not in a background session such as the job queue." | The import ran in a background session in which no user can select a file. Run Retrieve Bank Transactions in the payment reconciliation journal. |
| "The file contains more than one transaction with the ID "…". Add a column that tells the rows apart to the Transaction ID Fields, or combine the rows into a single transaction by using the Group By Fields." | The Transaction ID Fields do not identify the rows of the file uniquely. Change Transaction ID Fields or Group By Fields as the message describes. |
| "Cannot convert "…" to date for field "…"." | The date in the file does not match the Date Format field or the Custom Date Regex field. See CSV settings. |
| "No new transactions found." | All transactions of the file already exist in a payment reconciliation journal or a posted payment reconciliation. |
If a file has several faulty rows, Business Central shows up to 100 messages at once and creates no transaction.