Send gnucash-user mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."
Today's Topics:
1. GnuCash 2.7.2 released (John Ralls)
2. Re: bank entries (Christine )
3. Re: bank entries (Colin Law)
4. RE: bank entries (Ken Pyzik)
5. Re: bank entries (DaveC49)
6. RE: bank entries (Christine )
7. Re: bank entries (David Carlson)
8. Re: bank entries (Maf. King)
9. recover GNUcash data after windows crash (Ian McAllister)
10. Re: recover GNUcash data after windows crash (David T.)
----------------------------------------------------------------------
Message: 1
Date: Sun, 26 Nov 2017 10:34:38 -0800
From: John Ralls <[email protected]>
To: Gnucash Users <[email protected]>
Subject: GnuCash 2.7.2 released
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
The Gnucash Development Team is pleased to release Gnucash 2.7.2, the third
release of an unstable series leading to Gnucash 2.8.0.
This release is UNSTABLE and SHOULD NOT BE USED in production.
This release changes file locations, binding APIs, report options, and can make
your data file no longer compatible with previous versions. See the Update
Notes Page for details.
See the KNOWN PROBLEMS list at the bottom of the announcement.
Bugs fixed in this release
? Bug 734865 - Assign as Payment... can silently 'unpay' a payed invoice
? if the selected transaction is already linked to an existing
payment, the payment dialog will present this payment again (same partner,
post-to account, same selected document(s), same amount, memo, and transfer
account).
? if the selected transaction is not linked to an existing
business transaction the logic will make a best guess as to whether the payment
should be for a customer or vendor.
? in both situations if the existing transaction has multiple
splits that can be considered as transfer (or 'payment') splits the payment
dialog can't work with it (it can only deal with one transfer split). In this
case the user will be informed that only one valid transfer split will be
retained and the others ignored.
? the other thing the payment dialog can't handle are APAR type
splits that are not associated to a lot at all. In case of transactions not
part of a business transaction they will be silently ignored on the assumptions
these were manually entered transactions with the intention to be linked to
business transactions. On the other hand if such a split is part of a
transaction that is also linked to a business payment already, a warning will
be issued these splits will be removed from the new payment.
? Bug 778692 - Assign as payment should work for employee expense
vouchers
? if gnucash can deduce a partner from the transaction that
partner will be proposed this works for all transactions that are part of a
business transaction already and will correctly detect pre-existing customer,
vendor and employee payments
? if no partner can be deduced gnucash will assume the
transaction to be a vendor or customer payment based on the sign
? in all cases the user can change the partner type in the
payment window that's presented to any of customer, vendor or employee to
correct gnucash' suggestion.
? Bug 784623 - GNUCash does not work with sql backend.
Wherin the problem is that MySQL's TIMESTAMP has a date range of 1970-01-01
00:00:01 to 2038-01-19 03:14:07 and is unable to handle time_t of 0. MySQL's
TIMESTAMP also assumes that input is in the server's timezone and adjusts it to
UTC. GnuCash has already done that conversion.
? Bug 789608 - Compilation problems when linking libraries.
? Bug 789928 - FTBFS with libdbi 0.9.0-5 on Debian.
? Bug 790550 - FTBFS: missing __init__.py
Some other fixes not associated with reported bugs:
? SQL parameter quoting is corrected in the backend so that only string
parameters are quoted. This caused trouble when trying to store SQL NULL; the
string 'NULL' is different from the value NULL.
? SQL table versions weren't set consistently and a bogus version test
could cause some tables to be not loaded.
? Better, more targeted handling of MySQL's penchant for setting date-time fields
to "0000-00-00 00:00:00" if it doesn't like the input. This should be much less
common thanks to fixing Bug 784623.
? Major repairs to the "Dense Calendar" date selector.
? Fix colors on graph reports so that the selections work and the
defaults are no longer transparent.
? Two large batches of styling fixes for Gtk3 from Bob Fewell.
? Fix the guile-compiled path in the environment file so that GnuCash
can start on Windows.
? Convert the graphical reports to use GnuCash's rational numbers
instead of doubles for better accuracy.
KNOWN PROBLEMS:
? On Microsoft Windows starting the AQBanking Setup Wizard crashes
GnuCash.
? test-import-bayes built with autotools intermittently fails at line
381, where the returned value is 1 instead of the expected 6.
Getting GnuCash for Windows and MacOS X
GnuCash is provided for both Microsoft Windows XP? and later and MacOS X 10.9
(Mavericks)? and later in pre-built, all-in-one packages. An installer is
provided for Microsoft Windows? while the MacOS X? package is a disk image
containing a drag-and-drop application bundle.
SourceForge:
? Download GnuCash for Win32
? Download GnuCash for Mac-Intel
Github
? Download GnuCash for Win32
? Download GnuCash for Mac-Intel
Getting GnuCash as source code
If you want to compile GnuCash 2.7.2 for yourself, the source code can be
downloaded from:
? Sourceforge: bzip2 tarball, gzip tarball, all files.
? Github: bzip2 tarball, gzip tarball WARNING Do not try to use the
github-generated files labelled "Source Code". They have not been processed
with swig and will not build.
? You can also checkout the sources directly from the git repository as
described here.
The SHA256 Hashes for the downloadable files are:
? baa6bae13918da62be58fe09d904ccf38893607e57dae4eba53db4ff96ab61b3
gnucash-2.7.2.tar.bz2
? 567e654f24e611a780ef66d3e92c0da695196594c7611bbfa99e550e04a2ca87
gnucash-2.7.2.tar.gz
? ea5ec52e896e05eec4659088866dca5132374f5e9ed424a4e2ad4d4d072b7be5
gnucash-2.7.2.setup.exe
? 5fe6fab0374ca77a86257ee83ee07288909c8f6b256b790ab8b1ff6e054eafff
Gnucash-Intel-2.7.2-1.dmg
Please consult the README.dependencies file in the sources for the required
dependencies and versions needed to build GnuCash from source. Additional
information on building GnuCash may be found in the Wiki
Getting the documentation
The documentation is available at Documentation page of the GnuCash website. Please refer
to the "Nightly Builds" section at the bottom of the page.
About the Program
GnuCash is a free, open source accounting program released under the GNU
General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, Mac
OSX and Microsoft Windows. Programming on GnuCash began in 1997, and its first
stable release was in 1998.
------------------------------
Message: 2
Date: Sun, 26 Nov 2017 21:52:12 -0000
From: "Christine " <[email protected]>
To: <[email protected]>
Subject: Re: bank entries
Message-ID: <007101d36700$d143d1a0$73cb74e0$@net>
Content-Type: text/plain; charset="us-ascii"
Whenever I post a deposit to the bank, it makes a withdrawal of the same
amount and I cannot get it to just take the entry, can anyone help pls
Christine
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
------------------------------
Message: 3
Date: Sun, 26 Nov 2017 22:06:55 +0000
From: Colin Law <[email protected]>
To: Christine <[email protected]>
Cc: "[email protected]" <[email protected]>
Subject: Re: bank entries
Message-ID:
<CAL=0glsyi8whmsnv5mu92+zn_lkukih0oxxhxdl9yumz3fm...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Have you read the tutorial and concepts guide? [1]
It sounds like you are making a basic mistake in how you are entering it.
Colin
[1] http://www.gnucash.org/docs/v2.6/C/gnucash-guide/
On 26 November 2017 at 21:52, Christine via gnucash-user
<[email protected]> wrote:
Whenever I post a deposit to the bank, it makes a withdrawal of the same
amount and I cannot get it to just take the entry, can anyone help pls
Christine
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
gnucash-user mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
------------------------------
Message: 4
Date: Sun, 26 Nov 2017 14:20:37 -0800
From: "Ken Pyzik" <[email protected]>
To: "'Christine'" <[email protected]>
Cc: <[email protected]>
Subject: RE: bank entries
Message-ID: <[email protected]>
Content-Type: text/plain; charset="us-ascii"
Christine -- without seeing the entry it is difficult to determine why is it
doing what you say it is. As a matter of principle, you must remember that
there must be a corresponding "other-side" to your deposit entry. While
this may seem counter-intuitive, your deposit to your bank account needs to
have a corresponding (and opposite) entry to another account. The way I
have mine is I have my bank account (account type BANK) and another account
called Income-deposits (account type INCOME). When I make a deposit to my
bank account the "transfer account" (or other side of the entry) is to the
income account. You will notice that the deposit to a BANK type account
will be on the "left side" (thus increasing the balance of the bank account)
and the entry will be on the "right side" of the income-deposits account
which will be income and thus increase the value of this account.
So it is very much dependent upon how you have setup your accounts.
Hope that makes sense.
-----Original Message-----
From: gnucash-user [mailto:[email protected]]
On Behalf Of Christine via gnucash-user
Sent: Sunday, November 26, 2017 1:52 PM
To: [email protected]
Subject: Re: bank entries
Whenever I post a deposit to the bank, it makes a withdrawal of the same
amount and I cannot get it to just take the entry, can anyone help pls
Christine
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
gnucash-user mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
------------------------------
Message: 5
Date: Sun, 26 Nov 2017 19:20:29 -0700 (MST)
From: DaveC49 <[email protected]>
To: [email protected]
Subject: Re: bank entries
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
Christine,
Gnucash is a double entry accounting system. What this means is that any
transaction affects at least two accounts. For example when you purchase
something your bank account is credited by the amount of the purchase any
purchase is also an expense so an expense account has to be debited by the
amount of the purchase in the second component of the transaction. These two
components of the one transactions are referred to in Gnucash as "splits".
The same methodology is applied to any other sort of transaction, it will
always consist of at least two components ( and sometimes more) affecting at
least two accounts. In any single transaction the sum of the debit and the
sum of the credit components of the splits of that transaction must be equal
The Gnucash Tutorial and Concepts guide
(https://www.gnucash.org/docs/v2.6/C/gnucash-guide/) along with the
Wikipedia articles on double entry bookkeeping
(https://en.wikipedia.org/wiki/Double-entry_bookkeeping_system will give you
some background information. Gnucash follows what is called the Accounting
Equation or American approach in this article. The article on the Accounting
equation (https://en.wikipedia.org/wiki/Accounting_equation) also provides
some useful background.
That said, it is possible when you are entering a transaction and create the
deposit split to your bank account (this will be a debit to that account if
you use the accounting terms) what you are seeing is the other
component/split of the transaction being automatically created. If you have
not yet created appropriate income accounts, it may be assigning your bank
account as the default account for this second split which will be a
credit. If you click in the account field in the second split, you should be
able to select a different account from your chart of accounts.
For a deposit to your bank account, the account for the second split would
normally be an income account for money coming from an external source or
another asset account if you are transferring money between accounts ofr
example.
David
-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
------------------------------
Message: 6
Date: Mon, 27 Nov 2017 02:33:50 -0000
From: "Christine " <[email protected]>
To: "'DaveC49'" <[email protected]>, <[email protected]>
Subject: RE: bank entries
Message-ID: <008601d36728$29bcace0$7d3606a0$@net>
Content-Type: text/plain; charset="us-ascii"
Hi Dave
My accounts are Cash, Bank, Income, various expenses, and 2 people who I pay
money too and who pay to the bank.
IF I balance one of the accounts another goes wrong. All I want to do is add
my bank and my cash and let gnucash do the rest (ie an income and
expenditure report) but it is not working. Reading the literature I just get
confused as I am used to DR and CR.
Thanks anyway maybe I should look for an easier program if anyone knows of
one
Christine
-----Original Message-----
From: gnucash-user
[mailto:[email protected]] On Behalf
Of DaveC49
Sent: 27 November 2017 02:20
To: [email protected]
Subject: Re: bank entries
Christine,
Gnucash is a double entry accounting system. What this means is that any
transaction affects at least two accounts. For example when you purchase
something your bank account is credited by the amount of the purchase any
purchase is also an expense so an expense account has to be debited by the
amount of the purchase in the second component of the transaction. These two
components of the one transactions are referred to in Gnucash as "splits".
The same methodology is applied to any other sort of transaction, it will
always consist of at least two components ( and sometimes more) affecting at
least two accounts. In any single transaction the sum of the debit and the
sum of the credit components of the splits of that transaction must be equal
The Gnucash Tutorial and Concepts guide
(https://www.gnucash.org/docs/v2.6/C/gnucash-guide/) along with the
Wikipedia articles on double entry bookkeeping
(https://en.wikipedia.org/wiki/Double-entry_bookkeeping_system will give you
some background information. Gnucash follows what is called the Accounting
Equation or American approach in this article. The article on the Accounting
equation (https://en.wikipedia.org/wiki/Accounting_equation) also provides
some useful background.
That said, it is possible when you are entering a transaction and create the
deposit split to your bank account (this will be a debit to that account if
you use the accounting terms) what you are seeing is the other
component/split of the transaction being automatically created. If you have
not yet created appropriate income accounts, it may be assigning your bank
account as the default account for this second split which will be a
credit. If you click in the account field in the second split, you should be
able to select a different account from your chart of accounts.
For a deposit to your bank account, the account for the second split would
normally be an income account for money coming from an external source or
another asset account if you are transferring money between accounts ofr
example.
David
-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
------------------------------
Message: 7
Date: Sun, 26 Nov 2017 22:49:24 -0800
From: David Carlson <[email protected]>
To: Christine <[email protected]>
Cc: DaveC49 <[email protected]>, "[email protected]"
<[email protected]>
Subject: Re: bank entries
Message-ID:
<cadygsbmy8n2c9xhe70mfqjhkfnitzp_8tzbkcuikocdp35b...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Christine,
If you receive income you might deposit it into the bank. If you spend
money for groceries, you use cash. If you withdraw money from the bank you
transfer from bank to cash.
That is what double entry is about.
David C,
On Sun, Nov 26, 2017 at 6:33 PM, Christine via gnucash-user <
[email protected]> wrote:
Hi Dave
My accounts are Cash, Bank, Income, various expenses, and 2 people who I
pay
money too and who pay to the bank.
IF I balance one of the accounts another goes wrong. All I want to do is
add
my bank and my cash and let gnucash do the rest (ie an income and
expenditure report) but it is not working. Reading the literature I just
get
confused as I am used to DR and CR.
Thanks anyway maybe I should look for an easier program if anyone knows of
one
Christine
-----Original Message-----
From: gnucash-user
[mailto:[email protected]] On Behalf
Of DaveC49
Sent: 27 November 2017 02:20
To: [email protected]
Subject: Re: bank entries
Christine,
Gnucash is a double entry accounting system. What this means is that any
transaction affects at least two accounts. For example when you purchase
something your bank account is credited by the amount of the purchase any
purchase is also an expense so an expense account has to be debited by the
amount of the purchase in the second component of the transaction. These
two
components of the one transactions are referred to in Gnucash as "splits".
The same methodology is applied to any other sort of transaction, it will
always consist of at least two components ( and sometimes more) affecting
at
least two accounts. In any single transaction the sum of the debit and the
sum of the credit components of the splits of that transaction must be
equal
The Gnucash Tutorial and Concepts guide
(https://www.gnucash.org/docs/v2.6/C/gnucash-guide/) along with the
Wikipedia articles on double entry bookkeeping
(https://en.wikipedia.org/wiki/Double-entry_bookkeeping_system will give
you
some background information. Gnucash follows what is called the Accounting
Equation or American approach in this article. The article on the
Accounting
equation (https://en.wikipedia.org/wiki/Accounting_equation) also provides
some useful background.
That said, it is possible when you are entering a transaction and create
the
deposit split to your bank account (this will be a debit to that account if
you use the accounting terms) what you are seeing is the other
component/split of the transaction being automatically created. If you have
not yet created appropriate income accounts, it may be assigning your bank
account as the default account for this second split which will be a
credit. If you click in the account field in the second split, you should
be
able to select a different account from your chart of accounts.
For a deposit to your bank account, the account for the second split would
normally be an income account for money coming from an external source or
another asset account if you are transferring money between accounts ofr
example.
David
-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
gnucash-user mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
------------------------------
Message: 8
Date: Mon, 27 Nov 2017 08:27:01 +0000
From: "Maf. King" <[email protected]>
To: Christine <[email protected]>
Cc: [email protected]
Subject: Re: bank entries
Message-ID: <4887569.lTmUt3ZDRC@janus>
Content-Type: text/plain; charset="UTF-8"
On Monday, 27 November 2017 02:33:50 GMT Christine via gnucash-user wrote:
Reading the literature I just get
confused as I am used to DR and CR.
Christine
Hi Christine,
if you are used to the terminology of DR and CR to describe the sides of a
transaction, then perhaps you would be helped by enabling "use formal
accounting labels" in the preferences of GC. This will put Debit & Credit as
the column headings in the account registers, rather than the more descriptive
(but variable) headings such as "withdrawal" etc.
Edit Menu -> Preferences -> Accounts Tab.
HTH,
Maf.
------------------------------
Message: 9
Date: Mon, 27 Nov 2017 22:24:07 +0800
From: Ian McAllister <[email protected]>
To: [email protected]
Subject: recover GNUcash data after windows crash
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8; format=flowed
Hi, I think I sent my earlier message to the wrong address.
My motherboard crashed and I needed a new one and re-installed Windows.
Fortunately I had a backup of my main folders.
I copied the GNUcash folder across from the backup then re-installed
over the top of it, in the hope that I would then have all my data files
included, but it didn't work that way.
So I found \Users\myusernam\.gnucash\books which contained my old files
AccountsBusiness.gnucash.gcm
Personal.gnucash.gcm
I copied these and ran the program, which identified the two files. I
highlighted and clicked each in turn, and was told both times
No suitable backend was found for
file://C:\Users\#######\.gnucash\books\AccountsBusiness.gnucash.gcm.
How can I get back my books?
Ian McAllister
------------------------------
Message: 10
Date: Mon, 27 Nov 2017 19:32:14 +0500
From: "David T." <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: recover GNUcash data after windows crash
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Ian,
Gcm files are not your data files. They are metadata files. Similarly, the
?.gnucash? folder is the system folder that holds this metadata. Your data
files (AccontsBusiness.gnucash and Personal.gnucash) are somewhere else on your
backup. Put those on your new machine (not in the ?.gnucash foldr?, BTW), and
you?ll have your data.
HTH,
David
On Nov 27, 2017, at 7:24 PM, Ian McAllister <[email protected]> wrote:
Hi, I think I sent my earlier message to the wrong address.
My motherboard crashed and I needed a new one and re-installed Windows.
Fortunately I had a backup of my main folders.
I copied the GNUcash folder across from the backup then re-installed over the
top of it, in the hope that I would then have all my data files included, but
it didn't work that way.
So I found \Users\myusernam\.gnucash\books which contained my old files
AccountsBusiness.gnucash.gcm
Personal.gnucash.gcm
I copied these and ran the program, which identified the two files. I
highlighted and clicked each in turn, and was told both times
No suitable backend was found for
file://C:\Users\#######\.gnucash\books\AccountsBusiness.gnucash.gcm.
How can I get back my books?
Ian McAllister
_______________________________________________
gnucash-user mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
------------------------------
Subject: Digest Footer
_______________________________________________
gnucash-user mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
------------------------------
End of gnucash-user Digest, Vol 176, Issue 55
*********************************************
