GL - Journal Entry & Import

GL - Journal Entry & Import

This article explains the process of entering and importing general ledger journals in automated accounting systems. Learn about the basic validations that must happen before the accounting data can be imported from any internal or external sub-system to the general ledger. Finally, understand what we mean by importing in detail or in summary.

Recording Journals in General Ledger:

Journals can either be directly entered in General Ledger or can be imported from Sub Ledgers. Most of the journals are created along-with business transactions like sales, purchases, receipts, and payments and get recorded in respective sub-ledgers. As sub-ledgers generally capture data at a more granular level, the relevant accounting information must flow to the general ledger for posting and subsequent reporting. From sub-ledgers, they need to be imported to the general ledger for financial recording and reporting.

Journal Entries can also be created manually in General Ledger by entering all the relevant accounting information. ERPs can also automate certain types of Journal Entries like recurring, reversing, or allocating journals. In case of manual entry follow the steps and guidelines outlined in the Recording Journals tutorial.

Importing – Detail V/s Summarized:

While importing journals from Sub Ledgers, journals can be clubbed together for the same accounts and posted in General Ledger as summarized.  

Various general ledger systems provide the functionality to create Summary Journals which summarize all transactions for the same account, period, and currency into one debit or credit journal line. This results in fewer transactions in the general ledger systems and makes financial reports more manageable in size. In the case of summary journal users, lose the one-to-one mapping of detail transactions in the sub-ledger to the summary journal lines created by the import process. However most of the organizations use this feature as this prevents too many transactions in GL Accounts and transactions get clubbed based on category, type, or transaction source.

Using the drill-down functionalities available in most of the modern general ledger systems, users can still perform various review and analysis functions, as even if the system creates summary journals, it can still maintain a mapping of how Journal Import summarizes sub-ledger detail transactions from feeder systems into general ledger journal lines.

GL - Journal Entry & Import

Journal Import Validations:

ERP’s and automated accounting systems must have built in validations during the import process to ensure that the data is correct and complete. An effective Journal Import program should validate key accounting information before it creates journal entries in the General Ledger application to prevent errors and reconciliation efforts.

Given below are some of the common data validations that can happen during the GL Import process:

1. Suspense Posting:

Suspense posting puts the remaining amount in the suspense account in case the debits and credits of the journal are not matching. In case it is not required, Journal Import should reject all invalid lines that do not balance.

2. Duplicate Batch Name:

If the batch name is a unique field then Journal Import should ensure that a batch with the same name does not already exist for the same period in the General Ledger application. Similarly, it must also check to ensure that more than one journal entry with the same name does not exist for a batch.

3. Other Attributes:

Attributes that can be validated to ensure that journals contain the appropriate accounting data could be accounting books, period, source, currency, category, accounting date, reversal period, account validation, account code combinations, effective date, roll date, and any other required validations.

Import Using Excel:

In today’s accounting world, financial and operational data typically is stored in a variety of programs and formats. Excel is one of such tools, most widely used by the accountants! When accountants need to prepare a report based on data from various systems, the first step is to export the data into Excel. Many times accounting information is stored in chronological order in excels by the accountants, and examples include adjusting entries and recurring entries.

Benefits of using the excel upload feature are that it makes life much easier for data operator and accounts executives. The great flexibility of excel based application increases productivity and results in reduced training costs as most users are already familiar with the excel functionalities and also improves user acceptance for automated systems. The biggest benefit comes from the fact that excel upload can also work in disconnected environments.

Typically, most of the automated systems provide the functionality to import accounting data from Excel to the general ledger and create journals. Most ERPs provide the ability to upload journals using the MS Excel worksheet. You can create journals in Excel Template and upload directly to General Ledger.

Related Links

Creation Date Tuesday, 30 November -0001 Hits 18450

You May Also Like

  • Concept of Legal Entity

    Concept of Legal Entity

    A legal entity is an artificial person having separate legal standing in the eyes of law. A Legal entity represents a legal company for which you prepare fiscal or tax reports. A legal entity is any company or organization that has legal rights and responsibilities, including tax filings.

  • GL - Journal Entry & Import

    GL - Journal Entry & Import

    This article explains the process of entering and importing general ledger journals in automated accounting systems. Learn about the basic validations that must happen before the accounting data can be imported from any internal or external sub-system to the general ledger. Finally, understand what we mean by importing in detail or in summary.

  • Business Metrics for Management Reporting

    Business Metrics for Management Reporting

    Business metric is a quantifiable measure of an organization's behavior, activities, and performance used to access the status of the targeted business process. Traditionally many metrics were finance based, inwardly focusing on the performance of the organization.  Businesses can use various metrics available to monitor, evaluate, and improve their performance across any of the focus areas like sales, sourcing, IT or operations.

  • General Ledger - Advanced Features

    General Ledger - Advanced Features

    Modern automated general ledger systems provide detailed and powerful support for financial reporting and budgeting and can report against multiple legal entities from the single system. These systems offer many advanced functionalities right from journal capture to advanced reporting. This article will provide an overview of some advanced features available in today's General Ledgers.

  • 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 is a Business Eco System?

    What is a Business Eco System?

    The goal of a business is to generate capital appreciation and profits for its owners or stakeholders by engaging in provision of goods and services to customers within the eco system/framework governed by respective laws(local/international).  The eco system involves various entities that the business works with for delivery of a product or service.

  • 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.

  • Different Types of Organizational Structures

    Different Types of Organizational Structures

    Modern business organizations run multiple product and service lines, operate globally, leverage 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.

  • 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.

  • GL - Intercompany Accounting

    GL - Intercompany Accounting

    After reading this article the learner should be able to understand the meaning of intercompany and different types of intercompany transactions that can occur. Understand why intercompany transactions are addressed when preparing consolidated financial statements, differentiate between upstream and downstream intercompany transactions, and understand the concept of intercompany reconciliations.

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

Subscribe to Our Newsletter


© 2023 TechnoFunc, All Rights Reserved