In this article:
Integrating SingleOps and QuickBooks Online
Syncable/ Non-Syncable Symbols from QuickBooks to SingleOps
Quickbooks Sync Chart
Here you will find a visual representation of "what" and "how" data sync between SingleOps and the accounting software Quickbooks. Note the arrows, some data will sync bilaterally, others in a single direction.
Operation : Class |
|
Item : Product and Service |
*See List of Symbols & Characters Accepted when Syncing Between Quickbooks > SingleOps |
Client : Customer |
|
QuickBooks Account : Account |
Only 1 Quickbooks account can be selected to a SingleOps account. If you run multiple businesses with multiple Quickbooks accounts, you will need to set up a new SingleOps account. |
Invoice/Expense Accounts : Chart of Accounts |
|
Payment Terms : Terms |
|
Sales Tax Configuration |
|
Invoice |
|
Purchase Order : Bill |
Note: QB inventory is not impacted, no inventory will be added |
Inventory |
Inventory syncing is not supported. |
Deposits & Prepayments |
|
Settings |
|
Integrating SingleOps and QuickBooks Online
- To connect your SO account to QBO, simply navigate to account settings within the gear icon in SO.
- Note: you must be an admin to perform this action.
- Within account settings, navigate to Quickbooks online
- Select connect and you’ll be prompted to enter your QBO credentials in QBO.
- If the credentials are valid, you will be redirected back into SO and the sync will begin.
- The initial sync will sync over the following items in the background over the span of several minutes
Post Integration Review
Items Review
- Make sure all Items in SingleOps have an income account identified.
- Run the items export in SingleOps to quickly verify which items do not have an income account specified. (This is only for Onboarding team members, users can’t export on their own)
- Any Item that does not have an income account will not sync on future invoices and create errors.
Why? An Item needs to be associated with an income QuickBooks account in order to be saved - This is so it tracks to the appropriate class on the Job level. For individual Items, there could be Items allocated to different departments, accounts, etc. This allows more control over where things are reported to in QuickBooks.
Tax Locations
- Review your tax locations to make sure that you don’t have any tax locations that were not synced from QBO.
- If you notice any discrepancies, please reach out to support to get the unsynced tax locations deactivated from your account.
Integration Settings
Need to determine how the user wants to sync their transactional data over to QBO
- Default - When Job is approved, invoice will sync
- Sync Invoices when payment is received
- Manual Syncing
Test
- Sync a fake invoice over with a few items
- Delete the invoice in QBO after confirmation
Syncable/ Non-Syncable Symbols from QuickBooks to SingleOps
QuickBooks does not allow certain characters in Item names or Client names to sync over, even if the Item/Client was created in QuickBooks. They will sync from Quickbooks but will not allow SingleOps to sync any invoices with Item/Client that have these characters.
Characters Sync from QuickBooks to SingleOps |
||
Symbol/Character Name | Symbol | Sync |
Alpha-numeric | A-Z, a-z, 0-9 | |
Ampersand | & | |
Asterisk | * | |
At symbol | @ | |
Colon | : | |
Comma | , | |
Exclamation point | ! | |
Minus sign/hyphen | - | |
Parenthesis | () | |
Period / dot | . | |
Plus sign | + | |
Pound / number sign | # | |
Question mark | ? | |
Semi-colon | ; | |
Single quote | ' | |
Space | . . | |
Tilde | ~ | |
Underscore | _ |
Comments
Please sign in to leave a comment.