cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

I am a US business currently operating in New Zealand and fear this time zone difference is creating the transaction date issue. Obviously, I need the dates to be accurate. I understand that QBO operates under the GMT time zone but it's as if the system is reading my time zone even with the use of a VPN placing my IP in Florida. Any help in the matter is appreciated. Regards, ~Shane
Solved
Best answer August 08, 2021

Best Answers
Fiat Lux - ASIA
Level 15

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

@suburbanoffgrid- 

You have to open a new blank QBO US version and cancel your QBO Global version.

https://quickbooks.grsm.io/US

https://quickbooks.grsm.io/us-promo

 

You will need a 3rd party app or purchase a 3rd party service to migrate data from QBO Global version to QBO US version. Support won't help to migrate your data.

View solution in original post

13 Comments 13
Fiat Lux - ASIA
Level 15

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

Why do you need to use VPN to access your QBO account? Do you have the QBO Global version for New Zealand?

https://quickbooks.grsm.io/Asia-Pacific

 

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

I don't need a VPN to access QBO. When the 1st account that I connected failed to show the correct transaction date, I was concerned it was due to my IP address and location being in New Zealand.

 

I then experimented with a VPN located in Tampa, Florida as an experiment to test if this would fix the problem.

 

I added account 2 while connected to the VPN however the date problem persists.

 

All transactions are +1 day off.

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

Do you have the QBO Global version for New Zealand?

 

Great question. I am viewing the account details and next to ITEMS ON THIS INVOICE: QuickBooks Online Plus.

 

I don't see anything regarding GLOBAL QuickBooks on my invoice.

 

Could GLOBAL QUICKBOOKS be creating this +1 day incorrect transaction history?

 

If so, should I delete this account and create a new account?

Ryan_M
Moderator

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

Thank you for the prompt reply, @suburbanoffgrid-. Allow me to clear things up for you about this matter.

 

QuickBooks Online (QBO) follows the time and date on your device and doesn't use a specific time zone. With that said, I suggest you change to the time zone you need on your device. This way, your transactions will show the correct dates. Be advised that this change applies to all transactions in your QBO company.

 

Post a reply if you have other questions about the time and date on QBO. I'll be around to help you out. Enjoy the rest of the day!

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

Hi Ryan! Yes, I have read this information about the device time throughout the forums.

 

My devices (both iMac and windows laptop) have always been set to my business time zone in Florida.

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

It's currently Monday the 9th of August, 1:35pm here in New Zealand.

 

My device time is shown below.

device time.png

katherinejoyceO
QuickBooks Team

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

Thanks for your swift response with screenshots of your time zone. The date and time of your transactions are affected by your computer's date and time settings. 

 

Let's make sure it's set up correctly. Here's how:

 

  1. Right-click on the time in the bottom right of the screen, then click Adjust Date/Time.
  2. In the Date & Time tab, turn on the Set time automatically.
  3. Set time zone automatically features. 
  4. If you don't want them turned on, choose the correct time zone by clicking the Time Zone drop-down arrow. 
  5. Select the Time & Language window. 

 

Once done, try to create a dummy transaction and check the date and time. 

 

For future reference, here's an article to help you learn about running reports in QuickBooks Online.

 

You can drop a comment if you have additional questions. 

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

Hi Katherine! I have created a test dummy transaction and the date is correct. Now, I will delete an account and hope that when I connect it again, the information is pulled in with the correct date.

 

TEST DUMMY TRANSACTION.png

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

I just finished a complete account purge, connected a credit card account, and the date is still off by +1 day for all transactions that QBO pulled in.

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

I really believe that the only solution to this is for someone at QBO to hit a button placing my account in the United States.

 

After purging the account twice, it automatically defaults back to NZD and not USD therefore the system is confused creating the +1 day problem.

 

I have done everything that I can do on my end including testing on a Mac and a Windows 10 laptop, both with correct device time based in Florida, USA.

 

It simply has to be an internal account settings problem that occurs when I connect a bank account or credit card account and the transactions have +1 day added automatically.

Fiat Lux - ASIA
Level 15

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

@suburbanoffgrid- 

When you open a QBO Global version for NZ, your home currency should be NZD. You have to enable the multi currency feature to change the home currency to USD prior to post any transactions.

https://quickbooks.grsm.io/Asia-Pacific

  

suburbanoffgrid-
Level 1

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

Hi Fiat Lux, yes, I changed the currency to USD the 1st moment upon opening the account and prior to connecting any accounts. Also, I had enabled multi currency as well.

 

It's just the +1 day issue upon connecting new accounts and pulling in the transactions.

 

I need a tech person at QBO to change my account from QBO Global version for NZ to whatever the version is called for the United States.

 

Fiat Lux - ASIA
Level 15

Dear QBO Support, I have successfully created and connected 2 new accounts. However, the transaction dates are incorrect by one day. All transactions are +1 day.

@suburbanoffgrid- 

You have to open a new blank QBO US version and cancel your QBO Global version.

https://quickbooks.grsm.io/US

https://quickbooks.grsm.io/us-promo

 

You will need a 3rd party app or purchase a 3rd party service to migrate data from QBO Global version to QBO US version. Support won't help to migrate your data.