Recurring Journals
  • 7 Minutes to read
  • Dark
    Light
  • PDF

Recurring Journals

  • Dark
    Light
  • PDF

Article summary

Recurring Journal Entries are those that will not vary across time. They can be automated and consistently applied for each period within the process.


Below are the functionalities available for recurring journals.

Add a Recurring Journal

Create Recurring Journals to repeat the same entry every accounting period. For example, if a user has an annual expense (such as rent), the expense can be accrued in twelve equal payments every month with a Recurring Journal entry. The user can accrue rent for the current period, which will be paid in the following period.

  • Rent Expense: $100,000
  • Rent Payable: $100,000

In this case, a debit and credit to the appropriate segment intersections will be created every month. Another example is a trucking organization that depreciates the value of their trucks every period by 10 percent. Or, accruals for utilities, telephone, property taxes, interest, or commissions.

Perform the below steps to add a recurring journal:

  1. Navigate to the Consolidation Control Panel, and select Scenario, Period, Entity. 
  2. Click the Recurring Journals Process.
  3. In the center pane, click Add to launch the Add Journal page.
    rec add
  4. Enter a Code and Name of choice.
    code rj
  5. Select the Period for the journal entry.
  6. Select Posting Type. By default, for the Posting Type, YTD (year to date) is displayed.
    Note:
    MTD evaluates entries based on the month’s activity whereas YTD evaluates the entries based on the cumulative balance for the line items.
  7. Select a common currency or local currency for reporting purposes (Adjustments CC or Adjustments LC).
    Note:
    A local currency is often used by a company's subsidiaries and then converted to a common currency for consolidated reporting purposes.
  8. Click Add to add a line item.
    add rj
    Note:
    Segment columns displayed are based on application configuration and user security. The Total field displays the Total Debit/Total Credit amount for the entire column as well as the running variance column. Validations exist to ensure that the entry is balanced before saving.
  9. To move several rows of journals, drag and drop each row to the correct place on the grid.
    • Duplicate Row - duplicate a current line, including; the description, segment selections, and debit/credit values. When a line is duplicated the new line is placed, in edit mode, directly below the line selected for duplication.
    • Copy/paste line items from an Excel spreadsheet into the Journal Entry grid. Copy/paste all values including; description, segments, and debit/credit. Use shortcut keys (Ctrl+C, Ctrl+V).
    • Segments - Columns displayed are based on application configuration and user's security.
    • Total - Displays the Total Debit/Total Credit amount for the entire column as well as the running variance column. Validations exist to ensure that the entry is balanced before saving.
      save rj
      Note:
      Use the auto-complete feature to select segment members quickly. Start typing a code if known, and the list of available members will be automatically filtered based on the letter or number entered.
  10. Click Save.

Upload a Recurring Journal

Upload Recurring Journals in xlsx format directly to the Consolidation module. Use the sample template (that can be downloaded) for ease of use when performing the upload.

Note:
The user must download and use the sample templates as they are journal-specific. For example, the user can’t use the Standard Journal template to upload Dynamic Journals.

Perform the below steps to upload recurring journals:

  1. Navigate to the Consolidation Control Panel and select Scenario, Period, Entity. 
  2. Click the Recurring Journals process.
  3. If no Recurring Journals were created or uploaded then this pane will be blank. The user can opt to upload or enter journals or do a medley of both. Click the Recurring Journals Upload icon shown below.
    upload rj
  4. The Recurring Journals Upload dialog appears. It is best practice to use the sample Excel template, as it demonstrates exactly how journal data needs to be organized for successful loading. Click Download sample Excel template.
    download sample rj
  5. The template is downloaded in the computer. Open the template.
  6. The template displays and indicates the required fields. It also provides information to ensure the correct data is entered where needed.
    imagea3jz123hz1239uz123678931.png

  7. Enter a Journal Code, the period for loading the journals, and the posting type.
  8. Enter Adjustments (CC) or Adjustments (LC) for reporting and enter notes as needed.
  9. Now, the journal data is ready for copy and paste into the spreadsheet. Before copying and pasting data to the Excel file, ensure to delete all the tips.
  10. Save the xlsx file to the computer.
  11. Back in the Consolidation Control Panel, click Choose File.
    choose rj
  12. Select the file saved to the computer and click Submit. Once processing is complete, the uploaded Recurring Journal will appear in the center pane.
  13. If the file fails to upload, download the failed file to view the cause(s) of the failure, fix the file, and upload again.

