5.2. Setting Up And Editing Accounts

Note

This section is a "work in process" all of the material has not been reviewed for V2.0. While it may not be strictly accurate, it is at least a "guide".

This section describes the process of setting up GnuCash Accounts. In GnuCash an Account is used as the basic tool to organize the recording of where money comes from and goes to. GnuCash also extends the concept of real world accounts such as a bank account or loan account to grouping income and expense accounts. This allows to to quickly see where you spent your money and what your major income and expenses are. GnuCash sets Account Types (as described in the next section) to help in organizing and grouping accounts. Account Types can be used to create a Chart of Accounts.

5.2.1. Types of GnuCash Accounts

GnuCash supports a number of different account types. It is recommended to choose an appropriate account type based on the list of account types described below.

Table 5.8. Types of GnuCash Accounts.

Account Type

Description

Accounts Payable

Accounts Payable are used by businesses to record amounts that must be paid. Example: The business has bought something, but the business has not paid the bill until later.

Note

Previous versions of this help defined A/P and A/R the other way round.

Accounts Receivable

Accounts Receivable records amounts for which money has not yet been received. Example: A business has sold something and issued a bill, but the client has not payed until later.

Note

Previous versions of this help defined A/P and A/R the other way round.

Asset

Asset accounts are used for tracking things that are of value and can be used or sold to pay debts. (Normally a placeholder account)

Bank

The Bank account type denotes savings or checking accounts held at a bank or other financial institution. Some of these accounts may bear interest. This is also the appropriate account type for check (debit) cards, which directly withdraw payments from a checking account.

Cash

The Cash account type is used to denote the cash that you store in your wallet, shoe box, piggyback, or mattress.

Credit Card

The Credit Card account type is used to denote credit card accounts, both for cards that allow floating lines of credit (e.g. VISA, MasterCard, or Discover) and with cards that do not permit continuing balances (e.g. American Express)

Currency

Currency Accounts are used for trading currencies.

Equity

Equity accounts are used to store the opening balances when you first start using GnuCash or start a new accounting period.

Expense

Any expense such as food, clothing, taxes, etc. This type is called a category in Quicken.

Income

Any income received from sources such as salary, interest, dividends, etc. This type is called a category in Quicken.

Liability

Liability accounts are used for tracking debts or financial obligations. (Normally a placeholder account)

Mutual Fund

A professionally managed portfolio of stocks and bonds or other investments divided up into shares.

Stock

A share of ownership in a corporation, which entitles its owner to all the risks and rewards that go with it.

The New Account Hierarchy Setup druid described in the first section of this help is a convenient way of setting up a set of accounts to use as a framework of account types.

When new accounts are created the available choices of account types are grayed out according to what type the parent account is. The following list contains the possible choices.

  • Accounts Payable: All accounts except Equity, Expense and Income can be child accounts.

  • Accounts Receivable: All accounts except Equity, Expense and Income can be child accounts.

  • Asset: All accounts except Equity, Expense and Income can be child accounts.

  • Bank: All accounts except Equity, Expense and Income can be child accounts.

  • Cash: All accounts except Equity, Expense and Income can be child accounts.

  • Credit Card: All accounts except Equity, Expense and Income can be child accounts.

  • Currency: All accounts except Equity, Expense and Income can be child accounts.

  • Equity: Only Equity accounts can be child accounts.

  • Expense: Only Expense or Income accounts can be child accounts.

  • Income: Only Expense or Income accounts can be child accounts.

  • Liability: All accounts except Equity, Expense and Income can be child accounts.

  • Mutual Fund: All accounts except Equity, Expense and Income can be child accounts.

  • Stock: All accounts except Equity, Expense and Income can be child accounts.

5.2.2. To Create a Chart of Accounts

The Chart of Accounts is like a table of contents for your finances. The best way to conceptualize a chart of accounts is as a tree. The main branches represent entire categories or groups, while the leaves of the tree denote individual bank accounts or expense categories. When a summary report is requested, typically only the main branches are shown in the report, rather than the individual accounts. For example, a chart of accounts might look like the following:


        300             Expenses
         |
         +--310         Living Expenses
         |   |
         |   +--311     Beer
         |   |
         |   +--312     Cable
         |
         +--320         Business Expenses
         |   |
         |   +--321     8-inch Floppies
         |   |
         :   :

