How to Import Bills into QuickBooks Desktop Using Dancing Numbers

Importing bills into QuickBooks Desktop streamlines your accounting processes and saves valuable time. This comprehensive guide will walk you through the process of importing bills using Dancing Numbers, a powerful tool designed specifically for QuickBooks Desktop users.

Understanding Dancing Numbers

Dancing Numbers is a specialized software built exclusively for QuickBooks Desktop. It supports multiple editions, including:

• QuickBooks Desktop Premier
• QuickBooks Desktop Pro
• QuickBooks Desktop Accountant
• QuickBooks Desktop Enterprise

This versatility ensures that regardless of your QuickBooks Desktop version, you can efficiently import bills and optimize your accounting workflow.

Getting Started with Dancing Numbers

Before diving into the import process, you’ll need to acquire and install Dancing Numbers:

1. Visit the Dancing Numbers website to download a free trial of the software.
2. Follow the installation instructions provided on the website to set up Dancing Numbers on your system.

Step-by-Step Guide to Importing Bills

Follow these detailed steps to import your bills into QuickBooks Desktop using Dancing Numbers:

Step 1: File Selection

1. Launch Dancing Numbers after installation.
2. Click on “Select your file” or “Browse File” to choose the Excel file containing your bill data.
3. Alternatively, click “View Sample file” to access a pre-formatted template from Dancing Numbers.

Step 2: Data Mapping

Data mapping ensures that the information in your Excel file correctly corresponds to the appropriate fields in QuickBooks Desktop.

1. The Dancing Numbers template automatically maps the data fields, saving you time and reducing errors.
2. If you’re using a custom file, manually map each column to the corresponding QuickBooks field.
3. Pay close attention to required fields, marked with an asterisk (*) in the field descriptions.

Step 3: Review and Import

Before finalizing the import, review your data to ensure accuracy:

1. Click “Next” to access the preview screen.
2. Carefully examine the data to confirm all information is correct and properly mapped.
3. If you spot any errors, go back to the mapping step to make necessary adjustments.
4. Once satisfied with the preview, proceed with the import process.

Understanding QuickBooks Fields for Bill Import

To ensure a smooth import process, familiarize yourself with the key QuickBooks fields and their requirements:

1. Bill/Ref No* (Required): A unique identifier for each bill, limited to 20 characters.
2. Vendor* (Required): The bill’s vendor, which can be matched using various criteria (e.g., full name, company name, account number).
3. Currency: Specify the currency code for the transaction.
4. Date* (Required): The date of the bill transaction.
5. Bill Due: The due date for bill payment.
6. Terms: Payment terms for the bill (up to 31 characters).
7. Address Lines 1-5: Vendor address information, each line limited to 41 characters.
8. City, State, Postal Code, Country: Location details for the vendor.
9. AP Account* (Required): The accounts payable account for the bill.
10. Memo: Additional notes about the bill (up to 4095 characters).
11. Exchange Rate: The currency exchange rate, if applicable.
12. Expense Account* (Required): The expense account related to the bill.
13. Expense Amount* (Required): The amount of the expense line item.
14. Product/Service* (Required): The item or service being billed.
15. Product/Service Quantity: The quantity of the item or service.
16. Product/Service Rate: The unit price of the item or service.
17. Product/Service Amount* (Required): The total amount for the product or service line item.

Advanced Import Settings

Dancing Numbers offers advanced import settings to customize the process:

1. Access the Import Settings menu in the top right corner of the interface.
2. Customize options such as:
   • Handling of Duplicate Bill Numbers
   • Treatment of Multi-line Transactions
   • Auto-creation of Products and Services
   • Date Format Specifications

Troubleshooting and FAQs

Q: Can I import bills with custom bill numbers?

A: Yes, Dancing Numbers supports importing bills with custom bill numbers from your file.

Q: Does the software support multi-line transactions?

A: Yes, multi-line transactions are supported. Ensure you repeat the bill number for each line to group related transactions.

Q: What if I make a mistake during the import process?

A: Dancing Numbers provides a delete feature that allows you to undo imports partially or completely.

Q: Can I import bills with tax information?

A: Yes, the software supports importing tax information along with your bills.

Q: What file formats are compatible with Dancing Numbers?

A: Dancing Numbers supports Excel file formats, including .xls and .xlsx.

Best Practices for Bill Import

To maximize the efficiency and accuracy of your bill imports:

1. Regularly back up your QuickBooks data before performing imports.
2. Use the Dancing Numbers sample template as a guide for formatting your import file.
3. Double-check all mapped fields before finalizing the import.
4. Start with a small batch of bills to test the import process before processing large volumes.
5. Reconcile your accounts payable after importing to ensure all bills are accurately reflected.

Conclusion

Importing bills into QuickBooks Desktop using Dancing Numbers significantly enhances your accounting efficiency. By automating this process, you reduce manual data entry errors, save time, and maintain more accurate financial records. As you become more familiar with the import process, you’ll discover additional ways to streamline your accounting workflows, ultimately contributing to better financial management for your business.

---