Small and medium business | Business Central, N...

Bank reconciliation in CSV import file BC takes first line only why

(5) Share

Report

Posted on by Raja

156

Dear Members,

In Business Central i need a requirement to import bank statement in CSV file format i configure the setup too and its working but while i import the file BC takes the first line of the file only but in the file its more than 30. Please guide me in that issue. I attach that CSV file too for your reference.

Thanks in advance,
Raja.

Bank_Statement_05...

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Please verify the steps:The Easiest Way to Import Bank Statements into Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Check if any third party extension is there.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Please go through this too: https://www.youtube.com/watch?v=S674nAVWWsE

https://www.youtube.com/watch?v=ygzx0mN5800

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
Hi ,

Your issue (only first line imported) is might be caused by

Wrong Row Separator (set to <LF> for your file.

Missing increment logic for Line No. in mapping.

sharing few official links which might help;-

Define how data is exchanged electronically - Business Central | Microsoft Learn

Data exchange definitions - Business Central | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

Your CSV only imports one line because the Data Exchange Definition isn’t set correctly.

Fix:

Check separators (comma/semicolon).

Enable “Header Line Exists” if your file has headers.

Ensure the line definition maps all rows (not just the first).

Re-import after correcting it.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

This issue might occurs due to incorrect CSV formatting or delimiter mismatch. Ensure:

> The CSV file uses the correct delimiter as defined in the Bank Statement Import Format setup.
> The first line is not treated as header unless specified.
> The import format mapping includes all required columns.
> The file encoding is UTF-8 without BOM.

If the setup is correct and the issue persists, test with a simplified CSV and verify the format line mappings

Thanks

Rishabh

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,152 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps as well - The Easiest Way to Import Bank Statements into Dynamics 365 Business Central - Dynamics 365 Business Central Insights

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

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You're importing a bank statement in CSV format into Business Central, and although you've configured the setup correctly and the import process starts, only the first line of the file is being processed despite the file containing over 30 lines.

This issue is likely due to incorrect configuration in the Data Exchange Definition—such as improper line definitions, missing record delimiters, or incorrect field mappings—causing Business Central to treat the entire file as a single record or ignore subsequent lines.

Please upload the CSV file so I can analyze its structure and guide you on correcting the setup to ensure all lines are imported properly.

Was this reply helpful? Yes No