eBay QuickBooks Integration: Keep Your Sales & Inventory in Sync

Each eBay order becomes one invoice. Products come across a line each, carrying the number sold and the price paid, tied to whichever QuickBooks item shares that SKU. Whatever else the buyer was charged sits under a heading of its own rather than folded into the goods: tax, shipping, tips, service charges, duties, any additional fees. None of them shows up unless the order genuinely carried it, so a plain sale of one item ends up a short invoice rather than a form with blanks in it.

Tax is the part to agree on early. Everywhere but Canada we flag all the lines non-taxable, which keeps QuickBooks from running its own calculation and stacking a second tax figure on top of the one eBay already collected. Canadian files work differently: there we apply whichever tax code you configured. Give your bookkeeper that detail in week one, because it costs a conversation now and a reconciliation later.

The money side is what we leave alone. Payouts, card fees and settlements are not ours to write, so the deposit that turns up in your bank, and whatever eBay took out of it on the way, stay with whoever reconciles your accounts. That boundary is drawn deliberately. We record the sale; something else records the settlement, and the two jobs do not have to belong to the same tool.

QuickBooks is not a shopfront. It has no listings, no photos and no variants, and the quantity we set against an item is a reporting figure that no buyer will ever look at. It is there for you and your accountant. When an eBay sale goes through we update it, which is mostly worth having because it stops that number being something a person types in from memory once a quarter.

Traffic runs one way only. Invoices go in; orders do not come out, so no amount of work inside the company file will produce an eBay listing or an eBay sale. That is the shape of the accounting side rather than a switch we have not built yet, and knowing it saves you an afternoon hunting for one. Selling stays on eBay. Recording it is what happens here.

Two eBay habits are worth planning around. eBay does not report its sales, so we look every couple of minutes and collect both stock and orders on the same pass, which means a short wait on a fast listing rather than a live figure. And eBay stops a SKU at 50 characters where QuickBooks would hold 100, so a longer one arrives cut short and quietly stops matching the item it belongs to.