How to Import Credit Memo into QuickBooks Online using Dancing Numbers Online?

May 24, 2022

Import Credit Memo into QuickBooks Online using Dancing Numbers Online

The Credit memo is used to track all the credits that you used to send your credit to the customer. This way it becomes easy to keep track of it. It is also an essential thing to import into your QuickBooks account. So do automatic import credit memo into QuickBooks Online using Dancing Numbers Online. Implement the automatic process by just uploading the file of the credit memo. Also, provide the required information for the import process, and you are done. Let’s get started with the import process below after fulfilling the prerequisites.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Online. Utilize import, export, and delete services of Dancing Numbers software.

Pre-requisites that is Required Before Processing the Import Process

Connect QuickBooks Online to Dancing Numbers Online via QuickBooks AppStore. Just click on “Get App Now” to start using the Dancing Numbers Online application program. You can also start the 7 Days Free Trial if you are not subscribed for Dancing Numbers Online yet.

Steps to Import the Credit Memo list into QuickBooks Online using Dancing Numbers Online

Follow the process to implement the import process without any issues:

  • Upload: Upload the credit memo transaction file into the Dancing Numbers Online then continue to the next step.
  • Mapping: After uploading the file, map the fields of your file according to the QuickBooks file format and also remove the fields that are not required.
  • Import: Now, review the data of the file that you are importing known as a preview. When everything is ok then clicks on the Import button to start the automatic import process.

Dancing Numbers Online Credit Memo Fields

Field NameFormatDescription
 No.21 CharactersMention the transaction number here. This is used for internal processing by default and QuickBooks also autogenerates the new value. You can also change it using the import settings.
CustomerCharactersMention the customer name in this field.
 DateDateProvide the date of the transaction for which you make the credit memo.
Memo4000 CharactersIt is the private note of the organization for the transaction. This memo note won’t be visible by default on your transaction records.
ShippingDecimalFor your transaction, provide the shipping amount here.
Sales Tax CodeCharactersMention the sales tax code that is related to this transaction.
Sales Tax AmountDecimalWrite the Sales tax amount that is related to the credit memo transaction.
Discount AmountDecimalHere mention the discount amount that you applied on the invoice. You can mention the amount or the percentage also if specified as it overrides the amount.
Discount PercentDecimalYou have to provide the discount percentage here by which the amount is decreased, from 0% to 100%. If you want to mention 5.5% then write 5.5, not 0.055. You can mention the amount or the percentage also if specified as it overrides the amount.
Discount AccountCharactersMention the discount account here.
Service DateDateYour service date from when the service is performing.
Product/ServiceCharactersMention the product / service name that you are taking.
Product/Service Description4000 CharactersWrite about the product / service you have taken.
Product/Service QuantityDecimalMention the quantity of the product / service in numbers.
Product/Service RateDecimalMention the rate of your product or service you are assigning a credit memo for.
Product/Service AmountDecimalIn this field, mention the total amount of your product / service for which you are creating a credit memo.
Product/Service TaxableBooleanIn this field, if it’s true then you have to mark the line amount for tax calculation.
Product/Service ClassCharactersMention the class name that is associated with this line.
Print StatusBooleanThis shows the print status.
Email StatusBooleanThis shows the Email status.
Message displayed on1000 CharactersThis shows the user-entered message to the customer and this message is visible to the end-user on the transactions.
LocationCharactersIf the location is provided or you can enter the location here.
Email100 CharactersMention the Email address and the format for this must be in RFC 822 standard.
Apply Tax After DiscountBooleanIn this field, if false or null then you have to calculate the sales tax. After that, apply discount. But if true then subtract the calculated sales tax.
Custom Field Name (1)15 CharactersMention the custom field name here.
Custom Field Value (1)31 CharactersMention the custom field value here.
Custom Field Name (2)15 CharactersMention the custom field name here.
Custom Field Value (2)31 CharactersMention the custom field value here.
Custom Field Name (3)15 CharactersMention the custom field name here.
Custom Field Value (3)31 CharactersMention the custom field value here.
Currency CodeCharactersWrite the currency reference where the amounts are expressed on the associated transactions.
Exchange RateDecimalIn this field the 1 is the default. It applicable when the multi-currency is shown for the company. The home currency unit number is equal to one unit of the currency that is specified by the field of currency code.

Importing a credit memo is also important if you have given it to any of your customers whose invoice is open for any reason. So, upload the file of the credit memo then click on import to automatically import it into your QuickBooks Online using Dancing Numbers Online. Feel free to connect with the expert team via email at support@www.dancingnumbers.com or LIVE CHAT to help in resolving issues or help you to easily do the import process.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


What if I Miss any Credit Memo While Importing Credit Memos into QuickBooks Online using Dancing Numbers Online?

In this case, you are unable to track one of your open invoices whose credit memo data won’t import into your QuickBooks account. You can import it again using the same process.

How can I Check the Data before Importing to Know that I am Importing the Correct Data?

You can easily check it in the Preview step that came after mapping and before importing the data. In this you can check all the data and also can do changes as well. When you think that everything is good then imports the data into your QuickBooks Online account using Dancing Numbers Online.

Does it is Important that the Credit Memo File must be in Excel Format to Import Credit Memo into QuickBooks Online using Dancing Numbers Online?

Yes, It is important as Dancing numbers Online only supports Excel File formats. Such as .xlsx or .xls. If you have any other file format then first convert it and then import it.

close btn

Get Your Case Study

Call Now +1-800-596-0806
Top