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
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
weslaughton
Level 3
posted
‎August 11, 2021 09:34 PM
last updated ‎August 11, 2021 9:34 PM

What is the easiest way to import transactions from Shopify to Quickbooks?

 
Solved
Reply Join the conversation
Best answer August 12, 2021
Solved

Best Answers
Fiat Lux - ASIA
Level 15
‎August 12, 2021 01:53 AM

What is the easiest way to import transactions from Shopify to Quickbooks?

Prepare the 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
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Software1 Year Warranty125  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 Extended Warranty1 Year Extended Warranty15  TAX
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Gift Certificate$50 Gift Certificate150  NON
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Magazine SubscriptionAnnual Magazine Subscription212  NON

 

then utilize an importer tool to proceed.

https://transactionpro.grsm.io/qbo

 

View solution in original post

Reply Join the conversation
4 Comments 4
Fiat Lux - ASIA
Level 15
‎August 11, 2021 10:38 PM

What is the easiest way to import transactions from Shopify to Quickbooks?

Do you only need to import the Sales Receipt data or sync data including inventory? You will need to have an additional help to do so.

Reply Join the conversation
weslaughton
Level 3
‎August 12, 2021 01:15 AM

What is the easiest way to import transactions from Shopify to Quickbooks?

Thanks for your reply. I need to import the sales receipt data. Do I need additional help to do this? 

Reply Join the conversation
Fiat Lux - ASIA
Level 15
‎August 12, 2021 01:53 AM

What is the easiest way to import transactions from Shopify to Quickbooks?

Prepare the 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
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Software1 Year Warranty125  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 Extended Warranty1 Year Extended Warranty15  TAX
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Gift Certificate$50 Gift Certificate150  NON
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Magazine SubscriptionAnnual Magazine Subscription212  NON

 

then utilize an importer tool to proceed.

https://transactionpro.grsm.io/qbo

 

Reply Join the conversation
weslaughton
Level 3
‎August 12, 2021 02:14 AM

What is the easiest way to import transactions from Shopify to Quickbooks?

Thank you so much 

Reply Join the conversation
Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.
Featured
Nurturing our Neighborhoods: The Vital Role of Small Businesses
Small businesses are the vibrant heart of our communities.From your favorit...
Read more
Three Things - Planting Seeds for Small Business Success This Spring
Launching a small business can be an adventure filled with excitement and t...
Read more
Spring Clean your Finances with these 12 steps
Join us today on SmallBizSmallTalk as we discuss practical strategies for d...
Read more

Need to get in touch?

Contact us