Search
Search Accounts Production Advanced Support Help and Support.

Import a nominal code list into Accounts Production Advanced

Open your Practice Master template. You'll import all new nominal codes and account assignments into the template, then publish it to make them available to your clients.
The FRS 102 2026 template introduces new
Right of Use (RoU)
asset categories. To support these categories, import the RoU nominal codes, then import an account assignment file for each category structure.
important
Template releases don't add the new nominal codes or account assignments to your template. You'll import them yourself from the supplied files.
  1. Download the file you want to import:
    • Limited Company Codes Excel file, for a standard limited company nominal code list.
    • Right of Use (RoU) nominal codes ZIP file, for the RoU asset categories in the FRS 102 2026 template.
    • Save the ZIP file to your desktop and extract it. It contains
      RoU codes.csv
      and an account assignment file for each category structure.
  2. Select the
    Import/Account Assignment
    tab.
  3. Select
    Import Wizard
    .
  4. Select
    Browse
    and mark the file you want to import.
    tip
    You can import our Limited Company Codes Excel file, the
    RoU codes.csv
    file from the ZIP, or your own nominal code list. Your own list will need to use the same format as our Limited Company Codes file.
  5. Select
    Next
    .
  6. In the Header Rows section of the wizard, mark the 1st checkbox in Row 1 to remove column headers from the imported file.
  7. Verify that the account codes appear in the correct format, for example 540.03, then select
    Next
    .
  8. 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
      .
  9. Select the
    Account Code
    column header in the Destination Fields section, then set the following options:
    1. Mark the
      Import account codes if zero value
      checkbox.
    2. When you import the RoU nominal codes, also mark the
      Use imported accounts
      checkbox. If a prompt appears, select
      No
      .
  10. 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.
  11. Import the RoU account assignments. Complete this step only when you import the RoU nominal codes.
    1. Select the
      Import/Account Assignment
      tab.
    2. Select
      Account Assignment (Master) Maintenance
      .
    3. Verify that the
      Category Structure
      dropdown is set to
      Balance
      .
    4. Select
      Import
      , then select
      RoU Assignment Balance.csv
      .
    5. Select
      Apply
      .
    6. Repeat the import for each remaining category structure, selecting the CSV file that matches it. Each structure has its own account assignment file.
      • Format 1
      • Format 2
      • iXBRL Format 1
      • iXBRL Format 2
  12. Publish the updated master template.
Your clients get the new nominal codes and RoU category assignments when you publish the template.