Understanding year-to-date data
Standard lines and intercompany lines can both be specified in either periodic or year-to-date format. Worksheet detail lines do not support year-to-date data entry.
Saved data is always stored as periodic amounts in the database regardless of the account type. Depending on the account type, the value specified is either first converted into a periodic amount and then saved to the database (profit and loss data) or it is stored as a periodic amount without being converted (balance sheet data).
Profit and loss data
When profit and loss amounts are specified in year-to-date amounts, the following rules are used to convert the data into periodic amounts to store in the database:
Year-to-date values are converted to periodic values as follows:
Periodic Stored Value = (YTD value specified) - (sum of
reported periodic values in prior periods)
For data specified in the first period of the fiscal year, the periodic value stored in the database is the same as the year-to-date value entered.
The selected Period dimension member determines the leaf period level for the calculation of the sum of the periodic values in prior periods for the conversion formula.
Balance sheet data
Balance sheet data behaves differently from profit and loss data, because balance sheet amounts are point-in-time amounts; therefore, year-to-date amounts should always be specified regardless of the selected Accumulation Method dimension member. Balance sheet amounts are stored as specified. They are not converted to periodic values.