You are here

Types of ledgers

11 May, 2016 - 11:43

Most organizations operate with two types of ledgers, the General Ledger and one or more subsidiary ledgers. The General Ledger contains a minimum of one page for each account in the chart of accounts. According to one authoritative source:

It is also known as G/L and The Final Book of Entry. It is a collection of all balance sheet, income, and expense accounts used to keep the accounting records of a company. A General Ledger is a perpetual record of the activity and balances of the accounts. Each company has only one General Ledger (Universal Accounting 2009)

However, some accounts, like accounts receivable or accounts payable, are comprised of the sum of a number of individual amounts. Let us look at accounts receivable as an example. Suppose we have a balance (i.e. total) amount of USD 3,250 in our accounts receivable account in the General Ledger. Remember, accounts receivable are amounts our customers owe us. Therefore, the USD 3,250 balance we have in our accounts receivable is the sum total of amounts owed to us by several individual customers. For the sake of convenience, we keep a subsidiary ledger of individual accounts receivable as illustrated in Figure 9.1 below.

The Accounts Receivable Subsidiary Ledger has one page for each customer who has earned the right to be extended credit, and is expected pay off their outstanding balance each month. The sum of the customer balances in the Accounts Receivable Subsidiary Ledger must equal the Accounts Receivable balance in the company’s General Ledger.

In the case of the Accounts Receivable example, when a sale is entered in the ledger, a corresponding entry is made in a Sales Journal. And, when a payment is received and posted to a customer’s account in the Accounts Receivable ledger, a corresponding entry is made in a Cash Receipts Journal.

Similar subsidiary ledgers are created any time there is a sufficient number of detail accounts to warrant it. Detailed accounts may be employee accounts for payroll, or product numbers for inventory, for example. Setting up subsidiary ledgers and journals for special purposes like this shields the General Ledger from an excessive amount of detail and, at the same time, preserves the principle of double-entry accounting, makes reconciliations easier and, in general, promotes accuracy in a company’s accounting records. In real life, of course, things can get more complicated, but this is the basic approach that is followed.

Figure 9.1 Accounts Receivable Subsidiary Ledger example
 

In Leveraging with information technology, we discuss the many opportunities that small businesses have to use computer software to set up and maintain records of all sorts for their business, from accounting, payroll, customer relationship management, inventory control and the like. Going much beyond this is beyond the scope of this chapter. You can expect the most popular accounting software packages to assume you do not know a lot about accounting. Therefore, most offerings will lead you through the process of setting up a chart of accounts that is appropriate for your business and help you decide which basic reports you should have. Over and above that, most will permit you to prepare the advanced reports and analyses discussed in the following section, as well as custom reports tailored to your specific needs.

There are several sources on the Internet that compare the functions, features, and prices of software packages for accounting to help you make the proper selection. One especially good one is “Accounting Software Review 2009 – TopTenREVIEWS” (Accounting Software Review 2009). Quoting from their website:

“Opening a small business in today's fast-paced economic climate can be an exciting, complicated and expensive endeavor. On the surface, it seems simple—just make sure you're selling your goods for more than it costs to produce them, right? Wrong. Without proper bookkeeping, your blooming company can take an abrupt dive towards bankruptcy.

“This is why accounting is a key component in any small business's success. It should play a role in every financial decision you make—from purchasing vehicles, equipment and supplies to increasing production, stocking inventory and determining salaries.

“But if you, like most people, lack an extensive background in accounting, where do you begin? Today's accounting software has the solution—giving you the tools and the information you need to keep your financial records in check, while aiding you in making the most of your company's cash flow.

“Unfortunately, there are about as many software packages for accounting as there are types of small businesses and determining which one best meets the needs of your company can be a tricky transaction—but that's where we can help.

“Within this site, you'll find articles on accounting and comprehensive reviews to help you make an informed decision on which accounting software is right for your business. At TopTenREVIEWS, we do the research so you don't have to!™” If you have access to the Internet, we highly recommend exploring this site for ideas on how to move forward with your accounting system.

Here is an excerpt from the website where they compare ten software packages feature by feature. In the table reproduced here, we only show the names of the packages and their prices. For more detail you will need to visit the Accounting Software Review 2009 website itself (see the end of chapter references for the link).

Package Name

Overall Ranking

Price in US Dollars

Table 9.4 2009 Accounting Software Review Product Comparisons

Peachtree Complete

Excellent

$249.99

MYOB Business Essentials

Very Good Plus

$99.00

Quickbooks Pro

Very Good

$178.95

NetSuite Small Business

Very Good

$1188.00

Cougar Mountain

Very Good

$1499.00

Bookkeeper

Very Good

$29.99

Simply Accounting

Good Plus

$149.99

CYMA IV Accounting for Windows

Good Plus

$595.00

DacEasy

Good Plus

$499.99

Bottom Line Accounting

Good

$399.00

 

As you can see, there is a wide range of prices, from USD 29.99 to USD 1499.00, and the package which sells for USD 29.99 is rated the same as the one that sells for USD 1499.00. Clearly, this shows that some analysis is necessary before settling on a specific accounting software package. You may need to engage the service of a professional accountant or, at least, a colleague who has studied accounting and accounting software packages to help you make the right selection for your business. Here is some good advice from the Accounting Software Review 2009 website:

With all the accounting software available, it's hard to know which program is the best fit for your business finances. Below are the criteria TopTenREVIEWS used to evaluate small business accounting software.

  • Ease of Use – We look for finance software that is simple to install, set up, and understand. The best accounting programs make navigating intuitive, so you never have to guess where you are or what to do next.
  • Accounting Modules – Accounting modules are categories required to successfully maintain your business finances (such as Accounts Payable and Accounts Receivable). Does the accounting software have all the basic accounting modules you'll need? All the bells and whistles of the software aren't relevant if the basics aren't covered. Will the finance software grow with your company? We look for accounting software that lets you grow and customize your system to fit your individual business needs.
  • Reporting Categories – Consider accounting software that offers a wide range of reports. You should be able to print at least one kind of report for every module. Reporting features are often built into each section, but it's better if you can create reports from anywhere in the program. Customizable reports save you time; look for accounting software that will let you set your own criteria. With detailed financial reporting, you can analyze what is and isn't working for your business.
  • Help Documentation – Look for email and phone support; toll-free phone and live support, online help is a bonus. Online, we look for indexed help topics that can be searched easily. You'll want quick access for both technical help and accounting help for your software. Accounting software companies should have qualified people (both technicians and accountants) answering these tough questions.

"With the right accounting software, you will be able to manage your company books quickly and easily”. (Accounting Software Review 2009)