Prevent QuickBooks sync errors by excluding special characters and limits
While we've tried our absolute best to create a pain-free syncing experience with QuickBooks Desktop and QuickBooks Online, sometimes errors occur. Some of those errors are caused by limitations within QuickBooks itself. In this article, we cover the acceptable characters and the character limits within QuickBooks, so that you can avoid any potential errors.
Characters to avoid
QuickBooks has a few special reserved characters that you should avoid using in certain fields within shopVOX. Avoid a bunch of error by NOT using the following characters within certain fields inside shopVOX.
Object in shopVOX
Characters to Avoid Using
Customer > Name
Contact > Name
Product > Name
Transaction > Line Item > Name
Acceptable characters in QuickBooks Online
Sometimes, having invalid characters in your QuickBooks Online company name, or in the name of one of your list items (such as Customers, Vendors, Products and Services, or the Chart of Accounts), can lead to server errors or other problems in the application. To avoid or remedy these errors, make sure your company name on QuickBooks Online only contains accepted characters from this list.
Here is a list of accepted characters:
- Alpha-numeric (A-Z, a-z, 0-9)
- Comma (,)
- Dot or period (.)
- Question mark (?)
- At symbol (@)
- Ampersand (&)
- Exclamation point (!)
- Number/pound sign (#)
- Single quote (')
- Tilde (~)
- Asterisk (*)
- Space ( )
- Underscore (_)
- Minus sign/hyphen (-)
- Semi-colon (
- Plus sign (+)
Character limitations for fields in QuickBooks
Each field in your company data file has a maximum number of characters that can be entered. To sync properly with QuickBooks Desktop or Online, please make sure you don't go over these limits inside shopVOX because you will receive nasty little errors that can be hard to diagnose.
POS Settings > Chart of Accounts > Name
POS Settings > Chart of Accounts > Account Number
Customer, Vendor and Other Names
Employee Name (first and last)
User > Name
Item Description (Invoices)
Transaction > Line Item > Description
Item Part number
POS Settings > Pricing > Products > Part Number
I've hit an error, now what?
Unfortunately, 💩happens. Check out one of the articles below based on which version of QuickBooks you are using. If those don't help, please contact our support team.