Year-to-date data entry
You can specify data in year-to-date format, as well as in periodic format interactively through the web or Excel Services.
Year-to-date data entry is enabled through the view, by allowing writeback on the year-to-date (YTD) member of the Accumulation Method dimension. If the YTD member is selected, the data entered by the user is displayed as entered, but converted to periodic format for storage for profit and loss lines, or stored as entered for balance sheet line types. If Periodic member is selected, the values are displayed and stored as periodic. The details of YTD data conversion to periodic format are described below.
In the CTrain application, CT FDE Expenses demonstrates the appropriate view settings for a data entry view that enables YTD data entry.
Periodic data entry view
A typical data entry view allowing periodic data entry has writeback enabled for these dimensions:
| Dimension | Member name |
|---|---|
| Currency | Local |
| Rate Set | Untranslated |
| Adjusted State | Reported |
| Accum Method | Periodic |
YTD data entry view
A data entry view allowing YTD data entry has writeback enabled for these dimensions:
| Dimension | Member name |
|---|---|
| Currency | Local |
| Rate Set | Untranslated |
| Adjusted State | Reported |
| Accum Method | Year-to-date |
Reporting views that reference YTD data are reading YTD values stored in the database which is populated from the consolidation YTD process. Data entry views that reference YTD data are reading from values stored in the database in periodic format and calculating YTD data on the fly.
Worksheet detail lines do not support YTD data entry. When setting up YTD data entry, use templates and views that do not include worksheet detail lines. If you try to enter data into worksheet detail lines with the accumulation method set to YTD, you get an error indicating that an invalid member is selected.
Guidelines for converting data
YTD values that are returned to the user are calculated based on stored values that are Reported, in Local currency, Untranslated rateset, and Periodic values.
Data entry view - writeback
- Year-to-date values are converted to periodic data based on the selected period and the schedule line type.
- Schedule line types of PR, PE, and PS, which are profit and loss type lines, are converted from YTD to periodic.
- Schedule line types of BA, BL, BE, BS are not converted to periodic as these are balance sheet accounts. They are stored as entered.
- The selected input period
determines the leaf period level for periodic calculation. Since the user can
control the periods, the following examples illustrate the point:
- If the selected period is April, periodic data calculation is based on sibling periods of Jan, Feb, Mar, based on a calendar year. If it were a fiscal year running from Jul through Jun, for instance, April YTD includes Jul + Aug + Sep + Oct + Nov + Dec + Jan + Feb + Mar + Apr.
- If the selected period is Qtr3, periodic data calculation is based on sibling periods of Qtr1, Qtr2, etc.
- The conversion of YTD data to periodic is based on prior periodic values, not stored YTD values.
- YTD values are converted
to periodic values using the following formula:
Periodic Value = Entered YTD Value - Sum (Prior Period(s) Periodic Value(s)) - Since the first period has no prior periods, Periodic Value(s) = Entered YTD Value(s).
- Opening Balance Lines are an exception to these rules. Opening and Beginning Balance lines cannot be entered in a data entry view because they are pulled forward from previous periods.
Reporting view
YTD values in a reporting view come directly from the database. If the YTD values have not been created by the consolidation, there are no values returned from the database.