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.
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 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. |
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@www.dancingnumbers.com or LIVE CHAT to help in resolving issues or help you to easily do the import process.
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.