export chart of account quickbooks desktop

Export QuickBooks Desktop Chart of Accounts

By Nicole Lewis
AD

Exporting your chart of accounts in QuickBooks Desktop is a crucial process, especially when you want to use it as a starting point for a new company file or need to share your accounting structure with an accountant or bookkeeper. Understanding how to do this accurately and efficiently can save you time and ensure the consistency of your financial records.

Before we delve into the step-by-step process, let's clarify what the chart of accounts is. It's essentially a formal, organized list of every account in your general ledger, categorized into groups like assets, liabilities, equity, revenue, and expenses. Each account represents a specific aspect of your business, such as cash on hand, accounts payable, retained earnings, sales revenue, or advertising expenses.

Preparing to Export Your Chart of Accounts

Before exporting, ensure that your chart of accounts in the source file is up-to-date and accurate. You wouldn't want to export and replace information in your target file with outdated or incorrect data.

AD
How To Set Up a Chart of Accounts in QuickBooks Online
How To Set Up a Chart of Accounts in QuickBooks Online
Export Chart of Accounts Quickbooks Desktop | Odoo Express
Export Chart of Accounts Quickbooks Desktop | Odoo Express
How to Export the Chart of Accounts From QuickBooks with Dancing Numbers?
How to Export the Chart of Accounts From QuickBooks with Dancing Numbers?

Here are a couple of housekeeping tasks to complete before proceeding:

Review and Update Your Chart of Accounts

Take a close look at the accounts in your chart. Make sure each account name is clear, concise, and accurately represents the aspect of your business it tracks.

QuickBooks Desktop Chart of Accounts - Complete Tutorial
QuickBooks Desktop Chart of Accounts - Complete Tutorial
Convert from QuickBooks Desktop to Quicken
Convert from QuickBooks Desktop to Quicken
Copy or Transfer chart of accounts across multiple QuickBooks Desktop files
Copy or Transfer chart of accounts across multiple QuickBooks Desktop files

Ensure that your accounts are grouped categorically and that the order and balance of accounts within each group are correct. You can use the 'Sort By' dropdown in the 'Accounting' menu to reorder accounts alphabetically, by type, or by number.

Backup Your Company File

It's a best practice to backup your QuickBooks Desktop company file before performing any significant tasks, including exporting the chart of accounts. If something goes awry during the process, you can restore your data from the backup.

AD

To backup your company file, go to the 'File' menu, select 'Backup Company', choose the location where you want to store the backup, and click 'Save it now'.

Industry-Specific Chart of Accounts Templates for Bookkeepers & Small Businesses/Template Library
Industry-Specific Chart of Accounts Templates for Bookkeepers & Small Businesses/Template Library
How To Set Up QuickBooks Online: All About Chart of Accounts | Small Business Tips
How To Set Up QuickBooks Online: All About Chart of Accounts | Small Business Tips
QuickBooks Online Chart of Accounts Template, Small Business COA Spreadsheet, CSV Import Ready, CPA-Created Bookkeeping Setup
QuickBooks Online Chart of Accounts Template, Small Business COA Spreadsheet, CSV Import Ready, CPA-Created Bookkeeping Setup
QuickBooks Accountant Desktop: Review for Accounting Firms
QuickBooks Accountant Desktop: Review for Accounting Firms
Smart, Simple Accounting & Bookkeeping Software | QuickBooks UK
Smart, Simple Accounting & Bookkeeping Software | QuickBooks UK
Get the Most out of your Chart of Accounts - Small Business Sarah
Get the Most out of your Chart of Accounts - Small Business Sarah

Exporting Your Chart of Accounts

Now that you've prepared your source file, let's proceed with the export process. Remember, you can only export the chart of accounts from QuickBooks Pro, Premier, or Enterprise Solutions.

Here's a step-by-step guide on how to do it:

AD

Step 1: Open the Source Company File

Launch QuickBooks Desktop and open the company file that contains the chart of accounts you want to export.

Components of Chart of Accounts - QuickBooks Tip
Components of Chart of Accounts - QuickBooks Tip

Step 2: Access the 'wydc' Folder

This folder contains all the data in your company file, including the chart of accounts. To access it, follow these steps:

AD
  • On your computer's keyboard, press and hold the Windows key, then press 'R' (for Run). This will open a window where you can type commands.
  • In the 'Open' field, type ' renv c:\temp\exporters', replacing 'c' with the drive letter where your QuickBooks file is located. Press 'Enter'.
  • A window displaying the 'exportqb' folder will open. Go into this folder and double-click on the 'wydc' folder. You'll see a list of files and folders.

Step 3: Copy the 'Account.ii' File

Among the files and folders, locate the 'Account.ii' file (it might not have a '.ii' extension, but treat it like it does). Right-click on it and select 'Copy'.

Step 4: Paste the 'Account.ii' File into the Target Company File

Now, open the target QuickBooks Desktop company file where you want to import the chart of accounts. Repeat the process from Step 2 to access the 'wydc' folder in this file. Right-click, select 'Paste', and the 'Account.ii' file will overwrite the existing one, replacing it with the chart of accounts from the source file.

The correct replacement of the 'Account.ii' file should import your chart of accounts. Double-check to ensure everything is in order and that none of the accounts have lost their balance. If you're having trouble, check if all the information is entered correctly, or consider consulting a professional or QuickBooks support.

Embracing new technology and features in QuickBooks, like exporting charts of accounts, can streamline your accounting processes and make your day-to-day tasks more manageable. As your business grows and evolves, keep refining and updating your practices to maintain a clean and efficient financial record-keeping system. That way, you're always prepared for whatever comes your way, be it a growth spurt, audits, or tax season.

AD