E-Commerce in QuickBooks: Track Every Sale and Get Sales Tax Right
Connecting your online store to QuickBooks can double-count sales and misstate tax. Here is how to keep orders, fees, refunds, and deposits straight.
Selling online means hundreds of small transactions, net deposits, and tax rules that shift as you grow. Connecting your store to QuickBooks Online can put every sale in the books, but only if the connection matches how your money actually arrives. Here is how we approach the parts that go wrong most often.
How do duplicate sales get into the books?
A store connector posts each order into your books as a sale. The money reaches your bank a day or two later, net of fees. If that deposit is then recorded as fresh income, the sale exists twice. Revenue is overstated, and so is the tax you appear to owe.
The deposit should move money that was already recorded, not create it. To see which pattern your setup follows, compare one day of orders against that day’s income entries. If the numbers double up, the fix lives in how deposits are categorized, not in the connector alone.
Why doesn’t the bank deposit match your sales total?
Marketplace and card settlements arrive net. Fees, refunds, and sometimes a held reserve come out before the money moves, so the deposit is smaller than your sales total. That gap is normal, not an error.
Reconcile against the settlement report from your platform or processor rather than the sales total. The report lists gross sales, fees, refunds, and the net transfer. Your books should mirror those same lines.
Where should collected sales tax land?
Tax you collect is not revenue. It belongs in a liability account until you remit it to the state. If your connector maps tax into a sales account, income is overstated and the amount owed reads wrong.
Check the tax mapping in the connector settings. Confirm that tax on refunds flows back out of the same liability account. Obligations also differ by state and can change as your sales grow, so review where you actually have a duty to collect.
Should platform fees be an expense?
Fees are a cost of selling, not a reduction of your prices. Many sellers let the connector net fees out of the deposit, which keeps reconciliation simple but hides the true cost of the channel. Recording fees in an expense category shows what that channel really charges you. Either method can work. Pick one and apply it consistently.
How do refunds stay accurate?
A refund reduces income; it is not an expense. Post it against the same income account the original sale used, and reverse the sales tax with it. Handled this way, your remittance matches what you actually kept. Booked as an expense instead, both income and tax payable end up overstated.
A monthly routine that keeps the books clean
Once the mapping is right, the ongoing work is a short monthly pass. Pull the settlement report and check gross sales against income, fees against expenses, and tax against the liability account. Then match the net deposit. Problems caught in month one are corrections; the same problems in year three are a rebuild.
Start with one settlement period this week. Compare it line by line, fix what the mapping got wrong, and let that first clean month set the standard. If the file already holds months of duplicated or misclassified sales, settings changes will not repair the past. That cleanup is a repair job rather than a tweak, and it is work we handle directly.