Bank Account Reconciliation in NAV | Step-by-Step Setup & Transaction


Background

  • The bank reconciliation feature is used to check the bank ledger entries and the balance on the accounts against the statement from the bank.

  • You perform bank reconciliation to make sure that the balance in NAV (your books) and the actual balance as per Bank Statement are always matched.

  • Bank reconciliation is also a practical way to discover and resolve missing payments and bookkeeping errors.




Possible Discrepancies


Note:

For a Customer using NAV, Company's Book = Dynamics NAV (COA or General Ledger area).


Setup at a Glance
  1. Data Exchange Definition.

  2. Bank Export/Import Setup.

  3. Fields to be updated on Bank Account Card.

Setup in Detail

1) Data Exchange Definition


Step 1: Go to the Data Exchange Definition page following the below path:


Departments/Administration/Application Setup/General/ Data Exchange Definition page


Here, we need to specify a data exchange setup that enables us to import a specific bank statement file.




Step 2: Click on 'New'.


Step 3: The ‘Data Exchange Definition' page will open. Enter the following details In the General Tab.

  • Code= TEST BANK IMPORT (Any relevant Code of your choice)

  • Name= TEST BANK IMPORT (Any relevant Name of your choice)

  • File Type= Variable Text

  • Type= Bank Statement Import

  • Reading/Writing Xml Port= 1220

  • Ext Data Handling Code unit= 1240

  • File Encoding = WINDOWS

  • Column Separator = Comma


And the following details in the Posting Line Definitions Tab:

  1. Line Type: Detail.

  2. Code = Test (Any relevant Code of your choice)

  3. Name = TEST BANK IMPORT (Any relevant Name of your choice)

  4. Column Count= 7 (The Number of columns in the Bank Statment to be imported. For my e.g., it's 7.)


Add the following details in the Posting Column Definitions Tab for all columns from the .CSV bank statement file, which we need to map in Dynamics NAV.

  • Enter Name of Column, Data Type of Column, Data Format, Data Formatting Culture.


Step 4: Click on the Field Mapping button in the Line Definition FatsTab. Now the Field Mapping window will open. Click on NEW.



Enter the following details to map the Posting Exchange with the Bank Reconciliation Line Table, through which we will import the Bank Statement.


General FastTab:


Table= 274

Name = Test CSV for Bank Recon (Any relevant Name of your choice)

Mapping Code unit = 1248


Field Mapping FastTab:

  • In Column No. click on the drop-down, then select the first line. It will point to the Column Definition from the Data Exchange Definition page.

  • Then, go to the Field ID column, click the dropdown. Field lookup will open. Select the field, then click on 'OK'.


  • Follow the same Procedure for all Lines.

  • Now the Field Mapping FastTabwill look something like this:



2) Bank Import/Export Setup


Step 6: Now go to Bank Export-Import Setup.

Path: Departments/Administration/Application Setup/General/Task/Bank Export-Import Setup. Click on New.



Enter the following details:

  • Code = TEST BANK IMPORT

  • Name = Test for Bank Recon

  • Direction = Import