Difference between revisions of "Using GnuCash"
(→Liability Piechart) |
m (→Liability Barchart) |
||
Line 207: | Line 207: | ||
The Liability Barchart report displays bars that present the value of all liabilities in a Gnucash file on a monthly basis. By default, the report shows all accounts in Liabilities, and it displays monthly bars for the current financial period. This report provides a graphic view of the liabilities in the file over time. Several settings on this report can greatly affect the information included. | The Liability Barchart report displays bars that present the value of all liabilities in a Gnucash file on a monthly basis. By default, the report shows all accounts in Liabilities, and it displays monthly bars for the current financial period. This report provides a graphic view of the liabilities in the file over time. Several settings on this report can greatly affect the information included. | ||
− | On the Accounts tab, the "Show Accounts until level" option changes how the report aggregates account totals. Change this value to see information at deeper levels of the account structure. | + | * On the Accounts tab, the "Show Accounts until level" option changes how the report aggregates account totals. Change this value to see information at deeper levels of the account structure. |
− | On the Display tab, the "Maximum Bars" option will display more bars in the chart, allowing information for more accounts to display. Additionally, the "Show table" option enables the display of chart information in tabular form below the chart. | + | * On the Display tab, the "Maximum Bars" option will display more bars in the chart, allowing information for more accounts to display. Additionally, the "Show table" option enables the display of chart information in tabular form below the chart. |
====Liability Piechart==== | ====Liability Piechart==== |
Revision as of 16:41, 18 October 2016
Contents
- 1 Introduction
- 2 Register Tips
- 3 Reporting Tips
- 3.1 A single report that shows summary amounts for multiple months for multiple accounts
- 3.2 Quicken-like "Overview" of your accounts
- 3.3 Displaying Split Account Details in Transaction Report
- 3.4 Monthly Income/Expense Reports
- 3.5 Reporting in single file resp. in landscape format
- 3.6 Exporting a report to OpenOffice Calc
- 4 Reports Included in GnuCash
- 4.1 Assets & Liabilities (Group)
- 4.1.1 Advanced Portfolio
- 4.1.2 Asset Barchart
- 4.1.3 Asset Piechart
- 4.1.4 Average Balance
- 4.1.5 Balance Sheet
- 4.1.6 General Journal
- 4.1.7 General Ledger
- 4.1.8 Investment Portfolio
- 4.1.9 Liability Barchart
- 4.1.10 Liability Piechart
- 4.1.11 Net Worth Barchart
- 4.1.12 Net Worth Linechart
- 4.1.13 Price Scatterplot
- 4.2 Budget (Group)
- 4.3 Business (group)
- 4.4 Income & Expense (group)
- 4.5 Sample & Custom (group)
- 4.6 Account Summary
- 4.7 Saved Report Configurations
- 4.8 Future Scheduled Transactions Summary
- 4.9 Tax Report & TXF Export
- 4.10 Transaction Report
- 4.11 Account Report
- 4.12 Account Transaction Report
- 4.1 Assets & Liabilities (Group)
- 5 Stocks
- 6 GnuCash on Holidays with your friend
- 7 Getting started with GnuCash' business features
- 8 Using third party software for data exploration and visualization
Introduction
GnuCash is a complex piece of software with many features and possibilities. It requires some learning and experience to work fluently and effectively with it.
To get you started, it comes with a good Concepts Guide, that will introduce you to some basic accounting concepts and explains how GnuCash works with those principles.
A second helpful source of information is the GnuCash Manual, which is sort of a reference to all the menu options and dialogs in GnuCash. At the time of this writing, it is in need of an update as some new features in GnuCash aren't documented yet.
These two documents cover only a part of what GnuCash can do. This is to be expected as there are as many use cases as there are users of the tool. It would be impossible to contain all of these use cases in a manageable static document.
Instead, this page and the ones linked to below will show ways to deal with specific problems. The examples and solutions are provided by users of GnuCash, most of them use (or have used) these solutions in real world scenarios.
If you know a solution to a particular problem while using GnuCash, you are welcome to add it to these pages as well.
Alternatively you can send it to the GnuCash user mailing list (Note: you need to be subscribed before you can post to this list). Use a subject in the lines of "GnuCash tip" or something similar, so it is easily recognized.
To keep some overview, the examples and solutions are grouped per context in GnuCash.
Register Tips
Moving Multiple Transactions
There is no direct way to move a large number of transactions from one account to another in GnuCash.
If you are trying to move a small subset of an account's transactions, your best approach is to edit each transaction manually. You can speed this up somewhat by changing your register view to Transaction Journal mode, which will show all split lines at once. You may also find that copying the destination account and pasting it into the split line may help.
If you are trying move all (or MOST) of an account's transactions, you can get GnuCash to re-designate all your transactions at once by asking GnuCash to DELETE the account in question. For accounts that have transactions in them, GnuCash will ask whether you want to completely delete the transactions, or move them to a different account. Select the account you want all your transactions to go, and they will be moved. (To delete an account, open the Accounts window, select the account you want to delete, and click the Delete button).
Import transactions from another program
Easy way to import a large amount of transactions from another your program (import from bank isn't covered by this tip)
If you use another program that may produce accounting data, tell your programmer to use QIF format to easy import into GnuCash. QIF format is simple and other programs can easy produce it. GnuCash's QIF importer is also easy to use and comes with self explaining wizard incorporated.
You can find QIF format description on Wikipedia or ask uncle Google.
--Provided by Pietro B.
Reporting Tips
A single report that shows summary amounts for multiple months for multiple accounts
To create a single report that shows summary amounts for multiple months for multiple accounts (for example, monthly totals for expense accounts over the course of a year), you can accomplish this with a little creative thinking. The trick is to use Gnucash's Budgeting features.
- First, create a Budget that includes the accounts upon which you ultimately want to base your report and a date range that is useful to you. Save this budget.
- Next, create a budget report, and in the options for this report, deselect the "Show Budget Amounts" check box. The resulting report will list monthly transaction totals for each account in the budget.
This solution is not perfect (you must, for example, edit the budget to cover the date range you want, and then open the report), but it does give a spreadsheet-like summary of a subset of accounts by month.
--Provided by David T.
Quicken-like "Overview" of your accounts
Quicken provides an "overview" of your accounts -- a list of today's balances for checking, savings, credit cards, major assets and liabilities.
For something similar in GnuCash, run the Balance Sheet report, then go to Options to pick the accounts that you want to see in the overview. Then just leave that tab open, and every time you start GnuCash you'll have the overview. Click "reload" if you put in transactions and want to see how things have changed.
--Provided by Anthony Dardis
Alternatively just keep the "Accounts" tab open. It shows the current balances of all the accounts too, without having to run a report. However, I don't use the business functions, or scheduled transactions, so that might perhaps make a difference.
--Provided by Mike Leone
Displaying Split Account Details in Transaction Report
For a simple transaction like this:
debit | credit | |||||
---|---|---|---|---|---|---|
<trans-date> | <ref-no> | "Cheques Received" | ||||
"multiple payers" | <income account> | £157.60 | ||||
<bank account> | £157.60 |
then on a Transaction Report for the bank account the details appear pretty much as above.
For clarity of the accounts, you might enter transactions with multiple splits referring to the same account. For example, the above transaction might well be entered like this:
debit | credit | |||||
---|---|---|---|---|---|---|
<trans-date> | <ref-no> | "Cheques Received" | ||||
<first payer name> | <income account> | £100.00 | ||||
<second payer name> | <income account> | £57.60 | ||||
<bank account> | £157.60 |
When this transaction is printed on the bank account's Transaction Report, then under "other account" it simply prints "split" instead of the account name.
To display the additional split detail, you need to set General -> Style = Multi-Line and then you need to turn on Display -> Account Name. Do NOT turn on Display -> Other Account Name.
You can choose whether or not to turn off the full account name using Display -> Use Full Account Name?
The Use Full Other Account Name? has no effect in this configuration.
--Provided by Derek Atkins (in response to Colin Scott)
Monthly Income/Expense Reports
You can export a GnuCash transaction report to HTML and then open the HTML file in Excel. You then have a ready-made data source from which you can create a pivot table with the transaction data grouped both by account and by period, with very few steps involved.
Two enhancements to the data to try are: (1) grouping the dates by month; and (2) parsing multilevel account names into columns labeled "Account1", "Account2", etc. using the ":" delimiter.
This gives you a report that is very close to the monthly/quarterly/yearly income/expense report that MS Money and Quicken provide.
--Provided by Martin Cunningham on gnucash-users
Reporting in single file resp. in landscape format
Currently, this isn't supported. Via HTML export, however, both options are possible, with the help of htmldoc. Sample call for landscape in european A4 format, which also puts alle single html files into one compound pdf:
htmldoc -t pdf14 --webpage --no-links --linkstyle plain --size 297x210mm --headfootsize 9 --header fff -f report.pdf *.html
Exporting a report to OpenOffice Calc
Sometimes a report needs to be laid out slightly differently than is possible in GnuCash. One way to do this is to export the report to OpenOffice Calc. GnuCash can't export directly into that format, but it can export to html. OpenOffice Calc can import such a html file. Here's what to do:
- Create your report in GnuCash
- With the report open in front of you, select File -> Export -> Export Report to save the report somewhere in html. Note: there is also a tool bar button that does exactly the same thing.
- Open OpenOffice Calc
- Select Insert -> Link to external data
- In the popup window, use the "..." button to find your exported report and below, choose "html all", then click ok.
This should load report in a Calc sheet. From here you can make tweaks as you like.
Reports Included in GnuCash
This section (in progress; started on GnuCash 2.2.9 and now being updated to GnuCash 2.4.13) includes a small amount of information about the standard reports in GnuCash, including when they might be used and some of the options. Information about each report might include how the report is used, common alternatives, and some of the options that make the report adaptable to different situations.
Assets & Liabilities (Group)
Advanced Portfolio
The Advanced Portfolio report produces report on commodity accounts using price information collected by the optional stock price retrieval features of GnuCash. (If you have not installed and used the additional stock price retrieval software, the report will indicate an error.) This report includes extended information about commodity holdings, including information about the basis, gain, and return of individual commodities.
Asset Barchart
The Asset Barchart report displays bars that present the value of all assets in a Gnucash file on a monthly basis. By default, the report shows all accounts in Current Assets and Special Accounts, and it displays monthly bars for the current financial period. This report provides a graphic view of the assets in the file over time. Several settings on this report can greatly affect the information included.
- On the Accounts tab, the "Show Accounts until level" option changes how the report aggregates account totals. Change this value to see information at deeper levels of the account structure.
- On the Display tab, the "Maximum Bars" option will display more bars in the chart, allowing information for more accounts to display. Additionally, the "Show table" option enables the display of chart information in tabular form below the chart.
- On the General tab, the "Price Source" option can significantly affect the reported value of various commodities included in the report.
Asset Piechart
The Asset Piechart report displays in piechart layout the value of asset accounts in a Gnucash file as of a given date. By default, the report shows the seven largest asset accounts in Current Assets and Special Accounts, arranged in descending order by value as of the end of the current accounting period. Several settings on this report can greatly affect the information included.
- On the Accounts tab, the "Show Accounts until level" option changes how the report aggregates account totals. Change this value to see information at deeper levels of the account structure.
- On the Display tab, the "Maximum Slices" option will display more slices in the chart, allowing information for more accounts to display.
- On the General tab, the "End Date" option establishes the report's effective date. Additionally, the "Price Source" option can significantly affect the reported value of various commodities included in the report.
Average Balance
Balance Sheet
A Balance sheet report lists Asset, Liability, and Equity account balances for all such accounts, and provides totals on a given date. Balance sheets are commonly run for the last day of each fiscal year to give an overall sense of the financial condition of the entity.
General Journal
The General Journal produces a register of all transactions (beginning to end) in order by date, showing the accounts and the amounts moved among them, and totals the Net Change by all currencies and assets. This report is not customizable by date or account, though you can include more or fewer details about the individual transactions, and whether or not to include running balances and totals for the credits and debits. If you need a report restricted to particular accounts, you might want to look at the #Transaction Report or open a particular account and choose the #Account Transaction Report.
General Ledger
The General Ledger report produces information about all transactions for a selected set of accounts. When first run, this report loads no data, and the report options must be changed to retrieve information from the file.
Investment Portfolio
The Investment Portfolio report produces report on commodity accounts (that is, accounts with type "Stock" or "Mutual Fund"), giving holdings, price and value information about commodities in the file.
Liability Barchart
The Liability Barchart report displays bars that present the value of all liabilities in a Gnucash file on a monthly basis. By default, the report shows all accounts in Liabilities, and it displays monthly bars for the current financial period. This report provides a graphic view of the liabilities in the file over time. Several settings on this report can greatly affect the information included.
- On the Accounts tab, the "Show Accounts until level" option changes how the report aggregates account totals. Change this value to see information at deeper levels of the account structure.
- On the Display tab, the "Maximum Bars" option will display more bars in the chart, allowing information for more accounts to display. Additionally, the "Show table" option enables the display of chart information in tabular form below the chart.
Liability Piechart
The Liability Piechart report displays in piechart layout the value of liabilities in a Gnucash file as of a given date. By default, the report shows the seven largest liability accounts in Liabilities, arranged in descending order by value as of the end of the current accounting period. Several settings on this report can greatly affect the information included.
- On the Accounts tab, the "Show Accounts until level" option changes how the report aggregates account totals. Change this value to see information at deeper levels of the account structure.
- On the Display tab, the "Maximum Slices" option will display more slices in the chart, allowing information for more accounts to display.
- On the General tab, the "End Date" option establishes the report's effective date.
Net Worth Barchart
Net Worth Linechart
Price Scatterplot
Budget (Group)
Budget reports in GnuCash allow you to gather summary information related to budgets you may have created. In order for these reports to work, you must first create a budget.
Budget Balance Sheet
Budget Barchart
Budget Flow
Budget Income Statement
Budget Profit & Loss
Budget Report
Business (group)
Customer Report
Customer Summary Report
The "Customer Summary Report" is a customer profit report, it can help with job analysis by comparing the income and expenses for a specific customer. Under the options for the report a tab labeled "Expense Accounts" will allow the selection of one or many expense accounts. Likewise the tab for "Income Accounts" will allow the selection of one or more income accounts. The tab for "Display" will allow sorting by name, profit percentage, or amount of profit. The "No Customer" is a warning that the report may be inaccurate, as the results are not all properly labeled.
Possible use scenarios:
Tracking retail sales from different cities:
Income:Princeton Showroom Sales Income:Beckley Showroom Sales Expense:Princeton COGS Expense:Beckley COGS
Tracking rental properties:
Income:Downtown Income:Northwestern Income:Park Ave Expense:Downtown Expense:Northwestern Expense:Park Ave
Tracking types of business:
Income:Labor Income:Materials Expense:Labor Expense:Cost of Goods Sold
Tracking commission sales:
Income:Robert Sales Income:Micah Sales Expense:Robert COGS Expense:Micah COGS
So to get the most out of the report use the Income & Expense tabs to hone down the information displayed on the report. By default it includes all income and expense accounts, GnuCash can't really predict the names and classification of income and expense accounts. To be useful out of the box, any thing that happened income or expense wise shows up as "No Customer": Rent, Paychecks, Utilities, Bank Charges.. everything. Luckily it is easy to remove this information, if it is distracting. It can also shed a light on how much information is being ignored, if the settings are overly selective the report might look good, but only be showing 10% of the picture.
Why does the information look out of place by default:
All invoices have an "Owner" in GnuCash speak, so any invoices made will show a customer and make it to the report. When creating a "Bill" the "Default Chargeback Customer" is blank, and often gets underused. To use the profit report this needs to be utilized, this is the tag that decides which line to attach the expense. Without a customer the bill will belong to "No Customer", when entering income in a random register instead of creating an invoice, it will also belong to "No Customer", but that doesn't happen very often.
Inventory based businesses won't benefit as much because of the nature of the report. Currently there isn't a way to avoid this. Creating invoices for items out of inventory usually shows as 100% profit, hardly reality. The best way to handle this is to use a different income account and exclude it from the report, if that won't over-complicate the entry of invoices. Once you get on a good start the invoice line item auto-fill will help remember the accounts for inventory items.
--Provided by Robert L Brush III via gnucash-users
Easy Invoice
Employee Report
Fancy Invoice
Payable Aging
Printable Invoice
Receivable Aging
This report provides a listing of all customers, their current balance, and how much they have outstanding from invoices over different time periods -- how much they owe from 0-30 days, from 31-60 days, from 61-90 days, and over 90 days. The report also contains links to each customer and to their current customer report.
--quoting Buddha Buck via GnuCash-Users
Vendor Report
Income & Expense (group)
Budget Report
Cash Flow
The Cash Flow Report shows the change in value for a set of accounts (the flow of cash) over a given period of time. Be default, this report uses the data file's assets accounts as the base set of accounts. {Special Accounts are also selected by default? This is not known} It uses the current financial period as the default time period. The report enumerates all money coming in to and going out of the base accounts, in different sections. The amounts for each account are provided, along with totals.
Equity Statement
The Equity Statement can be seen as extension of the Balance Sheet report.
The Balance Sheets states the balance of Assets, Liabilities and Equity for a specific point of time.
The Equity Statement puts focus on the Equity Accounts by showing the cashflow to and from them for a given period of time (as set in the report options).
By Balancing this cashflow with the income, the report states the available "Capital" at the beginning and at the end of this time period.
Expense Barchart
The Expense Barchart (also known as Expense over Time) report shows a set of vertical bars, with the vertical axis indicating the amount, and the horizontal axis indicating time periods (such as quarters, months, or weeks). The report aggregates the amounts in the selected amounts. Report options enable you to adjust the horizontal and vertical sizes, step size (time periods), number of bars, and whether or not to include the detailed amounts in a table below the graph.
To create a chart for income accounts, see #Income Barchart.
Expense Piechart
The Expense Piechart report totals transactions for income accounts over a specified financial period, and presents the totals as graphical "wedges" of the aggregate total "pie." You might use such a report to get a "big-picture" overview of some of the largest expenses in your accounts. By default, the chart displays a maximum of 7 wedges, which limits the display the largest six wedges and combining all the remaining items into a seventh wedge marked "other."
To generate a pie chart display of your income accounts, use the #Income Piechart report.
Expenses vs. Day of Week
Income Barchart
The Income Barchart (also known as Income over Time) report shows a set of vertical bars, with the vertical axis indicating the amount, and the horizontal axis indicating time periods (such as quarters, months, or weeks). The report aggregates the amounts in the selected amounts. Report options enable you to adjust the horizontal and vertical sizes, step size (time periods), number of bars, and whether or not to include the detailed amounts in a table below the graph.
To create a chart for expense accounts, see #Expense Barchart.
Income & Expense Chart
Income Piechart
The Income Piechart report totals transactions for income accounts over a specified financial period, and presents the totals as graphical "wedges" of the aggregate total "pie." You might use such a report to get a "big-picture" overview of some of the largest income sources in your accounts. By default, the chart displays a maximum of 7 wedges, which limits the display the largest six wedges and combining all the remaining items into a seventh wedge marked "other."
To generate a pie chart display of your expense accounts, use the #Expense Piechart report.
Income Statement
An Income Statement report is also called a "Profit and Loss" report or "Revenue Statement."
In earlier versions of Gnucash, this report was called "Profit & Loss," but with GnuCash version 2, the report was re-named "Income Statement" to use more common accounting terminology.
This report lists Income and Expense account totals for a set period. By default it shows all Expense and Income accounts (down to 3 levels of sub-accounts) for the current financial period.
The Income Statement helps show where your money is coming from, and where it is going for a given time period.
Income vs. Day of Week
The Income vs. Day of Week report presents a pie chart showing the totals for selected income accounts totaled by the day of the week of the transaction. The report options enable you to make some adjustments (such as accounts, display options, and the date range) but the account selector only allows income accounts to be chosen. The report aggregates income transactions by day of week, not by any other period or category. Due to these limitations, the report may be considered a demonstration or an example to someone wanting to examine the source code for composing a useful custom report.
Trial Balance
Sample & Custom (group)
Custom Multicolumn Report
This selection let's you combine several standard and custom reports into one view.
Initially this report comes up with an empty window. The selection is done through the report Options, giving you the list of available reports from which you can select.
Saving the the Multicolumn View is done similar to saving custom reports, see Using_GnuCash#Custom_Reports.
Sample Report with Examples
Welcome Sample Report
Account Summary
Lists accounts and subaccounts, with a total of account balances as of a particular date. By default, shows accounts and totals down to third-level subaccounts.
- Report Usage:
This report provides an overview of all (or selected) accounts. The totals on this report (if shown) include all transactions to the beginning of each account, so the amounts may only be useful for asset and liability accounts that you reconcile, or expense accounts after you have "closed the books" to a particular financial period. (Closing the books is NOT a requirement in GnuCash.)
This report gives effectively the same information as the accounts page (that shows the accounts tree). You can use this report to export and print the accounts page information and make it accessible and readible for some outside GnuCash, as it is not possible to directly print from the accounts page.
- Suggested Alternatives:
To generate a report of account totals over a particular period (especially if you do not close your books at regular intervals), you might consider using the #Income Statement, #Cash Flow, or #Budget Report.
- Report Options:
- Accounts tab: Choose accounts to display; levels of subaccounts; Depth limit behavior (how to handle any accounts lower than the set level of subaccounts -- choosing between Recursive Balance, Raise Accounts, or Omit Accounts).
- Commodities tab: Currency; Price Source (Average Cost, Weighted Average, Most Recent or Nearest in Time); Show Foreign Currencies; Show Exchange Rates
- Display tab: Include accounts with zero total balances; Omit zero balance figures, Parent account balances (Account Balance, Subtotal, and Do not show); Parent account subtotals (Show subtotals, Do not show, or Text book style [experimental]); Display accounts as hyperlinks; Show accounting-style rules; Account balance; Account Code; Account Description; Account Type; Account Notes.
- General tab: Report name; Stylesheet (Default, Easy, and Technicolor); Report Title; Company Name; Date.
Saved Report Configurations
Selecting this menu option will open a dialog window with a list of available Saved Report Configurations.
In this context Saved Report Configurations mean sets of customized settings for standard reports.
These sets need to be saved by the user before they show up in this list. This is how you do it:
- Go to the Reports Menu and choose the required report type
This will open the report with standard settings - Go to the report Options and change the settings
Do this repeatedly until this report type shows the info according to your needs - Go to the report options, select the General section and change the Report Name to a significant term that let you remember the goal for the change settings
Do not confuse this with the Report Title, it only works for Report Name - Click the Save Report Configuration or Save Report Configuration As... button
This will store the just customized report options in a file in your home directory
Linux Ubuntu:~/.gnucash/saved-reports-<versioninfo>
The first time you save a report with a name that has not already been saved, you can use either the Save Report Configuration or the Save Report Configuration As... button. You can modify the report name before saving it.
Once a report has been saved with the current name, the Save Report Configuration button will immediately update the saved report configuration without giving the opportunity to save the configuration with a new name. Use the Save Report Configuration As... button to save the current report configuration with a new name.
Now your customized report is available for use by the Reports->Saved Report Configurations entry and it will also be listed when starting Reports->Sample&Custom->Custom Multicolumn Report.
Managing the saved report configurations is simple. The option to delete a saved report configuration is given in the dialog window showing after selecting Reports->Saved Report Configurations.
If you want to edit your saved report configurations, then
- open the report via Reports->Saved Report Configurations
- keep the tab open, and select Reports->Saved Report Configurations again
- in the upcoming dialog window select the report
- press Delete and confirm
- press Cancel to get back to the opened report tab
and then go again through the procedure as listed on top of this section.
Future Scheduled Transactions Summary
to be done
Tax Report & TXF Export
Generates a report and a downloadable .txf file of taxable income and deductible expenses for a particular accounting period. To download the report data, choose the Export button on the toolbar and choose between html and .txf downloadable versions.
To use this report, you must use Edit --> Tax Options to identify which form the taxing authority uses for each income or expense account. (You can see but not modify the "Tax related" checkbox in Edit --> Edit Account.)
Transaction Report
This report lists the transactions in all accounts during a specified financial period. By default the report includes all accounts, subtotals the transactions by month and includes the totals for each account for the currently defined fiscal year.
Account Report
The Account Report is not meant to be run on a selected account. It can only be run from a ledger window in GnuCash . A ledger window is the tab-window that can be created e.g. by opening an account (double-click on an account in the accounts page) or by running a find (Edit->Find) which will list the find result in a ledger window.
The Account Report only appears on the Report menu when a ledger window is the current top window in GnuCash. You will not find it when looking at e.g. a report or the accounts page.
The Account Report produces a list of all transactions in the open ledger window.
You can use this report to export and print the transactions listed in a ledger window to make it readible and accessible for someone outside GnuCash.
Account Transaction Report
The Account Transaction Report has the same pre-requisites as the Account Report, but the Account Transaction Report only lists transaction that have been selected (e.g. by mouse click) in the current ledger window.
If now transaction is selected, an empty report will be generated. (This is valid for 2.4.x. For 2.5.3 no report will be generated if no transaction is selected.)
You can use this report to export and print transaction data of a single transaction and make it accessible and readible for someone outside GnuCash.
If you need to see transactions in other accounts or for different dates, you could use the #Transaction Report or Find ( Edit --> Find ) to create an ad-hoc report.
Stocks
- Add stock to portfolio
- Add historic stock quotes to the database
- Importing fund or stock prices from an OFX file
GnuCash on Holidays with your friend
Yes you can use GnuCash while on holidays with your friend.
Here's what you need:
- a computer + gnucash - a freshly created gnucash file - two people on holiday wanting to share costs.
Setup:
1. Account schema: - Group Account "Cash", with one account named Me, and one named MyFriend - Group Account "Expenses", with accounts like Lunch, Dinner, AfterEight, Hostels, TravelCosts etc. - Group Account "Equity", with one account named Me, and one named MyFriend
2. Initial deposit:
Before taking off, both you and your friend empty your wallets, and count the money inside. No need to create a third wallet. Gnucash will take care of that. Now say your friend has 15.50 in her wallet. The booking in GnuCash is : Cash:YourFriend +15.50 Equity:YourFriend -15.50 See how easy that is?
3. After the holidays are over:
Again count the money inside both of your wallets, then create the exact opposite booking for the remainder in cash. So let us say you paid for everything and your friend paid nothing, then the booking after the holidays would be: Cash:YourFriend -15.50 Equity:YourFriend +15.50
So now you see that Equity is really what you put into the holidays. In your friend's case: -15.50 + 15.50 = 0 IMPORTANT: the Equity:Me and Equity:MyFriend show how much you put into the holiday each. Calculation to make 50-50: subtract the lower amount from the higher amount, then divide this subtracted amount by two. The result is what the owner of the lower amount should pay the owner of the higher amount. Example: You spent 150 dollars, your friend spend nada. Now 150-0=150 . 150 : 2 = 75. So your friend needs to pay you 75 dollars.
4. While on holidays, adding cash money:
From whatever funding you add to your wallet (Cash:Me) it is a deposit so you can book the same as with (2. Initial deposit)
5. While on holidays, spending money:
Now here is the interesting part. What was the money spent on? Whatever the answer, one thing is clear: Expenses:XXX go up, and some other account goes down.
5a. Option#1: While on holidays, your friend spends money to buy two beers, one for you, one for her (beer costs 2.20 each): This is where Expenses:XXX is debited (plus amount) and the Cash:YYY or Equity:ZZZ is credited (minus amount).
- With cash payment, it is Cash:YourFriend -4.40 Expenses:AfterEight +4.40 - However, if she paid with creditcard, it is Equity:YourFriend -4.40 Expenses:AfterEight +4.40
5b. Option#2: While on holidays, you spend money from your own cash on private affairs (private affairs cost 9.70). This is where Equity:Me is debited and Cash:Me is credited (less cash)
- With cash payment, it is Cash:Me -9.70 Equity:Me +9.70 - If you used your own creditcard, it is Equity:Me -9.70 Equity:Me +9.70
This last line looks a little stupid for the laymen bookkeeping, so best use your own creditcard and not tell GnuCash about private affairs.
Enjoy ! Best regards, Ron
Getting started with GnuCash' business features
A prerequisite for using the Business features of GnuCash is that you have some business related accounts setup (Accounts Receivable/Accounts Payable). The easiest way to do this is to create a new file and add Business Accounts in addition to the Common Accounts.
To get to your invoice you could take these steps:
- If you want GnuCash to deal with taxes properly you should first set up the proper tax tables for your country
- Select Business-Tax Table Editor
- Create a new tax table and set the proper tax amounts (for example, here in Belgium we have 21% VAT, so I have a tax table with one entry for 21%)
- Customer
- Select Business->Customer->New Customer
- Enter the required fields
- Optionally select a tax table
- Hit ok
- For your project, you can create a job
- Select Business->Customer->New Job
- Enter the information you need
- Note: in 2.2.x you have to use the "Select" button to enter a customer, the text field is read-only
- Hit ok
- Now you can create your invoice
- Select Business->Customer->New Invoice
- Select a customer and job and set the other fields to your likings
- Hit OK
- The invoice entry window should appear now as a new tab in the main window
- Enter all the lines you wish to appear on your invoice in this window. The entry method is similar to the normal GnuCash register. Enter here for example your work, the items you sell to the customer and additional charges such as freight and insurance.
- Note that GnuCash will calculate the taxes and totals automatically. You find them at the bottom of the window.
- When you are satisfied with the invoice entries, you have to post the invoice:
- Select Edit->Post Invoice
- Choose a post date and hit OK
That should be it. You can now print your invoice:
- You can use either
- Reports->Business->Easy Invoice
- Reports->Business->Fancy Invoice
- Reports->Business->Printable Invoice
- I'm not exactly sure what the difference is. Just take the one you like best
- Choose one of the three reports above
- It will open with an empty window. Click on the options button (second button from the right in the toolbar) to configure your report.
- The most important information is the invoice number (use the Select button)
- Other than that, you can play a little with the layout of your invoice, by changing the other options.
- When finished, hit ok and the invoice will display onscreen. You can choose to print it from there.
-- Provided by Geert Janssens
Using third party software for data exploration and visualization
You can use third party software like Excel, Tableau and Qlik Sense to explore and visualize GnuCash data through an ODBC connection as long as you save your data in sqlite format.
Here are instructions for Qlik Sense in Windows 10 (I chose Qlik Sense because it is a free download).
I wanted to visualize GnuCash transaction data without having to write templates and compile stuff, so I turned to QlikSense as they have a free personal edition (although similar steps would work for Tableau and other software that accepts ODBC connections). The trick is fairly simple:
- Download sqlite3 drivers (for windows: install the 64bit version from http://www.ch-werner.de/sqliteodbc/)
- Export your GnuCash data as a sqlite file
- Configure the ODBC providers in your operating system to point to the Gnucash export
- Open Control Panel >> Administrative Tools >> Data sources (ODBC)
- Click on System DSN, then on Add
- Select Sqlite3 ODBC Driver, then click Create
- Provide a name for the connection (GnuCash)
- Under Database Name, click on Browse and select the file you exported from GnuCash
- Click Ok, then Ok again to close the previous dialog
- Open QlikSense, create a new app, load data via ODBC, select System DNS and the source you created earlier
- In the Data Editor, open or create a section and write some SQL. This is the trickiest part. See an example below.
- The results of the queries are automatically joined through columns of the same name; go into your app overview and start editing a sheet. The charts and tables you add will be tied together automatically!
Sample SQL Queries:
LIB CONNECT TO [GnuCash]; //* [expense_accounts]: SQL SELECT accounts.name AS parent_account, p_acc.name AS account, p_acc.hidden AS account_is_hidden, p_acc.placeholder AS account_is_placeholder FROM accounts INNER JOIN accounts AS p_acc ON p_acc.parent_guid = accounts.guid WHERE accounts.account_type = 'EXPENSE' AND accounts.hidden = 0 AND p_acc.hidden = 0; //*/
User G2010a has a repository with some more GnuCash-related queries.