Importing the line item report file

After you transfer the line item import file to the computer on which the Pillar application's data set is located, complete these steps to import the data in the Pillar application's budget report:

  1. In the Pillar application, retrieve the data set and select the module that contains the budget report to import the file.
    This list shows the modules:
    • Assets
    • Liabilities and Equity
    • Revenues
    • Expenses
  2. Add or retrieve the budget report to import line item data.
    Note: The report columns must match exactly the report column template assigned to the import report definition. You can view your import file in Excel, Notepad, or any other application capable of reading an ASCII file before importing it.
  3. From the File menu, use the Import command to import the line item import file.
  4. Specify these ASCII separators in the Pillar application's import form:
    • Field separator: comma (,)
    • Record separator: carriage return (CR-LF)
    • Quote: Double quotation mark (")
  5. Verify that the file has column headings if you included them in your report definition.