Note that accounts not only have names; they have codes, to order the accounts. When a report is generated, the sort order is determined by the numbering. It's customary to have the leaf accounts end in non-zero digits, while parent nodes have increasing numbers of zeros.

GnuCash does not prevent duplicate numbering, although we would encourage you to avoid this. Account codes are treated as numbers in base-36, thus, if you run out of numbers, you can use the letters, a through z.

A sample chart of accounts is shown below. Each account is of a given account type. This example is a combination of some typical business and personal accounts.

  • Assets

    • Cash On Hand

      • Checking account

      • Money Market Account

      • Certificate of Deposit

    • Fixed Assets

      • Furniture

      • Computers

      • Jewelry, Collectibles

      • Tools, Machinery

    • Investments

      • Stocks

      • Bonds

      • Mutual Funds

      • Real Estate

  • Liabilities

    • Taxes

      • Federal Income Tax

      • Social Security

      • Medicare

      • FUTA

      • State Income Tax

    • Accounts Payable

      • MasterCard

      • Visa

      • American Express

      • Diner's Club

    • Loans

      • Debentures

      • School Loan

      • Uncle Harry's Tide-me-over

  • Equity

    • Retained Earnings

    • Current Year Earnings

    • Historical Adjustments

  • Income

    • Interest Income

      • Bank Account Interest

      • Certificate of Deposit

      • Bond Interest

    • Dividends

      • Stock

      • Mutual Fund

    • Consulting

      • ABC Design

      • PQR Infomatics

    • Salary

      • My Day Job

    • Commissions

      • Royalties

  • Expenses

    • Rent and Utilities

      • Rent

      • Rent Late Fees

      • Electricity

      • Gas

      • Phone

      • Internet

      • Cable TV

    • Office Expenses

      • Accounting

      • Legal

      • Software

      • Postage

      • Bank Charges

      • Credit Card Charges

      • Toner, Paper, Paper Clips

    • Auto Expenses

      • Gas

      • Insurance

      • Repair

      • Rental

    • Taxes

      • Social Security

      • Unemployment

      • IRS penalties

    • Wages and Salaries

      • Consulting

      • Wages

      • Health Insurance

    • Travel

      • Air

      • Hotel

      • Meals

      • Auto

    • Marketing

      • Advertising

      • Trade Shows

      • Give Aways

5.2.3. To Create a New Account

The New Account properties dialog consists of two tabs, the General Information tab and the Opening Balance tab. This dialog can be accessed by going to File -> New Account... or by clicking the New toolbar icon in the Account Tree Window.

Creating a New Account involves planning in advance several details that are used in the New Account dialog.

  • What type of account is needed .

  • Where it fits in the structure of the Chart of Accounts.

  • If there is an Opening Balance.

  • If there is a Commodity needed for the account.

  • If on-line updating of the commodity price is needed.

These details are described below.

5.2.3.1. General Information

The General Information tab is used to access the basic information about the account. It provides a way of connecting the account to stock information if it is one of the currency, mutual fund or stock account types. It can also be flagged as a Tax Related or Placeholder account.

There are five panes in this tab. Below the panes are check-boxes to mark the account as Tax Related and a Placeholder account. The Tax Related check-box means that this account has been flagged to be included in Tax Exports. This flag should only be set for Income and Expense type accounts. The Placeholder check-box means this account is not used for transaction data. This check-box is used to enable a hierarchy or chart of accounts to be setup.

The top pane contains the Account Information.

  • Account Information: Enter a name for the account such as First Bank Checking.

  • Description: This is an optional description for the account.

  • Commodity: For most accounts this should be the default, USD (US Dollar) or your local currency symbol. If this account is for a foreign currency then use the Select... button to choose a different currency in the Select currency/security dialog. Use the Select... button to choose a security if this is a mutual fund or stock account.

  • Select currency/security: To select a different currency click the Currency/security: drop down list and choose the currency symbol you need. To create a security for mutual fund and stock accounts select the New... button to bring up the New Currency/Security dialog. After the security is created select the Type:(usually the exchange the security is traded on) and the name in the Currency/security: drop down list.

  • New Currency/Security: The options here are described in detail in the Security Editor section. Fill in a name, symbol and type.

  • Account Code: Enter an optional number code as described in the To Create a Chart of Accounts section.

