web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Setting up Bank Reconc...
Microsoft Dynamics NAV (Archived)

Setting up Bank Reconciliation in Nav 2017

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

We are in the processing of upgrading to Nav 2017 and one of the features that I'm excited to try is the Bank Reconciliation by uploading the bank file. I'm in the test mode right now and under the "Bank Import/Export Setup" it asks for a Code. Can someone tell me what code it's asking for? My Bank file is in either CSV or PDF. 

Can someone walk me through the process or lead me to a link that explains the set up? 

Much appreciated.

Thank you,

*This post is locked for comments

I have the same question (0)
  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Setting up Bank Reconciliation in Nav 2017

    [quote user="AnamB"]

    I've tried researching for format for HSBC bank but haven't been able to figure it out yet.

    [/quote]

    The technical support of HSBC can help you. Check also the information in your online bank account. I think there is somewhere a kind of documentation.

    [quote user="AnamB"]

    Is it true that a CSV file, regardless of the institution is in different format?

    [/quote]

    Yes - the only exception is SEPA CAMT.
    That's a industry wide standard which tries to define a format that can/should be used by all banks. HSBC has it's own format. Microsoft offers the Bank Data Conversion Service as an alternative. It's built-in, but it will costs a monthly fee.

  • Community Member Profile Picture
    Community Member on at
    RE: Setting up Bank Reconciliation in Nav 2017

    Hi,

    Thanks so much for that! I tried going through it but it seems that each bank has it's own format? I've tried researching for format for HSBC bank but haven't been able to figure it out yet. Is it true that a CSV file, regardless of the institution is in different format?

    Thank you again.

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Setting up Bank Reconciliation in Nav 2017

    Hi,

    You can start from here: msdn.microsoft.com/.../dn495313(v=nav.90).aspx

    In the "Bank Import/Export Setup" it is possible to create a setup of data imports. You can select the the codes in the Bank Account-Page. You also must set up the Data Exchane Definition of the bank file you want to import. Possible format is either CSV, XML, XLSX or JSON.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans