To import eBay sales into QuickBooks, download the transaction report from the Payments tab in Seller Hub, group its lines by payout, and record each payout as gross sales minus fees, refunds and shipping labels. The net figure should equal the deposit on your bank statement, which you then match to that entry instead of adding it as income.
Why an eBay payout never equals the eBay sales behind it
An eBay payout is what is left after eBay takes its share. eBay's page on getting paid for items you've sold says selling fees and other costs are deducted automatically before the money is released. The deposit in your bank is a net figure, not your sales.
That gap is the whole problem. If you record the bank deposit as income, your sales look smaller than they were and your fees disappear from the books. Both numbers matter: gross sales for your income, and fees as a cost of selling. A payout can also bundle several days of orders, so one deposit stands for many sales.
Timing adds a wrinkle. eBay pays out daily by default, or weekly, biweekly or monthly if you choose. A weekly payout starts on a Tuesday and can take one to three business days to clear, so sales from one month can reach your bank in the next.
Downloading the eBay transaction report from Seller Hub
The detail you need lives in the transaction report. eBay's guide to the Payments tab in Seller Hub says the Reports section lets you download a transaction report, a tax invoice and a financial statement. The transaction report lists each transaction with its date, order number, buyer name, payout date and fees.
Pick a date range that matches the period you are closing, and download it as a spreadsheet. The Payouts section is useful alongside it: each payout has its own payout ID, and selecting it in Seller Hub shows every transaction and fee inside that payout. eBay also gives each payout a bank reference ID, shown in the payout details, which helps when two payouts land close together.
Splitting each eBay payout into sales, fees and refunds
Work payout by payout. Filter the transaction report to one payout ID, then add up four groups: order totals, eBay fees, refunds and other costs such as shipping labels. Gross sales minus the rest should equal the payout amount to the cent. If it doesn't, a line is missing from your filter.
Here is an example for one weekly payout. The figures are made up for illustration.
| Line | Amount |
|---|---|
| Gross sales, 14 orders | 1,286.50 |
| eBay selling fees | -171.40 |
| Refund to one buyer | -42.00 |
| Shipping labels bought on eBay | -96.35 |
| Payout sent to checking | 976.75 |
The deposit on your bank statement for this payout is 976.75. In QuickBooks, that one deposit turns into four lines: 1,286.50 to sales income, 171.40 to a selling fees expense, 42.00 against sales as a refund and 96.35 to a shipping or postage expense.
How should eBay sales be recorded in QuickBooks?
The simplest record is one entry per payout. A sales receipt or a deposit with several lines works well: positive lines for gross sales, negative lines for fees, refunds and labels. Use a generic customer such as "eBay sales" rather than creating a customer for each buyer. The entry's total equals the payout.
Some sellers prefer a clearing account called "eBay clearing." Each payout's sales and fees post into it, and the bank deposit moves the net amount out of it to checking. The clearing account should return to zero after each payout. A balance left in it points to a payout you recorded but haven't matched, or the reverse.
A refund to one specific buyer can also go in as a credit memo, if you track buyers as customers. The guide to importing credit memos into QuickBooks Online covers that record. Sellers on Xero follow the same split with Xero's own sales records; the guide to importing invoices into Xero shows Xero's sales import.
Matching the eBay payout to the bank deposit
Once the payout entry exists, the deposit from your bank should be matched to it, not added as new income. QuickBooks usually suggests the match when the amount and date are close. Accepting it links the bank line to the entry and keeps the sale from being counted twice.
The bank line needs to reach QuickBooks first, either through a bank feed or a bank file. If your bank only gives you PDF statements, SimpleBankConvert is being built to turn them into a file QuickBooks can take, so each eBay deposit has a line to match. Use the bank reference ID from Seller Hub when two payouts have similar amounts.
What if an eBay payout includes refunds or shipping labels?
Refunds and labels are ordinary lines in the split. A refund reduces sales, and a shipping label is a postage cost. Both are deducted before the payout, so they appear as negative lines in the payout entry. The awkward cases are a payout that is negative, and money eBay takes from your bank directly.
eBay's list of all transactions includes transfers, which it describes as funds moving in or out of your payment method on file. When fees or refunds in a period outweigh the sales, there may be nothing to pay out, and money can move the other way. A transfer out of your account shows up as a withdrawal on your bank statement. Record it against the same eBay entry or clearing account, never as a new, separate expense, or the fees get counted twice.
Keep eBay entries clear of financing too. If you borrowed money to buy stock, the repayments belong to the loan, not to eBay; the guide to importing loan payments into QuickBooks Online shows how to split principal from interest.