Bookkeeping – Chart of Accounts Using the Numbering System (Lesson 18)
To identify offsets, parenthesis is used with the final report read by owners and the management team.
Up to this point in this series about bookkeeping only accounts (ledgers) by name have been mentioned. To speed up the process of entering information accountants convert names to numbers. This makes it easier to enter information in the original journals. Instead of long hand-written words for the particular ledger, you simply enter a number.
Chart of Accounts – Core Numbering System
Thus, a numbering system was developed around the six types of accounts. The primary digit indicated the type of account. See the following schedule:
Assets – 1
Liabilities – 2
Equity – 3
Revenue – 4
Cost of Sales – 5
Expenses – 6
The minimum number of digits is three and often I’ve seen six digits. The most common is a four digit code. Read the digits from left to right. Let’s explore the second digit in this numbering system. Each account type expands into account groups. For example, assets are divided into three major groups:
The second digit in this system identifies the particular group of assets as follows:
Assets – 1
Current Assets – 0 through 4
Fixed Assets – 5 through 7
Other Assets – 8 through 9
To clarify, if you are identifying other assets, the first two digits of the account number would be either 18 or 19. In a well organized set-up, the first two digits for other assets are tied to certain types of assets as described below:
18 – Non governmental investments or rights such as organizational costs, refinancing expenses, goodwill, purchased legal rights
19 – Governmental purchased rights such as patents, copyrights, licenses, branding, logo and judicial claims
Now let’s explore the third digit. Suppose a contractor purchased several lots and holds back one lot to build on in two years. This is a non governmental investment so it ends up in the 18 area. To elaborate, let’s break this down further:
Assets – 1
Non Governmental Investments – 8
Organizational Costs – 1
Refinancing Expenses – 2
Physical Assets – 3 through 5
Private Legal Rights – 6
Goodwill – 7
Franchise Contract – 8
Other – 9
In the case of this lot the first three digits of its account number will be 183 to 185. Can it get more detailed?
Yes it can. The two following examples illustrate how the numbering system goes to the fourth digit.
Using the same contractor purchasing lots, he purchases three lots for future construction. One lot is located in a subdivision known as Cripple Creek and the other two are in an area identified as Governor’s Land. How is the numbering system formatted?
Assets – 1
Non Governmental – 8
Land – 5
Cripple Creek – 2
Governor’s Land – 7
The account number for the lot purchased in Cripple Creek is 1852 and the two lots in Governor’s Land are entered into account number 1857.
Another example uses refinancing of a real estate bond for an apartment complex in Missouri. Here is the existing the four-digit structure:
Non Governmental – 8
Refinancing – 2
Missouri – 7
This business may have complexes in eight states representing digits 1 through 8 and the number 9 is simply left open for future use. Therefore, the bond refinancing would be posted to account number 1827 which means asset, non-governmental, refinancing in Missouri.
This numbering structure exists throughout the entire chart of accounts. Let’s discuss practical application.
Chart of Accounts – Practical Application
It has been stated several times throughout these lessons, one of the most common mistakes bookkeepers make is having too many accounts. Think about this for a moment, with a four digit number you could literally end up with 9,999 accounts. For your average small business, this is more than enough. The author has reviewed the account structure for operations with over $5,000,000 in revenue and they get by fine with less than 200 accounts, they actually had less than 120 accounts. If a business operation is doing less than $1,000,000 per year in sales, they should not have more than 100 accounts.
Once an operation gets to a sales volume of more than $10 Million you may consider expanding to a five-digit numbering system. Most likely it will not be needed but it can be considered.
WITH SMALL BUSINESS, USE A THREE OR FOUR-DIGIT ACCOUNT NUMBERING FORMAT.
To assist you in your set-up, the following identifies the first two digits for each of the six most account types and their corresponding groups:
11 – Cash
12 – Accounts Receivable
13 – Inventory and Work in Process
14 – Other Current Assets such as Prepaid
15 – Fixed Assets at Cost
16 – Accumulated Depreciation
17 – Open
18 – Non Governmental Investments
19 – Governmental Investments
21 – Accounts Payable
22 – Credit Cards and Charge Accounts
23 – Taxes Due
24 – Lines of Credit
25 – Unearned Revenues Including Progress Billings
26 – Open
27 – Long-Term Debt Tied to Fixed Assets
28 – Long-Term Debt Unsecured
29 – Open
31 – Stock and Capital Paid in Excess
32 – Partnership Capital Accounts
33 – Open
34 – Open
35 – Retained Earnings
36 – Distributions/Dividends/Draws
37 – Open
38 – Open
39 – Open
41 – Sales
42 – Returns, Allowances, Discounts
43 – Open
44 – Specialized Sales such as service or contracted income
45 – Open
46 – Open
47 – Other Revenue
48 – Interest on Working Capital
49 – Open
Cost of Sales
51 – Prime Costs such as materials
52 – Prime Costs such as labor
53 – Prime Costs such as outside services (subcontractors)
54 – Prime Costs – Other
55 – Open
56 – Internal Costs Transferred to Cost of Sales (depreciation/amortization)
57 – Indirect Costs such as project management
58 – Open
59 – Open
61 – Administration Management Payroll
62 – Administration Office Staff Wages
63 – Administration Employee Benefits and Taxes
64 – Admin Training
65 – Admin Travel
66 – Open
67 – Open
68 – Open
69 – Open
70 – Facilities
71 – Insurance
72 – Taxes and Licenses
73 – Communications
74 – Open
75 – Office Operations
76 – Outside Services including professional
77 – Working Capital Costs such as banking and interest
78 – Depreciation and Amortization
79 – Open
In general, account numbers starting with an 8 or 9 are designed for other expenses and revenue which are explained in the next lesson.
Chart of Accounts – Practical Application with QuickBooks
QuickBooks allows the bookkeeper to use the numbering system when setting up the chart of accounts. Click on ‘Lists‘, then ‘Chart of Accounts‘ and at the bottom, click on the word ‘Accounts‘. Hit ‘Add a New Account‘ or ‘Edit an Account‘. The account’s detail information card is displayed. Up in the right hand corner is the field to add an account number. Please try to adhere to the three or four-digit numbering system.
Summary – Chart of Accounts
Accountants use a numbering system to speed up the process of entering data into the journals and transferring information to the respective ledgers. The number system is tied to the six types of accounts for the first digit. The second digit refers to a more defined section of the type of account. The remaining digits provide flexibility in meeting the information needs of the respective business. ACT ON KNOWLEDGE.
Do you want to learn how to get returns like this?
Then learn about Value Investing. Value investing in the simplest of terms means to buy low and sell high. Value investing is defined as a systematic process of buying high quality stock at an undervalued market price quantified by intrinsic value and justified via financial analysis; then selling the stock in a timely manner upon market price recovery.
There are four key principles used with value investing. Each is required. They are:
- Risk Reduction – Buy only high quality stocks;
- Intrinsic Value – The underlying assets and operations are of good quality and performance;
- Financial Analysis – Use core financial information, business ratios and key performance indicators to create a high level of confidence that recovery is just a matter of time;
- Patience – Allow time to work for the investor.
If you are interested in learning more, go to the Membership Program page under Value Investing section in the header above.
Join the value investing club and learn about value investing and how you can easily acquire similar results with your investment fund. Upon joining, you’ll receive the book Value Investing with Business Ratios, a reference guide used with all the decision models you build. Each member goes through three distinct phases:
- Education – Introduction to value investing along with terminology used are explained. Key principles of value investing are covered via a series of lessons and tutorials.
- Development – Members are taught how pools of investments are developed by first learning about financial metrics and how to read financial statements. The member then uses existing models to grasp the core understanding of developing buy/sell triggers for high quality stocks.
- Sophistication – Most members reach this phase of understanding after about six months. Many members create their own pools of investments and share with others their knowledge. Members are introduced to more sophisticated types of investments and how to use them to reduce risk and improve, via leverage, overall returns for their value investment pools.
Each week, you receive an e-mail with a full update on the pools. Follow along as the Investment Fund grows. Start investing with confidence from what you learn. Create your own fund and over time, accumulate wealth. Joining entitles you to the following:
- Lessons about value investing and the principles involved;
- Free webinars from the author following up the lessons;
- Charts, graphs, tutorials, templates and resources to use when you create your own pool;
- Access to existing pools and their respective data models along with buy/sell triggers;
- Follow along with the investment fund and its weekly updates;
- White papers addressing financial principles and proper interpretation methods; AND
- Some simple good advice.