Importing Data from ASCII files

This option requires that the active Strategic Finance file or template has a time period in common with the data in the ASCII file that is being imported.

  To import data from an ASCII file:

  1. Open the target Strategic Finance file and make it the active window.

  2. In the Strategic Finance file, create the same time-period structure as that in the ASCII data file.

    Note:

    Time periods need not be identical.

    For example, your file may contain five years—two historical and three forecast—and your ASCII file may contain two years of history. On import, Strategic Finance matches the historical periods based on their period labels.

  3. Select File, then Import, then From an ASCII file... to open Import File.

  4. In Import Files of Type, select ASCII files.

  5. Select the ASCII file to import and click OK.

    Strategic Finance transfers the output values into the current data file. The inputs are back-calculated based on your forecast methods to generate a relational model that justifies the output values. After the data is in the Strategic Finance file, you can save, display, and print the financial statements to check your work.

    Strategic Finance transfers data from the ASCII file to the data file by matching the account number or names, whichever is provided in the ASCII file for import.