Last Updated: July 2026
Key Takeaways
The following covers what finance teams need to know about setting up Business Central bank feeds and automating the monthly reconciliation process:
- Business Central bank feeds connect your online bank account directly to the Payment Reconciliation Journal, pulling transactions in automatically every two hours
- The primary integration service is Envestnet Yodlee, available for Business Central Online for US and Canadian banks; CSV import is the fallback for unsupported banks or on-premises environments
- Business Central’s built-in matching rules compare imported transactions against open customer and vendor ledger entries and apply confident matches automatically
- Payment Application Rules let you fine-tune matching logic for recurring payment patterns specific to your vendors
- Teams using Business Central with Copilot enabled get an additional AI-assisted matching layer for transactions the standard rules don’t catch
- The Payment Reconciliation Journal and the Bank Acc. Reconciliation page serve different purposes and can be used together depending on the task
Your finance team is probably spending a chunk of month-end closing time on bank reconciliation. Here’s what I normally see – you download a statement from your bank’s portal, import it into the system, manually match transactions line by line, and track down anything that doesn’t line up. It works, but it’s slow, and it’s the kind of repetitive work that creates errors when someone’s tired and trying to close the books at 5pm on the last day of the month.
Microsoft Dynamics 365 Business Central has a direct answer to this. With Business Central bank feeds configured properly, bank transactions flow into your reconciliation journal automatically and with ease. The system matches most of them for you, and what used to consume hours of manual effort gets reduced to a few in a review-and-post process that takes a fraction of time.
Here’s how the setup works and what to expect at each stage.
What Is Business Central Bank Feeds and How Do They Work?
Business Central bank feeds create a direct connection between your online bank account and your Business Central environment. Instead of manually downloading and uploading a bank statement file each month, the feed pulls your bank transactions directly into the Payment Reconciliation Journal, where Business Central’s matching rules go to work automatically.
The primary service that powers this is Envestnet Yodlee, a bank feed integration built into Business Central. It’s worth knowing upfront: the Envestnet Yodlee service is available for the online version of Business Central and is currently supported for US and Canadian banks only.
Here’s the process: bank transactions come in, Business Central matches them against open ledger entries, and your team reviews and posts what remains.
How Do You Set Up Business Central Bank Feeds with Envestnet Yodlee?
Setting up the Yodlee bank feed service is a one-time process done at the bank account level. Use the search function in Business Central (Alt+Q) and search for Bank Accounts. Open the specific bank account you want to connect, then link your Business Central bank account to your corresponding online bank account through the Yodlee service.
Once the connection is established, you can enable automatic imports. Business Central will pull new bank statement transactions into your Payment Reconciliation Journal every two hours. Transactions that have already been posted or reconciled won’t be re-imported, so there’s no risk of double-posting.
If your bank isn’t supported by Yodlee, the workaround is straightforward. Business Central accepts bank statement files in comma-delimited or semicolon-delimited format (.CSV). You can define a custom import format using the assisted setup guide and attach it to a specific bank account, so your import process stays consistent every month.
For businesses dealing with a bank that exports in an unusual format, the AMC Banking 365 Fundamentals extension can convert statement files from almost any bank format into a stream that Business Central can import.
How Does Automatic Matching Work in the Business Central Payment Reconciliation Journal?
Once transactions are imported through a feed or file, the Payment Reconciliation Journal applies built-in matching rules to compare each bank transaction against open customer and vendor ledger entries. This is where Business Central does the heavy lifting.
The matching logic looks at payment text, amounts, and dates. When it finds a confident match, it applies it automatically. Your team’s job shifts from doing the matching to reviewing it, which is a significantly faster process.
You can also set up Payment Application Rules to fine-tune how matching works. These are prioritized rules that tell Business Central how to interpret specific patterns in payment descriptions. If a vendor always includes a specific reference number in wire transfers, you can create a rule that recognizes that pattern and routes it to the right ledger entry every time.
When your team is ready, they review the matched transactions, handle anything the system flagged as uncertain, and post the journal. At that point, Business Central automatically reconciles the bank account for all applied payments in one step.
What Happens to Business Central Bank Feed Transactions the System Can’t Match?
Not everything matches automatically, and that’s expected. Transactions Business Central can’t confidently match are left open for manual review. Your team looks at the unmatched lines, investigates if needed, and either applies them manually or uses the Map Text to Account function to route recurring unmatched items to the right G/L account going forward.
That mapping step is genuinely useful for things like bank fees, interest income, or recurring charges that don’t tie to a specific invoice. You set it up once, and Business Central handles those entries automatically in every future reconciliation.
For teams running Business Central with Copilot enabled, there’s an additional layer here. Copilot in Business Central applies AI to inspect transactions the standard automatch didn’t handle, looking for matches based on dates, amounts, and descriptions that the rule-based logic missed. It can also suggest G/L accounts for residual transactions that need to be posted but don’t tie to an open entry. Your team still reviews and approves everything before posting, but the manual workload shrinks further. We’ve covered how this fits into the broader picture in our post on Microsoft Copilot for Finance with Business Central.
What’s the Difference Between the Payment Reconciliation Journal and the Bank Account Reconciliation in Business Central?
Business Central has two reconciliation paths, and they serve different purposes. Knowing which one to use saves your team from working in the wrong tool.
The Payment Reconciliation Journal is designed for processing incoming and outgoing payments. It applies payments to open customer and vendor ledger entries and reconciles the bank account in one posting step. This is typically the right tool when you’re working with regular payment activity, and it’s where Business Central bank feeds flow by default.
The Bank Account Reconciliation page is a more traditional reconciliation worksheet. It’s better suited for verifying your ending balance against a bank statement, handling adjustments, and reconciling accounts where the primary goal is confirming the balance rather than processing payments. The two tools can coexist, and many finance teams use both depending on the task.
If you’re on Business Central and haven’t set up either path consistently, that’s usually the first thing worth getting right. It directly affects how cleanly your close process runs every month.
Frequently Asked Questions: Business Central Bank Feeds and Reconciliation
What banks are supported by Business Central bank feeds?
Business Central’s built-in bank feed service, Envestnet Yodlee, currently supports US and Canadian banks for the online version of Business Central. If your bank isn’t supported, or if you’re running Business Central on-premises, you can import bank statement files in CSV format using a custom import format attached to your bank account. The AMC Banking 365 Fundamentals extension is also available for banks that export in non-standard formats.
How often do Business Central bank feeds update?
When the Envestnet Yodlee service is enabled, Business Central pulls new bank statement transactions into the Payment Reconciliation Journal every two hours. Transactions that have already been posted or reconciled are not re-imported, which prevents duplicate entries.
Can Business Central automatically match all bank transactions?
Business Central’s matching rules handle a significant portion of transactions automatically by comparing payment text, amounts, and dates against open ledger entries. Transactions the system can’t confidently match are left for manual review. Payment Application Rules can be configured to improve match rates for recurring payment patterns. Teams using Business Central with Copilot get an additional AI-assisted layer for transactions the standard rules don’t catch.
Ready to Get Business Central Bank Feeds Working Properly?
The setup is not complicated, but the configuration decisions made early determine how much time you actually save. Which import method fits your bank, how your matching rules are structured, and how your team handles exceptions all factors into the result. Getting that foundation right from the start is worth the upfront investment.
If you’re running Microsoft Dynamics 365 Business Central and want to get bank feeds and automatic reconciliation working properly, contact CAL Business Solutions to talk through your setup.
CAL Business Solutions is a Microsoft Dynamics 365 Business Central implementation partner serving distribution, manufacturing, brick & block, and professional services businesses across the United States. Our team helps Business Central customers configure financial workflows, including bank integration and reconciliation, to reduce manual effort and close the books faster.
