cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Do you have a question about self-assessment or anything else? - Ask it here!
spookiebabe
Level 2

customer refund csv

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.

Solved
Best answer October 22, 2020

Accepted Solutions
Kristine Mae
Moderator

customer refund csv

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. 

View solution in original post

6 REPLIES 6
Kristine Mae
Moderator

customer refund csv

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. 

spookiebabe
Level 2

customer refund csv

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 15

customer refund csv

@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

 

NFA
Level 1

customer refund csv

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?

JessT
QuickBooks Team

customer refund csv

Hi NFA,

 

Welcome to the QuickBooks Online family! I'm glad that you're using the option to import your sales receipts into QuickBooks. However, please know that this doesn't include a field for discounts, so you really need to edit your imported sales receipts to add the discounts.

 

I'll walk you through creating a report that lists all the sales receipts you have, so you can easily pick the one that needs to be edited.

 

  1. Go to Reports and search for Transaction list by customer.
  2. Click on Customise and change the date range. Be sure it covers the dates of your imported transactions.
  3. Click to expand the Filter section.
  4. In the Transaction Type dropdown list, select Sale Receipt.
  5. Choose Run reports.

 

To open a sales receipt from the list, simply click one. Then, enter the discounted amount in the field provided. Do this to all sales receipts that have a discount to recalculate their amounts.

 

If you need help with your imported transactions, please feel free to go back to this thread. Take care and have a good one!

Fiat Lux - ASIA
Level 15

customer refund csv

@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

 

Need to get in touch?

Contact us