Importing GL account records

You can import GL account records into Storeroom, instead of manually creating a record. You must specify the data in a Microsoft Excel spreadsheet that is saved as a CSV file format. However, you can also use a text editor, such as Notepad, to create the file.

This table displays the format that is required for the file. You must specify each header name in the same order that it is displayed. These values are required to create a record:

  • accountKey
  • description
Column Header name Accepted data values
A accountKey String
B description String
C activeStatus True or false

* To import multiple values, use the pipe symbol (|) as a separator. For example, GL01|GL02|GL03.