Example of Subsidiary Ledgers

Example of Subsidiary Ledgers

In this article, we explain some commonly used subsidiary ledgers like accounts receivable subsidiary ledger, accounts payable subsidiary ledger or creditors' subsidiary ledger, inventory subsidiary ledger, fixed assets subsidiary ledger, projects subsidiary ledger, work in progress subsidiary ledger, and cash receipts or payments subsidiary ledger. 

Subsidiary Ledgers help manage and store specific information regarding each of the control accounts in your GL. Companies create subsidiary ledgers whenever they need to monitor the individual components of a controlling general ledger account. You can keep all the details in your sub-ledgers and post the summation for each account in the control account maintained at General Ledger.

Commonly Used Subsidiary Ledgers:

Some commonly used subsidiary ledgers are accounts receivable subsidiary ledger, accounts payable subsidiary ledger or creditors' subsidiary ledger, inventory subsidiary ledger, fixed assets or property or plant & equipment subsidiary ledger, projects subsidiary ledger, work in progress subsidiary ledger, and cash receipts or payments subsidiary ledger.

1. Accounts Receivable Subsidiary Ledger:

The accounts receivable subsidiary ledger is essential to most businesses and is used to manage sales of goods and services to customers and entering receipts for the sales made. Main transactions are recording of sales invoices and managing the receipts from the customers. It is also known as Customers Sub-Ledger or just AR Sub-Ledger. Companies may have hundreds or even thousands of customers who purchase items on credit, who make one or more payments for those items, and who sometimes return items or purchase additional items before they finish paying for prior purchases. Different customers may be subject to different credit terms and an organization might need to track these terms to raise reminders or due date invoices.

Recording all credit sales, sales returns, and part or subsequent payments in a single account would make it virtually impossible to calculate an individual customer's balance because the customer's transactions would be interspersed among thousands of other transactions belonging to different customers. Accounts receivable subsidiary ledger provides quick access to each customer's balance and account activity.

Companies maintain a list of invoices due from their customers, normally in the form of an accounts receivable aging register.  This provides them with a listing of all the outstanding and unpaid invoices due to their customers.  It also lets them know how old the invoices are, so they are aware of any past due items.

Balance in the “Account Receivable Control Account” in the general ledger will represent the total amount receivable from all the customers on a given date. In the ERP context, it is known as the Accounts Receivable (AR) Module.

2. Accounts Payable Subsidiary Ledger:

Accounts Payable Subsidiary Ledger is used to manage invoices from suppliers and payments to them against the purchases made. Main transactions are recording of invoices for purchases & managing the payments for these invoices. It is also known as Suppliers Subsidiary Ledger or Creditors Subsidiary Ledger.

Once the PO has been raised and against that material has been received, suppliers will raise invoices on the company for the payment due to them. Accountants enter individual invoices due to suppliers in the accounting system for later payment.  Suppliers usually offer the company payment terms, along with discounts for early payments. The company needs to track these payment terms for making effective use of its cash resources. All these invoices entered into the accounting system that has not yet been paid off make up the subsidiary ledger for accounts payable. 

Balance in the “Accounts Payable Control Account” in the general ledger will represent the total amount payable to all the suppliers/creditors on a given date. In the ERP context, it is known as the Accounts Payable (AP) Module.

3. Inventory Subsidiary Ledger:

Inventory Sub-Ledger is used to manage the inventory/stock or items that a company buys, sell,s, or manufacture. Inventory Ledger is also used to manage and track item cost and issue prices and movements of stock items due to trading transactions. It is also known as “Stock Sub-Ledger” and sometimes referred to as “Material Ledger”.

From the Inventory sub-ledger, one can get details of the quantity and cost price of any inventory item at any point in time. Manufactures, Retailers, and Wholesalers keep a record of in-stock inventory items so that they know what is available for sale or as a raw material for the subsequent manufacturing process.  This record normally contains a description of each item, quantity on-hand, the normal selling/issue price, and the cost of the item. The quantitative record is used periodically to conduct physical verification of the stock and account for any variances both positive and negative. Sales Returns and Purchase Returns are also recorded in the inventory sub-ledger.

Balance in the “Inventory Control Account” in the general ledger will represent the total cost of all inventory items in stock with the organization on a given date. In the ERP context, it is known as the Inventory Module.

4. Fixed Assets Subsidiary Ledger:

Fixed Assets Subsidiary Ledger is used to manage purchase, sale, allocation, and retirement of fixed assets. This is also known as “Equipment Subsidiary Ledger” or just the “Asset Register”. It is a very important to record for the companies that carry a large number of depreciable assets, each of which must be depreciated over a number of years.

The depreciation is recorded for each item in the Fixed Assets Subsidiary Ledger. This sub-ledger can include information about the acquisition, original cost and disposal of the item, residual value, the accumulated depreciation, and current book value. Fixed assets include items like equipment, plant, and machinery, office furniture, computer equipment, machinery, buildings, or land. Using Fixed Assets Sub-Ledger organization can get details of any fixed asset including original cost, current depreciated value, and location, etc. at any point in time.

Balance in the “Fixed Assets” control account in the general ledger will represent the total cost of all assets owned by the organization on a given date. When all of the depreciation taken is added together, the total should equal the general ledger balance in accumulated depreciation. In the ERP context, it is known as the Fixed Assets Module.
Example of Subsidiary Ledgers

5. Projects Subsidiary Ledger:

