Before you Begin

This 20-minute hands-on tutorial shows you how to create year-to-date journals. The sections build on each other and should be completed sequentially.

Background

You can select the YTD_Input member for the View dimension in the Manage Journals point of view to create year-to-date (YTD) journals. When you select YTD_Input, you can post the journals as either YTD or Journal-to-Date (JTD).

If you post as YTD, you input journal line items as year-to-date values for movement rather than current period values. The system posts the YTD value to the movement member for the current period, and posts a reversal to the following period movement member. The values are posted to the Periodic member of the View dimension. For example, you enter a YTD value of 500 for Changes in Cash to your Jan FY20 Cash journal. When you post, 500 is posted to Changes in Cash, Jan, FY20, Periodic, and a reversal of -500 is posted to Changes in Cash, Feb, FY20, Periodic. When you post the YTD amount for Changes In Cash from your Feb FY20 Cash journal, the -500 reversal posted from Jan is applied, to calculate the current period movement for Feb. The value for the YTD member of the View dimension is aggregated from the Periodic values.

Note that if it it the last period of the year, a reversal in not posted to the first period of the following year.

If you post journals as JTD, you input in your line items the cumulative value for movement across all years, instead of the year-to-date movement for the current year. If it is the last period of the year, a reversal of the JTD value is posted to the first period movement of the following year. For example, if you post a JTD value of 1500 to Changes in Cash for Dec FY19 from the Dec, FY19 Cash journal, a reversal of -1500 is posted to Changes in Cash, Jan, FY20. This will be applied when the JTD value is posted from the Jan FY20 Cash journal, to calculate a correct periodic value for Jan FY20.

Note that YTD and JTD journals adopt a YTD "zero view" for periods for which journals are not posted; that is, if a journal is not posted to recognize the cumulative value for the current period, the cumulative value is assumed to be zero. The reversal posted to the current period by any prior period YTD or JYD journal aggregates with the prior period YTD value, resulting in a current period YTD value of zero.

If you post multiple journals to the same POV, the values are accumulated, not replaced, regardless whether the journals are YTD, JTD, or Periodic. For example, if you post 100 as the YTD value for Cash, Jan, FY20 from Journal A, and post 200 as the YTD value for Cash, Jan, FY20 from Journal B, the YTD value for the POV is 300.

What do you need?

  • Have Service Administrator access to EPM Enterprise Cloud Service. The instance should not have a business process created.
  • Note:

    An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.
  • Upload and import this snapshot into your Financial Consolidation and Close instance.
  • Upload and import this additional snapshot into your Financial Consolidation and Close instance to add the form used in this tutorial.

    Note:

    For more information on uploading and importing migration snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.
  • Save this compressed file locally and extract the journal load file (.jlf).

Creating year-to-date journals

Opening Periods

  1. From the Home page, click Application, and then Manage Periods.
    Manage Periods card
  2. In the POV, verify that Scenario is Actual and Year is FY18.
    Manage Periods
  3. In the Dec row, click the Actions icon and select Open to change the Period status to Opened.
    Open Period
  4. In the POV, click Years and select FY19 in the Select a Member dialog box. Click OK.
    Select a Member dialog
  5. Click Gp icon Go to update the POV.
  6. Repeat step 3 to change the status of January and February to Opened.
    Open Periods
  7. Click Home icon (Home) to go to the home page.

