cancel
Showing results for 
Search instead for 
Did you mean: 
pkdisti
Level 1

Retail

Does anyone deal with retail returns- can you upload a csv file into QB instead of manually entering them?  then upload the csv file for each vendor that has returns?

2 Comments 2
JonpriL
Moderator

Retail

Hello @pkdisti,

 

As of the moment, there isn't an integrated way to upload a list of retail returns in a CSV file format. In QuickBooks Desktop including the Accountant version, the Import tool only lets you upload a CSV file of your list of names and items.

 

With this, let's consider manually entering them manually and making sure the retail return is associated with the correct vendor name accordingly. While the option to upload transactions in CSV file format, I'd recommend letting our product developers know by sending feedback.

 

This way, they'll know of your need to upload a list of transactions in a CSV file format. You can let them know by following the steps below:

 

  1. Go to Help.
  2. Select Send Feedback Online.
  3. Click Product Suggestion.
  4. Enter a few words describing your request in the Here is my suggestion: field.
  5. Select Send Feedback.
  6. Click Close Window.

 

Also, here's a couple of articles you can read helpful in keeping you up-to-date with the latest improvements and enhancements: 

 

 

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Stay safe!

Fiat Lux - ASIA
Level 15

Retail

@pkdisti 

Prepare the Vendor Credit data with the following template

VendorTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableAP AccountCurrencyExchange Rate
Bell Telephone01/09/2020891Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Delivery Charge15Refund Delivery Charge             
Bell Telephone01/09/2020891Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA       Overhead1Overhead Costs100      
Ajax Lumber02/09/2020892 Ajax Lumber200 Smith Street  AnytownNY11111USA Late Fee10Refund Late Fee             
John's Landscaping01/09/2020893 John's Landscaping1 North Street  AnytownNY11111USA       Landscaping1Plantings25      
John's Landscaping01/09/2020893 John's Landscaping1 North Street  AnytownNY11111USA       Landscaping1Plantings25      
John's Landscaping01/09/2020893 John's Landscaping1 North Street  AnytownNY11111USA       Landscaping1Plantings25      

 

then utilize one of these importer tools.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us