3 May’17

Dynamics NAVImport a .csv file for Bank Reconciliation in Dynamics NAV 2017


This article gives a step by step process to import a .csv file in Dynamics NAV 2017 for Bank Reconciliation.


  1. Microsoft Dynamics NAV 2017
  2. Microsoft Excel


1. Browse to Data Exchange Definition page, and click on new to create a new data exchange setup. This setup enables us to import a specified bank statements file.

2. In the new ‘Data Exchange Definition’ enter the code and name.

  1. File type – Variable Text
  2. Type – Bank Statement Import
  3. Reading/Writing Xml Port – 1220
  4. Ext Data Handling Codeunit – 1240
  5. And in the Line definition enter the code, name and the column count

3.  Enter the column definition and associate appropriate data types. The columns are from the bank statement file which we need to map to Microsoft dynamics NAV. Go to Column definitions for Data Exchange Definition, and make sure Data Format has an uppercase M.

4.  Now click on the ‘Field Mapping’ button in the Line definition tab.

5.  The Data exchange Mapping window opens, click on new and enter the details

  • Table Id: 274
  • Mapping codeunit:1248
  • And give a Name to the Mapping.

In the Field Mapping tab, select the column number and map it with the appropriate field Id.

6.  Now in the search bar of the NAV Windows client, browse to Bank Export-Import setup and click on new and enter the details, fill the entries for code, name

  • Direction – Import
  • Processing Codeunit Id – 1270
  • In the Data Exchange Definition code, select the drop down to the Data exchange definition created and click on OK.

7.  Browse to ‘Bank account’ from the NAV Windows Client and select the bank where you want to import the bank statement. Click on Edit. In the Bank Statement Import format of the Transfer tab, select the bank import set up created.

8. Browse to the Bank account Reconciliation page and click on new, select the bank account where the Bank statement Import Format is assigned.

9. Click on the Import Bank Statement button under the Home tab.

10. Select the CSV file of the bank statement.

11. The Bank statement will be imported and you can view the changes in the Bank statement Lines tab.


Written by

Chris D'Silva

Software Developer

2 thoughts on “Import a .csv file for Bank Reconciliation in Dynamics NAV 2017”

  1. Hi Chris, your blog is excellent and was able to configure all the setups easily.the only issue which I am facing is that whenever I import the file, the transaction date changes to 01/entered month/ entered year.
    so i tried to import 3 lines as 03/12/2018,03/13/2018 and 03/14/2018(mm/dd/yyyy), but they all got imported as 01/12/2018,01/13/2018,01/14/2018.
    if you look at your screen shot closely the transaction date for all the lines are 01-01-2015 whereas they are different in all the lines in the file which you imported.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Managing mailbox through Email Archiving

    20 March’ 2018

    Introduction: Email can fill your Outlook Inbox quickly – new messages, replies, and forwards. Before you know it, yo...

    Read more
  • Workaround to Report.SAVEASPDF in NAV 2018

    20 March’ 2018

    Objective: In NAV 2017 Emailing the PDF by running the report using Report.SAVEASPDF is now not allowed in NAV 2018. Th...

    Read more
  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more