Importing Fund Assignments with Trial Balance

When importing a trial balance, you can include fund assignments by mapping a column in your file to the Fund Index field.

When to Use

Use this option when your source file includes fund information per account and you want to

streamline the account-to-fund mapping process.

Requirements

  • Funds must already exist in the engagement. To add funds, navigate to the Funds Setup page and add Funds under the Funds tab.

  • The fund assignment values in your file must exactly match the Index values of those funds.

  • If a fund index is missing or invalid, that account will be imported as Unassigned and must be corrected manually.

How to Import Fund Assignments

  1. Import the Trial Balance.

  2. On the Map step, locate the column in your file that contains the fund index values.

  3. From the dropdown above that column, select Fund index.

  4. Proceed through validation and complete the import.

Note: You can only assign funds that have already been created in the engagement. If needed, return to the Funds tab and add the missing fund before retrying the import.

Tips & Behavior

  • Fund Index values must match exactly.

  • Fund assignments can be reviewed on the Accounts tab in the Funds Setup page after import.