cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
t-rdd-amz-gmail-
Level 1

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

if you have done this please provide/show examples...thank you in advance
2 REPLIES 2
Rasa-LilaM
QuickBooks Team

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

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.

4Gal
Level 11

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

@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

 

Need to get in touch?

Contact us