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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Envestnet Yodlee Bank Feed

(0) ShareShare
ReportReport
Posted on by 20

Hey Guys,

I used the Envestnet Yodlee Bank Feed service to link my bank account and setup the auto bank statement import. But I cannot see any bank statement imported after several days. do you have same problem previously and Can anyone help me about it?

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Yang,

    To enable automatic import of Bank Statements, follow these steps:

    1. Go to Bank Accounts List

    2. Highlight the Bank you are talking about and then choose Automatic Bank Statement Import Setup action

    3. On the Automatic Bank Statement Import setup page, in the Number of Days Included field, specify how far back in time to get new bank transactions for. It is recommended and I setup the value here for 7 days.

    4. Select the Enabled check box.

    Now every hour the Payment Reconciliation Journal will display new payments that are made on the online bank account. Note that any transactions for payment that have already been posted as applied and/or reconciled on the Payment Reconciliation Journal will not be imported.

    Hope this helps.

    Thanks,

    Steve

  • Yang Gao Profile Picture
    20 on at

    Hey Steve,

    Thanks for your answer. I did the step you mentioned. but there was no any transactions was imported on the payment reconciliation Journal. I setup the Number of Days Included is 90 days. Is it too long?

  • Verified answer
    Community Member Profile Picture
    on at

    Yang,

    That is way too long since if you run this hourly one would not require 90 days to pull. I would change this to 7 days and try again. You can always manually Import off the Payment Reconciliation Journal. Lastly, Manually printout the Bank Statement, from your Bank, for the 7 day window, and see what could be imported.

    Thanks,

    Steve

  • Yang Gao Profile Picture
    20 on at

    ok thank you Steven, if I want to import the transactions 2 months ago how I can do that, I didn't find any button to let me import manually on the page

  • Suggested answer
    Community Member Profile Picture
    on at

    Yang,

    Consider doing this in small chunks. As you have the downloaded transaction files from the Bank, you go to the Payment Reconciliation Journal, click Actions/Process/Import Bank Transactions.

    pastedimage1616606072498v1.png

    You are then prompted to select the Bank and click OK, The you locate the file to import. 

    pastedimage1616606132227v2.png

    The transactions are imported for processing.

    Hope this helps.

    Thanks,

    Steve

  • Yang Gao Profile Picture
    20 on at

    Hey Steve,

    Thanks for your reply. but on my end, i don't have the option to import the file. After I click the "import bank transactions" option, the new window pop out to let me select the period and not give me the option to import the file from my end.

    6685.Capture12.JPG

    Capture213.JPG

  • Suggested answer
    Community Member Profile Picture
    on at

    Yang,

    Here is one I just setup in my test company matching your setup. I connected to my Bank via Yodlee.

    pastedimage1616611647440v1.png

    Next I click OK and the prompt appears for the Bank Statement Date filter range:

    pastedimage1616611699798v2.png

    It calls to the Bank to pull the Date Range:

    pastedimage1616611735144v3.png

    Lines are brought in and noted:

    pastedimage1616611766313v4.png

    pastedimage1616611796633v5.png

    Now I can begin reconciliation and posting of these records that have not been posted in BC yet.

    On the Bank Account you have Linked the Account to the Bank and it is shown Linked, yes? Double-check. Also, if you logged into the Bank via their website can you pull a Statement for the Date Range and their is data downloaded. This is ow I test to make sure there is data to pull via Yodlee.

    pastedimage1616611997234v6.png

    Hope this helps. 

    Thanks,

    Steve

  • Yang Gao Profile Picture
    20 on at

    Steve,

    I'm sure I'm linked and setup the auto import, 

    Capture3211.JPG

    but when I go to payment recon journals page, click the import bank transactions

    Capture655.JPG

    select the date,

    Capture313.JPG

    it keep showing "no bank transactions were imported"

    pastedimage1616684645105v1.png

  • Suggested answer
    Community Member Profile Picture
    on at

    Yang,

    Can you go to the Bank Website and perform a download of the Bank Statement from there with the same date range? I have seen this before and sometimes there are no posted transactions to download. You can always widen the Date Filter to be 03/01/21 thru 03/25/21 to see if any Bank transactions import.

    Thanks,

    Steve

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans