Import Account Assignments

Digita Accounts Production Advanced allows you to import account assignments.

You will need a spreadsheet (xls or xlsx) or a csv file containing account codes in column A, category codes in column B and Debit/Credit/Always (or left blank) in column C. Ensure the accounts codes in the Excel spreadsheet are formatted as text to ensure the codes are an exact match. For example, 002.00 will appear as 2 if not formatted as text and the account will not be assigned.

Account assignments cannot be imported whilst there are existing assignments.

Assign an account as follows:

1. Select Financial Period | Configuration | Account Assignment to open the Account Assignment dialog. Alternatively, click one of the following links on the Import / Account Assignment tab:
   1. Account Assignment (Master) Maintenance or
   2. Account Assignment (Entity) Maintenance
2. Click Import to import an Excel spreadsheet or CSV file containing account assignments.
3. Navigate to the file you wish to import and click Open.
4. The import process attempts to assign account codes to the corresponding category codes.

Debit and credit values included in the source file (xls, xlsx or csv) are automatically assigned to the correct category.

To remove an erroneous assignment, right click on the account in the category structure and select Unassign. To reassign, drag and drop the account onto the correct category.

5. Click OK to close the dialog.