Business Central Bank Integration: Bank Feeds and Bank File Formats

How to set up a bank account for import and export

1. 1Search for Bank Accounts, open the account card (or create one) and fill Bank Account No., IBAN or SWIFT code, Currency Code and the Bank Acc. Posting Group.
2. 2On the card, set Bank Statement Import Format to a format for your bank, such as a CAMT or MT940 style definition, or a custom CSV definition.
3. 3Set Payment Export Format (for example SEPA Credit Transfer) if you send payments by file, and fill the bank's clearing or creditor information as needed.
4. 4To use a bank feed, use the action to link to an online bank account on the Bank Account card or the Bank Account Reconciliation, and complete the sign-in with your bank through the feed service.
5. 5Open Payment Reconciliation Journals, choose Import Bank Transactions, select the file or refresh the feed, and run Auto Match.
6. 6Review unmatched lines, apply them to customer or vendor ledger entries or G/L accounts, and post the journal.
7. 7For a missing bank layout, create a Data Exchange Definition with column definitions and mappings, and assign it as the bank import format.

Data Exchange Definitions: the meaning of format

Common pitfalls

• !Importing the same statement twice; use statement numbers and date ranges to avoid duplicates.
• !Assuming a feed covers every bank; coverage and consent renewal vary.
• !Wrong decimal or date format in the Data Exchange Definition, giving shifted amounts or failed import.
• !Assigning the wrong Bank Acc. Posting Group, so postings hit the wrong G/L account.
• !Skipping the header line setting, so the first row is read as a transaction.