Business Central Bank Statement Converter: Import Bank Statements into Dynamics 365 Business Central as CSV

Last updated July 2026

What file formats does Business Central accept for bank statement import?

Business Central imports bank statements as CAMT.053 XML or as a comma or semicolon delimited file. CAMT works out of the box. A CSV or TXT needs a bank statement file format defined against the bank account first, which is really a data exchange definition telling Business Central which column holds the date, the description, and the amount. PDF is not on the list.

How do I import a bank statement into Business Central?

Open the bank account, choose Bank Account Reconciliation, and create a new reconciliation for the account and statement date. From the reconciliation page choose Import Bank Statement and pick your file. Business Central loads each row as a bank account reconciliation line, and you then match those lines against bank account ledger entries, either by hand, with the suggest lines action, or with Copilot proposing matches.

How do I set up a bank statement import format in Business Central?

On the Bank Account card, run the assisted setup called Set up a bank statement file format. It walks you through creating a data exchange definition: you tell it the file type and delimiter, number the columns in the order they appear in your file, then map each numbered column onto a field on the Bank Acc. Reconciliation Line table. Two settings catch people out. The header lines value has to account for a title row, and the Negative-Sign Identifier tells Business Central which marker means money out so it can flip those amounts negative.

Because the definition maps by column number rather than by header name, the value of a converted file is consistency. Every statement you convert comes out with the same columns in the same order, so the definition you build once keeps working next month and the month after.

Why a converted CSV beats a hand built one

A spreadsheet you assemble by copying pages out of a PDF will import happily even when it is missing three rows. Nothing errors. The problem shows up at the end of the reconciliation, when the statement ending balance you entered does not agree with the lines that loaded, and you spend an afternoon hunting a difference that was a page break. Converting straight from the PDF keeps every transaction and both balances.

The amount column is the other reliable trap. Statements that print withdrawals and deposits in two separate columns have to be collapsed into one signed value, and a manual paste usually leaves withdrawals positive, which inflates the bank balance and makes every subsequent match wrong.

Does Business Central have bank feeds for US banks?

Yes, through the Envestnet Yodlee Bank Feeds extension available in the North American versions. Coverage is broad but not universal, and more importantly a feed begins the day you connect it. It will not reach back to the start of your fiscal year, it will not cover an account you have already closed, and if the connection lapses for a month, that month has to be loaded from the statement. Those are exactly the cases a converted file handles.

Loading opening bank history during a Business Central go live

Most implementations go live partway through a year, so the bank account starts empty while the business has months of activity behind it. Convert each monthly PDF, concatenate them into one file, import once per bank account, then reconcile forward. The guide to reconciling multiple bank accounts covers doing this across several accounts at once, and transaction categorization cleans up descriptions before they hit the ledger. If you support clients on other platforms there are matching guides for the NetSuite bank statement converter, the Odoo bank statement converter, and the Xero bank statement converter. Running the enterprise product instead of the small and midsize one? Business Central and Finance and Operations are different products with different import mechanics, so use the Dynamics 365 Finance bank statement converter for that side of the family. Coming off QuickBooks? The QuickBooks bank statement converter handles the other side of that migration. Starting from a PDF? Use the bank statement converter.

The documents around the bank line

A reconciled bank account is only half the picture, because every payment line has a document behind it. Vendor invoices still have to be read and coded, which teams handling real volume do by automating accounts payable rather than typing them one at a time.