Skip to main content
R
rofellods-gmail-
November 22, 2023
Question

Can I import TCGPlayer Transactions properly?

  • November 22, 2023
  • 2 replies
  • 0 views
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?

2 replies

4
4Gal
November 22, 2023

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

 

C
Carneil_C
November 22, 2023

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.

Terms & ConditionsAccessibility statement