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.
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
You May Also Like
-
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.
-
An allocation is a process of shifting overhead costs to cost objects, using a rational basis of allotment. Understand what is the meaning of allocation in the accounting context and how defining mass allocations simplifies the process of allocating overheads to various accounting segments. Explore types of allocations and see some practical examples of mass allocations in real business situations.
-
As the business grows, the company may want to transition to a branch structure as branches are allowed to conduct a much broader range of activity than representative offices. Branches can buy and sell goods, sign contracts, build things, render services, and generally everything that a regular business can do. A company expands its business by opening up its branch offices in various parts of the country as well as in other countries.
-
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.
-
Multi Currency - Functional & Foriegn
Currency is the generally accepted form of money that is issued by a government and circulated within an economy. Accountants use different terms in the context of currency such as functional currency, accounting currency, foreign currency, and transactional currency. Are they the same or different and why we have so many terms? Read this article to learn currency concepts.
-
Trial Balance in General Ledger
One of the greatest benefits of using a double-entry accounting system is the capability to generate a trial balance. What do we mean by trial balance? As the name suggests a trial balance is a report that must have its debits equals to credits. Understand the importance of trial balance and why it is balanced. Learn how it is prepared and in which format.
-
For any company that has a large number of transactions, putting all the details in the general ledger is not feasible. Hence it needs to be supported by one or more subsidiary ledgers that provide details for accounts in the general ledger. Understand the concept of the subsidiary ledgers and control accounts.
-
Global Business Services (GBS) Model
Global business services (GBS) is an integrated, scalable, and mature version of the shared services model. Global Business Services Model is a result of shared services maturing and evolving on a global scale. It is represented by the growth and maturity of the Shared services to better service the global corporations they support.
-
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 - 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.
