This article explains a specific accounting symptom: an invoice that was fully paid in Sharper later shows a small open balance — often just a few cents — and there is no error message anywhere to explain it. It happens only when your company syncs to QuickBooks Online, and it is caused by QuickBooks Online calculating a slightly different sales tax amount than Sharper did. This article covers how to recognize it, how to confirm it, and how to stop it happening again.
Note: This applies to QuickBooks Online only. If your company syncs to QuickBooks Desktop or Sage Intacct, you will not see this symptom — see Which accounting systems are affected below.
What you will see
An invoice showed as Paid, or the payment covered the full amount you expected.
Later, the same invoice shows a small amount still owed — commonly $0.01 to a few cents, occasionally more.
The invoice total or tax total in Sharper no longer matches what you originally saw.
Nothing appears in your accounting sync error list. The sync completed successfully.
Over a month, these small amounts accumulate into an aged balance nobody can account for.
Why this happens
Sharper and QuickBooks Online each calculate sales tax, and they can disagree. Here is the sequence in plain terms.
When Sharper sends an invoice to QuickBooks Online, it does not send a tax total. It marks each line on the invoice simply as taxable or not taxable, and it adds its own tax amounts as ordinary line items on the invoice.
QuickBooks Online, if automatic sales tax is switched on, then calculates its own tax for the lines Sharper marked taxable — using the customer's address and tax jurisdiction as recorded in QuickBooks.
Sharper then reads the finished invoice back from QuickBooks Online and accepts QuickBooks Online's figures — tax total, subtotal, total, amount paid, and paid status — replacing its own.
If QuickBooks Online's tax figure differs from Sharper's by even one cent, the read-back raises the invoice total while the payment already recorded stays the same. The difference becomes an open balance. Neither system reports a problem, because from both systems' point of view nothing failed.
Why the two tax amounts can differ
Sharper applies the tax rate you configured on the tax code attached to the product or customer — one rate, applied as you set it up. QuickBooks Online's automatic sales tax works differently: it derives a rate from the customer's address, combining state, county, city, and special-district components, and it may round each component separately. Common causes of a mismatch:
The customer's address in QuickBooks sits in a district with a slightly different combined rate than the rate configured in Sharper.
The customer's tax record in QuickBooks is set to taxable when your Sharper setup treats that customer or product as exempt, or the reverse.
Rounding: Sharper rounds one tax figure for the invoice; QuickBooks Online rounds per component or per line, producing a total a cent or two apart.
A rate change took effect in one system on a different date than the other.
Neither system is broken. Both are calculating tax correctly according to their own configuration. The problem is that two different configurations are being applied to the same invoice.
Which accounting systems are affected
Accounting system | Can this happen? |
QuickBooks Online | Yes. This is the only affected integration. QuickBooks Online recalculates tax on the invoice, and Sharper accepts the result. |
QuickBooks Desktop | No. This integration absorbs a small difference on a dedicated rounding line, so no open balance is created. |
Sage Intacct | No. Sage Intacct receives summary journal entries only. It never recalculates tax, so there is nothing to send back. |
To check which system your company uses, go to Accounting → Settings and open your accounting integration settings.
How to confirm this is what you are looking at
A small unexplained balance can have other causes. Work through these checks in order before changing any tax configuration.
Open the invoice in Sharper and note the Tax amount and the Total.
Open the same invoice in QuickBooks Online and compare its tax amount and total. If QuickBooks Online's tax is higher by exactly the amount still owed, this article describes your situation.
Check the payments applied to the invoice. If a payment was recorded for less than the full amount, or a deposit was only partly applied, the balance is a payment-application issue rather than a tax difference.
Check for a credit memo applied to the invoice. A credit memo applied for less than the remaining balance leaves a residual that looks identical from the invoice list.
Check whether the amount owed is a round figure. Tax differences are typically a few cents. A balance of several dollars or more is far more likely to be a partial payment, a partly applied deposit, or a credit memo.
Note: There is no side-by-side tax comparison view in Sharper. You need to open the invoice in both systems to compare the two tax figures.
Fix option 1 — stop QuickBooks Online from calculating the tax
This is the fix you can make entirely within Sharper. Turning off the Taxable setting on a tax code makes Sharper mark those invoice lines as non-taxable when it sends them, so QuickBooks Online does not calculate any tax on them. Sharper's own tax line items still appear on the invoice and still carry the tax amount, so the tax is not lost — QuickBooks Online simply stops adding a second, competing calculation.
Identify the tax code used on the affected invoices. It is set on the product or on the customer record.
Go to Accounting → Settings → Tax Code.
Open the tax code you identified.
Turn the Taxable setting off.
Click Save.
Before you change this: The Taxable setting affects every invoice that uses this tax code from this point forward, and it is what determines whether QuickBooks Online calculates tax at all. Review with whoever owns your tax setup — usually your bookkeeper or accountant — and confirm that letting Sharper's configured rate be the single source of tax is what you want for that code. If you rely on QuickBooks Online's automatic sales tax to determine the correct rate by jurisdiction, use fix option 2 instead.
Fix option 2 — align the tax configuration in QuickBooks
The alternative is to make QuickBooks Online's calculation agree with Sharper's, so the read-back returns the same figure Sharper already had.
In QuickBooks Online, check the affected customer's tax setting — whether the customer is marked taxable or exempt — and make it consistent with how that customer is treated in Sharper.
Check the customer's billing address in QuickBooks Online. The address determines which jurisdiction's rate automatic sales tax applies.
Review your automatic sales tax configuration in QuickBooks Online and confirm the resulting combined rate matches the rate configured in Sharper under Accounting → Settings → Tax Rate.
Note: All of fix option 2 is done inside QuickBooks Online. Customer tax settings and automatic sales tax cannot be configured from Sharper. Sharper only reflects whatever QuickBooks Online returns.
Cleaning up invoices that are already affected
Fixing the configuration prevents new occurrences. It does not reverse invoices that have already been changed.
Re-syncing will not undo it. Once QuickBooks Online's figures have been written onto a Sharper invoice, running the sync again does not restore Sharper's original total. It reads the same figures back.
Clear the residual balance the way you would clear any other small write-off in your accounting process — for example with a credit memo or an adjustment to the invoice — and use whatever method your bookkeeper or accountant normally applies to immaterial differences.
Do the cleanup for a defined date range, and finish the configuration fix first, so you are not clearing balances that are still being created.
Keep a note of which invoices you adjusted and why, so the adjustment is explainable at year end.
How long a fix takes to appear
The accounting sync runs on an hourly cycle. After you change a tax code in Sharper or a customer's tax setting in QuickBooks Online, allow a sync cycle to pass before checking whether new invoices are still affected. Testing on a single new invoice immediately after the change will not tell you anything useful.
Preventing it going forward
Once a month, compare the sales tax liability total in Sharper against the same account in QuickBooks Online. A small but steadily growing gap is the earliest signal this is happening.
Filter your customer balances for very small open amounts. A cluster of one-, two-, and three-cent balances is characteristic of this issue rather than of ordinary underpayment.
When you add a customer in a new tax jurisdiction, check the first invoice for that customer in both systems before the balance has a chance to accumulate.
Avoid editing tax items directly in QuickBooks Online. Changes made there can put the two systems out of step and cause invoice import problems as well as tax differences.