cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Contributor **

Having trouble with ‘round tripped' Quickbooks file

Some background:
Several years ago, I attempted to ‘round trip’ my Quickbooks file to my accountant.  At the time, I had Quickbooks 2011 for Mac, and he had Quickbooks 2011 for Windows.  After I sent him my Quickbooks file, and not knowing that I was supposed to retain the version of Quickbooks that had created my file, I mistakenly updated my software when informed that a new version was available.  When he returned my file, I was unable to load it because , as I was informed by Quickbooks, "This file was originally created with another version of QuickBooks for Macintosh. Please import it into the version with which it was created.”  
After a lot of swearing and quite a bit of help from the online community, I was eventually able to correct the situation by locating the version of Quickbooks that had created my file, and downloading it on to my Mac.  Thankfully, I then had no trouble loading the ‘round tripped’ Quickbooks file!  I then reverted to the most-up-to-date version of Quickbooks.  
Ever since then, whenever I have ‘round tripped’ a file to my accountant, I have taken great care to retain the version of Quickbooks which created that file until my accountant returned the update Quickbooks file to me.  The ‘round tripping’ has worked flawlessly these last few years.
 

Fast forward to early 2019.  
I have Quickbooks 2016 for Mac, and my accountant has Quickbooks 2016 for Windows.  Once again, I initiated a ’round trip’ to my accountant.  As usual, I went to great pains to ignore any notifications regarding a new version of Quickbooks.  However, when my accountant returned the file to me, I was prompted for a password.  This had never happened before.  My accountant’s office confirmed that they had not required a password.  I asked my accountant to email the file again, and once again, I was prompted for a password.  
Then, I horrifyingly remembered that although I had not migrated to a new version of Quickbooks, I had, in fact, migrated from Mac OS 10.13 (High Sierra) to Mac OS 10.14 (Mojave)!!!
 
Does anyone know whether that migration could have provoked the inability to load the ‘round tripped’ Quickbooks file?
 If, in fact, the migration is to blame, does anyone know how I might be able to rectify the situation?
 
You guys were instrumental in saving my rear-end several years ago.  I hope and pray you'll be able to pull off a repeat performance.
 
Thanks in advance!
16 Comments
QuickBooks Team

Re: Having trouble with ‘round tripped' Quickbooks file

Hello hshillet,

 

There are some factors that could trigger QuickBooks for Mac to require you to enter a password. Let me share them with you and help you fixed this.

  • Setting up permissions such as replacing the admin and Data Entry passwords.
  • Setting a Closing Date for your company file.
  • Round trip or converting between QuickBooks for Mac to QuickBooks Desktop for Windows.

You can locate your password if it's sorted in the OS X keychain to get this resolved. Here's how:

  1. From the Finder menu, click Go then Utilities.
  2. Double-click Keychain Access.
  3. Click Passwords from the Category list on the left side of the window.
  4. Locate the keychain with the name QuickBooks User Password. Double-click to open.
  5. Click Show Password.
  6. When prompted, enter your OS X user account password, then select Allow.
  7. Note the password and log in to your company file.

Please refer to this article for more information about: How users and passwords work in QuickBooks for Mac.

 

If you haven't set up a password before, you'll have to reset a password.

 

I've also added our page about account management for future reference.

 

Drop a comment anytime if you have other concerns. The Community is always for you.

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

Sheila,


Thank you so very much for the super-swift response and your suggestion!  Unfortunately, it didn't help   :(

 

Everything was going swimmingly until STEP 4 (Locate the keychain with the name QuickBooks User Password).  I was unable to locate a Quickbooks user password in my list of passwords; probably not surprising as neither I nor my accountant has ever used a password to gain access to Quickbooks.  Your suggestion also included resetting a password if I haven't yet set one up.  Please elaborate.

 

Is it not possible for my migration from High Sierra to Mojave to have caused this problem?

Thanks for trying to help me   :)

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

SheilaGraceA,


Thank you so very much for the super-swift response and your suggestion!  Unfortunately, it didn't help   :(


Everything was going swimmingly until STEP 4 (Locate the keychain with the name QuickBooks User Password).  I was unable to locate a Quickbooks user password in my list of passwords; probably not surprising as neither I nor my accountant have ever used a password to gain access to Quickbooks. 

