How to Import Chart of Accounts into QuickBooks Desktop using Dancing Numbers?

December 1, 2020

Importing your Chart of Accounts into QuickBooks Desktop is a crucial step in setting up or transitioning your accounting system. This guide will walk you through the process 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 simplifies the import process, making it quick and efficient. The tool supports multiple editions of QuickBooks Desktop, including:

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

Getting Started with Dancing Numbers

To begin importing your Chart of Accounts, 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.
  3. Once installed, you can access the tool directly through QuickBooks Desktop Apps.

Step-by-Step Guide to Importing Chart of Accounts

Follow these detailed steps to import your Chart of Accounts into QuickBooks Desktop using Dancing Numbers:

Step 1: File Selection

  1. Launch Dancing Numbers after installation.
  2. Click the “Import (Start)” button on the home screen to begin the process.
  3. Select “Chart of Accounts” as the type of data you want to import.
  4. Click “Select Your File” or “Browse File” to choose the Excel file containing your Chart of Accounts data.
  5. 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 and ensure all necessary information is included.

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 Chart of Accounts Import

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

  1. Name: The Account Name (text format).
  2. Account Type: The Category of the Account (text format).
  3. Account Number: A Unique Identifier for the Account (numerical format).
  4. Bank Account Number: The Associated Bank Account Number, if applicable (numerical format).
  5. Description: A Brief Description of the Account (text format).
  6. Opening Balance: The Initial Balance of the Account (numerical format).
  7. Opening Balance Date: The Date of the Opening Balance (format: MM/DD/YYYY).
  8. Currency Code: The Currency used for the Account (e.g., USD, CAD).

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 account names or numbers
    • Treatment of sub-accounts
    • Date format specifications
    • Currency handling for multi-currency setups

Best Practices for Chart of Accounts Import

To maximize the efficiency and accuracy of your Chart of Accounts import:

  1. Prepare Your Data thoroughly before Import:
    • Ensure all account names are unique and descriptive.
    • Verify that account types are consistent with QuickBooks categories.
    • Double-check opening balances and dates for accuracy.
  2. Use Consistent Formatting throughout Your Import File:
    • Stick to the recommended date format (MM/DD/YYYY).
    • Use standard currency codes (e.g., USD, EUR, GBP).
  3. Consider Your Account Numbering System:
    • If you use account numbers, ensure they are unique and follow a logical structure.
    • Leave the Account Number field blank if you don’t use account numbers in your system.
  4. Handle Sub-accounts Carefully:
    • Use a consistent method to indicate parent-child relationships in your import file.
    • Verify that all parent accounts are created before importing sub-accounts.
  5. Perform a Test Import:
    • Start with a small subset of your Chart of Accounts to verify the import process.
    • Review the results in QuickBooks Desktop before proceeding with a full import.
  6. Back up Your QuickBooks Company File:
    • Always create a backup before performing any large-scale imports.

Troubleshooting and FAQs

Q: Can Dancing Numbers handle multi-line transactions for the Chart of Accounts?

A: The Chart of Accounts import typically doesn’t involve multi-line transactions. Each account is imported as a single line item.

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. However, it’s always best to work from a backup of your QuickBooks company file.

Q: Does Dancing Numbers Support Importing Tax Information with the Chart of Accounts?

A: Yes, you can import tax-related information for your accounts, such as tax codes or tax agency assignments.

Q: What File Formats are Compatible with Dancing Numbers for Chart of Accounts import?

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

Q: How can I get help if I Encounter Issues during the Import Process?

A: You can contact Dancing Numbers support via email at support@dancingnumbers.com or visit their Support Center at https://www.dancingnumbers.com/support/ for assistance.

Conclusion

Importing your Chart of Accounts into QuickBooks Desktop using Dancing Numbers streamlines the setup or transition of your accounting system. This automated process significantly reduces manual data entry errors, saves time, and ensures accuracy in your financial structure.

A well-organized Chart of Accounts forms the backbone of your financial reporting system. By efficiently importing and maintaining your accounts, you set the stage for:

  1. More Accurate Financial Reporting
  2. Easier Tracking of Income and Expenses
  3. Simplified Tax Preparation
  4. Better insights into Your Business’s Financial Health

As you become more familiar with the import process, you’ll discover additional ways to optimize your Chart of Accounts and overall accounting workflows. Remember to periodically review and update your Chart of Accounts to ensure it continues to meet your business’s evolving needs.

Stay updated with the latest versions of both QuickBooks Desktop and Dancing Numbers to access new features and improvements that can further enhance your accounting processes.

Video Tutorials

close btn

Get Your Case Study

Call Now +1-800-596-0806
Top