Skip to main content
T
t-rdd-amz-gmail-
November 25, 2023
Question

I am looking to import from excel cost of goods data, has anyone did this and how?

  • November 25, 2023
  • 2 replies
  • 0 views
if you have done this please provide/show examples...thank you in advance

2 replies

R
Rasa-LilaM
November 25, 2023

It's nice to see you in the Community today, t-rdd-amz.

 

I can see the need for your business to import the cost of goods data into QuickBooks Online (QBO). However, I just have to ask for more details about your concern to get me on the same page.

 

May I know if you're importing your products and services? Are you referring to the Cost of Goods Sold account in your chart of accounts?

 

Your response will be of great help in resolving the issue quickly. I look forward to hearing from you. Have a pleasant weekend, t-rdd-amz.

4
4Gal
November 26, 2023

@t-rdd-amz-gmail- 

You can prepare Purchase Cash data with the following template

RefNumberBankAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteToBePrintedCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClassLocation
101Cash On HandJoe's Coffee 01/10/2020 12 Main StreetSuite 102  AlbanyNY12345  N  General SuppliesGeneral Supplies85.21            
102Cash On HandCostco 01/10/2020 PO Box 1000   DallasTX28456  N  General SuppliesGeneral Supplies125            
103Cash On HandProperty Mgmt Assoc 01/10/2020 PO Box 1800   AlbanyNY12345 Mar 2011 RentN  RentRent1000            
103Cash On HandProperty Mgmt Assoc 01/10/2020 PO Box 1800   AlbanyNY12345 Mar 2011 RentN  Common Area MaintenanceCommon Area Maintenance100            

 

then use an importer tool to proceed

https://get.transactionpro.com/qbo

 

Terms & ConditionsAccessibility statement