Import Chart of Accounts

Follow

Before you start importing your Chart of Accounts, please ensure you have created any relevant Divisions in Zipi. This will allow Zipi to assign (if applicable) any Division-specific ledger accounts upon import.

  1. Go to Company > Data

    blobid0.png

  2. This takes you to the Data page

    blobid1.png

  3. Click the Import/Export dropdown at the top right of your screen and click Import

    blobid2.png

  4. Click Chart of Accounts

    blobid3.png

  5. This will take you to the import wizard

    blobid4.png

  6. You can import data from the following file types:
    • .csv
    • .txt
    • .tsv
  7. The data does not need to be in any particular order, you just need to ensure that you have one record per row
  8. Click Upload data from file to upload a file from your computer

    blobid5.png

  9. Once you have uploaded your file, you will be asked to identify any rows with headers in the file

    blobid6.png

    • Zipi will identify the first row as the header by default, if that is the case, you can click Yes and proceed to the next step

      blobid7.png

    • If your header row is different, you can click Select another row

      blobid8.png

      • This will allow you to select another row as the header row by clicking the radio button next to the row

        blobid9.png

      • Once you have selected the row, click Confirm to proceed to the next step

        blobid12.png

    • If you have no headers, click No header row to proceed to the next step

      blobid10.png

  10. The next step is to match the columns in your file to the available options in Zipi

    blobid11.png

    Note: Zipi only has the following columns:
    - Account Name
    - Account Type
    - Ledger Code
    - Description
    - Parent Name
    - Bank Account Number
    - Currency
    - Show in Expenses? Should this specific ledger account be available as an Account Type Expense. Choose Yes only for the expenses you want visible and No for the ones you do not. 
    - Accessible for All Divisions? Should this specific ledger account be visible and available for assignment to all Company Divisions. Choose Yes in all rows if you want every ledger account to be visible to all companies and divisions within your organization.
    - Accessible for named Company Divisions. Which Company Division(s) should be able to view or assign accounting entries to this specific ledger account. If you have Divisions created within your organization, you can choose which Division each ledger account will be assigned, unless you choose Accessible for All Divisions?

    Some of these columns are only available for certain account types. 

  11. You will see each column from your file represented as a table in this step

    blobid12.png

    Note: This table will only preview the first three rows of your file. 
  12. You will now match your columns to one of the columns in Zipi. To do that click the Lookup Matching Columns dropdown 

    blobid13.png

  13. Now choose the Zipi column from the dropdown

    blobid14.png

  14. The Confirm mapping button will allow you to save these mappings for future imports, meaning Zipi will remember that Account Name column in your file maps to the Account Name column in Zipi

    blobid15.png

  15. Repeat for all your columns
  16. If you have any columns that don't match the Zipi columns, you can ignore them in this step by clicking Ignore this column

    blobid16.png

  17. You will need to match the account types from your file to the account types in Zipi

    blobid17.png

  18. You can do that by selecting an account from the dropdown

    blobid18.png

  19. Once you have mapped your columns, click Review to move to the next step

    blobid19.png

  20. The next step allows you to review and if needed, modify your data

    blobid20.png

  21. Once the data has been modified, click Continue

    blobid21.png

  22. You will be asked to confirm your submission, click Yes

    blobid22.png

  23. Next, click Ok

    blobid23.png

  24. You will now see your imported file on the Data page with the Imported status

    blobid24.png

  25. Go to Company > Finance > Chart of Accounts

    blobid25.png

  26. You will see the imported products/services on the Chart of Accounts page

    blobid26.png

Comments

0 comments
Please sign in to leave a comment.