Search
Search Accounts Production Advanced Support Help and Support.

Import a nominal code list into Accounts Production Advanced

  1. Download our Limited Company Codes Excel file.
  2. Select the
    Import/Account Assignment
    tab.
  3. Select
    Import Wizard
    .
  4. Select
    Browse
    and choose the file you want to import.
    tip
    You 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.
  5. Select
    Next.
  6. 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 select
    Next
    .
  7. Match the Source Data to the Destination Fields:
    1. Drag and drop the
      Code
      column header from the Source Data section to the
      Account Code
      column of the Destination Fields section.
    2. Drag and drop the
      Description
      column header from the Source Data section to the
      Account Description
      column of the Destination Fields section.
    3. Select the
      Value 1
      column header in the Destination Fields section, then select
      Delete field
      .
    Example
  8. Select the
    Account Code
    column header in the Destination Fields section, then mark the
    Import account codes if zero value
    checkbox.
  9. Select
    Next
    , then
    Finish
    to import the list.
    You will get a warning that the
    Value
    column is not mapped but you can ignore it because this column is not required.