Skip to main content

How to Import Multiple Chart of Accounts Records

Learn how to import multiple account records to your Chart of Accounts with Adam’s assistance.

Ibrahim A. avatar
Written by Ibrahim A.
Updated this week

If you have a large Chart of Accounts or want to migrate your account records from another system, Adam, your AI accountant, can help you upload multiple accounts in one go using a file. Whether it’s an image, PDF, Excel, or CSV, Adam will analyze your file and populate the Chart of Accounts Table accordingly.

Step-by-Step Guide

  1. Prepare your File

    • Before uploading, make sure your file includes all necessary details such as:

      • Account names

      • Account types (e.g., Asset, Liability, Expense)

      • Opening balances (if applicable)

      • Account codes (optional but recommended for structured accounting)

    • Your file can be in an Image, PDF, Excel (.xlsx/.xls), or CSV format. Ensure that it’s clear, well-structured, and legible. Adam reads both tabular and listed formats.

  2. Open the Prompt Area

    • Navigate to the Chart of Accounts Table.

    • Click the “Add Data” button at the top right to open the prompt input area.

  3. Attach your File

    • Inside the prompt modal, look for the attach icon, usually located near the message input box.

    • Click it and select the file you want to upload from your device.

  4. Write a Short Instruction

    • In the prompt field, provide a simple instruction to guide Adam. For example:

      • “Please upload all the accounts from this file into the Chart of Accounts.”

    • This helps Adam understand the context and purpose of the upload.

  5. Observe Upload Limits
    For optimal performance:

    • Send up to 20,000 characters per file (roughly 150 account entries).

    • For PDFs, limit to 10 pages per upload.

    • If your file is too large, split it into smaller chunks and upload them one after the other.

  6. Let Adam Process the Upload

    • After sending, Adam will begin analyzing the file.

      • Important: Do not close or refresh the page while the upload is being processed. It may take up to 5 minutes, depending on the file size and complexity.

  7. Review the Results

    • Once complete, your new account entries will appear in the Chart of Accounts Table. Review and confirm the accuracy of each record.

    • You can edit or delete any entry manually if needed.

Did this answer your question?