In your reply, you also mentioned something about RESETTING MY PASSWORD in case I had never set one up…please elaborate.

 

Is it not possible for the migration form High Sierra to Mojave to have caused this problem?

 
Thanks for trying to help   :)
 
hshillet
Anonymous
Not applicable

Re: Having trouble with ‘round tripped' Quickbooks file

Thanks for getting back, @hshillet.

 

I'd like to help add some information to my colleague's post. 

 

Since you're unable to locate a QuickBooks user password, you have to add one to ensure the protection of your data. You'll need your QuickBooks license number and other information to reset your password. 

 

In case you didn't have the information needed, you can check this on the CAMPS website.

 

Also, QuickBooks Desktop for Mac 2016 is compatible with Mac OS X v10.14(Mojave). You can check the minimum system requirements through this link: System requirements for QuickBooks Desktop for Mac.

 

Let me include this article as well for more details about setting up password security: Password security for QuickBooks Desktop.

 

Keep me posted on how it goes. I'll be around to help if you have additional questions about your QuickBooks file. 

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

 
Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

Thank you very much, LilyC!

 

Here's the problem...I have NEVER had a password for Quickbooks.  My file is simple, and I round trip it to my accountant once a year so that he can make several entries on my behalf before he sends it back to me for safekeeping until the next tax season.

 

If I NEVER used a password for Quickbooks, why would I suddenly be prompted for one when attempting to load the file my account returned to me? 

QuickBooks Team

Re: Having trouble with ‘round tripped' Quickbooks file

Hello hshillet,

 

Round-tripping will require you to enter a password. That said, you'll have to create a password for your QuickBooks. Let me guide you how.

  1. On your QuickBooks login screen, click Forgot Password.
  2. Fill out all the information on the form, then click OK.
  3. You'll receive a code through email. Enter the code, then click OK.
  4. QuickBooks will then guide you through creating a new admin password.

Please refer to this handy article for more details about: Reset password for QuickBooks Mac Desktop.

 

Also, you may visit https://qblittlesquare.com/ for future reference.

 

Don't hesitate to reach out anytime if you need help with anything else.

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

Thanks yet again, SheilaGraceA!

Is this requirement for a password-for-round-tripping something new?

 

I ask because I have NEVER needed one...and I have been round-tripping ANNUALLY for 5 or 6 years!  The most recent round-trip commenced in January 2019.  HOWEVER, before my accountant returned my file, I switched from High Sierra to Mojave.

 

Although you guys have told me that Quickbooks is compatible with Mojave, I still wonder whether I might have run into problems by having initiated the round trip while in High Sierra and having sought to conclude the round trip while in Mojave.  Just a thought!

 

Trust me...if generating a password for the first time during my ownership of Quickbooks solves the problem, I'm all in.  However, I thought I should share my suspicions.

 

Thanks in advance!

 

hshillet

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

SheilaGraceA,

 

Here's some more information that I have been able to dig up.

 

The password in question is a password that Quickbooks is expecting FOR THE ROUNDTRIPPED FILE.

 

In January 2019, I commenced the annual roundtrip of my company file to my accountant.  The file I sent out was a QBB file.  At the time, I was still using High Sierra! 

 

In April, my accountant's office completed the annual roundtrip by emailing the file back to me.  By that time, I was using Mojave!  The file I received was also a QBB file.  When I double-clicked on the file, I was prompted for a file name.

 

After supplying the name, I was prompted for a password.  I have attached a screen shot of the password request. 

 

As I had NEVER attached a password to my roundtripped files, I checked with the staff at my accountant's office, and they confirmed that they had not set a password either.  To this day, I am not able to open the file in question   :(

 

I hope the extra info helps.

 

Thanks yet again,

hshillet

QuickBooks Team

Re: Having trouble with ‘round tripped' Quickbooks file

Greetings, hshillet.

 

I appreciate the detailed information and screenshot from your response in this thread. Allow me to join in and help access the company file from your accountant.

 

Let's run our password reset tool to get back on track with accessing the company file. To download the software needed, I suggest visiting the article below and follow the step-by-step instructions in the order shown:

 

Reset password for QuickBooks Mac Desktop.

 