The next pane contains a list of Account Types. Select a type from the descriptions in the Types of GnuCash Accounts section.

The next pane contains an account tree to choose a Parent Account. To create a new account tree select New top level account. If the parent account is a certain type, then several of the choices in Account Type become out. For example if the Parent Account is Assets then Equity, Expense and Income become This is to help maintain a proper account structure for the Chart of Accounts.

The next pane is the Price Quote Source pane.

  • Get On-line Quotes: This check-box is only enabled when currency, mutual fund or stock account types are selected. It is used to enable this account to have quotes downloaded from an on-line source.

  • The source for price quotes: Select a quote source from the pull-down menu. Currently supported quote sources include Yahoo, Yahoo Europe, Fidelity Investments, T. Rowe Price, the Vanguard Group, the Australian Stock Exchange (ASX) and TIAA-CREF. Note that Yahoo will provide price quotes for many mutual funds including Fidelity, T.Rowe Price and Vanguard, and that the quoted prices at Yahoo should be identical to those that may be found at the source sites. If you choose Yahoo Europe, you should append the market code for the security, such as PA for Paris, BE for Berlin, etc. Example: 12150.PA (a Peugeot security in the Paris market). Table 5.9 and Table 5.10 below list codes for various markets.

  • Timezone for these quotes: Select the timezone for the source of the on-line quotes you are receiving. For example, Yahoo normally quotes Eastern timezone, so choose America/New York if you use that quote source.

Note

The set of steps needed to properly enable on-line quote updating with the Price Editor are;

  • Create the mutual fund or stock with either the Security Editor or the New Currency/Security dialog described above.

  • Create the Account for the mutual fund or stock with it listed in the Commodity field.

  • Select On-line Quotes, the source for price quotes and Timezone.

  • To determine if the Perl module Finance::Quote is already installed on your system, type “perldoc Finance::Quote” in a terminal window and check to see if there is any documentation available. If you see the documentation, then the module is installed, if you do not see the documentation, then it has not been installed.

    To install Finance::Quote;

    1. Close any GnuCash applications you have running.

    2. Locate the folder where GnuCash is installed by searching for “gnc-fq-update” (without the quotes).

    3. Change to that directory, open a root shell and run the command “gnc-fq-update” (without the quotation marks). This will launch a Perl CPAN update session that will go out onto the Internet and install the Finance::Quote module on your system.

      The gnc-fq-update program is interactive, however, with most systems you should be able to answer “no” to the first question: “Are you ready for manual configuration? [yes]” and the update will continue automatically from that point.

    After installation is complete, you should run the “gnc-fq-dump” test program, in the same directory, distributed with GnuCash to test if Finance::Quote is installed and working properly.

    Note

    If you feel uncomfortable about performing any of these steps, please either email the GnuCash-user mailing list (<gnucash-user@gnucash.org>) for help or come to the GnuCash IRC channel on irc.gnome.org. You can also leave out this step and manually update your stock prices.

  • Add a commodity to the Price Editor as described in the Price Editor section of Tool Windows.

  • Select Get Quotes in the Price Editor.

If you wish to update price quotes from the command line, you can do so by the following command;

gnucash --add-price-quotes <gnucash-file-name>

Code List for European Markets

Table 5.9. Code List for European Markets

Code

Market

BC

Barcelona

BE

Berlin

BI

Bilbao

BR

Brême

CO

Copenhagen

D

Dusseldorf

F

Frankfurt

FX

Xetra

H

Hamburg

HA

Hanover

L

London

MA

Madrid

MC

Madrid (M.C.)

MI

Milan

MU

Munich

O

Oslo

PA

Paris

ST

Stockholm

SG

Stuttgart

VA

Valence

Table 5.10. Pseudo-symbols that can be used for TIAA-CREF quotes

Name

Pseudo-symbol

Bond Market

CREFbond

Equity Index

CREFequi

Global Equities

CREFglob

Growth

CREFgrow

Inflation-Linked Bond

CREFinfb

Money Market

CREFmony

Social Choice

CREFsoci

Stock

CREFstok

Teachers PA Select Stock

TIAAsele

Teachers PA Stock Index

TIAAsndx

TIAA Real Estate

TIAAreal

The last pane is the Notes pane. This is used for any additional notes about the account.

5.2.3.2. Opening Balance