Certain companies like Real Estate Builders and Construction Companies undertake various independent projects. Many businesses of the same nature sometimes need to isolate and track financial activity associated with a particular project or event.  They need projects sub-ledger for storing, tracking, and reporting financial activity like capital budgeting, capital expenditure tracking, monitoring costs, isolating and reporting the labor and overhead costs, etc. that helps them understand their operational costs and profitability. In that case, a sub-ledger is required for each project.

Projects Sub-Ledger is used to track project milestones, costs, and resources and to make billing to the customers. From projects sub-ledger, you can get details of any project like percentage complete, current cost, etc. at any point in time.

This approach necessitates reconciliation of the project ledger with the general ledger because certain project-related costs might need to be posted to both the project ledger as well as general ledger and hence this can be a reconciliation of the project ledger's balances against the main financial ledger, or a reconciliation of the journals extracted from the financial ledger to those journals posted to the project ledger. 

Balance in the “Projects Control Account” in the general ledger will represent the total cost associated with a particular project on a given date. In the ERP context, it is known as the Projects Module.

6. Work in Progress Subsidiary Ledger:

Companies using a job costing system use their job cost sheets as a subsidiary ledger for the Work-in-Process Inventory account.  Construction contractors might also track the costs associated with each unit under construction separately in a subsidiary ledger. Similarly, manufacturers make use of the Work-in-Progress sub-ledger to keep track of the costs associated with work-in-process inventory for several different products being produced.

When the total costs incurred on all units are added together, the total should balance to the Work-in-Progress control account in the general ledger. In the ERP context, it is known as the Work in Progress (WIP) Module.

7. Cash Management Subsidiary Ledger

Cash Management subsidiary ledger is used to manage cash and its reconciliation with the bank. This ledger contains all cash receipts and payments, including bank deposits and withdrawals. This sub-ledger is periodically reconciled with the bank statements to ensure balances match and account for the missing transactions.

Maintaining a cash subsidiary ledger helps to reconcile and void payments generated in the accounts payable sub-ledger, reconcile accounts receivable and other bank transactions, record funds transfers between bank accounts, and enter cash receipt deposits.

Final Balance in the “Cash Sub-Ledger” will represent the final cash in hand in the general ledger on a given date. In the ERP context, it is known as Cash Management Module. In the case of an automated accounting system, this module also supports the automatic reconciliation of cash with bank statements and other integrated external sources which helps in reducing the volume of transactions requiring reconciliation.

8. Payroll Subsidiary Ledger:

In a company, payroll is the sum of all financial records of salaries for an employee, wages, bonuses, and deductions. In accounting, payroll refers to the amount paid to employees for services they provided during a certain period of time. The Payroll subsidiary ledger is used to process all types of payroll transactions for the purpose of computing and paying your salaried employees or time and labor-based contractors. Payroll subsidiary ledger is used to manage both salaries and wages. You can record calculations & payments made to each of the employees in this sub-ledger. The Payroll Sub-ledger captures the salary cost under different account heads as prescribed by the law based on the timecards submitted by the employees.

Maintaining payroll subsidiary ledger also facilitates capturing other employees related information like earnings detail, contribution detail, deduction detail, payments and check detail, and timecard detail.

Payroll maintains records for each employee and the consolidated salaries and wages cost is expensed off to the relevant control accounts in the general ledger. Sometimes the cost is expensed to other sub-ledgers, for example in the case of an organization using projects sub-ledger all associated employer burdens are expensed to the relevant project. Other examples are expensing payroll cost to Cost Accounting, Equipment, and Capital Work in Progress or Work Order, etc. In the ERP context, it is known as the Payroll Module or the Payroll Management System.


Related Links

Creation Date Tuesday, 30 November -0001 Hits 75862

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.

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

  • Team-Based Organizational Structure

    Team-Based Organizational Structure

    Team-based structure is a relatively new structure that opposes the traditional hierarchical structure and it slowly gaining acceptance in the corporate world. In such a structure, employees come together as team in order to fulfill their tasks that serve a common goal.

  • GL - Understanding Chart of Accounts

    GL - Understanding Chart of Accounts

    A chart of accounts (COA) is a list of the accounts used by a business entity to record and categorize financial transactions. COA has transitioned from the legacy accounts, capturing just the natural account, to modern-day multidimensional COA structures capturing all accounting dimensions pertaining to underlying data enabling a granular level of reporting. Learn more about the role of COA in modern accounting systems.

  • Divisional Organizational Structures

    Divisional Organizational Structures

    The divisional structure or product structure consists of self-contained divisions. A division is a collection of functions which produce a product. It also utilizes a plan to compete and operate as a separate business or profit center. Divisional structure is based on external or internal parameters like product /customer segment/ geographical location etc.

  • Defining Internal Structures

    Defining Internal Structures

    Internally, an organization can be structured in many different ways, depending on their objectives. The internal structure of an organization will determine the modes in which it operates and performs. Organizational structure allows the expressed allocation of responsibilities for different functions and processes to different entities such as the branch, department, workgroup and individual.

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

  • General Ledger Process Flow

    General Ledger Process Flow

    In this article, we will explain the general Ledger journal processing flow from entering journals to running the final financial reports. Understand the generic general ledger process flow as it happens in automated ERP systems. The accounting cycle explains the flow of converting raw accounting data to financial information whereas general ledger process flow explains how journals flow in the system.

  • 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 - Journal Posting and Balances

    GL - Journal Posting and Balances

    In this tutorial, we will explain what we mean by the posting process and what are the major differences between the posting process in the manual accounting system compared to the automated accounting systems and ERPs. This article also explains how posting also happens in subsidiary ledgers and subsequently that information is again posted to the general ledger.

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

Subscribe to Our Newsletter


© 2023 TechnoFunc, All Rights Reserved