Question

If I cannot connect to update my transaction from OCBC to to qbo. something to do with the ocbc app connection, anyone have the same problem?

Forum|Forum|6 years ago
December 27, 2019
8 replies
20 views

No text available

QuickBooks Online

JoesemM

QuickBooks Team

Hello there, @nithipong-subane.

I'm here to share insights about the update of your transaction from OCBC to QuickBooks Online.

Manual updates in QuickBooks Online(QBO) will download any new transaction listed within the previous 90 days and the most current information when you connect to your account.

Let me guide you on how to manually update your account:

From the left menu, select Banking, then Banking.
On the upper right, select Update.
If prompted, enter your Multi-Factor Authentication (MFA) credentials and select Continue update.
Enter these credentials within 2 minutes of being prompted.

You'll be notified when the update is complete. If it's successful, the date and the total number of transactions will be shown on the account card change.

For more information, you can check this article: How to manually update an account to fix banking errors.

I've also provided these articles for future reference:

You can tag my name if you have further questions. I'll be happy to help. Have a good one.

J

jasontgw

Yes, I am also facing the same issue. Somehow the OCBC app's notification does not appear at the right time to prompt us for verification.

I will attempt to press 'Done' then 'Connect' on QBO (without any notification from app). THEN the notification appears on app, but pressing it will say the notification has expired.

MichelleBh

Level 8

We're receiving reports that other users are getting this error as well, asontgw

Our records show that we have an open investigation about the notification code that has expired. Our Engineering Team is still working with OCBC Bank to get a permanent fix for this unusual behavior.

While they are at it, let's perform the following workaround.

First, let's log in and access your account in a new incognito or private browser because it won't save cookies that will help load faster and seeing the latest info.

Here are the shortcut keys:

Google Chrome: press CTRL + Shift + N

Mozilla Firefox: press CTRL + Shift + P

Internet Explorer: press CTRL + Shift + P

Safari: press Command + Shift + N

Second, if you can successfully connect your bank, go back to your regular browser and clear the cache. Deleting your cache and history may clear up some room on your computer or mobile device. Switch to a different browser like Firefox, Internet Explorer, Google Chrome, or Safari is good alternative too.

However, if the issue persists, you can manually update your bank. You can follow the steps provided by my colleague @JoesemM above.

For additional insight in updating bank, you can check this article: How to manually update bank accounts.

And also, I would advise you to reach out to our QuickBooks Online Support.

This way our engineers can add your account information to the list of affected users and attach your case to the INV-36471. Any progress will be communicated via email.

To reach us, here's how:

Click (?) Help at the upper right corner, then select Contact US on the pop-up.
Enter a brief description of your concern, then hit Continue.
Click Get a callback, then enter your contact information.
Select Call me.

You can also go to this article: http://status.quickbooks.intuit.com/. You can sign up with that website so that you'll be up to date if there are ongoing issues and the statuses of any investigation. Simply click the Intuit Developer Group then click the Subscribes to Update button.

Let me know if you have additional concerns. I'm glad to help. Have a great day ahead.

M

mark1231

Sadly, none of the proposed solutions seem to work: private browser session, clear cache, edit bank login details to reset. It seems that when OCBC implemented their new mobile "One Token" tool, obviating the need for the password generation fob, it broke the connection with QBO. Right now the only option is to download transactions from OCBC and upload them to QBO - a clunky and annoying step.

This has been going on for weeks now. Please can you (Intuit) prioritize a fix or offer a refund for our service for the month of January. Thanks.

K

ksim1

Hi,

Is there any update to this issue? We are basically facing months of backlog of transaction to reconcile. Please give us an update please.

Jen_D

Level 8

Thanks for requesting an update about this banking issue, @ksim1,

Our Financial Data Team is still working to identify what's causing the issue with OCBC Bank account.

In the meantime, you can upload the transactions manually to ensure the account is up-to-date. Download the data from your bank then map the transactions in the following supported formats or file types:

Comma-Separated Values (CSV). CSV files may require additional mapping. Please see this article to know more about the steps: How to import bank transactions using Excel CSV files?
Quicken (QFX)
QuickBooks Online (QBO)
Microsoft Money (OFX)

Once the bank file is ready, start importing the file to your QuickBooks Online company. Follow these steps:

