The rule that fixes most of it.
One system owns each piece of information, and it is the system where that information is created by the person doing the work.
The job or booking software owns the customer, the schedule, the job, the labour and materials on it, and the invoice that comes out of it. That is where a real person is standing when those things become true. QuickBooks owns the bank feed, the reconciliation, payroll, sales tax, and the reports your accountant works from. It is a ledger and it is very good at being a ledger.
Information then moves in one direction, from where it was created to where it is counted. Customers, invoices and payments go across. Nothing comes back. The moment you turn on a two-way sync, you have created a system that needs rules for what happens when the same invoice is edited in both places on the same afternoon, and nobody in a small business has time to be the referee for that.
What not to do
- Do not enable every available sync option because it is there. Each one is another thing that can disagree at month end.
- Do not let two people fix the same mismatch in two different systems. That produces a third version of the truth.
- Do not build the connection before the naming is fixed. A sync between two systems that name customers differently automates the confusion and makes it faster.
- Do not move to QuickBooks Online purely to get an integration, or away from Desktop because someone told you to. Both are live decisions with real costs and neither is automatically right.