Bank reconciliation format

(3) Share

Report

Posted on by Sneha Mani

340

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)

Sort by

Verified answer

Andrés Arias 5,192 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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,561 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
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 101,643 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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. 22,549 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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