Missing transactions from a bank feed
Related information
Related topics
If you are experiencing transaction delays, or if your bank feed has stopped:
-
Check to see if you have a bank feed status of Auth required. You might need to reauthorize your account.
-
Use the Bank transaction assistant file import to import missing transactions into Sage Intacct.
Oftentimes, transactions are simply delayed and can take up to 5 business days to arrive into Intacct. This is dependent on many factors outside of Intacct's control, such as the number of connected accounts and volume of transactions.
About transaction delays
Transactions can appear in Sage Intacct as early as the business day after they post at the bank. In some cases, it can take up to 5 business days for transactions to appear in Intacct. Check at your bank to make sure that there are transactions available to download.
Transactions that post at the bank on Friday can appear in Intacct as early as Saturday. As weekends are usually non-business days for banks, no transactions post at the bank on Saturday or Sunday. That means that there are no bank feed transactions in Intacct on Monday. Monday's bank transactions appear as early as Tuesday.
What to do when transactions do not appear
If it's taking longer than usual for previous-day transactions to arrive in Intacct, do not disconnect from the bank feed. Transactions should arrive in Intacct within 5 business days. If transactions still do not appear, check the bank feed status. Or, you can reconcile by importing transactions using Bank transaction assistant file import.
-
Go to Cash Management > All or Setup > Accounts and select the required account type.
-
Find the account you want to check.
-
Select Edit at the end of the row.
-
On the Banking cloud tab, check the status of the bank feed.
-
Go to Cash Management > All or Setup > Accounts and select the required account type.
-
Find the account you want to check and select Edit.
-
On the Banking cloud tab, check the status of the bank feed.
How to fix the connection issues depends on the status:
| Status | Action |
|---|---|
|
Connected |
Log in to your online bank to make sure that there are new transactions available for download. You might need to Edit sign-in information to reestablish the connection to your bank. |
|
Pending |
If your connection has a Pending status, select Confirm on the Banking cloud tab. |
|
Auth required |
Reauthorize your account login credentials. If you need to log in using a different login name, disconnect from the bank feed and reconnect using the new user ID. |
|
Verifying auth |
Disconnect and reconnect the bank feed only if this status persists for longer than 3 days. |
|
Partial success |
|
|
Failed |
If you are missing bank feed transactions and need to reconcile, you can import transactions instead.
Use Bank transaction assistant file import to import transactions that are missing from a bank feed without overwriting your reconciliation progress.
If your bank feed starts working again, ignore any duplicate transactions.
You have bank feed data from January 1 through February 15. It's now April, and you want to reconcile through March 31 but are missing data from February 16 to the current day.
If you import data starting in January using the classic import experience, transactions unmatch for reconciliation and any reconciliation progress is lost.
Solution
Perform two bank reconciliations for January 31 and for February 15 with your bank feed data and then either:
-
Import transactions from February 16 to March 31 using Bank transaction assistant file import.
-
Manually clear remaining Intacct transactions.
Compare Intacct transactions to a physical bank statement and select Clear transactionson the account reconciliation page. Transactions are marked as Matched for reconciliation.
There are different levels of quality and availability for bank feeds. You might be using a standard bank connection. Sage Intacct cannot control the connectivity or efficacy of these connections. This can sometimes result in not receiving bank feed data. Standard connections also require more frequent reauthorizations.
Check out available and preferred standard connections or sign up with AccessPay for premium bank feeds.
Frequently asked questions
Ask your designated support user to contact Support if you have not received any new transactions after 5 business days.
It's possible that there's an issue with the bank or with a third-party aggregator. In these cases, Intacct has no control over whether transactions download into Intacct.
If it's taking longer than usual for transactions to arrive in Intacct, do not disconnect from the bank feed.
Instead, wait until you see a bank feed status of Partial success or Failed and refresh the feed. If you're still having trouble and not seeing transactions after 5 business days, ask your designated support user to call Support or log a support case.
Ask your designated support user to contact Support if you have not received any new transactions after 5 business days.
It's possible that there's an issue with the bank or with a third-party aggregator. In these cases, Intacct has no control over whether transactions download into Intacct.
You can set the banking cloud time zone and control when transactions are dated.
We will attempt to retrieve missing data for the previous 14 days. After that time we recommend that you add any missing data using the bank transaction assistant file import, or reconcile without the transactions.
Do not open a support case until data is missing for a minimum of 5 business days.
