GL - Recurring Journal Entries

GL - Recurring Journal Entries

A “Recurring Journal” is a journal that needs to be repeated and processed periodically.  Recurring Entries are business transactions that are repeated regularly, such as fixed rent or insurance to be paid every month. Learn the various methods that can be used to generate recurring journals. See some examples and explore the generic process to create recurring journals in any automated system.

What is a Recurring Journal?

A “Recurring Journal” is a journal that needs to be repeated and processed periodically.  Recurring Entries are business transactions that are repeated regularly, such as fixed rent or insurance to be paid every month. Each accounting period the journal should have the same accounts but the amounts could be different. A recurring journal entry enables you to automate similar or repeating entries.  For users who need to post certain transactions frequently with few or no changes, it is an advantage to use recurring journals.

Recurring entries allow for common repeatable transactions to be saved in a template and created in multiple accounting periods upon request, making it unnecessary to retype the entire transaction thereby improving productivity. The Auto-generation of recurring accounting entries minimizes the occurrence of errors and omissions. Systems allow the generation of recurring entries at weekly, monthly, or any other frequency.

Characteristics of Recurring Journals:

  • Needs to be entered periodically

  • The same set of accounts are included every period

  • The same number of Journal Lines

  • Logic exists to define the line selection criteria

  • Simplifies the process of recording repetitive journal entries

  • Creates same journal entries with varying or same amounts in different accounting periods

Methods to Create Recurring Journals:

1. Same Account Combinations with no amounts:

This is useful when the same accounts need to be used every period however the amounts get changed every time. In this scenario, the template is defined with no amounts, and amounts are entered manually every accounting period for which the entry needs to be generated.

2. Same Account Combinations with fixed amounts:

This is useful when both accounts and amounts can be pre-determined. A good example of this scenario is fixed rent payable each month on a specific date. In this case, the template is defined with actual amounts, and journals are created and posted for relevant accounting periods.

3. Same Account Combinations with mathematical logic to calculate amounts:

This is useful when accounts can be pre-determined and amounts will be based on some logic or pre-defined formula. A good example of this scenario could be defining salesmen accounts as the pre-determined accounts. The commission is to be paid to these salesmen as a fixed percentage of sales made by each salesman during the month and sales for each salesman are recorded in separate accounts. A recurring journal can be defined that can look for the balance in respective sales accounts at the end of the period and automatically calculate the commission and create the required accounting entry for commission payable.

GL - Recurring Journal Entries

Examples of Recurring Journals:

This method works best for repeatable transactions. For example annual expenses that can be charged through twelve equal monthly entries such as, rent or insurance expense allocation or annual lease rentals. Each month 1/12th of the total annual expense can be debited and credited to the appropriate accounts and appear as the current month’s actual transaction. Users can benefit by creating a recurring entry for some of the business scenarios listed below:

  • Fixed Rent to be paid every month
  • Fixed Insurance to be paid every month
  • Leasing Payments
  • Amortization Expenses
  • Fixed Expenses
  • Payroll Expenses
  • Based on Usage – Like departmental allocation of rent based on space utilized
  • Depreciation
  • Allocations

Generic Process to Create Recurring Journals:

Users need to define recurring journal formulas for transactions that they want to repeat every accounting period, such as accruals, depreciation charges, and allocations. The formulas can be simple or complex but need to have some logic of ascertaining the amounts for each of the accounts that need to be repeated. Each formula can use fixed amounts and/or account balances and period-to-date or year-to-date balances from the current period, prior period, or same period last year. Given below is a generic process flow to define recurring journals:

  1. Define Accounts, Amounts or Formula or Logic
  2. Create Recurring Template
  3. Define the accounting periods for which the recurring journals need to be created
  4. Generate Journals by Running automated recurring journals creation program
  5. Enter missing data in case of Skelton journals – missing amounts
  6. Review, Edit, Approve and Post recurring journals

