The Financials templates are created based on the dimensionality of your application, and include any custom dimensions you added when you enabled features.

Depending on the features you've enabled, the following templates are available in the zip file:

• FinStmt Expense Data Load Template.csv
• FinStmt Expense Weekly Load Template.csv—use this template if you are planning at the weekly level
• FinStmt Revenue Data Load Template.csv
• FinStmt Revenue Load Weekly Template.csv—use this template if you are planning at the weekly level
• FinStmt Balance Sheet Load Template.csv
• FinStmt Cash Flow Direct Assumptions.csv
• FinStmt Cash Flow Indirect Load Template.csv

The templates have a placeholder for every enabled dimension; each dimension is defaulted to the NoMember member. Specify the appropriate dimension members for each record of data that you're loading. Use NoMember if the dimension is not applicable for a record of data.

For all templates other than FinStmt Cash Flow Direct Assumptions.csv, import data using these guidelines:

• Specify accounts in the rows in Column A and time periods vertically.

• Modify account dimension members in Column A to reflect renamed accounts.

• Time periods are in columns D-S (rows B - BA if you are planning expenses at the weekly level, rows C - BB if you are planning revenue at the weekly level). Delete columns for periods that you don't use.

• Modify the data in the Point of View column to identify where to import data:

  • OFS_Load—Data value to import

  • <Custom Dimension>—Any custom dimensions that you added when you enabled features.

  • OEP_No Entity—Member in the Entity dimension that identifies the departments in the business hierarchy to import data to

  • No Year—Year member

  • OEP_Actual—Scenario member

  • OEP_Working—Version member

  • USD—The exchange rate (for a multicurrency application)

• The Data Load Cube Name must be OEP_FS.

• For FinStmt Balance Sheet Load Template.csv, you can use BegBalance to accommodate the opening amount for balance sheet accounts.

For FinStmt Cash Flow Direct Assumptions.csv, import data using these guidelines:

• Rows

  • Identify Cash Flow Sources and/or Cash Flow Uses accounts in rows under Column A.

  • The first column is for the Account dimension. If the Account is renamed, make the corresponding update.

• Columns

  • Cash Flow Direct Assumption members are in columns B - F.

  • Column B sets the cash collection or cash disbursement terms you would like to set for the particular account.

  • Columns C-F set the cash collection or cash disbursements timing for the particular account. The values entered must equal 100% for the four columns.

• Point of View—identify where to load BegBalance, No Product, No Services, No Channel, No Customer, No Segment, OEP_No Entity, No Year, OEP_Plan, OEP_Working, USD

  • BegBalance—Cash flow Direct assumptions are loaded to BegBalance.

  • No Product, No Services, No Channel, No Customer, No Segment—Indicate the applicable custom dimensions that you set up when you enabled features. If you don't use custom dimensions, these members will not be seeded.

  • OEP_NoEntity—Member in the Entity dimension that identifies the departments in the business hierarchy to which to load data.

  • NO Year— Indicate the Year dimension member.

  • OEP_Plan—Scenario dimension member.

  • OEP_Working—Version dimension member.

  • USD—The exchange rate (for a multicurrency application).

• The Data Load Cube Name must be OEP_FS.

• For the first data import, run the rules required to process and calculate the data:Financials: Calculate Actuals, and Rollup.