Are you looking for the automated process to batch import bills into your QuickBooks Online account? This article is what all about. The bills can be imported with multiple lines and have information in each line such as bill number, date, and supplier. You have to import the bills into QuickBooks Online to track your sales tax and other reports.
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.
Import bills Into QuickBooks online using Dancing Numbers Online software. this provides you with an automated process that helps you to save time and money that can be used anywhere else. The whole process is mentioned here and before that, you have to take care of the prerequisites that are required to run the software so that you can easily transfer your data without facing any kind of issues.
Things Required Before Starting the Bills 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.
What is the Process to Import Bills into QuickBooks Online using Dancing Numbers Online?
To process the Import procedure you have to connect the Dancing Numbers Online account to QuickBooks online. After that, you can start the process of importing data with an automated procedure by clicking on the Import button. The steps to process bills are as follows:
- Upload: Upload the Bills file that has all the data stored in a manner. The file must be an excel spreadsheet or a text file. Click on the Upload button and then Browse the file and then open it to upload it. Now proceed to the next step to continue.
- Mapping: When uploading is done correctly, map all the fields in a data file format so that you won’t lose any data or it won’t create any confusion or issues while or after importing.
- Import: Now, review the mapped data and make changes accordingly if required. Then click on the Import button to start the automatic import process.
You have to let it be done and do your own things side by side. It let you know by notifying you when done. In the case of any error or issues, it shows on your screen so that you can fix them and proceed with the import process.
Import Bills Fields in Dancing Numbers Online
|Bill No||21 Characters||Mention the Bill Number for the transaction done. This number is used internally by QuickBooks for processing internally. After that, QuickBooks auto-generates the new value and you can change it in the import settings.|
|Vendor||Characters||Mention the vendor’s name for the transaction done.|
|Bill Date||Date||The bill date is mentioned by the user after happening the transaction.|
|Due Date||Date||Provide the due date for the payment to remember when the transaction is due.|
|Terms||4000 Characters||Mention reference that is related Reference to the terms for the Bill.|
|Mailing Address Line 1||500 Characters||It is the first line of the Mailing address for the invoice.|
|Mailing Address Line 2||500 Characters||It is the second line of the Mailing address for the invoice.|
|Mailing Address Line 3||500 Characters||It is the third line of the Mailing address for the invoice.|
|Mailing Address City||255 Characters||Mention the city’s name for your Mailing address.|
|Mailing Address Postal Code||31 Characters||Mention the zip code for your Mailing address.|
|Mailing Address Country||255 Characters||Mention the name of the country for your Mailing address.|
|Mailing Address State||255 Characters||Mention the name of the state for your Mailing address.|
|Memo||4000 Characters||Mention a note that is related to the bill transaction.|
|Category Account||Characters||Reference to the Expense Account Name associated with the billing.|
|Category Description||4000 Characters||Free form text description of the Expense.|
|Category Line Amount||Decimal||Mention the category line amount in this field for the item.|
|Category Billable Status||Boolean||In the field if TRUE then it is Billable, If FALSE then it is Not Billable.|
|Category Markup Percent||Decimal||Provide the category markup value for the expense transaction.|
|Category Customer||Characters||Reference to the Customer associated with the expense.|
|Category Class||Characters||Mention the category class for the product.|
|Category Taxable||Boolean||It if it is TRUE that means you are taxable.|
|Line Item or Product/Service||Characters||If you have any references then mention them here.|
|Line Item Description or Product/Service||4000 Characters||Description of the Item. It will be populated from the Item description entered in QuickBooks Online.|
|Line Item Quantity or Product/Service Quantity||Decimal||In this field mention the quantity of product / service or item.|
|Line Item Rate or Product/Service Rate||Decimal||Write down the Line item or product / service rate.|
|Line Item Amount or Product/Service Amount||Decimal||Provide the Line item amount or the product / service amount according to the current price. The Total Amount of the Item. Not required if the Line Item Quantity & Line Item Rate is present.|
|Product/Service Expense Account||Characters||You have to provide the expense account name or number that you have used in the product creation.|
|Line Item Billable Status or Product/Service Billable Status||Boolean||If it is TRUE then it is Billable; If it is FALSE then it is Not Billable.|
|Line Item Taxable or Product/Service Taxable||Boolean||If you show it TRUE then apply the tax here.|
|Line Item Markup Percent or Product/Service Markup Percent||Decimal||Mention the line item markup value or percentage for the product or item.|
|Line Item Customer or Billable Customer: Product/Service||Characters||You have to provide the customer name for the item or product / service.|
|Line Item Class or Product/Service Class||Characters||Provide the class name for the item or product / service.|
|Location||Characters||You have to write the transaction’s location.|
|Currency Code||Characters||Mention the transaction’s currency code here.|
|Exchange Rate||Decimal||Provide the exchange rate of the currency you have for the home currency.|
Bills files are essential to make correct reports and track your payments that are paid or due. You have to properly import bills into QuickBooks Online using Dancing Numbers Online. If you are facing any issues then contact the Dancing Numbers Online helpdesk team via email email@example.com or do a live chat with experts.
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.
Frequently Asked Questions (Faqs)
Are there any Important Fields to be included in the Excel or Text File before Importing Bills into QuickBooks Online using Dancing Numbers Online?
Few fields that are required are mentioned here:
Line Tax Code
What can be Imported When You Import Bills into QuickBooks Online using Dancing Numbers Online?
Multiple line items can be easily imported.
The sales tax codes are mapped so you don’t have to change them for importing bills.
It supports multicurrency.
What if I have New Accounts or Suppliers in my Bill Transactions List? Can I Import Bills into QuickBooks Online using Dancing Numbers Online directly?
In this case, you are required to create or add the new account or supplier and then do process the import steps for transferring all the data properly.