How doe we determine what format and structure to upload Bank Reconciliation?

(5) Share

Report

Posted on by joshtechsolutions

4,979

Hi Community,

In bank Reconciliation, there is this import bank statement, may I know how doe we determine what format and what structure do we set up our excel sheet or pdf such that BC/NAV can recognize/read and populate all the data in BC?

Thank you !

Categories:

Microsoft Dynamics NAV

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

Gerardo Rentería Ga... 25,367 Most Valuable Professional on at

Like (4)

Report

Hi, good day
I hope this can help you, and give you some hints.

The Easiest Way to Import Bank Statements into Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,485 Super User 2025 Season 2 on at

Like (4)

Report

Typically you will see what format your bank can provide, you would login to your bank and export a statement in either excel or csv to get the format.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,739 Super User 2025 Season 2 on at

Like (3)

Report

Yes, it depends on the format provided by the bank in your region. For example, in Japan, it used to be Txt format, but now it has become XML.

And hope the following helps as well.

Simplified bank statement file import (Bank Statement File Format Wizard)

https://yzhums.com/11072/

Add more custom processing when importing Bank Statement (Bank Export/Import Setup) – Customization

https://yzhums.com/44582/

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

For Import Bank Statements, you need to Configure the Data Exchange Definitions as per the Format of the Bank Statement File.

https://learn.microsoft.com/en-us/dynamics365/business-central/ubb/masterdata/dataexchangedefinitions

Was this reply helpful? Yes No
Verified answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

You need to setup the data exchange for the file the format you will be using

https://valentincastravet.com/create-a-bank-statement-import-format/

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-setup-bank-accounts

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,614 Super User 2025 Season 2 on at

Like (3)

Report

Hope this helps:

Was this reply helpful? Yes No