Import a nominal code list into Accounts Production Advanced
- Download our Limited Company Codes Excel file.
- Select theImport/Account Assignmenttab.
- SelectImport Wizard.
- SelectBrowseand choose the file you want to import.tipYou can import our Limited Company Codes Excel file or you can import your own nominal code list saved as an Excel file provided that it has the format as our Limited Company Codes file.
- SelectNext.
- In the Header Rows section of Step 2 of the Wizard, mark the first checkbox in Row 1 to remove column headers from the imported file, then selectNext.
- Match the Source Data to the Destination Fields:
- Drag and drop theCodecolumn header from the Source Data section to theAccount Codecolumn of the Destination Fields section.
- Drag and drop theDescriptioncolumn header from the Source Data section to theAccount Descriptioncolumn of the Destination Fields section.
- Select theValue 1column header in the Destination Fields section, then selectDelete field.
Example
- Select theAccount Codecolumn header in the Destination Fields section, then mark theImport account codes if zero valuecheckbox.
- SelectNext, thenFinishto import the list.You will get a warning that theValuecolumn is not mapped but you can ignore it because this column is not required.