ClientSynq keeps a copy of your QuickBooks customers, invoices and payments so your team and your clients can see them. The copy refreshes every night, when QuickBooks reports a payment change, and whenever someone clicks Sync now in the QuickBooks status strip (or Sync QuickBooks on the settings page). Syncing only reads from QuickBooks. It never changes your QuickBooks data.
Before you start
- Available on every plan.
- QuickBooks must be connected. See Connect QuickBooks.
- The QuickBooks status strip at the top right of the Dashboard, Client Invoicing, the QuickBooks Online Tools and Budget Reports appears for the Owner and Administrator roles and for roles with a QuickBooks Tools permission (Import to QuickBooks, Export from QuickBooks or Sync QuickBooks). Its Sync now button needs Sync QuickBooks; owners and administrators always have it.
- Settings → QuickBooks connection and sync has the same sync as Sync QuickBooks, plus Sync Customers.
What syncs
| Data | Which records | What ClientSynq keeps |
|---|---|---|
| Customers | Every active customer in QuickBooks | Display name, email and open balance. These fill the customer list on Client Invoicing and update the name and email of clients you invited. |
| Invoices | Every invoice, of any date, for customers whose status is Has Account | Invoice number, invoice date, due date, total, balance, paid status (paid, partly paid or unpaid), product and service lines, tax and the memo on statement |
| Payments | Every payment for those same customers | Amount, date and the invoices each payment applied to |
Invoices and payments sync only for customers who accepted their invitation and created an account. Customers who are Not Invited or Invited appear in the customer list, but their invoices do not load until they have an account. See Invite clients to your portal.
If your organization has the Library, the same sync also refreshes the Library's copy of invoices and credit memos. See Find your way around the Library.
When it syncs
| When | What runs |
|---|---|
| Every night at 00:00 UTC | Customers, then invoices, then payments, for every connected organization |
| Every night at 02:00 UTC | Library data, for organizations with the Library; then the budgets, actuals and month-end balance sheets behind Financial Statements, for organizations with Financial Statements |
| When a payment is added, changed or deleted in QuickBooks | QuickBooks notifies ClientSynq, and ClientSynq refreshes payments right away |
| When someone clicks Sync now (or Sync QuickBooks on the settings page) | Customers, invoices, payments, Library data when you have the Library, and the budgets, actuals and month-end balance sheets behind Financial Statements when you have that |
If a payment your client made through ClientSynq is deleted in QuickBooks, ClientSynq marks it cancelled and sends an alert email.
Deleted and voided records
Every sync asks QuickBooks what was deleted since the last run (QuickBooks keeps 30 days of changes) and removes those invoices, credit memos, payments, customers, products and classes from ClientSynq's copy, including the Library data. An invoice you void in QuickBooks stays in the copy, marked voided, and no report or tile counts it. Every Sunday night ClientSynq also checks every invoice, credit memo and payment from the last 90 days against QuickBooks one by one, as a safety net, and removes anything QuickBooks no longer has.
Hover the QuickBooks synced … text in the status strip to see what the last sync removed, for example "3 invoices deleted in QuickBooks; 1 invoice voided".
Run a sync now
- Open the Dashboard, Client Invoicing or any QuickBooks Online tool. The status strip at the top right reads QuickBooks synced … (hover it to see when each kind of sync last ran) or QuickBooks connected, never synced.
- Click Sync now. On Settings → QuickBooks connection and sync, the button is Sync QuickBooks.
- The Syncing QuickBooks Data... window shows Overall Progress and each stage: Customers, Invoices, Payments, and Analytics mirror (invoices + credit memos) when you have the Library. Keep the window open.
- When the title changes to Sync Completed!, click Close.
Screenshot to come: Client Invoicing → Syncing QuickBooks Data window with the stage list and Overall Progress barpublic/help/quickbooks/sync-1.png
Good to know
- One sync runs at a time for an organization. If someone else started one in the last few minutes, Sync now opens the window with "A sync is already running. Showing its progress." and follows that sync instead of starting a second one.
- Every role sees how current the data is, with or without the strip: the line under the page title on the Dashboard and the Library reads "QuickBooks data through date · synced when" (the latest invoice date in the copy, and the last successful sync).
- After the Library data syncs, ClientSynq checks for QuickBooks items that match no currency, fee type or adjustment; the strip's hover text shows how many, and Map QuickBooks items to currencies and fees explains the fix.
- A sync that runs longer than 5 minutes stops with "The sync did not finish in time. Close this window and try again; if it keeps happening, contact support." Click Close, then Sync now again.
- Settings → QuickBooks connection and sync also has Sync Customers, which refreshes only the customer list (names, emails and balances) and reloads the page.
- When the strip shows QuickBooks needs reconnecting, nothing syncs until you reconnect. See Connect QuickBooks.
- Inactive QuickBooks customers do not sync.
- A customer without an email address in QuickBooks syncs, but you cannot invite them until you add an email in QuickBooks and sync again.
- Pending bank (ACH) payments are checked with QuickBooks Payments once a day.