How to 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.

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 Name	Format	Description
No.	21 Characters	Mention 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.
Customer	Characters	Mention the customer name in this field.
Date	Date	Provide the date of the transaction for which you make the credit memo.
Memo	4000 Characters	It is the private note of the organization for the transaction. This memo note won’t be visible by default on your transaction records.
Shipping	Decimal	For your transaction, provide the shipping amount here.
Sales Tax Code	Characters	Mention the sales tax code that is related to this transaction.
Sales Tax Amount	Decimal	Write the Sales tax amount that is related to the credit memo transaction.
Discount Amount	Decimal	Here 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 Percent	Decimal	You 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 Account	Characters	Mention the discount account here.
Service Date	Date	Your service date from when the service is performing.
Product/Service	Characters	Mention the product / service name that you are taking.
Product/Service Description	4000 Characters	Write about the product / service you have taken.
Product/Service Quantity	Decimal	Mention the quantity of the product / service in numbers.
Product/Service Rate	Decimal	Mention the rate of your product or service you are assigning a credit memo for.
Product/Service Amount	Decimal	In this field, mention the total amount of your product / service for which you are creating a credit memo.
Product/Service Taxable	Boolean	In this field, if it’s true then you have to mark the line amount for tax calculation.
Product/Service Class	Characters	Mention the class name that is associated with this line.
Print Status	Boolean	This shows the print status.
Email Status	Boolean	This shows the Email status.
Message displayed on	1000 Characters	This shows the user-entered message to the customer and this message is visible to the end-user on the transactions.
Location	Characters	If the location is provided or you can enter the location here.
Email	100 Characters	Mention the Email address and the format for this must be in RFC 822 standard.
Apply Tax After Discount	Boolean	In 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 Characters	Mention the custom field name here.
Custom Field Value (1)	31 Characters	Mention the custom field value here.
Custom Field Name (2)	15 Characters	Mention the custom field name here.
Custom Field Value (2)	31 Characters	Mention the custom field value here.
Custom Field Name (3)	15 Characters	Mention the custom field name here.
Custom Field Value (3)	31 Characters	Mention the custom field value here.
Currency Code	Characters	Write the currency reference where the amounts are expressed on the associated transactions.
Exchange Rate	Decimal	In 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@dancingnumbers.com or LIVE CHAT to help in resolving issues or help you to easily do the import process.

---