Creating YTD journals

  1. Click Journals to open the Manage Journals page.
    Journals card
  2. Click View in the POV to open the Select a Member dialog box and select YTD_Input.
    YTD Input Member
  3. Select FY18 for Year and Dec for Period and click OK to close the Select a Member dialog box. In the POV tool bar, click Go icon (Go).

    The POV for Manage Journals should now be set to Actual, FY18, Dec, YTD_Input

    Journals POV
  4. Click Create to start a new journal.
    Create button
  5. Enter the following journal details:
    • Label: Cash Adjustments
    • Journal Type: Regular
    • Data Source: Journal Input
    • Post As: Year-to-date
    Journal Detaisl
  6. Click Create to add a blank journal line item.
    line-item
  7. Enter the following member information. You can type the member names in the field or click the Action menu for the row and select Pick Members to browse the member hierarchy.
    • Entity: Legal Entity 0013 (GBP)
    • Account: Cash
    • Intercompany: No Intercompany
    • Movement: Changes in Cash
    • Multi-GAAP: Local GAAP
    • Movement: No Product
    Line-Item
  8. Click Create to add another journal line item. The member information is inherited from the existing line-item. Change the Account member in the new line-item from Cash to Bank1.
  9. Enter 100 in the Debit field for Cash and 100 in the Credit field for Bank1.
    Completed Line Items
  10. Click Save, and then click Close.
    Save button
  11. In the row for the Cash Adjustments journal, click the Actions icon and select Copy from the menu.
    Copy option
  12. In the Copy Journal dialog box, select Actual for Scenario, FY19 for Year, and Jan and Feb for periods. Click Copy.
    Copy Journal Dialog Box
  13. At the Information dialog box, click OK.
    Information dialog box

Posting Journals

  1. In the row for the Cash Adjustments journal, click the Actions icon and select Post from the menu.
    Post Journal
  2. In the Post dialog box, click Post.
    Post dialog box

    The status of the Cash Adjustments Journal on the Manage Journals page changes to Posted.

  3. In the Manage Journal POV, click Years. In the Select A Member dialog box, select FY19 for Year and Jan for Period, and click OK. Click Go icon (Go) to update the POV.

    The journal you copied to Jan FY19 displays in the list of journals.

    Manage Journals page
  4. Click Cash Adjustments to open the journal. Enter 350 in both he Debit field for Cash and the Credit field for Bank1, replacing the existing values.
    January line items
  5. Click Save.
  6. In the Actions menu in the upper right, select Post.
    Post option
  7. In the Post dialog box, click Post.
    Post dialog box
  8. Click Close to close the journal and return to the Manage Journals page.
  9. Click Data.
    Data card
  10. Open the Reference_Application folder and click YTD Journals.
    Forms list
  11. Review the journal data.

    The Periodic and YTD values for Jan FY19 are the same because it is the first period of the year. Notice that the YTD values entered for Jan were posted forward to Feb Periodic as reversals. YTD journals post a reversal to the following period if the following period is in the same year. The value for the YTD member for Feb is zero, due to the reversal posted to Feb from Jan. If YTD journal data has not been posted to a period, it is assumed the YTD value of journal data for that period is zero.

    Dec and Jan Journal Data
  12. Click the x on the YTD Journals tab at the bottom of the page to close the form.
  13. Click Journals to return to the Manage Journals page.
    Journal card
  14. In the Manage Journals POV, click Period. In the Select A Member dialog box, select Feb for Period and YTD_Input for View, and click OK. Click Go icon (Go) to update the POV.

    The journal you copied to Feb FY19 displays in the list of journals.

  15. Click Cash Adjustments to open the journal. Enter 500 in both the Debit field for Cash and the Credit field for Bank1, replacing the existing values.
    Feb Line Items
  16. Click Save.
  17. In the Actions menu in the upper right, select Post.
  18. In the Post dialog box, click Post.
  19. Click Close to close the journal and return to the Manage Journals page.
  20. Click Data.
    Data card
  21. Open the Reference_Application folder and click YTD Journals.

    The -350 reversal posted to Feb Cash from the Jan journal was applied to the 500 value posted to Feb Cash from the Feb journal to result in a Periodic value for Cash of 150 for Feb. The Jan and Feb Periodic values for Cash are aggregated to the 500 value in the Feb YTD member. Similar calculations were performed for Bank1.

    Feb journal data
  22. Click the x on the tab for YTD Journals to close the form.