The Opening Balance tab is visible only when creating a new account. It is used to record the beginning balance for an account. This allows it to be used for two different scenarios. If using GnuCash for the first time to record transactions, it can be used as a beginning balance. If the accounts in use are closed at the end of a period and new accounts are created, it is used to close and carry balances forward.

There are three panes in this tab. The top pane contains the Balance Information.

  • Balance: Enter here the balance to start the account with.

  • Date: Choose here the date the opening balance should be recorded.

The next pane is the Transfer Type pane.

  • Use Opening Balances Equity account: This transfers the opening balance for the account from a standard Equity account called Opening Balances.

  • Select Transfer Account: This enables the pane below so a different account can be used to transfer the opening balance.

The last pane is the Transfer Account pane. Select the account to use for opening balances from the list of accounts in this pane.

5.2.4. To Edit an Account

The Edit Account dialog consists of just the General Information tab. This tab has the same information that was described in To Create a New Account. To access the Edit Account dialog go to Edit -> Edit Account (menu shortcut Ctrl-E) or click the Edit toolbar icon in the Account Tree Window.

5.2.5. To Edit a Chart of Accounts

Editing the Chart of Accounts is done within the Parent Account pane of the Edit Account dialog. It is possible to move an account to any part of the Chart of Account. It is recommended to keep accounts generally under the related types of accounts as described in the Types of GnuCash Accounts section. This helps to preserve the Chart of Accounts structure.

To move the selected account to a different parent account just select the account in the Parent Account pane. If New top level account is selected then the account will be move to the top level.

5.2.6. To Renumber Subaccounts

Use "Renumber Subaccounts" to rewrite the account codes for all children of the current account. For example, you have the following account structure:

Table 5.11. Starting account numbers.

Code

Name

10

Colors

10-1

Red

10-2

Orange

10-3

Yellow.

10-4

Blue

10-5

Violet

You now need to add the "Green" account, but you want it to sort between the Yellow and Blue accounts. Instead of having to manually renumber all the accounts starting with Blue, you can use the "renumber subaccount" command on the Colors account. In the pop-up dialog the prefix value should default to "10", the account code for the colors account. If you set an interval value of 5 and click "Renumber" you will end up with the following account structure:

Table 5.12. Renumbered account numbers

Code

Name

10

Colors

10-05

Red

10-10

Orange

10-15

Yellow.

10-20

Blue

10-25

Violet

Now you have room in the account code numbering space to add the Green account with an account code to force the proper ordering.

Table 5.13. Final account numbers.

Code

Name

10

Colors

10-05

Red

10-10

Orange

10-15

Yellow.

10-18

Green

10-20

Blue

10-25

Violet

5.2.7. To Delete an Account

Deleting an Account means removing all transaction information and information about this account from the file. This cannot be undone. You will be prompted to that you wish to remove the account. If the account still contains transaction information you will be warned that this account contains transactions.

A side effect of removing an account that contains transactions is that you will end up with unbalanced accounts. This will be indicated in the account by a gray check-box next to the debit and credit amounts. You can repair automatically these unbalanced accounts by using the Actions -> Check & Repair menu. This will automatically assign the unbalanced amounts to a new account named Imbalance.

5.2.8. To Jump to another Account

When using the Account Register Window it is frequently useful to be able to view an account and also the transfer account at the same time. GnuCash allows you to do this quickly by using 'Jump'. This is available on the toolbar and in the Actions menu in the Account Register Window.

Select the transaction in the Account Register Window and click jump to open the transfer Account Register Window. If the transaction is split between more than one transfer account then you will need to show all the split transfer accounts first and select the transfer account to jump to.

5.2.9. To Reconcile an Account to a Statement

Reconciliation of Accounts in GnuCash with statements from a bank or other institution is a way of double checking the balance of your accounts. It also is useful to track uncleared checks and other outstanding transactions.

The Summary Bar at the top of the Account Register Window indicates the amounts of Cleared and Reconciled transactions. On-line account information can be used to mark which transaction the bank has processed by changing the R (reconciliation) column in the register from n (new) to c (cleared). The bank statement is then used with the Reconcile Window to reconcile the account which changes the R field to y (reconciled).

The Reconcile Window is accessed in the Account Tree Window by going to Actions -> Reconcile... (menu shortcut Ctrl-R). In the Account Register Window it is accessed by going to Actions -> Reconcile...

