Previous

Import CSV file transactions to Business Central

  • 3 min.

"I used to hold my breath every time I imported a statement file, hoping nothing landed wrong in the journal. Now I check the data in the CSV Header list first, and once I trust the port, the files flow straight in. No more guessing whether it worked.".

Ester, Accountant at Cronus

There are two ways of importing a statement CSV file to Business Central:

From the CSV Port page

  • The first time you import a CSV file using a new CSV port, it's recommended you first import to the CSV Header page. When you do, you essentially import the transaction file into a list from where you can verify if the imported data is correct before you import the data into a specific company’s payment reconciliation journal.

From the Payment Journal Reconciliation page

  • When you are confident that your CSV Port configuration works as intended you can import future transaction files directly into a payment reconciliation journal. This way, you skip the step of importing the statement file into the CSV Header list first - this happens automatically behind the scenes.

Scenario

Let's follow Lina as she configures a CSV port to import statement files from the third-party payment provider, PayPal. Here you can follow as she:

  • Analyzes the file.
  • Creates and configures the CSV Port.
  • Imports the PayPal statement file to check if everything is imported correctly.

Import transactions from a CSV port

To import the statement file, search for and open CSV Ports.

Select the CSV Port you want to use for your import, for example, Klarna, and then select Actions > Import to open the CSV Headers page.

Drag and drop the file directly into the CSV Headers page to import the list according to your configuration. This page provides an overview of:

  • All the files that have been imported into Business Central.
  • How many lines they include.
  • Whether the lines have already been imported to a specific company’s payment reconciliation journal.

Verify the CSV port configuration

In the CSV Headers page, select the header to open the Header Card. From there you can check the line details such as invoice numbers, posting dates, and other key settings to ensure that your separators and alternatives have been correctly applied and all data has been accurately converted.

For example, if a line was imported that you don't want to include in the payment reconciliation journal just yet, you can manually mark a specific line as already imported to a company. In this way, it won't be included when you import the header and lines to a payment reconciliation journal.

  • To do this, select the line, in the Details FactBox, select the Details drop-down menu and select Set as Imported. If the import did not go as expected, you can refine the configuration of the CSV port and import the file into Business Central again. However, before you do, you must first delete the CSV header from the list.

When the imported lines look good, you can go ahead and import the transactions to a payment reconciliation journal.

Import transactions from a payment reconciliation journal

To import CSV file transactions into the payment reconciliation journal, search for and open Payment Reconciliation Journals.

From the payment reconciliation journal on the action bar, select Import Bank Transactions.

This will open a file upload window that will allow you to select the correct file. You’ll see that the transactions are successfully imported into the payment reconciliation journal and you're ready to reconcile the imported CSV transaction lines.

More resources

Importing Transactions (Continia Docs)

The Payment Reconciliation Journal (Continia Learn unit)

Use Payment Service Providers (PSPs) (Continia Learn unit)