How to import a bank statement into Business Central (CSV format, setup wizard, PDF)
Business Central doesn't have one fixed bank statement format. A file import goes through a bank statement import format that you set up once per bank layout, and the lines land on a bank reconciliation or payment reconciliation journal for matching. This guide covers the ways bank data gets in, the CSV layout that works, the setup wizard screen by screen, what it detects in a sample CSV, the import and reconciliation steps, PDF statements, and the messages you're likely to see.
Short answer: first set up a format: search for Assisted Setup and open Set up a bank statement file import format (or choose Bank Statement File Format Wizard on the Bank Export/Import Setup page), upload one CSV from the bank, confirm the header lines, separator, columns, date format and decimal separator, test it, and attach it to the bank account. Then search for Bank Account Reconciliation, choose New, select the bank account, enter the statement date and ending balance, choose Import Bank Statement and pick the file. Microsoft's docs list comma- or semicolon-separated files for this; they don't list PDF, so convert a PDF statement to CSV first.
See a PDF statement turned into a CSV Business Central can import
Open Utilly's fictional September 2026 checking statement (account ending 0427, 31 transactions: 11 deposits totalling 29,597.43 and 20 withdrawals totalling 28,575.27). You see every line, the balance check from 12,418.36 to 13,440.52, and the CSV download, all free because the data is made up.
- The ways bank data gets into Business Central
- The bank statement import format: what the CSV needs
- Set up the format with the wizard
- What the wizard detects in a sample CSV
- Import the statement and reconcile
- Or import into the Payment Reconciliation Journal
- Check the import against the statement
- PDF statements
- Messages and problems
- Convert your own statement
1. The ways bank data gets into Business Central
From Microsoft's Reconcile bank accounts, Set up bank accounts and banking setup pages:
| Route | What it is | What to know |
|---|---|---|
| Bank statement file (CSV) | A comma- or semicolon-separated file, read through a bank statement import format you create with the Set up a bank statement file format assisted setup | Works for any bank that gives you a CSV, and for older months. One format per file layout |
| Envestnet Yodlee bank feed | Links the bank account to the online bank account; the Bank Statement Import Format is YODLEEBANKFEED | Microsoft: supported only in the online version, and only in the United States and Canada |
| SEPA CAMT | A data exchange definition with the code SEPA CAMT | Microsoft: "Business Central supports import of SEPA CAMT bank statement files out-of-the-box" |
| AMC Banking 365 Fundamentals | An extension that converts a bank statement file "from any format" to a data stream Business Central imports | A sign-up service; Microsoft recommends files under 1,000 lines |
| Suggest Lines / manual | Fills the statement pane from open entries in Business Central, or you type lines in | No file at all; you tick lines off against a paper or PDF statement |
Behind the scenes a file import is a chain: the data exchange definition describes the file and maps its columns to fields, the Bank Export/Import Setup links to that definition, and the bank account's Bank Statement Import Format field (on the Transfer FastTab of the Bank Account Card) points to the setup. The wizard in section 3 creates all three for you.
2. The bank statement import format: what the CSV needs
The wizard maps three columns, and Microsoft's source shows where each one goes on the bank reconciliation line:
| Column in your file | Field in Business Central | Rule |
|---|---|---|
| Date | Transaction Date | One date format for the whole file, written the .NET way with capital MM for month, e.g. yyyy-MM-dd or MM/dd/yyyy |
| Amount | Statement Amount | One column, money in positive and money out negative (a leading minus sign), with a dot or a comma as the decimal separator |
| Description | Transaction Text | The bank's text for the line. Automatic matching compares it with your ledger entries, so keep it |
Other columns, such as a running balance, can stay in the file; the wizard only maps these three. A file with separate Debit and Credit columns doesn't fit the wizard's single amount column, so combine them into one signed Amount first (in Excel, =Credit-Debit). If your bank marks money out with a code instead of a minus sign, the full Data Exchange Definitions page has a Negative-Sign Identifier for exactly that, but the wizard doesn't set it.
Utilly's CSV has that shape already: a header row, ISO dates, the bank's description, one signed amount and a running balance. These are the first lines of the CSV Utilly writes for the sample statement:
Date,Description,Amount,Balance
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18,5998.18
2026-09-01,STRIPE TRANSFER ST-K2M8Q4,3184.27,9182.45
2026-09-02,CHECK 2041,-1850.00,7332.45More about CSV layouts and why bank exports differ is in sample bank statement CSV.
3. Set up the format with the wizard
Open it from Assisted Setup (Set up a bank statement file import format), from the Bank Statement File Format Wizard action on Bank Export/Import Setup, or from the notification on a bank account card that has no format ("A Bank Statement Import Format is not specified for the bank account"). The window is called Bank Statement File Setup. Its steps, from Microsoft's source for the wizard:
- Welcome. There's a Download a sample bank statement file link if you want to see a layout the wizard understands. Choose Next.
- Upload. Choose Upload a bank statement file and pick one real file from the bank. The wizard then detects the format for you. You can also choose Define the bank statement file layout yourself and fill everything in by hand.
- Header Lines to Skip. The lines with the bank name and column names, highlighted in the File Preview.
- Column Seperator (Comma or Semicolon, spelled that way on screen), Column Count and Line Separator (CRLF, CR or LF).
- Date Column No., Amount Column No. and Description Column No.: the position of each column, counting from 1.
- Date Format and Decimal Separator (Dot or Comma). The tooltip notes that month must be capital M, for example dd/MM/yyyy.
- Try it out. Choose Test the bank statement file format. The preview shows the first 10 lines and colors problems red; the wizard's own advice is to check the decimal separator, because the wrong one gives wrong amounts.
- One last thing. Enter a Format Code (the wizard suggests the file name without .csv, up to 20 characters) and optionally the Bank Account to attach it to, then Finish.
If you skip the bank account in the last step, open the bank account card later and set Bank Statement Import Format to the code you chose. One format serves every month from the same bank layout.
4. What the wizard detects in a sample CSV
The wizard guesses from the uploaded file: the first line with separators is taken as the header, a column whose heading contains "date", "amount", or "description" (or "detail") is mapped to that field, and the date and decimal formats are read from the first data line. Following those rules in Microsoft's source, the sample CSV above comes out like this:
| Wizard field | Sample CSV | Why |
|---|---|---|
| Header Lines to Skip | 1 | The column-name row |
| Column Seperator / Column Count | Comma / 4 | Date, Description, Amount, Balance |
| Line Separator | CRLF | Utilly writes Windows line endings |
| Date / Amount / Description Column No. | 1 / 3 / 2 | Matched by the headings |
| Date Format | yyyy-MM-dd | 2026-09-01 is year first, so day and month can't swap |
| Decimal Separator | Dot | -6420.18 |
The Balance column isn't mapped and is ignored. Two cautions from the same source: the header guess means a file with no header row still gets 1 header line, so set it to 0 or your first transaction is skipped; and amount detection only allows for a leading minus sign, so amounts in parentheses won't be detected as amounts. When you test, the 10 preview lines should start with 2026-09-01, ACH DEBIT GUSTO PAYROLL 0912, -6420.18.
5. Import the statement and reconcile
From Microsoft's Reconcile bank accounts:
- Search for Bank Account Reconciliation and choose New.
- In Bank Account No., select the account. Its ledger entries appear in the Bank Account Ledger Entries pane.
- Enter the Statement Date and the Statement Ending Balance from the bank statement.
- Choose Import Bank Statement, locate the file and choose Open. The lines fill the Bank Statement Lines pane.
- Choose Match Automatically. Transaction Date Tolerance (Days) widens the date window; 0 matches on the posting date only. Matched lines turn bold green; entries matched on other reconciliations show in italic blue.
- Match the rest by selecting a statement line and one or more ledger entries, then Match Manually. Match Details shows why a line matched.
- For lines with no entry in Business Central, typically bank fees and interest (the sample's MONTHLY SERVICE FEE -15.00 and INTEREST PAYMENT 3.21), choose Transfer to General Journal, complete and post the journal lines, then match them.
- Run the Test Report, then Post.
You can post when the Total Balance of the statement lines equals Balance To Reconcile plus Balance Last Statement. Ledger entries dated after the statement date are filtered out, and many-to-one matches can't carry differences, even ones that net to zero. If the reconciliation feature is turned on, Reconcile with Copilot runs the automatic match first and then proposes more matches for you to keep or discard; from the Bank Account Reconciliations list it can take the statement file itself when the account isn't linked to a bank feed.
6. Or import into the Payment Reconciliation Journal
If the statement is mostly customer and vendor payments, Microsoft's Reconcile payments using automatic application describes the other route: search for Payment Reconciliation Journals, choose New Journal, pick the bank account, then Import Bank Transactions and select the file. The action's tooltip says the file name must end in .csv, .txt, asc, or .xml. Business Central applies each line to open customer or vendor entries and shows a Match Confidence of Low, Medium or High. Map Text to Account sends recurring lines like bank fees to a fixed account. When nothing is left to review, Post → Post Payments and Reconcile Bank Account posts the payments and reconciles the account in one go; Post Payments Only leaves the reconciliation for later.
7. Check the import against the statement
Before matching, compare what came in with the statement. For the sample:
| Check | Sample checking 0427, September 2026 | If it's off |
|---|---|---|
| Lines imported | 31 | 30: the header line count is one too many. 32: the header row came in as a line |
| Deposits | 11, totalling 29,597.43 | Deposits showing as negative means the amount signs are reversed |
| Withdrawals | 20, totalling 28,575.27 | Amounts 100 times too large or small: wrong decimal separator in the format |
| Net change | +1,022.16 | Must equal the statement's closing minus opening balance |
| Balance Last Statement → Statement Ending Balance | 12,418.36 → 13,440.52 | Dates in the wrong month: the Date Format has day and month swapped |
Balance Last Statement comes from the account's previous reconciliation and is zero on the first one. Microsoft's advice for a new bank account is to post its opening balance through a bank account reconciliation, never directly to the G/L account, or the account won't reconcile. When the difference won't go to zero, finding bank reconciliation discrepancies shows how to find the line, and the free bank statement balance checker confirms the statement itself adds up.
8. PDF statements
Microsoft's banking pages describe comma- or semicolon-separated files, bank feeds, SEPA CAMT and the AMC conversion service. They don't list PDF, OFX or QFX as a standard import format. PDFs are the usual situation for older months, a closed account, or statements a client emailed.
Convert the PDF to CSV first. Utilly's PDF to CSV converter reads the statement, checks that the opening balance plus every transaction equals the closing balance, and writes the four-column CSV shown in section 2. That file goes through the format you set up in section 3, so one format covers every converted month. Scanned PDFs of up to 10 pages are read with OCR. For a client who is months behind, catch-up bookkeeping from bank statements covers the order of work.
9. Messages and problems
The first three messages are quoted from the Base Application source; the rest are common causes.
| Message or symptom | What it means | What to do |
|---|---|---|
| "The bank account must have a value in Bank Statement Import Format. Do you want to open the bank account card?" | No format is attached and the account isn't linked to a feed | Run the wizard, or pick an existing format on the card |
| "No bank account exists that is ready for import of bank statement files." | No bank account has a format set or a feed linked (payments import) | Fill the Bank Statement Import Format field on the bank account card |
| "No bank transactions were imported." | Microsoft's examples: "the transactions were imported in other bank account reconciliations, or because they are already applied to bank account ledger entries" | Look on the Bank Account Statement List and Posted Payment Reconciliations; don't force the lines in twice |
| "The line separator in the uploaded file, … differs from your setup." | The test file's line endings differ from the format (wizard) | Go back and change the Line Separator |
| First transaction missing | Header Lines to Skip is too high | Edit the data exchange definition's Header Lines |
| Dates in the wrong month, or a date error | The Date Format doesn't match the file, or month was typed as lowercase mm | Use capital MM, e.g. MM/dd/yyyy for 09/01/2026 |
| Wrong amounts | Wrong Decimal Separator, or Debit and Credit in separate columns | Fix the separator; combine into one signed Amount |
| No Import Bank Statement option on a Bank Rec. Worksheet | Older North American versions had a worksheet that doesn't import files. Microsoft retired it in 2023 release wave 2 | Use Bank Acc. Reconciliation (Bank Recon. with Auto. Match turned on in General Ledger Setup) |
Posted the wrong reconciliation? Microsoft's page describes Undo on the Bank Account Statement List: the entries go back to an open reconciliation you can correct and post again.
10. Convert your own statement
Utilly reads a bank or credit card statement PDF, checks every transaction against the opening and closing balances, and writes a CSV with Date, Description, signed Amount and Balance, ready for the format above. PDF statements get a free preview. Files are read in memory and not stored.
Get your statement into Business Central
Pick what you're starting from.
Utilly isn't affiliated with Microsoft. Menu names change between versions and countries; the steps above are from Microsoft Learn's Business Central documentation and Microsoft's published Business Central source, checked November 10, 2026, and weren't run in a live Business Central company. Sources: Reconcile bank accounts, Reconcile bank accounts and apply payments, Reconcile payments using automatic application, Set up bank accounts, Set up data exchange definitions, Set up the Envestnet Yodlee Bank Feeds service, AMC Banking 365 Fundamentals, Reconcile bank accounts with Copilot, Reconciling bank accounts in the US version, Bank Statement File Wizard source, Bank Acc. Reconciliation source, Payment Reconciliation Journal source.
FAQ
How do I import a bank statement into Business Central?
Set up a bank statement import format once with the Set up a bank statement file import format assisted setup and attach it to the bank account. Then search for Bank Account Reconciliation, choose New, select the bank account, enter the statement date and ending balance, choose Import Bank Statement and pick the file. Match the lines and post.
What is the Business Central bank statement import format?
There isn't one fixed layout. You create a format for your bank's file: a comma- or semicolon-separated file with a date, one signed amount and a description column. The wizard saves it as a data exchange definition and a Bank Export/Import Setup, and the bank account's Bank Statement Import Format field points to it.
How do I set up the bank statement import wizard in Business Central?
Open Assisted Setup and choose Set up a bank statement file import format, or use the Bank Statement File Format Wizard action on Bank Export/Import Setup. Upload one file from the bank, confirm the header lines, column separator and count, the date, amount and description columns, the date format and decimal separator, test it, then name it and attach it to a bank account.
What date format does the Business Central bank statement import use?
Whatever your file uses, as long as the format says so. Dates are written the .NET way with capital MM for the month, such as yyyy-MM-dd, MM/dd/yyyy or dd/MM/yyyy. The wizard detects common patterns from the first data line; a year-first date like 2026-09-01 avoids day and month swaps.
Can Business Central import a PDF bank statement?
Microsoft's banking documentation doesn't list PDF, OFX or QFX as a standard import format. It describes comma- or semicolon-separated files, bank feeds through Envestnet Yodlee (online, US and Canada), SEPA CAMT and the AMC Banking 365 Fundamentals conversion service. Convert a PDF statement to CSV and import that.
Why does Business Central say no bank transactions were imported?
Business Central's message gives two examples: the transactions were already imported in other bank account reconciliations, or they're already applied to bank account ledger entries. Check the Bank Account Statement List and Posted Payment Reconciliations pages rather than importing the same lines again.
How do I import bank transactions into the Payment Reconciliation Journal?
Search for Payment Reconciliation Journals, choose New Journal, select the bank account, then choose Import Bank Transactions and select the file (.csv, .txt, asc or .xml). Business Central applies lines to open customer and vendor entries with a match confidence. Review, then Post Payments and Reconcile Bank Account.
Related guides
- Free sample bank statement CSV (fictional, with known totals)
- How to find a bank reconciliation discrepancy: 7 causes and a 15-minute method
- Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled
- camt.053 format explained: every XML element, with a real example
- How to import a bank statement into NetSuite (CSV template, OFX, BAI2 or PDF)
- How to import a bank statement into Odoo (CSV, OFX, QIF, CAMT.053 or PDF)
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.
