web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Automatic Bank Stateme...
Small and medium business | Business Central, N...
Suggested Answer

Automatic Bank Statement Import Solutions

(3) ShareShare
ReportReport
Posted on by Durito 44
Hi there,
 
We are looking for an automatic bank statement import solution and are currently torn between using an extension or developing a PowerShell script to import the files. Has anyone had any success with one or the other or could recommend good third-party extensions to handle this task across multiple environments and companies?
 
Thank you!
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,554 Super User 2026 Season 1 on at
    hi there! 
    good morning, evening, or afternoon - depending on where you are :) 
     
    hope this helps some: 
     
    Criteria extensions / third party solutions PowerShell Scripts Yodlee
    ease of use user friendly, generally minimal technical knowledge needed higher technical expertiese required user friendly, automated data import, and support for multiple accounts & currencies
    support and updates provided by the vendor, regular updates requires in house maintenance and updates provided by yodlee, regular updates
    integration integrates with business central custom integration needed seamless integration with business central 
    cost may  involve subscription fees or one-time costs generally cost-effective, espeically with in house expertiese involves subscription fees / one time costs
    customization limited based on the extension high level of customization capability varies depending on solution but generally flexible
    dependency dependent on third party vendor in house / more control and management of the solution dependent upon Yodlee
     
    hope this helps some! 
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 27,054 Most Valuable Professional on at
  • Durito Profile Picture
    Durito 44 on at
    Thank you both, let's say this narrows this down to Yodlee (extension), Bankfeed (extension) and custom PowerShell script development. We don't want to import the statements manually. Is there a resource somewhere comparing the 3 options or do you have any input regarding the pros/cons?
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 22,551 Super User 2026 Season 1 on at
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,755 Super User 2026 Season 1 on at

    The pros and cons are as follows:

    Yodlee is much faster, but it has several issues. It often breaks, and you can find forum posts discussing how it regularly goes down. It's not the most reliable, sometimes it works for weeks or even a month, but then it stops suddenly. Another downside is that it doesn't support all banks, and for some banks, it can only pull transactions from the past 1-2 weeks instead of a full month, which can be problematic if you reconcile only once a month.

    On the other hand, importing using Excel/CSV files is slower but more reliable since it won't randomly break down. Personally, I suggest this option as its the most reliable. 

     

    Valentin Castravet
    Work: Zander ERP Services
    Blog: Dynamics 365 Business Central Insights
    LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

     

  • Durito Profile Picture
    Durito 44 on at
    Thank you Valentin, that's very helpful. Unfortunately there is a strong desire within the business to automate the import so I might look into PowerShell automation after all.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,497 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,778 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,507

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans