GnuCash Tutorial and Concepts Guide

About This Document

Table of Contents

About the Authors
1. Overview
I. The Basic Knowledge
2. The Basics
3. Importing Data into GnuCash
4. Configuring GnuCash
II. The Common Usage
5. Checkbook
6. Expense Accounts
7. Credit Cards
8. Loans
9. Investments
10. Reports
11. Capital Gains
12. Multiple Currencies
III. The Advanced Features
13. Business Features
14. Budgets
15. Other Assets
16. Depreciation
17. Python Bindings
18. Importing Business Data
IV. Appendices
GnuCash Glossary
A. Migration Guide
B. Auxiliary File Formats
C. GNU Free Documentation License

List of Figures

2.1. The basic accounts relationships
2.2. Save screen when xml or sqlite3 is selected.
2.3. Save screen when mysql or postgres is selected.
2.4. New Account Hierarchy Setup: Introduction
2.5. New Account Hierarchy Setup: Book Options
2.6. New Account Hierarchy Setup: Currency Selection
2.7. New Account Hierarchy Setup: Account Selection
2.8. New Account Hierarchy Setup: Account Setup
2.9. New Account Hierarchy Setup: Finish
2.10. Tutorial: Starting Account View of the Test File
2.11. Entering a split transaction
9.1. Selling Shares, Gain Combined, Gross Pricing
9.2. the Account Tree after the Example of Selling Shares for a Gain
9.3. Selling Shares for Gain using Net Pricing in Transaction Journal View
9.4. Selling Shares for Gain Where the Sale and Gain are Recorded in Separate Transactions, in Transaction Journal View
9.5. Selling Shares for Gain Where the Sale and Gain are Recorded in Separate Transactions, in Transaction Journal View
9.6. Selling Shares - Capital Gains - Lots in Account window
9.7. Selling Shares - Capital Gains - Security register before scrubbing a single lot
9.8. Selling Shares - Capital Gains - Lots before scrubbing a single lot
9.9. Selling Shares - Capital Gains - Lots before scrubbing a single lot, after manual linking
9.10. Selling Shares - Capital Gains - Register after manual linking and scrubbing a single lot
9.11. Selling Shares - Capital Gains - Register before Scrub Account
9.12. Selling Shares - Capital Gains - Lots before Scrub Account
9.13. Selling Shares - Capital Gains - Lots after Scrub Account
9.14. Selling Shares - Capital Gains - Register after Scrub Account
9.15. Selling Shares - Capital Gains - Register after Scrub Account
9.16. Selling Shares - Capital Gains - Lot 0 after Scrub Account
9.17. Selling Shares - Capital Gains - Lot 1 after Scrub Account
9.18. Selling Shares - Capital Gains - Register after scrubbing a single lot
13.1. Sales Tax Tables Editor
13.2. New Sales Tax Table Entry
13.3. Entering Company Information
13.4. Billing Terms Editor
13.5. New Billing Term
13.6. New Customer Registration Window
13.7. Find Customer Window
13.8. Creating a New Invoice
13.9. Edit Invoice Window
13.10. Post Invoice Window
13.11. Invoice Print Output
13.12. New Customer Job
13.13. Process Customer Payment
13.14. The New Style Sheet Window
13.15. HTML Style Sheets Example Window
13.16. HTML Style Sheets Example Output
13.17. New Vendor Registration Window
13.18. Find Vendor Window
13.19. New Bill Registration Window
13.20. Edit Bill Window
13.21. Post Bill Window
13.22. New Vendor Job
13.23. Process Vendor Payment
13.24. Payroll Example: Initial Setup
13.25. Payroll Example: Employee Split Transaction
13.26. Payroll Example: Accounts After Salaries Paid
13.27. Payroll Example: Accounts After Paying Government

List of Tables

2.1. Summary of effect of debits (Dr) and credits (Cr) on the balance of accounts of the 5 account types
2.2. Storage Comparison
2.3. Application Settings Locations
2.4. Saved Reports Locations
2.5. Online Banking Settings Locations
8.1. Buying a House Split Transaction
8.2. Personal loan to Peter
8.3. Selling an asset (house) with a profit
8.4. Selling an asset (house) with a loss
8.5. Selling an asset (house) with a profit
8.6. Selling an asset (house) with a profit 2
9.1. Selling Shares Split Scheme, Sale and Capital Gain/Loss Are Combined, Gross Pricing
9.2. Selling Shares Split Scheme, Sale & Gain Combined, Gross Pricing
9.3. Selling Shares Split Scheme, Sale and Capital Gain/Loss Are Combined, Net Pricing
9.4. Selling Shares Split Scheme, Sale & Gain Combined, Net Pricing
9.5. Selling Shares Split Scheme, Sale and Capital Gain/Loss Are Separate Transactions, Sale Transaction
9.6. Selling Shares Split Scheme, Sale and Capital Gain/Loss Are Separate Transactions, Capital Gain/Loss Transaction
9.7. Selling Shares Split Scheme, Sale Transaction, Gross Pricing
9.8. Selling Shares Split Scheme, Gain Transaction, Gross Pricing
9.9. Selling Shares Split Scheme, Sale and Capital Gain/Loss Are Separate Transactions, Sale Transaction
9.10. Selling Shares Split Scheme, Sale and Capital Gain/Loss Are Separate Transactions, Capital Gain/Loss Transaction
9.11. Selling Shares Split Scheme, Sale Transaction, Net Pricing
9.12. Selling Shares Split Scheme, Gain Transaction, Net Pricing
9.13. Transaction 1 dealing with value received and the reduction of the number of shares
9.14. Transaction 2 capital gain/loss (loss in this example)
10.1. Sample Chart of Accounts for Income and GST Statement
10.2. Income and GST Statement
10.3. Sample Chart of Accounts for the Transaction Report
11.1. Turning an Unrealized Gain into a Realized Gain - Accurate Estimation
11.2. Turning an Unrealized Gain into a Realized Gain - Over estimation
11.3. Turning an Unrealized Gain into a Realized Gain - Under estimation
12.1. Selling a currency with a Split Transaction Scheme
13.1. Sample Tax Table Entries for EU country (e.g. 21% / 6% / 0% Belgium, 20% / 5% / 0% UK etc.) (2017)
13.2. Sample Tax Table Entries for Australia (2017)
13.3. Sample Tax Table Entries for Cook County, Illinois (2017)
13.4. Payroll Transaction Map
13.5. Payroll Transaction Map for Employee 1
16.1. Linear Depreciation Scheme Example
16.2. Geometric Depreciation Scheme Example
16.3. Sum of Digits Depreciation Scheme Example
B.1. Overall Page Description Fields
B.2. Multiple Checks Per Page Fields
B.3. Individual Check Item Fields
B.4. Individual Check Item Types

List of Examples

8.1. Accounts for the loan to Peter
9.1. Sale of Shares with Profit, Manual Profit/Loss Calculation, Sale & Profit Combined, Gross Pricing
9.2. Sale of Shares with Profit, Manual Profit/Loss Calculation, Sale & Profit Combined, Net Pricing
9.3. Sale of Shares with Profit, Manual Profit/Loss Calculation, Sale & Profit Separated, Gross Pricing
9.4. Sale of Shares with Profit, Manual Profit/Loss Calculation, Sale & Profit Separated, Net Pricing
9.5. Manual Lot Creation and Linking
9.6. Automatic Creation of Capital Gain Or Loss Transactions
9.7. Automatic Creation of Capital Gain Or Loss Transactions, 2 Sales at Once
9.8. Automatic Creation of Capital Gain Or Loss Transactions - After a Simple Stock Split
9.9. Changing the Orphaned Gains-CCC to Gain/Loss Account

List of Equations

2.1. The static accounting equation
2.2. The (dynamic) accounting equation
2.3. The rearranged accounting equation