3.3. Putting It All Together

Let's go through the process of building a common personal finance chart of accounts using the information we have learned from this chapter. A chart of accounts is simply a new GnuCash file in which you groups your accounts to track your finances. In building this chart of accounts, the first task is to divide the items you want to track into the basic account types of accounting. This is fairly simple, let's go through an example.

3.3.1. Simple Example

Let us assume you have a checking and a savings account at a bank, and are employed and thus receive a paycheck. You have a credit card (Visa), and you pay monthly utilities in the form of rent, phone, and electricity. Naturally, you also need to buy groceries. For now, we will not worry about how much money you have in the bank, how much you owe on the credit card, etc. We want to simply build the framework for this chart of accounts.

Your assets would be the bank savings and checking account. Your liabilities are the credit card. Your Equity would be the starting values of your bank accounts and credit card (we do not have those amounts yet, but we know they exist). You have income in the form of a salary, and expenses in the form of groceries, rent, electricity, phone, and taxes (Federal, Social Security, Medicare) on your salary. Simple, isn't it?

3.3.2. The Basic Top Level Accounts

Now, you must decide how you want to group these accounts. Most likely, you want your assets groups together, your liabilities grouped together, your Equity grouped together, your income grouped together, and your expenses grouped together. This is the most common way of building a GnuCash chart of accounts, and it is highly recommended that you always begin this way.

Start with a clean GnuCash file (do not select any predefined accounts) and build this basic starting account structure (File -> New Account...).

  1. Account name Assets (account type Assets, parent account New top level account)

    Creating an Assets account

    This image shows the dialog to create an asset account

  2. Account name Liabilities (account type Liabilities, parent account New top level account)

  3. Account name Equity (account type Equity, parent account New top level account)

  4. Account name Income (account type Income, parent account New top level account)

  5. Account name Expenses (account type Expenses, parent account New top level account)

When you have created the top-level accounts, the main Account page in GnuCash should look like below

The Basic Top-level Accounts

This image shows the basic top-level accounts.

3.3.3. Making Sub-Accounts

You can now add to this basic top-level tree structure by inserting some real transaction-holding sub-accounts. Notice that the tax accounts are placed within a sub-account named "Taxes". You can make sub-accounts within sub-accounts. This is typically done with a group of related accounts (such as tax accounts in this example).

  1. Account name Checking (account type Bank, parent account Asset)

  2. Account name Savings (account type Bank, parent account Asset)

  3. Account name Visa (account type Credit Card, parent account Liabilities)

  4. Account name Salary (account type Income, parent account Income)

  5. Account name Phone (account type Expenses, parent account Expenses)

  6. Account name Electricity (account type Expenses, parent account Expenses)

  7. Account name Rent (account type Expenses, parent account Expenses)

  8. Account name Groceries (account type Expenses, parent account Expenses)

  9. Account name Taxes (account type Expenses, parent account Expenses)

  10. Account name Federal (account type Expenses, parent account Expenses:Taxes)

  11. Account name Social Security (account type Expenses, parent account Expenses:Taxes)

  12. Account name Medicare (account type Expenses, parent account Expenses:Taxes)

  13. Account name Opening Balance (account type Equity, parent account Equity)

After you have created these additional sub-accounts, the end result should look like below

The Basic Chart of Accounts

This image shows a simple chart of accounts.

Save this chart of accounts with the name gcashdata_3, as well as gcashdata_3emptyAccts, as we will continue to use them in the later chapters.

You have now created a chart of accounts to track a simple household budget. With this basic framework in place, we can now begin to populate the accounts with transactions. The next chapter will cover this subject in greater detail.