Edit a Recurring Journal

Perform the below steps to edit a recurring journal:

  1. In the Consolidation Control Panel, under Processes, click Recurring Journals
  2. Select the checkbox beside the journal to enable the Edit option.
    edit rj
  3. Click Edit. The Edit Recurring Journal dialog appears.
  4. Edit as needed.
    Note:
    The user can also use Add Row, Delete Row, and Duplicate Row to add a new entry, delete an entry, or copy an existing entry.
    add edit copy
  5. Click Save to save the changes and to exit the Edit Recurring Journal dialog.
    edit rj 2

Copy a Recurring Journal 

Perform the below steps to copy a recurring journal:

  1. Navigate to the Consolidation Control Panel, and select Scenario, Period, and Entity
  2. Under Processes, click Recurring Journals. 
  3. Select the desired Recurring Journal and click Copy.
    copy(2)
  4. Select Single Copy. The Copy Recurring Journal dialog appears.
    Note:
    The user can also copy recurring journals from one scenario to another using the Copy Multiple option. Perform the below steps to do so:

    1. Select Copy Multiple. The Copy page appears.
    2. Enter a Code and Name and select period dates.
    3. Select the Target Scenario.
      copy multiple
    4. Complete all selections based on the process being copied.
    5. Select the Email notification checkbox to receive an email notification when the process is completed. 
    6. Click OK.

    If the user selects multiple entries to copy, the Copy Single option will not be available.


  5. Complete all the fields. Changes can also be made to the existing Posting Type, Reporting, and Period here.
    copy rj
  6. Click Save.

Best Practices

It is a best practice to limit the number of copied journals and journal lines to a combined total of 30,000 (journals + lines). For example, 1000 journals with no more than 30 lines. Or, 60 journals; each of which has no more than 500 lines.

Delete a Recurring Journal

Perform the below steps to delete a recurring journal:

  1. In the Consolidation Control Panel, under Processes, click Recurring Journals. The Recurring Journals grid appears.
  2. Select the Recurring Journal to enable the Delete option.
  3. Click Delete.
    delete(7)
  4. In the confirmation dialog that appears, click OK. The Recurring Journal(s) will be deleted.
    delete rj
    All journals can be deleted together. In the image below, 7 Recurring journals are selected and available for deletion.
    delete all


Process a Recurring Journal Entry

Process a Recurring Journal when all the entries in a Recurring Journal are accurate and ready to be posted frequently for specific periods.

Process recurring journals for multiple periods with multiple processing options. Process one or all recurring journals and create, overwrite, and post standard journals while processing these journals for multiple periods. 

Let’s understand this with an example:

In the Recurring Journal tab, select the Bonus UK journal. Click on the process action, the Process Recurring Journals dialog box pops up.
New_1(1)

This journal can be processed for multiple periods, for example, Jan-23 to March-23. Along with multiple period processing, it is possible to select the Create Standard Journals, Overwrite Standard Journals, and Post Standard Journals processing options, or select all.New_2

This process will create relevant standard journals, post those standard journals, and overwrite the standard journals in case they have already been processed but not posted.

Perform the below steps to process recurring journals:

  1. Navigate to Consolidation Control Panel > Processes > Recurring Journals.
  2. Select one or all Recurring Journals and click Process.RJ_MP1


    Or
    New_3
  3. In the Process Recurring Journals dialog box, select From and To period.
  4. Select either one or a combination of these processing options:
    • Create Standard Journals: This option processes recurring journals for a selected period and creates respective Standard Journals.
    • Overwrite Standard Journals: This option processes recurring journals for a selected period and overwrites the standard journals with status not posted.
    • Post Standard Journals: This option posts the standard journals created while processing the recurring journals.
      RJ_MP2
      Or
      New_2
  5. Click Process.
  6. The ADC task is triggered and the user will receive a notification once the processing is complete.

In the Standard Journals screen, standard journals created and posted for the respective period can be seen.

Note:
Only users having full access to Standard Journals can select the Post Standard Journals processing option.
Export as Excel

Click Export as Excel to download the recurring journal Excel report.
export 1


Print

Click Print to print out the recurring journals list.
print rj


Apply Filter

Click Apply Filter to filter out journals based on Code, Name, Reporting, Posting Type, and Period.
apply filetr



Was this article helpful?