Learn how to connect your eBay seller account to QuickBooks Online so you can easily import your sales transactions and eBay expenses.
With the eBay Managed Payments app, you can automatically import your sales transactions and payment data from eBay into QuickBooks daily. Once set up, the app monitors your eBay account for all transactions, including sales, refunds, and shipping fees.
Step 1: Set up the eBay Managed Payments app
During set up, you’ll decide whether to import your sales data in individual or summary view. For individual view, each sale is used to create one sales receipt. For summary view, all daily sales will be summarized into one sales receipt.
- Sign in to QuickBooks Online.
- Go to the Apps menu.
- Search for and select Connect to eBay Managed Payments.
- On the app details page, select Get app now.
- Select Continue.
- Select the start date for the transactions you want to sync with QuickBooks, up to a maximum of 90 days in the past.
- QuickBooks needs your permission to connect with your eBay account. This allows QuickBooks to get info from eBay, like sales details and payout info. Select Agree to continue.
- In the new tab that opens, enter your eBay account login credentials, then select Sign in.
- Select I agree to grant application access for QuickBooks.
- Back in QuickBooks, use the dropdown menu to select the bank account where you deposit your eBay sales, then select Next.
- Choose whether you want the app to record sales individually, or as a daily summary, then select Next.
- Congratulations! Your eBay Payments account is now connected to QuickBooks. Select Check it out to be taken to the App Transactions tab.
It may take awhile to bring in your eBay transactions. Try periodically refreshing the page so see if some are ready.
Step 2: Review your eBay transactions
When your eBay transactions appear in QuickBooks, you’re ready to review, add, exclude, or undo them. For easy reconciliation, add transactions through the eBay Managed Payments app first and then match them on your banking tab.
- Go to Banking or Transactions.
- Select App transactions, then the For review tab. Your eBay transactions appear in the list, with details like date of sale, payee, description, amount spent or received, and fee breakdowns.
- For each transaction, select an option in the Action column:
- View details: Expands the details such as the eBay Payout ID and the breakdown of the individual transactions in the bank deposit.
- Add: This transaction is ready to add to your books. Note: To ensure all your sales data from eBay gets added to QuickBooks, we recommend you add transactions from the App transactions tab, then match them from the Banking tab.
- Exclude: This transaction won’t be added to your books.
- Once you’ve added transactions, you can review the sales receipts and matching deposits under the Added/Matched column in the Reviewed tab.
- If you need to undo a transaction that you’ve added to your books, select Undo under the Action column in the Reviewed tab.
Manage your settings or disconnect the app
You can change the deposit account, item, and customer settings for the Connect to eBay Managed Payments app by going to the app settings. Here you’ll also find advanced settings, and where to go to disconnect the app.
- Go to Banking or Transactions.
- Select the App Transactions tab.
- Select App settings, then eBay Payments.
- Select the tab for the type of setting you want to change. To disconnect the app, select Disconnect eBay.
- Select Done.
Change the income account for the default eBay Item
By default, all imported sales transactions are added as “eBay Item” in QuickBooks. This product or service item maps to a specific income account in your chart of accounts. To change the account the eBay Item maps to:
- Go to Get paid & pay or Sales, then select the Products and services tab.
- In the Find products and services field, search for “eBay Item”.
- Under the Action column, select Edit.
- In the Income account dropdown menu, select the income account you want eBay sales to record to.
- Select Save and close.