Accounts

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
    Screenshot of Step 3 of the Import Wizard. There are 3 sections: Source Data, Destination Fields, and Field Options. The Code and Description column headings from the Source Data have been dragged and dropped to the Account Code and Account Description headings of the Destination Fields section. The Value 1 column header of the Destination fields and the Delete Field button are highlighted to show that this column is to be deleted.
  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.

This article applies to:

  • Product: Digita Accounts Production Advanced
  • Subject: Import,Trial balance