Open Forum

We are on BC14 and working to upgrade to BC17 on premise

We are looking to find a solution to import bank transactinos from Wells Fargo, Bank of America and possibly one other bank.

What are tools and best practices others are using for bank transaction import and bank transaction mapping in business central?  What tools should we be evaluating?

Thanks in advance.

Benji,

Out-of-the-Box BC allows you to connect, for free, to Banks via YODLEE. This process is very simple and here are the steps:

1. Go to the Bank Account Card and open the Bank you want to Link to YODLEE

2. On the Bank Account Card, click Bank Statement Service then Link to Online Bank Account. 

3. YODLEE should find your Bank of you have 'named' the Bank correctly but if not you can search for it

4. After you click OK on your Bank selection you will be prompted to enter Log In credentials (something like below). Note that each Bank is different and could require Login ID, Password, and possible TOKEN No.

5. After you connect you will see a list of possible Bank Account Numbers to link too. Select the one you want to link to the Bank Account No. in BC and click OK

That is it. You can establish and Automatic Bank Import by going back to the Bank Account Card, for the Bank you just linked, and under Bank Account Service, click Automatic Bank Statement Import Setup (see step 1 image). On the screen you set the numbers of days the import will include (these are the number of days between imports so if you are doing weekly 7 would be the value). Check the Enabled box and click OK.

Your Bank is now Linked and Auto. Bank Statement Enabled.

Hope the above helps. If you have questions or want to chat more, feel free to email or call (774-254-1185).

Thanks and Happy Holidays,

Steve

We are on BC14 and working to upgrade to BC17 on premise

We are looking to find a solution to import bank transactinos from Wells Fargo, Bank of America and possibly one other bank.

What are tools and best practices others are using for bank transaction import and bank transaction mapping in business central?  What tools should we be evaluating?

Thanks in advance.

https://docs.microsoft.com/en-us/dynamics365/business-central/bank-how-setup-bank-statement-service

The Envestnet Yodlee Bank Feeds service is only supported in the online version of Business Central. To use this functionality on-premises, you must obtain a cobrand account from Envestnet, and you must add code to integrate with the Yodlee API.

Any ideas how hard this is ?

Benji,

Out-of-the-Box BC allows you to connect, for free, to Banks via YODLEE. This process is very simple and here are the steps:

1. Go to the Bank Account Card and open the Bank you want to Link to YODLEE

2. On the Bank Account Card, click Bank Statement Service then Link to Online Bank Account. 

3. YODLEE should find your Bank of you have 'named' the Bank correctly but if not you can search for it

4. After you click OK on your Bank selection you will be prompted to enter Log In credentials (something like below). Note that each Bank is different and could require Login ID, Password, and possible TOKEN No.

5. After you connect you will see a list of possible Bank Account Numbers to link too. Select the one you want to link to the Bank Account No. in BC and click OK

That is it. You can establish and Automatic Bank Import by going back to the Bank Account Card, for the Bank you just linked, and under Bank Account Service, click Automatic Bank Statement Import Setup (see step 1 image). On the screen you set the numbers of days the import will include (these are the number of days between imports so if you are doing weekly 7 would be the value). Check the Enabled box and click OK.

Your Bank is now Linked and Auto. Bank Statement Enabled.

Hope the above helps. If you have questions or want to chat more, feel free to email or call (774-254-1185).

Thanks and Happy Holidays,

Steve

We are on BC14 and working to upgrade to BC17 on premise

We are looking to find a solution to import bank transactinos from Wells Fargo, Bank of America and possibly one other bank.

What are tools and best practices others are using for bank transaction import and bank transaction mapping in business central?  What tools should we be evaluating?

Thanks in advance.

We are on BC14 and working to upgrade to BC17 on premise

We are looking to find a solution to import bank transactinos from Wells Fargo, Bank of America and possibly one other bank.

What are tools and best practices others are using for bank transaction import and bank transaction mapping in business central?  What tools should we be evaluating?

Thanks in advance.