Click Banking from the left navigation panel.
Pick File Upload from the Update drop-down menu or Upload transactions manually if there isn’t any bank connected to QBO.
Select Browse and choose the file you downloaded.
Choose an account from the list, then Next.
Follow the on-screen instructions to map the fields.
Select the transactions to import.
Click Yes.
Hit Let’s go.

For the information and steps on importing these files, see this article: Manually upload transactions into QuickBooks Online.

Please note that the Bank Feed will download these transactions once the connection resumes to its normal order. To avoid duplicates, exclude them to keep your accounts accurate.

Here's how:

Go to the For Review tab.
Check the box next to each transaction you want to exclude.
Select the Batch action drop-down menu, and then select Exclude selected.

Excluded transactions are moved to the Excluded tab, and won’t be added to QuickBooks or downloaded again.

If you haven't contacted us to receive live updates about this issue, I recommend getting in touch with our Support Team. They can add your account and email to the notification list of affected users. Provide the investigation number INV-36471.

Here's how to contact Support:

Click the (?) Help icon in the upper right-hand corner of the Dashboard.
From there, select the Contact Us button and enter your concern in the description box.
Once done, select Chat or Email us option.

I'll be waiting for an update from you about this topic or if you have other questions about QuickBooks Banking. Click the Reply button below to notify me. I'll be more than happy to share additional insights and help at any time. Have a wonderful day!

J

jasontgw

Hi all,

I have managed to pull the bank statement feeds into my QBO. What needs to happen is the following:

a) Press 'Update' like you normally would;

b) Click into 'Complete secure connection' in your QBO;

c) When prompted by your OCBC Business mobile app, press in to validate via your OneToken;

d) Click on 'Done' and click on 'Connect' in your QBO;

You would expect things to work from here, but I have come to realise your QBO will prompt you to enter a 6-digit One Time Password to fix the connection.

e) Return to your OCBC Business mobile app, do not login;

f) Go to top right arrow on screen;

g) Click on OneToken;

h) Generate OTP for account login;

i) Use the 6-digit generated OTP in QBO.

At least for me (at time of writing), QBO will show me a successful connection after doing the above steps. For most of you, you would not be able to pull the bank statement feeds from Dec 2019 as there is a limit to how far back you can pull. I had to manual upload the transactions for those which did not get sync-ed into my QBO.

Hope this has been helpful.

M

mark1231

You are a worker of miracles! Thank you so much for figuring this out. It does indeed work.

It is clunky, but works as promised.

Thanks again.

P

paradrop

I've been having this problem as well. When trying to connect to OCBC Business Velocity, it always asks for OTP after I've authorise the Onetoken through the notification.

I've found a solution tho!

At the top right corner of the OCBC Business Velocity App, there is an arrow.
In there, there is a option named "OneToken". Click that and a "Generate OTP" page will appear.
Click the "For Account Login" and a 6 digit OTP will appear. Input that 6 digit when QBO prompts you to input your 6 digit OTP.

All done! Hope it works for yall :)

P

proj1

Hi Paradrop :) !! Does it pull out bank transactions with only one time authentication or it still require multiple times reauthentication with OCBC mobile app?

S

SGRuth

How do you manually update the bank statement in CSV file? Do you have to change some of the header inside the file or just do a direct download from bank and proceed to direct upload to QBO?

C

coachrafiansari

Same here..I'm getting really frustrated. After using my fingerprint recognition, they keep prompting again to key in the OTP which I did not get any.

C

ConorIB

Hi i can connect my OCBC account but it only downloads 90 days of transactions.

do you know if the bank allows download for say 12 months of past transactions?

A

AileneA

Moderator

Hello, ConorIB.

Thanks for dropping by in Community. In QuickBooks, the system only downloads up to the last 90 days of transactions, you can manually import data beyond the time limit. Download the bank statement from your bank using the following supported formats or file types:

Comma-Separated Values (CSV)
Quicken (QFX)
QuickBooks Online (QBO)
Microsoft Money (OFX)

Once the bank file is ready, start importing the file to your QuickBooks Online company. You can refer to this article for more detailed steps and the process: Manually upload transactions into QuickBooks Online. Then, you can categorise and match the transactions.

Feel free to shoot comments below if you have any other concerns or questions about bank transaction. I'm always glad to help in any way I can. Take care!