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

Bank Statement Import

(7) Share

Report

Posted on by AG-20111813-0

How can I automatically import and post bank transactions in Dynamics 365 Business Central by matching them to the correct G/L accounts and categories?
I’m looking for guidance on automating bank transaction posting in Microsoft Dynamics 365 Business Central.
Here’s what I want to achieve:

Import bank transactions directly from my bank feed or uploaded statement.
Have Business Central automatically detect or match each transaction to the correct G/L account (or posting category) based on rules, descriptions, or past behaviour.
Automatically post these transactions into the system without requiring manual reconciliation every time.

My questions:

Does Business Central support automatic G/L account assignment for bank transactions out-of-the-box?
Can the system “learn” or remember mappings (e.g., merchant name → G/L account) to reduce manual work?
Do I need to set up specific rules, transaction categories, or a third-party extension to achieve full automation?
Is it possible to auto-post these matched transactions, or does BC require manual review before posting?

I want to reduce 70%+ of bookkeeping effort by automating AP/AR-related bank entries.
Any suggestions, configuration steps, or extension recommendations would be greatly appreciated.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Sathish Kumar Palan... 388 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi

Kindly provide additional information regarding the error, along with the specific format of the import statement you are following.

Was this reply helpful? Yes No
AG-20111813-0 74 on at

Like (3)

Report
Copy link

Link copied!
How can I automatically import and post bank transactions in Dynamics 365 Business Central by matching them to the correct G/L accounts and categories?
I’m looking for guidance on automating bank transaction posting in Microsoft Dynamics 365 Business Central.
Here’s what I want to achieve:

Import bank transactions directly from my bank feed or uploaded statement.

Have Business Central automatically detect or match each transaction to the correct G/L account (or posting category) based on rules, descriptions, or past behaviour.

Automatically post these transactions into the system without requiring manual reconciliation every time.

My questions:

Does Business Central support automatic G/L account assignment for bank transactions out-of-the-box?

Can the system “learn” or remember mappings (e.g., merchant name → G/L account) to reduce manual work?

Do I need to set up specific rules, transaction categories, or a third-party extension to achieve full automation?

Is it possible to auto-post these matched transactions, or does BC require manual review before posting?

I want to reduce 70%+ of bookkeeping effort by automating AP/AR-related bank entries.
Any suggestions, configuration steps, or extension recommendations would be greatly appreciated.

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Moved Finance | Project Operations, Human Resources, AX, GP, SL forum to Small and medium business | Business Central, NAV, RMS forum.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

BC can import bank feeds, suggest matches, and remember rules, but it cannot fully auto-post everything out-of-the-box.

Automatic G/L matching: Partially (via Bank Transaction Rules + Auto-Match in Bank Reconciliation).

“Learning” past behaviour: Yes — BC remembers your mappings and can auto-apply them.

Full automation: No — BC still requires a manual review before posting.

Want 70% automation? You’ll need Bank Transaction Rules + possibly a third-party app (Continia, etc.) for true hands-free posting.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

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

Like (5)

Report
Copy link

Link copied!

The function you're looking for is the payment reconciliation journal. It will do a lot, but not all, of what you're looking for. More info here - Use the payment reconciliation journal in Dynamics 365 Business Central - Training | Microsoft Learn

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

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

BC also includes a Copilot function for this part of the matching; you can try it out.

Reconcile bank accounts with Copilot

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-reconciliation-with-copilot?wt.mc_id=DX-MVP-5004336&tabs=fromlist

Thanks.

ZHU

Was this reply helpful? Yes No
AG-20111813-0 74 on at

Like (1)

Report
Copy link

Link copied!
Hi Oussama,
Thanks for your help!
Let me clarify the full scenario:
We have a corporate structure with five companies, and within each company, we maintain:

Three Bank of Montreal accounts(Multiple bank accounts)

One credit card account

One AMEX credit card account

At the moment, we’re only able to link one bank account.
Do you know if it’s possible to link multiple bank accounts per company—especially for the Bank of Montreal and credit card feeds?
Looking forward to your input.

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report
Copy link

Link copied!

Yes, it's possible to link multiple bank account per company.

How did you link your one account? Did you use Yodlee? You can use Yodlee to link multiple accounts to import transactions, as long as Yodlee supports your bank, or you can import bank statements with the transactions from a csv file download from your bank. Either option supports more than one bank account.

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 (2)

Report
Copy link

Link copied!

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-apply-payments-auto-reconcile-bank-accounts

https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-how-reconcile-payments-auto-application

1 people found this reply helpful.

Was this reply helpful? Yes No