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.
For a Customer using NAV, Company's Book = Dynamics NAV (COA or General Ledger area).
Setup at a Glance
Data Exchange Definition.
Bank Export/Import Setup.
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:
Line Type: Detail.
Code = Test (Any relevant Code of your choice)
Name = TEST BANK IMPORT (Any relevant Name of your choice)
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.
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