In case the problem persists, it would be best to proceed with getting in touch with our QuickBooks Support Specialists. One of them will be able to take over and perform further troubleshooting to the password problem you're having on your end.

 

Here's how you can reach them:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Select QuickBooks Mac Desktop.
  3. Choose a topic.
  4. Scroll-down and click Get Phone Number.

Additionally, I'm also attaching the support link on the round-tripping process for future reference:

 

Convert a QuickBooks for Mac file to QuickBooks for Windows.

 

Feel free to get back to me anytime on how this goes. I'm just one click away whenever you need help with importing the file back into the QuickBooks system.

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

Thanks for getting back to me, !

 

However, I feel that the conversation may have lost its way for 2 reasons:

1)  I am being prompted for the password to a roundtripped FILE, not for an ADMIN or LOGIN password;

2)  What you and SheilaGraceA may not have noticed is that I am using QuickBooks for Mac 2016.  Thus, I do not see the LOGIN screen to which both you and Sheila have referred.

 

I'll probably check with QuickBooks Support Specialists but if you have any suggestions as to how to get the relevant password on QuickBooks for Mac 2016, I would be very eager to find out!

 

Regards,

hshillet

QuickBooks Team

Re: Having trouble with ‘round tripped' Quickbooks file

Thanks for coming back, hshillet.

 

I have more steps we can try. Let's restore your back up (.dmg) file  to see the login page. Let me walk you through how.

  1. Locate your .dmg file from your QuickBooks preferences. Please refer to the article (restoring a backup) below under "Locate the .dmg file".
  2. Double-click the .dmg file. A new window opens with your company file and available attachments.
  3. Drag the company file and the Attached Documents Library folder (if there is) to the folder where you’ll store the company file. Note: a company file has a .qbXXXX extension.
  4. Go to File, then click Open Company to restore the file.

Please refer to this handy article for more information about restoring a backup.

 

If you're still experiencing the same results, please contact our Technical Support. The steps to reach them are found in @AlcaeusF's post.

 

You can also visit our page tips and related articles about: QuickBooks Desktop for Mac Self-help.

 

Let us know if you need help with anything else. We're always here for you.

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

ShiellaGraceA,

 

Thanks for not giving up.  I apologize for having misspelled your name in earlier messages!

 

I'm not sure to which .dmg file you refer.

 

I went ahead, and contacted Tech Support.  The rep believes that my accountant's office might have inadvertently added a password to my company file WHILE processing it (and BEFORE returning the file to me).  The rep suggested several easy steps that would allow the accountant's office to determine whether a password might have been unwittingly attached at their office.

 

Fingers crossed!

 

Thanks,

hshillet

Established Community Backer ***

Re: Having trouble with ‘round tripped' Quickbooks file

The accountant added the password.  QuickBooks Windows requires the user to add a password when they convert the file.  This is a relatively new requirement of QuickBooks Windows.  The accountant has to tell you the password they gave it.  You may be able to remove the password using the built in password removal tool (I'm not certain as I can't remember how that was in 2016 - its been updated since and works in newer versions). 

 

The problem you had long ago with switching versions while the file was at the accountant has been fixed (also quite a long time ago).  You don't need to worry about that anymore.  

Community Contributor **

Re: Having trouble with ‘round tripped' Quickbooks file

Thank you so very much, IntuitBooks!

It's now a moot point as I gave up and purchased QB Desktop for Mac 2020, naively hoping that would solve the problem...as a Tech Support rep had told me.

 

Turns out that the software still wanted a password.  As the accountant's office did not know what might have been used, I escalated the problem within Tech Support, who advised that Data Services would be able to remove the password.

Late on 18 October, someone from Data Services called to say they had been able to remove a password only after converting my MAC file back to a WINDOWS file; it seems that the password-removal tool might work only in Windows.

The woman in Data Services said she would then have to fix the file but she thought I might receive it on 21 October.

Fingers crossed!

Established Community Backer ***

Re: Having trouble with ‘round tripped' Quickbooks file

QuickBooks Mac 2020 has a password removal option but in this case I don't know if it will work. Its right there in the UI though when it asks for a password - you can give it try. But I think its only for QuickBooks Mac passwords and not one that originated on Windows. 

 

Your accountant, if they can open the Windows file, can just tell you the password they used. 

Need to get in touch?

Contact us