Posting multiple journals

  1. Click Journals to return to the Manage Journals page.
    Journal card
  2. Click Actions, and then select Import.
    Actions Menu
  3. In the Journal Import dialog box, click Create.
    Create button
  4. Click Browse and browse to the location where you unzipped the journals import file. Select the file Journals Imports.jlf. Leave the other import options at their default values. Click Import.
    Job Details dialog box
  5. At the Information dialog box, click OK.
  6. Click Close twice to return to the Manage Journals page.
  7. In the Manage Journals POV, click View. In the Select A Member dialog box, select YTD_Input for View, and then click OK. Click Go icon (Go) to update the POV.

    The imported journal Feb Journal 2 YTD displays in the list.

    Journal list
  8. Click Feb Journal 2 YTD to open the journal, and review the contents.

    The Post As type is YTD, and the journal debits Cash 1000 and credits Bank1 1000.

    February journal data
  9. In the Actions menu in the upper right, select Post.
  10. In the Post dialog box, click Post.
  11. Click Close to close the journal and return to the Manage Journals page.
  12. Click Data.
    Data card
  13. Open the Reference_Application folder and click YTD Journals.
  14. Review the data in the YTD Journals form.

    The YTD value of 500 for Cash posted from the Cash Adjustments journal for Feb is combined with the YTD value of 1000 for Cash posted from Feb Journal 2 YTD, for a total value of 1500. The reversal of -350 that was posted to Feb Cash from the Jan journal is applied to the 1500 to calculate the periodic value of 1150. The value of 1500 for Feb YTD is aggregated from the Jan and Feb Periodic values. Similar calculations were performed for Bank1.

    February journal data
  15. Click x on the YTD Journals tab to close the form.

Posting journal-to-date journals

In this section you unpost the Dec FY18 and Jan FY19 YTD journals. You then enter JTD data in the Jan journal and re-post the journals as JTD.

  1. Click Journals to return to the Manage Journals page.
    Journal card
  2. In the Manage Journals POV, click Years. In the Select A Member dialog box, select FY18 for Year, Dec for Period, and YTD_Input for View, and then click OK. Click Go icon (Go) to update the POV.
  3. Click the Actions icon in the row for the Cash Adjustment journal and select Unpost.
    Unpost option
  4. In the Unpost dialog box, click Unpost to unpost the journal. The journal status changes to Working.
  5. Click Cash Adjustments to open the journal.
  6. For the Post As option, select Journal-to-date.
    JTD option
  7. Click Save.
  8. In the Actions menu in the upper right of the page, select Post.
  9. In the Post dialog box, click Post.
  10. Click Close to close the journal and return to the Manage Journals page.
  11. In the Manage Journal POV, click Years. In the Select A Member dialog box, select FY19 for Year and Jan for Period, and click OK. Click Go icon (Go) to update the POV.
  12. Click the Actions icon in the row for the Cash Adjustments journal and select Unpost.
  13. In the Unpost dialog box, click Unpost to unpost the journal. The journal status changes to Working.
  14. Click Cash Adjustments to open the journal. For the Post As option, select Journal-to-date.
  15. Change the year-to-date values to journal-to-date values by entering 450 in both he Debit field for Cash and the Credit field for Bank1, replacing the existing values.
  16. Click Save.
  17. In the Actions menu in the upper right, select Post.
  18. In the Post dialog box, click Post.
  19. Click Close to close the journal and return to the Manage Journals page.
  20. Click Data.
    Data card
  21. Open the Reference_Application folder and click YTD Journals.
  22. Review the journal data.

    The 100 for Cash posted by the Dec, FY18, JTD journal was also posted as a reversal of -100 for Cash to Jan, FY19. This was applied to the value of 450 posted from the Jan, FY19, JTD journal, for a Periodic value of 350. Because it is the first period in the year, the Periodic and YTD values for Jan FY19 are the same. Similar calculations were performed for Bank1.

    Dec and Jan Journal Data

Learn More