Common Accounting Connector Errors and how to resolve them

Customer with that name already exists

QB does not allow duplicate names in more than one list.

Un-mapping and re-mapping the customer account in the Accounting Connector ( Mapping -> Customers ) should resolve this error.

This is usually because the customer is not mapped to the right account in Quickbooks.

If you don't see the customer account appear in the list in the Accounting Connector, make sure to filter the list appropriately for un-mapped and mapped accounts by clicking on the buttons to accordingly

To un-map, go to the account in Manage360 and click on the green icon shown in the screenshot below.

Afterwards, go to the Mapping section in the Accounting Connector and re-map the account.

Cell phone number must be formatted as XXX-XXX-XXXX when QuickBooks Payroll is enabled

For these error messages, try re-formatting the cell phone number as specified in the error message. This may be a formatting requirement for Quickbooks. 

City is required when QuickBooks Payroll is enabled

You are missing the City under the specified accounts. Please check the accounts stated to ensure a city is entered

All the DS/Manage360 Taxes must be mapped before syncing data

You must map your taxes in the Accounting Connector - Mapping section.

Each tax item must be mapped to an appropriate item in Quickbooks.

Could Not Create the Customer; This Customer Already Has Job Information

There is job information that’s already on the Customer account. You must remove this information to allow the sync to find the job.

If there is job information on the customer account, Quickbooks will assume it is a Job which affects how the Accounting Connector syncs.

Please follow the instructions in this link here covered by Quickbooks Support:

Could Not Create the Customer; This Customer Already Has Job Information

Paid status is not updating in Manage360 

Were these invoices manually created in Quickbooks before syncing them over to Manage360? If not, did you make any changes to the amount, date or invoice number? This can happen when the invoice in Manage360 is no longer correctly linked to the matching invoice in QuickBooks.

For example, if Manage360 has a link to Invoice A based on the date, invoice amount and number but invoice B was actually paid over in QB then Invoice A in Manage360 will always show up as unpaid. 

For these invoices, you can try un-mapping and re-mapping the customer accounts. 

On the customer account, click on the green icon to un-map it. 

Then, on the Accounting Connector,  re-map it by using the Mapping tab -> Customers list. Filter the list to show unmapped customers, then select the correct QuickBooks account.

You can also un-map and re-map the invoices directly under the Mapping tab -> Invoices 

Make sure that the sync finishes completely as well. The sync has to update in order for the invoice paid status to update.  Let the sync run overnight if you need to as this can take some time. 

Duplicate invoices 

Similar to above. Check whether the invoice was changed in QuickBooks before syncing.

Did this invoice already exist in Quickbooks prior to syncing? If so, if changes were made to that invoice and you sync one over from Manage, it will sync that over if the three criteria don’t match for that invoice. 

So this means if the invoice amount, date or number don’t match, the accounting connector will think it’s a new invoice and sync it over. 

Make sure the invoices in Quickbooks and Manage360 all match for the invoice amount, date and number 

In some cases, the accounting period in Quickbooks has passed for your company file. 

To fix this, you must have an administrator reopen the books by going to Settings -> Account and settings -> Advanced -> Accounting and update the closing date. 

Failed to get verified invoices. Value cannot be null. Parameter name: value 

The account for that error may not be mapped correctly.  

You can do this by going to the Mapping section on the Accounting Connector and click on Mapped to view all of your currently mapped customers. 

Next, find the account for that invoice and un-map this account.  

Click on the Un-mapped radio button to view all of your un-mapped customers where you should find the unmapped account there. Map this to the appropriate matching Quickbooks account that you see on the right side of the screen there. 

After doing this, try syncing again and see if that invoice goes over. 

Error 6140: Duplicate Document Number Error : You must specify a different number. This number has already been used. 

It may be that the invoice number for that invoice already exists in Quickbooks.  

To fix this error, you have to unposted this invoice and assign a different invoice number that doesn't already exist in Quickbooks in order to sync it over. 

You can un-post the invoice by going to Actions -> Revert to Un-posted 

If the issue continues, your invoice totals may be different which makes the accounting connector think that they’re different invoices. If you need to make adjustments to the invoice amounts in QB, it will break the invoice link between Manage360 and QB. 

If that’s the case, re-map the invoices accordingly using the Mapping section in the Accounting Connector ( Mapping -> Invoices )