Importing and Exporting Chart of Accounts in CustomBooks™

Importing and Exporting Chart of Accounts in CustomBooks™

Importing Chart of Accounts

You can import accounts to the Chart of Accounts (CoA) in CustomBooks™ in two ways:
  1. From the Company/Client List.
  2. From a file using the Data Import Wizard.

Importing from the Company/Client List

If you have another company or client with a fully set up Chart of Accounts, you can copy and import it into a newly set up account.

From the Setup Wizard: CoA Setup

If the account is newly set up and you're importing from the Setup Wizard.
  1. In the Accounting, Chart of Accounts (page 8), choose Import from Client List.
  2. Select the source company/client to import the Chart of Accounts (CoA) from, then click Next.
  3. Select the GL accounts to import, and click Next.
  4. Once the import is successfully completed, click Close to proceed.








From the Chart of Accounts:

  1. Open the Chart of Accounts by navigating to Accounting > Chart of Accounts.
  2. Click the More Actions dropdown, select Import, and then choose From Client List.
  3. Select the source company/client to import the Chart of Accounts (CoA) from, and click Next.
  4. Select the GL accounts to import, and click Next.
  5. Once the import is successfully completed, click Close to proceed.








Importing from a File Using the Data Import Wizard

If you have a custom Chart of Accounts that you'd like to use, the best way to import it is through the Data Import Wizard: Chart of Accounts.

​

We recommend using import templates to simplify field mapping and ensure a smooth import process. These templates act as a foundation for organizing your data before uploading it into the system. You can download or export the import templates from the Tab 2 (Data Relationships) window, or refer to the attachments included in this article.


From the Setup Wizard: CoA Setup

If the account is newly set up and you're importing from the Setup Wizard.
  1. On the Accounting, Chart of Accounts (page 8), choose Import from File.



  2. The Import Tool - Chart of Accounts window will pop up. Click Next to proceed.
  3. Click the Chart of Accounts button to select the data file from your computer.
  4. The Fields Mapping - Chart of Accounts window should pop up.
    • If you're using our recommended Chart of Accounts data import template, you can easily map the fields by the column headers, and the system will automatically map the fields. Click the Mapping drop-down in the yellow command bar at the top, then select Map by field by header.



    • Otherwise, you will need to manually map the fields. Double-click the fields within the CustomBooks™ fields column to map them.



      Additional Settings      :
      - Set the Enter Beginning Balance as of date.
      - Set and select the Default Chart of Accounts.

      Click the Save and Close button to save the field mapping and proceed.
  1. Next is the Chart of Accounts Mapping Preview. Review the data and the mapping, then click Import to Staging.
  2. On the Staging Data tab, the Data Import Wizard will verify and check for errors. Select all data, then click the Verify Staging Data button. If there are any errors, double-click the staging data to open and correct them (the error details will appear in the Error Description column). Once all data is verified, click Create CustomBooks™ Data to import the staging data into live CustomBooks™ data.



  3. On the Create Data tab, click the Import Staging Data into CustomBooks™ button to complete the import.



  4. Close the Data Import Wizard and return to the Setup Wizard.

From the Chart of Accounts

  1. Open the Chart of Accounts. Go to Accounting > Chart of Accounts.
  2. Click the More Actions dropdown > Import > then select From CSV File.
  3. The Import Tool - Chart of Accounts window will pop up. Click Next to proceed.
  4. Click the Chart of Accounts button to select the data file from your computer.
  5. The Fields Mapping - Chart of Accounts window should pop up.
    • If you're using our recommended Chart of Accounts data import template, you can easily map the fields by the column headers, and the system will automatically map the fields. Click the Mapping drop-down in the yellow command bar at the top, then select Map by field by header.



    • Otherwise, you will need to manually map the fields. Double-click the fields within the CustomBooks™ fields column to map them.



      Additional Settings      :
      - Set the Enter Beginning Balance as of date.
      - Set and select the Default Chart of Accounts.

      Click the Save and Close button to save the field mapping and proceed.
  1. Next is the Chart of Accounts Mapping Preview. Review the data and the mapping, then click Import to Staging.
  2. On the Staging Data tab, the Data Import Wizard will verify and check for errors. Select all data, then click the Verify Staging Data button. If there are any errors, double-click the staging data to open and correct them (the error details will appear in the Error Description column). Once all data is verified, click Create CustomBooks™ Data to import the staging data into live CustomBooks™ data.



  3. On the Create Data tab, click the Import Staging Data into CustomBooks™ button to complete the import.



  4. Close the Data Import Wizard and return to the Chart of Accounts.

Exporting Chart of Accounts

To export your Chart of Accounts:
  • Go to Accounting > Chart of Accounts.
  • Click Export List on the yellow command bar at the top.
  • Select the fields/columns you want to export.
  • In the CoA - Preview window, click the Export button and choose the desired format. The supported formats are .pdf, .xlsx, .xls, and .docx.





      • Related Articles

      • How to Setup the Chart of Accounts

        CustomBooks™ comes with a standard Chart of Accounts. You may add, change or remove these to suit your needs. You can import your own chart of accounts or you can even copy it from another client if you have more that one CustomBooks™ account. ...

      • The Chart of Accounts

        You can check these articles to know more about the CustomBooks™ Chart of Accounts : Charts of Accounts Overview Working with the Chart of Accounts Sample Chart of Accounts Importing and Exporting Charts of Accounts

      • Data Import Wizard

        Data Import Wizard If you are trying to import transactions into Cloud Banking, please see this article. The Data Import Wizard is a powerful tool and feature that enables users to efficiently bring external data into their system. With this tool, ...

      • Chart of Accounts Overview

        Chart of Accounts The Chart of Accounts is a listing of all the accounts in the general ledger, each account accompanied by a reference number. To set up a chart of accounts, one first needs to define the various accounts to be used by the business. ...

      • Data Import Tool - Lists

        Highlights Explore the new features of our rebuilt Data Import Tool for Lists. Import multiple data import types for Lists in the same import session, using one or many files - your choice! Example: Import Companies with it's related data types: ...