Sign in

QuickBooks Sync Error: The QuickBooks file is not available

Error

The QuickBooks file is not available.
1. If this file has never been synced before, open the QuickBooks Company file. If prompted to allow Bill.com access to the company file, choose "Yes always; allow access even if QuickBooks is not running"
2. If your QuickBooks application is open but the open file is not what you selected, please either close QuickBooks or close the current Company file, and open the select file in QuickBooks.

Explanation

This error occurs when syncing for one of several reasons:

  • The opened QuickBooks file is not what is selected in the QuickBooks file field of the Profile Editor in the Bill.com Sync Dashboard
  • In the Profile Editor, on the Please Confirm your QuickBooks company file screen, the Browse Button was clicked
  • If you have previously synced, the QuickBooks file was moved to a different location

Solution

  1. Exit QuickBooks.
  2. In The Bill.com Sync Dashboard, Click OK on the Error Occured screen
  3. Click Cancel in the Profile Editor
  4. In the Bill.com Sync Dashboard, click New
  5. Open the QuickBooks file as the QB Admin user in Single User Mode
  6. Click Edit > Preferences
  7. On the left, click Integrated Appications
  8. Click Company Preferences
  9. Ensure the following is not checked
    • Don't allow any applications to access this company file
    • Notify the user before running any application whose certificate has expired
      QB_Preferences.png
  10. Click Ok
  11. Return to the Bill.com Sync Dashboard Profile Editor, click Next
  12. On the QuickBooks - Application Certificate, select Yes, always; allow access even if QuickBooks is not running
  13. Click Continue
  14. For Access Confirmation, click Done
  15. In the Profile Editor of the Bill.com Sync Dashboard, enter your Bill.com login details
  16. Click Next
  17. Select the Bill.com company you will be syncing with
  18. Click Finish
  19. In the Bill.com Sync Dashboard, under Sync Profiles, select your Bill.com Company
  20. Click Sync


If these steps do not work for you, please contact Customer Support.