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 33597

You May Also Like

  • Five Core General Ledger Accounts

    Five Core General Ledger Accounts

    Typically, the accounts of the general ledger are sorted into five categories within a chart of accounts. Double-entry accounting uses five and only five account types to record all the transactions that can possibly be recorded in any accounting system. These five accounts are the basis for any accounting system, whether it is a manual or an automated accounting system. These five categories are assets, liabilities, owner's equity, revenue, and expenses.

  •  Network Organizational Structures

    Network Organizational Structures

    The newest, and most divergent, team structure is commonly known as a Network Structure (also called "lean" structure) has central, core functions that operate the strategic business. It outsources or subcontracts non-core functions. When an organization needs to control other organizations or agencies whose participation is essential to the success, a network structure is organized.

  • Organizational Elements

    Organizational Elements

    McKinsey 7S Framework is most often used as an organizational analysis tool to assess and monitor changes in the internal situation of an organization. The model is based on the theory that, for an organization to perform well, seven elements need to be aligned and mutually reinforcing.

  • Introduction to Legal Entities Concept

    Introduction to Legal Entities Concept

    Modern business organizations operate globally and leverage a large number of registered legal entities, and operate through complex matrix relationships.  To stay competitive in the current global business environment, they must often develop highly diverse and complex organizational structures that cross international borders. Learn more about Legal Entities and their importance for businesses.

  • Organizational Design

    Organizational Design

    An organizational design is the process by which a company defines and manages elements of structure so that an organization can control the activities necessary to achieve its goals. Good organizational structure and design helps improve communication, increase productivity, and inspire innovation. Organizational structure is the formal system of task and activity relationships to clearly define how people coordinate their actions and use resources to achieve organizational goals.

  • GL - Inquiry & Drilldown

    GL - Inquiry & Drilldown

    An account inquiry is a review of any type of financial account, whether it be a depository account or a credit account. In this tutorial, you learn what we mean by drill through functionality in the context of the general ledger system. We will explain the concept of drill-down and how it enables users to perform account and transaction inquiry at a granular level and the benefits of using this functionality.

  • What are Management Entities?

    What are Management Entities?

    In this article we will discuss various types of "Management Entities". Various types of operational units, are created by management, to effectively run, manage and control their business. Different types of functional units, and divisional units, are widely used across industry.

  • Introduction to Organizational Structures

    Introduction to Organizational Structures

    Organizations are systems of some interacting components. Levitt (1965) sets out a basic framework for understanding organizations. This framework emphasizes four major internal components such as: task, people, technology, and structure. The task of the organization is its mission, purpose or goal for existence. The people are the human resources of the organization.

  • GL - Errors & Reversals

    GL - Errors & Reversals

    Explore the concept of journal reversals and understand the business scenarios in which users may need to reverse the accounting entries that have been already entered into the system. Understand the common sources of errors resulting in the reversal of entries and learn how to correct them. Discuss the reversal of adjustment entries and the reversal functionalities in ERPs.

  • Partnership Form

    Partnership Form

    When the quantum of business is expected to be moderate and the entrepreneur desires that the risk involved in the operation be shared, he or she may prefer a partnership. A partnership comes into existence when two or more persons agree to share the profits of a business, which they run together.

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

Subscribe to Our Newsletter


© 2023 TechnoFunc, All Rights Reserved