Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 22, 2020
Solved

customer refund csv

  • October 22, 2020
  • 1 reply
  • 0 views

I have an internet business and have found the import function really useful for uploading sales receipts.  Does anyone know if it is possible to upload customer refunds in the same way via a csv which will then allow me to show the bank account from which the refund is to be deducted.  I have looked at the import credit note csv and this does not seem to fit what I am trying to do.

 

If nothing currently exists to do this is anything being developed to assist.

Best answer by Kristine Mae

Let me share how it works in QuickBooks Online, Spookiebabe.

 

These are the only data or lists you can import into the system:

  • Bank data
  • Customers
  • Suppliers
  • Chart of Accounts
  • Products and Services
  • Invoices
  • Credit Notes
  • Sales Receipts
  • Journal Entries
  • Bills

For now, you're unable to import the customer refund. You'll want to enter it manually in the program. You have three ways to record it. It's either you create a Refund receipt, Expense, or Cheque. For more information, you can refer to this article: Record a customer refund in QuickBooks Online.

 

Also, we're taking notes of our customers' ideas. I suggest sending feedback directly to our software engineers. It will help us know what features our users want to add to our software. Here's how:

  1. Click the Gear icon.
  2. Select Feedback.

Feel free to let us know if you have other concerns. We'll respond as soon as we can. 

1 reply

Kristine Mae
Moderator
October 22, 2020

Let me share how it works in QuickBooks Online, Spookiebabe.

 

These are the only data or lists you can import into the system:

  • Bank data
  • Customers
  • Suppliers
  • Chart of Accounts
  • Products and Services
  • Invoices
  • Credit Notes
  • Sales Receipts
  • Journal Entries
  • Bills

For now, you're unable to import the customer refund. You'll want to enter it manually in the program. You have three ways to record it. It's either you create a Refund receipt, Expense, or Cheque. For more information, you can refer to this article: Record a customer refund in QuickBooks Online.

 

Also, we're taking notes of our customers' ideas. I suggest sending feedback directly to our software engineers. It will help us know what features our users want to add to our software. Here's how:

  1. Click the Gear icon.
  2. Select Feedback.

Feel free to let us know if you have other concerns. We'll respond as soon as we can. 

July 18, 2021

I'm new to QBO and I'm at the stage where I am importing my sales receipts via CSV.  I found another post detailing how to display a DIscount field on the Sales form. The process was:

 

  Account and Settings >> Sales >> Sales form content >> tick the Discount toggle.

 

My question is: How do I include this field in my CSV file? Is it just a case of adding a 'Discount' column and inserting a negative number there?

Fiat Lux - ASIA
Level 14
July 19, 2021

@NFA 

You may 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

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo