gnucash-user Digest, Vol 129, Issue 39

John Donnee jdonnee at ec.rr.com
Mon Dec 30 13:42:34 EST 2013


Message 1. Split Transactions

I also had difficulty following the example in the Users Guide. It would be a real help to me if there was an example showed something like an expense report where you had multiple expense items that needed to be posted to different categories.

Thanks
John Donnee

910.622.8111
8422 Emerald Dunes Rd.
Wilmington, NC 28411

On Dec 30, 2013, at 12:00 PM, gnucash-user-request at gnucash.org wrote:

> Send gnucash-user mailing list submissions to
> 	gnucash-user at gnucash.org
> 
> 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
> 	gnucash-user-request at gnucash.org
> 
> You can reach the person managing the list at
> 	gnucash-user-owner at gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>   1. Re: Entering Split Transactions (Buddha Buck)
>   2. Re: EU en USD currencies not updated after upgrading to
>      Ubunto 12.04 (liberace)
>   3. Invoicing On-going Customers - A New Invoice Each Year?
>      (Terry Morse)
>   4. Re: Entering Split Transactions (David Carlson)
>   5. Announcement: GnuCash 2.6.0 Released (John Ralls)
>   6. Re: Announcement: GnuCash 2.6.0 Released (Maf. King)
>   7. Re: EU en USD currencies not updated after upgrading to
>      Ubunto 12.04 (Frank H. Ellenberger)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Sun, 29 Dec 2013 23:55:24 -0500
> From: Buddha Buck <blaisepascal at gmail.com>
> To: Bob Qualls <bobqualls84 at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: Entering Split Transactions
> Message-ID:
> 	<CAAyPE3BoHMMyk7SUZ2LLrbxcKYp7Crrc5pmTc5vaUCARD7vmeg at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
> 
> In a split, the left-hand column and the right-hand column have to balance.
> In your example, you have 670+180+90+60=1000 in the left-hand column, and
> 1000 in the right-hand column.  That seems to balance to me.
> 
> Perhaps the confusion is coming from the column headers: the right-hand
> column is shown in that screen-shot as "total withdrawal", but you aren't
> doing a withdrawal of 1000, so what's the 1000 doing there?  The answer is
> that while a regular "non-split" transaction shows the transaction from the
> viewpoint of one account of the two affected accounts, a "split"
> transaction shows the transaction from the viewpoint of all affected
> accounts simultaneously.  The "Account" column for the final row (with the
> $1000 "total withdrawal") shows the account "Income:Salary", which is where
> you are getting the money to deposit from.  But for the "Income:Salary"
> account, the right-hand column is not "total withdrawal", it's "Income"
> (with the left-hand being "Charge").  It make sense for the $1000 that goes
> into your checking account, taxes, etc to be recorded as "Income" from your
> Income:Salary account.
> 
> There are 5 accounts in this transaction.  In one, the left-hand/right-hand
> columns read "Deposit/Withdrawal", in three, they read "Expense/Rebate",
> and in the last, they read "Charge/Income".  It is impossible to show all
> those labels at once, so only the labels for the account in that register
> (Checking) is used.  I just noticed that when selecting a split, they all
> get "Tot. " prepended, which may be making things more confusing.
> 
> This is one of the reasons I, personally, use "formal accounting labels".
> For me, every left-hand column is labelled "Debit", and every right-hand
> column is labeled "Credit" (or "Tot Debit/Tot Credit" with splits).  So
> when I look at an analogous transaction, I can see my total debits equal my
> total credits in a split, and I know that for my salary, my "After Tax"
> salary is debited to my checking account and my "Before Tax" salary is
> credited to my Income:Salary account.
> 
> Does this help?
> 
> 
> On Sun, Dec 29, 2013 at 10:07 PM, Bob Qualls <bobqualls84 at gmail.com> wrote:
> 
>> As I'm trying to master entering split transactions, as demonstrated in the
>> tutorial (see attachment as a location reference in the tutorial), I find
>> that I have to continually clear the amount entered by default in the
>> "Withdrawal" column to get the numbers to work out correctly.  Is this
>> typical behavior, or am I doing something incorrectly?
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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: 2
> Date: Mon, 30 Dec 2013 02:13:24 -0800 (PST)
> From: liberace <philsdutchie at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: EU en USD currencies not updated after upgrading to
> 	Ubunto 12.04
> Message-ID: <1388398404831-4666641.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
> 
> Ok Frank
> 
> Here are the results. Hope they give you some insights whats wrong.
> 
> gnc-fq-dump -v yahoo USDEUR=X
> 
> 
> 
> nav:                      <=== one of these
>     price: 0.7276               <=/        
>  timezone:                      <=== optional
> 
> All fields returned by Finance::Quote for stock USDEUR=X
> 
> stock           field  value
> -----           -----  -----
> USDEUR=X          ask: 0.7277
> USDEUR=X      avg_vol: 0
> USDEUR=X          bid: 0.7275
> USDEUR=X          cap: 
> USDEUR=X        close: 
> USDEUR=X     currency: EUR
> USDEUR=X         date: 12/30/2013
> USDEUR=X    day_range: N/A - N/A
> USDEUR=X          div: 
> USDEUR=X     div_date: 
> USDEUR=X    div_yield: 
> USDEUR=X          eps: 
> USDEUR=X       ex_div: 
> USDEUR=X         high: 
> USDEUR=X      isodate: 2013-12-30
> USDEUR=X         last: 0.7276
> USDEUR=X          low: 
> USDEUR=X       method: yahoo
> USDEUR=X         name: USD to EUR
> USDEUR=X          net: 
> USDEUR=X         open: 
> USDEUR=X     p_change: 
> USDEUR=X           pe: 
> USDEUR=X        price: 0.7276
> USDEUR=X      success: 1
> USDEUR=X       symbol: USDEUR=X
> USDEUR=X         time: 04:38
> USDEUR=X       volume: 
> USDEUR=X   year_range: N/A - N/A
> 
> 
> ------------------------------------------------------------------
> 
> gnc-fq-dump -v yahoo USDEUR=X
> Finance::Quote fields Gnucash uses:
>    symbol: USDEUR=X             <=== required
>      date: 12/30/2013           <=== required
>  currency: EUR                  <=== required
>      last: 0.7275               <=\       
>       nav:                      <=== one of these
>     price: 0.7275               <=/        
>  timezone:                      <=== optional
> 
> All fields returned by Finance::Quote for stock USDEUR=X
> 
> stock           field  value
> -----           -----  -----
> USDEUR=X          ask: 0.7275
> USDEUR=X      avg_vol: 0
> USDEUR=X          bid: 0.7275
> USDEUR=X          cap: 
> USDEUR=X        close: 
> USDEUR=X     currency: EUR
> USDEUR=X         date: 12/30/2013
> USDEUR=X    day_range: N/A - N/A
> USDEUR=X          div: 
> USDEUR=X     div_date: 
> USDEUR=X    div_yield: 
> USDEUR=X          eps: 
> USDEUR=X       ex_div: 
> USDEUR=X         high: 
> USDEUR=X      isodate: 2013-12-30
> USDEUR=X         last: 0.7275
> USDEUR=X          low: 
> USDEUR=X       method: yahoo
> USDEUR=X         name: USD to EUR
> USDEUR=X          net: 
> USDEUR=X         open: 
> USDEUR=X     p_change: 
> USDEUR=X           pe: 
> USDEUR=X        price: 0.7275
> USDEUR=X      success: 1
> USDEUR=X       symbol: USDEUR=X
> USDEUR=X         time: 04:40
> USDEUR=X       volume: 
> USDEUR=X   year_range: N/A - N/A
> ---------------------------------------------------------------
> gnucash --debug
> gnc.bin-Message: main: binreloc relocation support was disabled at configure
> time.
> 
> Found Finance::Quote version 1.17
> ------------------------------------------------------------------
> perldoc -lm Finance::Quote::Tiaac
> No module found for "Finance::Quote::Tiaac"
> 
> 
> 
> 
> 
> --
> View this message in context: http://gnucash.1415818.n4.nabble.com/EU-en-USD-currencies-not-updated-after-upgrading-to-Ubunto-12-04-tp4666544p4666641.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Mon, 30 Dec 2013 04:25:56 -0800 (GMT-08:00)
> From: Terry Morse <tmorse at teleport.com>
> To: GNUCash <gnucash-user at gnucash.org>
> Subject: Invoicing On-going Customers - A New Invoice Each Year?
> Message-ID:
> 	<1276302.1388406356893.JavaMail.root at mswamui-backed.atl.sa.earthlink.net>
> 	
> Content-Type: text/plain; charset=UTF-8
> 
> I am helping a friend keep the books for her childcare service using GNUCash, but have no training in accounting so I need some advice.
> 
> I am using an invoice for each customer to track their charges and payments. As we are about to enter a new year, I need to know whether it makes more sense from an accounting standpoint to create a new invoice for on-going customers each year, or should I just keep updating their original invoice as long as they remain customers?
> 
> Is there a more sensible or efficient way to keep track of accounts receivable for the business than by invoicing? We don't actually send the customers invoices, as they make their payments (usually) in advance at the start of each week.
> 
> Thank you,
> Terry
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Mon, 30 Dec 2013 06:43:12 -0600
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Entering Split Transactions
> Message-ID: <52C16A60.7030000 at gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> On 12/29/2013 10:55 PM, Buddha Buck wrote:
>> In a split, the left-hand column and the right-hand column have to balance.
>> In your example, you have 670+180+90+60=1000 in the left-hand column, and
>> 1000 in the right-hand column.  That seems to balance to me.
>> 
>> Perhaps the confusion is coming from the column headers: the right-hand
>> column is shown in that screen-shot as "total withdrawal", but you aren't
>> doing a withdrawal of 1000, so what's the 1000 doing there?  The answer is
>> that while a regular "non-split" transaction shows the transaction from the
>> viewpoint of one account of the two affected accounts, a "split"
>> transaction shows the transaction from the viewpoint of all affected
>> accounts simultaneously.  The "Account" column for the final row (with the
>> $1000 "total withdrawal") shows the account "Income:Salary", which is where
>> you are getting the money to deposit from.  But for the "Income:Salary"
>> account, the right-hand column is not "total withdrawal", it's "Income"
>> (with the left-hand being "Charge").  It make sense for the $1000 that goes
>> into your checking account, taxes, etc to be recorded as "Income" from your
>> Income:Salary account.
>> 
>> There are 5 accounts in this transaction.  In one, the left-hand/right-hand
>> columns read "Deposit/Withdrawal", in three, they read "Expense/Rebate",
>> and in the last, they read "Charge/Income".  It is impossible to show all
>> those labels at once, so only the labels for the account in that register
>> (Checking) is used.  I just noticed that when selecting a split, they all
>> get "Tot. " prepended, which may be making things more confusing.
>> 
>> This is one of the reasons I, personally, use "formal accounting labels".
>> For me, every left-hand column is labelled "Debit", and every right-hand
>> column is labeled "Credit" (or "Tot Debit/Tot Credit" with splits).  So
>> when I look at an analogous transaction, I can see my total debits equal my
>> total credits in a split, and I know that for my salary, my "After Tax"
>> salary is debited to my checking account and my "Before Tax" salary is
>> credited to my Income:Salary account.
>> 
>> Does this help?
>> 
>> 
>> On Sun, Dec 29, 2013 at 10:07 PM, Bob Qualls <bobqualls84 at gmail.com> wrote:
>> 
>>> As I'm trying to master entering split transactions, as demonstrated in the
>>> tutorial (see attachment as a location reference in the tutorial), I find
>>> that I have to continually clear the amount entered by default in the
>>> "Withdrawal" column to get the numbers to work out correctly.  Is this
>>> typical behavior, or am I doing something incorrectly?
>>> 
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> 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.
>>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
>> 
> 
> When you are adding new lines to a partially entered split transaction
> you will notice that GnuCash wants to add another entry at the bottom to
> complete the transaction balance.  This is normal.  There are a couple
> of different ways to cope with this.  The method that I use is to
> religiously use the tab key to move through the fields while entering
> data, remembering to delete that extra value as I encounter it.  I try
> to avoid using the Enter key until I am done, as that will cause all the
> lines with numbers in the right hand column to move to the bottom and
> any leftover amount gets assigned to "Imbalance".  Once I have a model
> transaction in the register I usually just 'Duplicate' it next time and
> change the date and amounts.
> 
> It also helps to plan the order of the lines to enter the right hand
> column lines last.  That way, GnuCash enters the last number for me.
> 
> David C
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Mon, 30 Dec 2013 07:22:24 -0800
> From: John Ralls <jralls at ceridwen.us>
> To: GnuCash Users List <gnucash-user at gnucash.org>, GnuCash development
> 	list <gnucash-devel at gnucash.org>, gnucash-announce at gnucash.org
> Subject: Announcement: GnuCash 2.6.0 Released
> Message-ID: <2E0000AD-C64B-4A94-AE31-29E63DFFA823 at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
> 
> The GnuCash development team proudly announces GnuCash 2.6.0, the first release in our new 2.6-stable series. Please take the tour[1] of all the new features. Details of the changes from the last unstable version can be found in NEWS [2].
> Getting GnuCash for Windows (Win32 binary)
> 
> The Gnucash 2.6.0 Win32 setup executable can be downloaded from Sourceforge. It will install everything needed to run GnuCash.
> Mac OSX binary
> 
> The Gnucash 2.6.0 MacOSX package can be downloaded from Sourceforge as well.
> 
> 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.
> 
> [1] http://gnucash.org/2.6-release-tour.phtml
> [2] https://github.com/Gnucash/gnucash/blob/38a0d336186caf67d89f30b57d4769c1f99cb7c1/NEWS
> 
> 
> ------------------------------
> 
> Message: 6
> Date: Mon, 30 Dec 2013 15:33:37 +0000
> From: "Maf. King" <maf at chilwell.net>
> To: gnucash-user at gnucash.org
> Cc: GnuCash development list <gnucash-devel at gnucash.org>,
> 	gnucash-announce at gnucash.org
> Subject: Re: Announcement: GnuCash 2.6.0 Released
> Message-ID: <6284455.QmnRmr30IC at calufrax.standbyevents.co.uk>
> Content-Type: text/plain; charset="utf-8"
> 
> Well done guys!
> 
> Look forward to switching to the new version when I have a bit more time (just 
> in case....) later in January.
> 
> Best wishes for 2014
> Maf.
> 
> 
> On Mon 30 December 13 07:22:24 John Ralls wrote:
>> The GnuCash development team proudly announces GnuCash 2.6.0, the first
>> release in our new 2.6-stable series. Please take the tour[1] of all the
>> new features. Details of the changes from the last unstable version can be
>> found in NEWS [2]. Getting GnuCash for Windows (Win32 binary)
>> 
>> The Gnucash 2.6.0 Win32 setup executable can be downloaded from Sourceforge.
>> It will install everything needed to run GnuCash. Mac OSX binary
>> 
>> The Gnucash 2.6.0 MacOSX package can be downloaded from Sourceforge as well.
>> 
>> 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.
>> 
>> [1] http://gnucash.org/2.6-release-tour.phtml
>> [2]
>> https://github.com/Gnucash/gnucash/blob/38a0d336186caf67d89f30b57d4769c1f99
>> cb7c1/NEWS _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
> 
> -- 
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
> 
> 
> 
> 
> 
> ------------------------------
> 
> Message: 7
> Date: Mon, 30 Dec 2013 17:19:47 +0100
> From: "Frank H. Ellenberger" <frank.h.ellenberger at gmail.com>
> To: liberace <philsdutchie at gmail.com>, gnucash-user at gnucash.org
> Subject: Re: EU en USD currencies not updated after upgrading to
> 	Ubunto 12.04
> Message-ID: <52C19D23.7090604 at gmail.com>
> Content-Type: text/plain; charset=ISO-8859-15; format=flowed
> 
> Hi,
> 
> Am 30.12.2013 11:13, schrieb liberace:
>> Ok Frank
>> 
>> Here are the results. Hope they give you some insights whats wrong.
>> 
>> gnc-fq-dump -v yahoo USDEUR=X
>> 
>> 
>> 
> 
> Did you loose here something?
> 
>>  nav:                      <=== one of these
>>      price: 0.7276               <=/
>>   timezone:                      <=== optional
>> 
>> All fields returned by Finance::Quote for stock USDEUR=X
>> 
>> stock           field  value
>> -----           -----  -----
>> USDEUR=X          ask: 0.7277
>> USDEUR=X      avg_vol: 0
>> USDEUR=X          bid: 0.7275
>> USDEUR=X          cap:
>> USDEUR=X        close:
>> USDEUR=X     currency: EUR
>> USDEUR=X         date: 12/30/2013
>> USDEUR=X    day_range: N/A - N/A
>> USDEUR=X          div:
>> USDEUR=X     div_date:
>> USDEUR=X    div_yield:
>> USDEUR=X          eps:
>> USDEUR=X       ex_div:
>> USDEUR=X         high:
>> USDEUR=X      isodate: 2013-12-30
>> USDEUR=X         last: 0.7276
>> USDEUR=X          low:
>> USDEUR=X       method: yahoo
>> USDEUR=X         name: USD to EUR
>> USDEUR=X          net:
>> USDEUR=X         open:
>> USDEUR=X     p_change:
>> USDEUR=X           pe:
>> USDEUR=X        price: 0.7276
>> USDEUR=X      success: 1
>> USDEUR=X       symbol: USDEUR=X
>> USDEUR=X         time: 04:38
>> USDEUR=X       volume:
>> USDEUR=X   year_range: N/A - N/A
>> 
>> 
>> ------------------------------------------------------------------
>> 
>> gnc-fq-dump -v yahoo USDEUR=X
>> Finance::Quote fields Gnucash uses:
>>     symbol: USDEUR=X             <=== required
>>       date: 12/30/2013           <=== required
>>   currency: EUR                  <=== required
>>       last: 0.7275               <=\
>>        nav:                      <=== one of these
>>      price: 0.7275               <=/
>>   timezone:                      <=== optional
>> 
>> All fields returned by Finance::Quote for stock USDEUR=X
>> 
>> stock           field  value
>> -----           -----  -----
>> USDEUR=X          ask: 0.7275
>> USDEUR=X      avg_vol: 0
>> USDEUR=X          bid: 0.7275
>> USDEUR=X          cap:
>> USDEUR=X        close:
>> USDEUR=X     currency: EUR
>> USDEUR=X         date: 12/30/2013
>> USDEUR=X    day_range: N/A - N/A
>> USDEUR=X          div:
>> USDEUR=X     div_date:
>> USDEUR=X    div_yield:
>> USDEUR=X          eps:
>> USDEUR=X       ex_div:
>> USDEUR=X         high:
>> USDEUR=X      isodate: 2013-12-30
>> USDEUR=X         last: 0.7275
>> USDEUR=X          low:
>> USDEUR=X       method: yahoo
>> USDEUR=X         name: USD to EUR
>> USDEUR=X          net:
>> USDEUR=X         open:
>> USDEUR=X     p_change:
>> USDEUR=X           pe:
>> USDEUR=X        price: 0.7275
>> USDEUR=X      success: 1
>> USDEUR=X       symbol: USDEUR=X
>> USDEUR=X         time: 04:40
>> USDEUR=X       volume:
>> USDEUR=X   year_range: N/A - N/A
> 
> OK, as expected.
>> ---------------------------------------------------------------
>>  gnucash --debug
>> gnc.bin-Message: main: binreloc relocation support was disabled at configure
>> time.
>> 
>> Found Finance::Quote version 1.17
> 
> wiki: Make sure you're running Finance::Quote 1.18 version or later. 
> Earlier versions can no longer retrieve currency quotes.
> 
> Here is your Problem. Probably you installed F::Q twice, from Ubuntu and 
> CPAN, but only one was updated and now the old version is disturbing.
> 
>> ------------------------------------------------------------------
>>  perldoc -lm Finance::Quote::Tiaac
>> No module found for "Finance::Quote::Tiaac"
>> 
> 
> # perldoc -lm Finance::Quote::Tiaacref
> /usr/lib/perl5/vendor_perl/5.18.1/Finance/Quote/Tiaacref.pm
> 
> Is copy&paste too difficult? ;-)
> But for your module:
> # perldoc -lm Finance::Quote::Currencies
> /usr/lib/perl5/vendor_perl/5.18.1/Finance/Quote/Currencies.pm
> 
> HTH
> Frank
> 
> 
> ------------------------------
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> 
> End of gnucash-user Digest, Vol 129, Issue 39
> *********************************************




More information about the gnucash-user mailing list