Allocations V/s Recurring Journals:

Recurring Journals are for transactions that repeat every accounting period as explained above and allocation Journals are for single journal entry using an accounting or mathematical formula to allocate revenues and expenses across a group of accounting dimensions like cost centers, departments, divisions, locations, or product lines depending upon usage factors.

Related Links

Creation Date Tuesday, 30 November -0001 Hits 33599

You May Also Like

  • Concept of Representative Office

    Concept of Representative Office

    A representative office is the easiest option for a company planning to start its operations in a foreign country. The company need not incorporate a separate legal entity nor trigger corporate income tax, as long as the activities are limited in nature.

  • Benefits of Automated GLs

    Benefits of Automated GLs

    The general ledger is the central repository of all accounting information in an automated accounting world. Summarized data from various sub-ledgers are posted to GL that eventually helps in the creation of financial reports. Read more to understand the role and benefits of an effective general ledger system in automated accounting systems and ERPs. 

  • Defining Organizational Hierarchies

    Defining Organizational Hierarchies

    A hierarchy is an ordered series of related objects. You can relate hierarchy with “pyramid” - where each step of the pyramid is subordinate to the one above it.  One can use drill up or down to perform multi-dimensional analysis with a hierarchy. Multi-dimensional analysis uses dimension objects organized in a meaningful order and allows users to observe data from various viewpoints.

  • GL -  Periods and Calendars

    GL - Periods and Calendars

    In some of the ERP tools, there are more than 12 accounting periods in a financial year. This article discusses the concept of accounting calendar and accounting periods. Learn why different companies have different accounting periods. Understand some of the commonly used periods across different organizations and the definition & use of an adjustment period.

  • The Accounting Cycle

    The Accounting Cycle

    Learn the typical accounting cycle that takes place in an automated accounting system. We will understand the perquisites for commencing the accounting cycle and the series of steps required to record transactions and convert them into financial reports. This accounting cycle is the standard repetitive process that is undertaken to record and report accounting.

  • Understanding Joint Ventures

    Understanding Joint Ventures

    A joint venture (JV) is a business agreement in which the parties agree to develop, for a finite time, a new entity and new assets by contributing equity. They exercise control over the enterprise and consequently share revenues, expenses and assets.  A joint venture takes place when two or more parties come together to take on one project.

  • GL - Unearned / Deferred Revenue

    GL - Unearned / Deferred Revenue

    Unearned revenue is a liability to the entity until the revenue is earned. Learn the concept of unearned revenue, also known as deferred revenue. Gain an understanding of business scenarios in which organizations need to park their receipts as unearned. Look at some real-life examples and understand the accounting treatment for unearned revenue. Finally, look at how the concept is treated in the ERPs or automated systems.

  • GL - Accrued Expenses

    GL - Accrued Expenses

    Accrued expenses, sometimes referred to as accrued liabilities, are expenses that have been incurred but have not been recorded in the accounts. Discuss the need to record accrued liabilities and why they require an adjustment entry. Understand the treatment for these entries once the accounting period is closed and learn to differentiate when the commitments become liabilities.

  • The Accounting Equation

    The Accounting Equation

    In this article we will help you understand the double-entry accounting system and state the accounting equation and define each element of the equation. Then we will describe and illustrate how business transactions can be recorded in terms of the resulting change in the elements of the accounting equation.

  • GAAP to STAT Adjustments

    GAAP to STAT Adjustments

    Understand what we mean by GAAP to STAT adjustments. This article discusses the different standards that are used for multiple representations of the financial results for global organizations. Understand the meaning of US GAAP, Local GAAP, STAT, IFRS, and STAT. Finally, understand why accounting differences arise and how they are adjusted for different financial representations.

Explore Our Free Training Articles or
Sign Up to Start With Our eLearning Courses

Subscribe to Our Newsletter


© 2023 TechnoFunc, All Rights Reserved