Bank reconciliation format

(3) Share

Report

Posted on by Sneha Mani

336

Dear members,

How to configure BC to create a sample bank reconciliation csv format? Can anyone share the step by step process and sample output format file to upload? Also what all format does BC standard support for bank reconciliation? Please help me with this!

Thanks in advance,

Sneha

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (4)

Verified answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

The following link may help you to set up a CSV file.

https://alexandrahorbatenko.blogspot.com/2021/12/how-to-import-bank-statement-file-for.html

The allowed formats are:

I hope I can help.

Best regards,

Andres

This was originally posted:

https://community.dynamics.com/blogs/post/?postid=31b8b290-8abf-45ac-ae00-ef5134bc317f

Was this reply helpful? Yes No
Verified answer

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

Like (2)

Report
Go to Bank Accounts (Search > Bank Accounts).

Create or select your bank account.

On the Bank Account Card, under Reconciliation FastTab, set the Bank Statement Import Format.

Configure Bank Statement Import Format (Data Exchange Definition)

Search for Data Exchange Definitions.

Create a new definition:

Code: e.g., CSV_RECON

Name: CSV Bank Reconciliation

File Type: Variable Text

File Encoding: MS-DOS or UTF-8 depending on your bank’s export

Field Separator: e.g., , (comma)

Header Lines: usually 1 if file has a header

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
Verified answer

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

Like (1)

Report

Hi, hope the following helps as well.

Dynamics 365 Business Central 2021 release wave 1 (BC18): Simplified bank statement file import (Bank Statement File Format Wizard)

https://yzhums.com/11072/

Dynamics 365 Business Central: 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

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

Like (1)

Report

Hope this helps as weell: https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately

https://learn.microsoft.com/en-us/training/modules/bank-reconciliation-dynamics-365-business-central/

Was this reply helpful? Yes No