Skip to main content
May 5, 2020
Question

Is the option to import credit memos available in QBO?

  • May 5, 2020
  • 4 replies
  • 0 views
Original commenter did not share additional details

4 replies

AddieC
May 5, 2020

Hello,

 

QuickBooks Online is a flexible solution for your business bookkeeping. There's tons of options for you to take advantage of when it comes to importing and exporting data in your account. I know how handy it would be to have the option to import credit memos into QBO. I'd be happy to explain the information you're able to import and the limitations.

 

To import data into QBO, click the Gear icon > Import Data. From there, you can select any of the following items to import:

  • Bank Data
  • Customers
  • Suppliers
  • Chart of Accounts 
  • Products and Services
  • Invoices
  • Bills

At this time, you're not able to import credit memos. You can make them within the account easily! All you have to do is click + New > Credit Memo.

 

If this is a feature you'd like to see incorporated into QuickBooks Online in the future, I'd recommend leaving us your ideas by clicking the Gear icon > Feedback

If you have any other questions, please don't hesitate to reach out to our tech support team.

Cheers.

December 29, 2020

Please add this soon

Rebecca R
December 29, 2020

Thanks for joining in on this thread @Westfair TV Audio. I know how helpful it would be to have the option to import credit memos into QuickBooks Online. I'm going to pass this feedback along on my end, but I hope you'll use the Feedback option that can be accessed by the Gear icon to have your voice heard as well. This way, you're sending a direct request to our product development team which helps them to prioritize the new features and improvements that will be made to the program. All the best!

Fiat Lux - ASIA
May 5, 2020

Utilize the trial period of TPI for QBO.

https://transactionpro.grsm.io/qbo

 

The template should be like this:

RefNumberCustomerTxnDateLocationClassBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgBillEmailCurrencyExchangeRateShipAmtShipItemDiscountAmtDiscountRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
CM101Janice Johnson01/10/2020  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingCustomer Memo   12Shipping 0.02   Leather CaseLeather Case210  TAX
CM101Janice Johnson01/10/2020  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingCustomer Memo   12Shipping 0.02   Gift CardsGift Cards25  TAX
CM102Leonard Walker Inc01/10/2020  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Customer Memo          HandheldsPortable Game Player1100  TAX
September 20, 2021

No there no any option for import credit notes

Fiat Lux - ASIA
September 20, 2021

@Ritu Singh  

You have to utilize an importer tool to do so.

https://transactionpro.grsm.io/qbo

 

September 20, 2021

https://app.qbo.intuit.com/app/importdata there don't have any option in import tools

 

 

March 9, 2022

I've got the same issue; we need to be able to import either

a) invoices with a negative quantity & value

-or-

b) credit memos

 

Can do neither in QBO here in Canada.

 

I've noted however that the Import Credit Memo functionality does already exist for those using QBO in the UK; which should indicate something fairly easy to provide to others; given the coding already to a large degree exists.

 

I've noted the responses and, yes, we know a credit memo can be manually entered; however it's a manual process; time consuming when dealing with numerous credit memos that, like invoices and bills could otherwise be imported; and are already being imported by other QBO users..  

 

Whomever reads this comment; kindly use the gear>feedback to voice your concern to whomever reads them at the other end; hopefully someone hears us and implements this basic function.

 

Thanks

 

 

 

Fiat Lux - ASIA
March 9, 2022

@myuserid2 

Prepare your Credit Memo data with tthe following template

RefNumberCustomerTxnDateLocationClassBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgBillEmailCurrencyExchangeRateShipAmtShipItemDiscountAmtDiscountRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
CM101Janice Johnson#########  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingCustomer Memo[email address removed]  12Shipping 0.02   MP3 PlayerBlue MP3 Player255  TAX
CM101Janice Johnson#########  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingCustomer Memo[email address removed]  12Shipping 0.02   Leather CaseLeather Case210  TAX
CM101Janice Johnson#########  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingCustomer Memo[email address removed]  12Shipping 0.02   Gift CardsGift Cards25  TAX
CM102Leonard Walker Inc#########  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Customer Memo[email address removed]         HandheldsPortable Game Player1100  TAX
CM102Leonard Walker Inc#########  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345   [email address removed]         Software1 Year Warranty125  TAX
CM102Leonard Walker Inc#########  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345   [email address removed]         Extended Warranty1 Year Extended Warranty15  TAX
CM103Lisa Smith#########  19 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256   [email address removed]         Gift Certificate$50 Gift Certificate150  NON
CM103Lisa Smith#########  19 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256   [email address removed]         Magazine SubscriptionAnnual Magazine Subscription212  NON

 

then utilize an importer tool for the time being

https://transactionpro.grsm.io/qbo