Get 50% OFF QuickBooks for 3 months*

Buy now
United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
rofellods-gmail-
Level 1
posted
‎November 21, 2023 10:25 PM
last updated ‎November 21, 2023 10:25 PM

Can I import TCGPlayer Transactions properly?

I use TCGPlayer to sell trading cards.  Each Order includes My "Product Amount", a "Shipping Cost", a "Fee" (paid to TCGPlayer) and the "Net Amount".   They provide a way to bulk export this in a way that breaks it out by state to satisfy wayfair requirements.   How can I import this data to the quickbooks platform so that I appropriately categorize my taxes as well as provide tax nexus information to the system?
Reply Join the conversation
2 Comments 2
4Gal
Level 11
‎November 21, 2023 11:08 PM

Can I import TCGPlayer Transactions properly?

You can prepare your Sales Receipt data with the following template

RefNumberCustomerTxnDateShipDateShipMethodNameTrackingNumLocationClassBankAccountPaymentMethodPaymentRefNumberBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgCurrencyExchangeRateBillEmailToBePrintedToBeEmailedShipAmtShipItemTipAmtDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y HandheldsPortable Game Player1100  TAX

 

then use an importer tool to proceed

https://get.transactionpro.com/qbo

 

Reply Join the conversation
Carneil_C
QuickBooks Team
QuickBooks Team
‎November 21, 2023 11:29 PM

Can I import TCGPlayer Transactions properly?

Welcome to the QuickBooks Community, rofellods.

 

I'll share some information about importing transactions from TCGPlayer to QuickBooks Online.

 

QBO depends on what the third-party app provides or how it transfers entries. That said, I recommend contacting the TCGPlayer Customer Support Team by getting their contact details on their website. They can properly guide you on the best process to import those data into the QuickBooks platform so you can organize your taxes and transactions seamlessly moving forward.

 

As always, you can visit our QuickBooks Community help website if you need tips and related articles in the future.

 

This thread is still open to help you again if you have follow-up questions about integrating third-party applications into QBO. Have a good one.

Reply Join the conversation
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Featured
When are taxes due? 2026 Critical Tax Deadlines
 (view in My Videos)
Read more
Quick Answers: A Mini Guide to W-2s
  Hello QuickBooks users, and thanks for joining us. We want to ensure you ...
Read more
Understanding Common Payroll Deductions
 (view in My Videos)NOTE: For more information on deductions, check out our...
Read more

Need to get in touch?

Contact us