RE: Bank Feeds integration “successfully” importing 0 transactions, skipping bank activity in one account

We integrate with Comerica’s web banking portal and successfully pull in transactions for several different accounts, but our account with the most activity has recently stopped importing and skips entire days. Occasionally it does import, and when it does the Bank Feed will not pull in all of the missed activity on the account. We do not receive an error message, rather the message we receive when it fails is “NetSuite has successfully imported 0 transactions from your bank statement file using login…” and the Banking Import History page shows a successful import for the day. Activity for this account is around 300 transactions per day.

Is there anything we can do to debug or fix the Bank Feeds SuiteApp to import the activity from this one account?

KyleW Rookie Asked on November 9, 2020 in Banking.
Add Comment
2 Answers

Hi Kyle

Were you ever able to resolve this issue?

We have the same issue with very little resolution on it.

Rookie Answered on February 4, 2022.

Hi Carlos,

We switched to Netsuite’s Automated Bank Statement Imports(ABSI), usingĀ  daily sFTP file drops for prior-day activity from the bank, and had the bank whitelist an IP address range for the Oracle datacenter that’s hosting us (Chicago/Central). The bank doesn’t report activity for non-operating accounts so we still had to make a bank feeds connection for some accounts in addition to the automated bank statement import. This has served us pretty well but took some doing: finally activated everything a year after the original post.

The issue seems like it might be a combination of bank-side data problems and the bank feed not looking back far enough? Resetting the bank feeds connection pulls further back than the usual 7-day daily request and in those cases we’d successfully get the activity from perhaps 30-15 days ago with strange posting vs. transaction dates in the raw response, and no activity for the previous or current weeks.

on February 4, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.