5.2.9.1. Reconcile Information

The Reconcile Information dialog is used to indicate the date the statement ends on and what the starting and ending balance of the statement is. The Include Sub-accounts check-box is used if two or more accounts are used to track a single bank account. The Enter Interest Payment button is used to add a transfer to the accounts for an interest payment. If selected a dialog will be displayed to add the payment to the account.

There are three panes in the Interest Payment dialog. At the bottom is a button called No Auto Interest Payments for this Account which will cancel the dialog. The top pane contains the Payment Information.

  • Amount: Enter the amount of the interest payment.

  • Date: Select the date for the interest payment.

  • Num: Enter a number for the transaction (optional).

  • Description: Enter an informational description for the transaction.

  • Memo: Enter a note about the transaction (optional).

The next pane contains a list of accounts for the Payment From account. If the payment is for a credit or loan account then usually this would be from an Expense account. If the payment is for a checking or savings account then usually this would be from an Income account. The Show Income/Expense check-box shows or hides the Income and Expense accounts.

The next pane contains the Reconcile Account. This shows the account that the interest payment will be transferred to or from.

5.2.9.2. Reconcile Window

The parts of the Reconcile Window are described in the Tool Windows section of GnuCash Windows. This window is used to open the account and to add transaction information to the account in order to reconcile the account to the bank statement.

The set of unreconciled transactions in the Funds In and Funds Out panes can be changed by using the menus and toolbar to access the account and transaction information. If you wish to postpone the reconciliation until later use the Reconcile -> Postpone menu item (menu shortcut Ctrl-P).

Select each unreconciled transaction matching a statement transaction so a green tick appears in the R column. The Balance pane changes to reflect each selected transaction until the Ending Balance equals the Reconciled Balance and the Difference is zero. Once this is done select the Finish button or Finish on the Reconcile menu (menu shortcut Ctrl-F) to finish the reconcile process.

5.2.10. To Perform a Stock Split

Stock splits commonly occur when a company decides its stock price is to expensive for individual investors to buy the stock. Splits have the effect of lowering the price of a single share while keeping the value of shares owned by investors who have already purchased shares.

5.2.10.1. Stock Split Druid

GnuCash uses the Stock Split druid to record stock splits. This provides a way of entering the details of the stock split and also any change in stock price or cash disbursement as a result of the stock split.

The Stock Split druid is accessed by going to Actions -> Stock Split...

The Stock Split druid opens with a screen that briefly describes what this druid does. The three buttons at the very bottom of the screen will not change while using the druid.

  • The Cancel button is used to exit the druid and cancel entering the stock split information. Any selections you have made in this druid up to this point will be lost.

  • The Back button will bring up the previous screen so you can change a selection made on that screen.

  • The Forward button will bring up the next screen so you can continue though the druid.

The next screen allows you to select a Stock Account. Select an account from the list to record a stock split or merger.

  • Account: Lists the GnuCash account name for the stock.

  • Symbol: The stock symbol for the stock associated with this account.

  • Shares: The amount of shares that have been purchased in the account.

The next screen lets you set the Stock Split Details. The top part of the screen contains details used in creating the stock split transaction.

  • Date: Choose the date of the stock split.

  • Share Distribution: Enter the amount of shares gained from the stock split. For a stock merger enter a negative number.

  • Description: Enter a description or leave as the default.

The bottom part of the screen contains details used to record a price for the split (optional).

  • New Price: Enter the price of the shares on the day of the stock split.

  • Currency: Choose the currency of the shares.

The next screen lets you enter a transaction for a cash disbursement (Cash In Lieu) as a result of the stock split (optional).

  • Cash Amount: Enter the amount of the Cash disbursement.

  • Memo: Enter a memo or leave as the default.

  • Income Account: Choose an Income Account for the disbursement.

  • Asset Account: Choose an Asset Account for the disbursement.

The last screen gives you a list of three choices to finish the druid.

  • The Cancel button is used to exit the druid and cancel creating the Stock Split transactions.. Any selections you have made in this druid up to this point will be lost.

  • The Back button will bring up the previous screen so you can change a selection made on that screen.

  • The Finish button creates the transactions for the Stock Split.

You should now have successfully entered the Stock Split or Merger.