I've run a Trial Balance using the Excel Macro for CODA and some nominal accounts aren't appearing. Why?

To solve this problem, use the CODAXREF program:

  1. Run CODAXREF:
    $ RUN EASYSOFT_SQL_SYSTEM:CODAXREF
    Easysoft CODA Cross Reference Version 1.4 (Build XXX : Release)
    Copyright (c) 1993-2000 by Easysoft Limited, Wetherby, United Kingdom.
    All Rights Reserved.
  2. Enter the catalog directory (either the logical or physical directory), and administrator's password:
    Catalog Directory : EASYSOFT_SQL_CODA_CATALOG
    Catalog User : ADMIN
    Catalog Password :
    Companies available : COMPANY * (ALL)
  3. Enter the Company you want, or use * for all companies.
    Company : *
    Processing files in directory DKA0:[IAS.V730.GROUP.COMPANY]
    0 25 50 75 100 (% Complete)
    #########################
    Validation Statistics
    
    Balance records read : 272
    Valid Nominal records read : 19
    Valid Subaccount records read : 104
    Valid Level3 records read : 120
    Duplicate Balance records : 29
    Deleted Balance records : 0
    Cross-ref. records written : 243
    
    Sequential file successfully written
    
    Converting to Indexed.....
    
    Indexed file successfully written
    
    ELAPSED: 0 00:00:03.14 CPU: 0:00:00.91 BUFIO: 146 DIRIO: 279 FAULTS: 52
  4. Press Return to exit the routine or select more companies:
    Select Company :
    Company :