Improve bookkeeping accuracy with the eBay Connector by Intuit, which syncs data directly into QuickBooks. Edit, categorize, and match eBay orders, payments, customers, and products.
The app imports order details like net amount, fees, taxes, discounts, products/services, and customers.
View status or orders/items
eBay orders will be automatically added to the books. You can view the status of the transactions and items being imported in the Integration transactions (Take me there) page.
There are several tabs in the App transactions page:
- Processing includes all orders and items that are in progress and not yet imported.
- Imported includes all orders and items that were successfully imported from eBay.
- Excluded includes all orders and items that have been manually excluded from being imported.
Once an order is created in eBay, it appears in the Imported tab of the Integration transactions page, usually within 4 hours.
How to connect
You need an active eBay account to use the eBay Connector by Intuit. If you haven't already, create an eBay account first. Then you’re ready to get started!
- Select Integrations
, then Find integrations (Take me there). - In the search bar, enter “eBay Connector by Intuit”, then select it when you find the app.
- Select Get app now.
- Then enter your eBay username (or email address) and password and select Login.
- To authorize eBay to send your orders to QuickBooks, select Approve.
- Complete the app settings. You can change these settings later by selecting Settings in the eBay tile.
Note: Use Income account in Item settings and Use Expense Account in Payment settings are required fields. - Select the date you want eBay to start importing orders, then select Done.
Note: The eBay API restricts historical data to 90 days from the current day. - Once the connection is complete, select Go to Integration Transactions.
Tips and terminology for your app settings
Retrieve settings specifies which order statuses should be retrieved. Set up the filters to determine which orders will be retrieved from eBay. You will have to set up the filters based on the Order Status
Sales settings tell QuickBooks how to create sales.
-
Create Sales in QuickBooks as specifies whether to create an order from eBay as a Sales invoice or a Sales receipt.
Note: If you select Sales receipt, it won’t get imported into QuickBooks until fully paid. - Order Number Prefix - The prefix you input here is added to all orders retrieved from your eBay account. For example: If you have an order '1234' in eBay and you add the prefix 'EB' in the configuration, your order will be retrieved into QuickBooks Connector with the order number 'EB1234' and sent to QuickBooks Online accordingly.
-
Automatic Invoice Numbers lets QuickBooks generate an invoice number for each sale.
By selecting this option, you will allow your accounting system to assign an automatic invoice number, e.g., to adhere to sequential invoice number rules, rather than using the invoice number provided by the source system.
Please note: To generate Invoice Numbers in QuickBooks, the Custom Transaction Numbers option in the Sales settings must be off. You can check the guide here. - Shipping charges define which item to use for shipping charges. This setting is only required if the Shipping option isn't turned on in the company settings.
- Discounts applied define which item to use for discounts. This setting is only required if the Discount option isn't turned on in the company settings.
Item settings tell QuickBooks how to create items.
-
Create items as specifies whether to create items as non-inventoried or inventoried items. Select Inventoried Items if you would like to track inventory in QuickBooks.
Please note: Select Inventoried Items if you would like to track inventory in QuickBooks. If you do not intend to track inventory within your QuickBooks Online, then you can specify the app to create items as Non-Inventoried Items within your QuickBooks Online - Match items by specifies whether to match eBay product SKU by the QuickBooks SKU or Name field. If the imported product matches the QuickBooks item, the app won’t create a new item.
- The Use Income account specifies which account will be used for all items. The account selected here will be the default income account assigned to all items that are sold.
- Use Expense Account specifies which account to use for purchased items. A value is recommended for the Expense Account.
Tax settings specify which eBay tax rates will map to which QuickBooks tax rates. This setting is only applicable if you have taxes set up in QuickBooks.
Payment settings configure which QuickBooks accounts get used for eBay payments and fees.
You’re ready to go! The eBay app and your orders are available in Integration transactions (Take me there).
How to disconnect the app:
1. Go to My Apps, then the Overview tab.
2. Find the eBay app card, select more options, then select Settings.
3. Select Disconnect.
eBay orders/items overview:
| Transaction Type / Item | What you'll see in QuickBooks |
| Invoice / Sales Receipt | QuickBooks imports detailed line item data and customer data from eBay. You can also match a transaction to existing invoices and sales receipts if you already recorded them in your QuickBooks Online account. |
| Payment | If orders are imported as invoices, then a separate Payment associated with the invoice will be created. |
| Refund Receipt | eBay refunds are imported as a Refund Receipt. |
| Fees | Fees associated with orders will be imported as an expense transaction with the Sales Receipt. Note: Fees are categorized into a Fee expense account which you can set in your app settings. |
| Customers | Customers will be automatically created when the order associated with the customer is imported. |
| Items (Products / Services) | Products / services sync as line items on the invoice or sales receipt. And they will be automatically created when the associated order is imported. |
Comments
0 comments
Please sign in to leave a comment.