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. 

October 22, 2020

Thank you.  I have already given feedback on this as I cannot be the only person using Quickbooks who has an internet business.  I am currently entering refunds manually but as you can imagine it is quite laborious.

Fiat Lux - ASIA
Level 14
October 22, 2020

@spookiebabe 

Explore TP to import Refund Receipts data into your QBO account

https://transactionpro.grsm.io/qbo

 

Prepare the data with the following template

RefNumberTxnDateCustomerLocationClassPaymentMethodPaymentRefNumberDepositToAccountPrivateNoteMsgBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryBillEmailToBePrintedToBeEmailedTaxRateTaxAmtShipAmtShipItemDiscountAmtDiscountRateDiscountTaxableCurrencyExchangeRateLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
R10101/10/2020Janice Johnson  Check20013CheckingPrivate NoteCustomer Memo 110 Main StreetSuite 2000  DallasTX99875  YN      N   MP3 PlayerBlue MP3 Player255  TAX
R10101/10/2020Janice Johnson  Check20013CheckingPrivate NoteCustomer Memo 110 Main StreetSuite 2000  DallasTX99875  YN      N   Leather CaseLeather Case210  TAX
R10101/10/2020Janice Johnson  Check20013CheckingPrivate NoteCustomer Memo 110 Main StreetSuite 2000  DallasTX99875  YN      N   Gift CardsGift Cards25  TAX
R10201/10/2020Leonard Walker Inc  Cashpaid cashCheckingPrivate NoteCustomer Memo 9 Winding Road   WinchesterNY12345  YN      N   HandheldsPortable Game Player1100  TAX
R10201/10/2020Leonard Walker Inc  Cashpaid cashCheckingPrivate NoteCustomer Memo 9 Winding Road   WinchesterNY12345  YN      N   Software1 Year Warranty125  TAX