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 75451

You May Also Like

  • 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 - Reversing Journal Entry

    GL - Reversing Journal Entry

    Reversing Journals are special journals that are automatically reversed after a specified date. A reversing entry is a journal entry to “undo” an adjusting entry. When you create a reversing journal entry it nullifies the accounting impact of the original entry. Reversing entries make it easier to record subsequent transactions by eliminating the need for certain compound entries. See an example of reversing journal entry!

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

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

  • 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 Subsidiary Ledgers

    The Subsidiary Ledgers

    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. 

  • Sole Proprietorship Form

    Sole Proprietorship Form

    The sole trader organization (also called proprietorship) is the oldest form of organization and the most common form of organization for small businesses even today.  In a proprietorship the enterprise is owned and controlled only by one person.  This form is one of the most popular forms because of the advantages it offers. It is the simplest and easiest to form.

     

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

  • Equity and Liability Accounts

    Equity and Liability Accounts

    Funds contributed by owners in any business are different from all other types of funds. Equity is the residual value of the business enterprise that belongs to the owners or shareholders. The funds contributed by outsiders other than owners that are payable to them in the future. Liabilities are generally classified as Short Term (Current) and Long Term Liabilities. Current liabilities are debts payable within one year.

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

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

Subscribe to Our Newsletter


© 2023 TechnoFunc, All Rights Reserved