Uploading financial data

You can capture financial summary data by downloading and uploading a spreadsheet that is configured as an offline content form.

Before you begin

Define the fiscal periods and cost code structure for your organization. Configure offline content forms.

Procedure

  1. Go to Tools > Document Manager and open the TRIRIGA\Cost Item folder.
  2. Download the financial summary offline form.
  3. Complete the form and save it to your computer.
  4. Go to Tools > Data Utilities > Financial Summary DTO and select Add.
  5. Specify a name for the financial summary. Specify the content by uploading the financial summary offline form.
  6. Create the financial summary DTO.

What to do next

Run your company’s ETL Job Item to move the data from the Financial Summary record to the database.

When you are ready to process this Financial Summary DTO, find it in the Financial Summary DTO business object in the Job Manager and edit it and then process it.

The import is finished when the total found count is displayed at the top of the Line Items section. Compare this number with the number of records in your spreadsheet.

When the import is finished, the data is ready to be processed by the appropriate Load Financial Summary From Offline Staging Kettle Transformation ETL Job Item. The data is not represented in metrics until the ETL Job Item is complete.