Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue

how to configure QuickBooks Online Edition to work with Projector

...

Info

Projector offers a pre-built integration for sending information from Projector to QuickBooks Online Edition. This page will help you install the necessary software to connect the two applications. Once configured, you'll be able to transmit AR. AP, GL, Clients, and Vendors from Projector to QuickBooks Online Edition. If you use the Desktop Edition of QuickBooks, please reference this help page instead.

This document only helps you connect the two pieces of software. If you need assistance mapping Projector fields to QuickBooks fields then you should be working with one of our accounting consultants.


Info
titleAttention IE Browser Users

Note starting Aug. 1, 2020, Intuit will no longer support the Internet Explorer 11 (IE 11) browser for QuickBooks Online and/or QuickBooks Authorization screens.


This form is reached from your Integration tab | QuickBooks subsection Accounting Systems | Quickbooks Online Edition blue dot.

Image RemovedImage Added

Permissions and Settings

...

You will need to steal a token if you share QuickBooks Online credentials with another Projector user for the same realm. 

Projector UserProjector Company FileQuickBooks LoginQuickBooks RealmToken
TomUS Companyaccounting@revcorp.comUS CompanyHas token currently
JimUS Companyaccounting@revcorp.comUS CompanyWhen Jim logs in he'll get a message that he doesn't have an active token. If he chooses to generate one, he is stealing that token from Tom

...


Locked Token

You will find yourself locked out of an account if somebody with a different QuickBooks Online login has already taken the token for the same realm. 

Projector UserProjector Company FileQuickBooks LoginQuickBooks RealmToken
TomUS Companytom@revcorp.comUS CompanyHas token currently
JimUS Companyjimmy@revcorp.comUS Company

When Jim logs in he'll get a message that someone else has the token. Jim needs to ask Tom to release it before he can proceed. Tom releases the token by clicking the Clear QuickBooks Online Connections button in Projector.

How do you see who has the token? There isn't a definitive way to do this, but you can infer who has it by logging into QuickBooks Online. Go to your Users section (under gear icon in upper right) and view activity for each user. Whichever user was last sending transactions from Projector likely has the token.

...


Connect to QuickBooks Online

To connect to QuickBooks Online, click either the Import Wizard or Synchronize Wizard buttons.

Image RemovedImage Added

You'll be taken to the following website. Click the Connect to QuickBooks button.

...

You can close any popup windows and click the Import Wizard or Synchronize Wizard buttons to start sending data to QuickBooks Online.

Image RemovedImage Added

 


Configure QuickBooks Online

...

To fix AR transactions, turn OFF Custom transaction numbers. This is available from Gear Icon | Company Settings | Sales.

 


AP Transactions

To fix AP transactions, turn OFF Warn if duplicate bill number is used. This is available from Gear Icon | Company Settings | Advanced.

 

 



Troubleshooting

Common problems when using QuickBooks Online.

...

Tip

Based on client feedback, access to your connectors via the new QuickBooks Online UI isn't possible. You have to know the secret link which is

https://qbo.intuit.com/app/sdkapplist

Once you go there, edit the connection. You should then be able to add people that require access. If you have multiple connections (is this possible?) you may need to delete obsolete ones.

 

 



Info

This solution was found online, but didn't end up working. QuickBooks Online has changed their UI significantly in the last two weeks or so. I don't think these steps apply anymore. I am leaving this here for temporary reference though. Once we get a clear case of reproducing this issue, we'll get this section cleaned up.

QuickBooks Online uses a "company" model rather than an "individual" model for signing-on, meaning that only one person can authenticate on behalf of their entire company. This means that only one person should create and authenticate the QuickBooks Online connector. From then on that one person may share the connector with other users. 

If you receive this error, you should take the following steps to gain access to the company QuickBooks Online data connector:

  1. Delete the QuickBooks Online Data Connector you have created to prevent confusion
  2. Contact the administrator listed in the error message asking for access to the company connector
  3. The owner of the authenticated data connector (which may be the listed administrator) should then share the Data Connector with you
  4. The Data Connector should appear in your "Shared with Me" folder and should not require any additional steps for you to use

...