gnucash-user Digest, Vol 138, Issue 36
Scott Roe
scott384 at hotmail.com
Sat Sep 27 12:12:12 EDT 2014
Thanks David, that is an excellent suggestion on the spreadsheet. I've decided I'll input the payment made in 2014 as I have the prin/int breakdown from my bank from 1 Jan 14 to present. The one issue is the mortgage is just about half of it's original amount and only the half will go into the asset account, but at least I'll be tracking the interest correctly for reporting purposes.
Thanks for your input,
Scott
> From: gnucash-user-request at gnucash.org
> Subject: gnucash-user Digest, Vol 138, Issue 36
> To: gnucash-user at gnucash.org
> Date: Sat, 27 Sep 2014 07:21:57 -0400
>
> 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: GnuCash 2.6.3 does not automatically create root account?
> (John Ralls)
> 2. Invoice Date or Due Date (William Storey)
> 3. Re: Request assistance for importing invoice/bill payments
> (Nelson Handcock)
> 4. Re: Setting up recurring mortgage payment (John Ralls)
> 5. Finance quotes (Paul Goyette)
> 6. Re: Finance quotes (farleykj)
> 7. Re: Finance quotes (Paul Goyette)
> 8. Re: Setting up recurring mortgage payment (David T.)
> 9. Re: Request assistance for importing invoice/bill payments
> (Geert Janssens)
> 10. RE: Manual in French (Kerspern Nicolas Wanadoo.fr)
> 11. Re: Manual in French (Geert Janssens)
> 12. Balance a Sheet Report (Renea Marie)
> 13. Re: Setting up recurring mortgage payment (David Carlson)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 26 Sep 2014 10:46:34 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: James Nylen <jnylen+gnucash at gmail.com>
> Cc: GnuCash List <gnucash-user at lists.gnucash.org>
> Subject: Re: GnuCash 2.6.3 does not automatically create root account?
> Message-ID: <838DA7B1-8AB9-4D66-951D-3E9EADFEF199 at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
> On Sep 25, 2014, at 9:12 PM, James Nylen <jnylen+gnucash at gmail.com> wrote:
>
> > james at computron ~ $ gnucash --version
> > GnuCash 2.6.3
> > This copy was built from rev 4e4a032+ on 2014-08-03.
> >
> > After I created the book, there were no accounts in the tree whatsoever.
> >
> > On Wed, Sep 24, 2014 at 8:53 AM, John Ralls <jralls at ceridwen.us> wrote:
> >
> > On Sep 23, 2014, at 10:26 PM, James Nylen <jnylen+gnucash at gmail.com> wrote:
> >
> > > (Note - I am not nvsoar.)
> > >
> > > I did not select any accounts using the assistant. I would have, but I must have missed that option. I created a blank MySQL database and an associated user using phpMyAdmin, then pointed GnuCash at that database.
> > >
> >
> > The assistant has the "Basic" accounts set by default. I just did the same thing, except that I used the mysql shell instead of phpMyAdmin and I didn't create the DB in advance, just granted all on it to the user. The ROOT-type accounts were created.
> >
> > What version of GnuCash did you use?
>
> Thanks, but please remember to copy the list.
>
> Regards,
> John Ralls
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 26 Sep 2014 15:31:16 -0700
> From: William Storey <eleethesontai at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Invoice Date or Due Date
> Message-ID: <A2363DCD-0597-4CEA-BDBB-2A05C295DA69 at gmail.com>
> Content-Type: text/plain; charset=us-ascii
>
> What is the standard when entering invoices/bills into accounts payable the invoice date or the due date?
>
> Sent from my iPhone
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 27 Sep 2014 08:56:46 +1000
> From: Nelson Handcock <nelson.handcock at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Request assistance for importing invoice/bill payments
> Message-ID:
> <CAO1TneYJxwSfYAyJ7aR91P9qrFeLWbytsfxaz+rQbqhVGV=Kwg at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Bump
>
> Thanks & Regards,
>
> Nelson Handcock
> 0409 149919
>
> http://www.linkedin.com/in/nelsonhandcockaustralia
>
> On Sat, Sep 20, 2014 at 10:12 AM, Nelson Handcock <nelson.handcock at gmail.com
> > wrote:
>
> > Hi,
> >
> > Could someone please advise on how best to import transactions into
> > Gnucash, so that invoices are paid?
> >
> > I'm running Version 2.6.3, Windows 8.1, Asus Laptop
> >
> >
> > I have documented the procedure that I followed to import the QIF file
> > that was generated from the bank transactions - they are imported
> > successfully into the nominated accounts, but they are not associated as
> > payments to the invoices and I can't see how to get this to occur.
> >
> > When I run a customer report, the transactions do not appear - I assume
> > this is because they are not considered as payments, and I'm trying to get
> > this to occur.
> >
> >
> > A copy of the QIF file I used as a test is here...
> > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYKa?dl=0
> >
> > A copy of screenshots of the import and the results is here...(Word 2007)
> > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYKa?dl=0
> >
> > When I look at the imported transactions, there does not appear to be any
> > way to change the "Ref" or the "Action" columns. (The transactions in the
> > screenshot that do have these columns set were processed manually)
> >
> > There seems to be a menu option "Assign as Payment..." but this does not
> > appear to do anything. I think this may be listed as a problem already.
> >
> >
> > Any advice would be appreciated!
> >
> >
> > Thanks & Regards,
> >
> > Nelson Handcock
> >
> >
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 26 Sep 2014 16:01:50 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Scott Roe <scott384 at hotmail.com>
> Cc: GnuCash List <gnucash-user at lists.gnucash.org>
> Subject: Re: Setting up recurring mortgage payment
> Message-ID: <0E0561CE-E7B4-4D24-9010-557674E471A6 at ceridwen.us>
> Content-Type: text/plain; charset=iso-8859-1
>
>
> On Sep 26, 2014, at 2:03 PM, Scott Roe <scott384 at hotmail.com> wrote:
>
> > Hi John:
> >
> > Just a quick note to thank you again for your assistance below. The initial cause of my errors with split entry were the two currencies, and from there I discovered, through further investigation, and some trial and error, that I was making several other small errors, and many of the split entries were in the imbalance folder, and I was able to clear them all off.
> >
> > I have another issue and I've been trying to make it work with no success, so hope you don't mind me asking. I have a mortgage that I've been paying for 8 years. Originally a 20 year mortgage, I've made some extra payments over time. I would now like to set up the loan recurring payments in gnucash to save manually entering them and be able to calculate my interest paid at the end of the year for my tax filing rather then to ask the Bank every year to give me the figure. I was attempting to take the remaining principal, the interest rate, the payment frequency, and payment amount to set up the recurring. It is a weekly paid mortgage, and when I complete the mortgage loan wizard, the principal and interest are the monthly amounts although I've entered weekly everywhere that I can.
> >
> > Any assistance appreciated,
>
> Scott,
>
> Please use the mailing list for all questions. There are more developers there along with a bunch of expert users, so you'll have a better chance of getting a useful answer from the list than from a single developer. That's especially true in this case, as I'm not particularly familiar with the Mortgage Assistant.
>
> The setting for how often the scheduled transaction runs is set on the editor's Frequency tab, but changing that isn't going to help much if the Mortgage Assistant insists on calculating the monthly amount. Is that the case?
>
> Regards,
> John Ralls
>
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 27 Sep 2014 09:12:41 +0800 (PHT)
> From: Paul Goyette <paul at vps1.whooppee.com>
> To: gnucash-user at gnucash.org
> Subject: Finance quotes
> Message-ID: <Pine.NEB.4.64.1409270907550.17688 at vps1.whooppee.com>
> Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
>
> I've recently installed gnucash 2.6.3 on a new Windows 8.1 laptop, and
> (like many other people, apparently) have problems with getting on-line
> quotes.
>
> I've searched for help, and found the FAQ entry "Q: Why doesn't online
> quoting work?" on the wiki (at http://wiki.gnucash.org/wiki/FAQ). It
> says that I should "...run Install Online Price Retrieval..." to get
> required perl stuff installed.
>
> Unfortunately, I don't seem to have this utility available. A search of
> the entire hard drive finds nothing.
>
> Is there some additional step I'm missing?
>
>
>
>
> -------------------------------------------------------------------------
> | Paul Goyette | PGP Key fingerprint: | E-mail addresses: |
> | (Retired) | FA29 0E3B 35AF E8AE 6651 | paul at whooppee.com |
> | Network Engineer | 0786 F758 55DE 53BA 7731 | pgoyette at juniper.net |
> | Kernel Developer | | pgoyette at netbsd.org |
> -------------------------------------------------------------------------
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 26 Sep 2014 19:19:13 -0700 (PDT)
> From: farleykj <farleykj at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Finance quotes
> Message-ID: <1411784353444-4673041.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> This comes up lots. I'm on Mac OS X, but from the Wiki:
>
> --- [ Begin Wiki Stuff ] ---
>
> Windows 8 Finance::Quote
>
> I am running gnucash successfully on Windows 8. I want to install
> Finance::Quote, but can't find instructions that don't reference the start
> menu. Anyone know how to do it from the command line? Mokeyib 00:20, 28
> March 2013 (EDT)
>
> Found it. After installing perl, cd to the gnucash\bin directory and run
> install-fq-mods.cmd from there. Mokeyib 00:48, 28 March 2013 (EDT)
>
> --- [ End Wiki Stuff ] ---
>
> Hopefully it's as simple as this, but if you have some more esoteric
> troubles, I'm sure folks will be able to help you out.
>
>
>
>
> -----
> Ken Farley
> --
> View this message in context: http://gnucash.1415818.n4.nabble.com/Finance-quotes-tp4673040p4673041.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> Message: 7
> Date: Sat, 27 Sep 2014 10:41:24 +0800 (PHT)
> From: Paul Goyette <paul at vps1.whooppee.com>
> To: farleykj <farleykj at gmail.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: Finance quotes
> Message-ID: <Pine.NEB.4.64.1409271041040.9229 at vps1.whooppee.com>
> Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
>
> Yup, thanks! That works great!
>
>
> On Fri, 26 Sep 2014, farleykj wrote:
>
> > This comes up lots. I'm on Mac OS X, but from the Wiki:
> >
> > --- [ Begin Wiki Stuff ] ---
> >
> > Windows 8 Finance::Quote
> >
> > I am running gnucash successfully on Windows 8. I want to install
> > Finance::Quote, but can't find instructions that don't reference the start
> > menu. Anyone know how to do it from the command line? Mokeyib 00:20, 28
> > March 2013 (EDT)
> >
> > Found it. After installing perl, cd to the gnucash\bin directory and run
> > install-fq-mods.cmd from there. Mokeyib 00:48, 28 March 2013 (EDT)
> >
> > --- [ End Wiki Stuff ] ---
> >
> > Hopefully it's as simple as this, but if you have some more esoteric
> > troubles, I'm sure folks will be able to help you out.
> >
> >
> >
> >
> > -----
> > Ken Farley
> > --
> > View this message in context: http://gnucash.1415818.n4.nabble.com/Finance-quotes-tp4673040p4673041.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> > _______________________________________________
> > 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.
> >
>
> -------------------------------------------------------------------------
> | Paul Goyette | PGP Key fingerprint: | E-mail addresses: |
> | (Retired) | FA29 0E3B 35AF E8AE 6651 | paul at whooppee.com |
> | Network Engineer | 0786 F758 55DE 53BA 7731 | pgoyette at juniper.net |
> | Kernel Developer | | pgoyette at netbsd.org |
> -------------------------------------------------------------------------
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 26 Sep 2014 19:47:33 -0700
> From: "David T." <sunfish62 at yahoo.com>
> To: John Ralls <jralls at ceridwen.us>
> Cc: GnuCash List <gnucash-user at lists.gnucash.org>, Scott Roe
> <scott384 at hotmail.com>
> Subject: Re: Setting up recurring mortgage payment
> Message-ID: <39FBFEF7-4A9D-44DB-9E14-4589008D4AE2 at yahoo.com>
> Content-Type: text/plain; charset=us-ascii
>
> Scott,
>
> If I understand your question correctly, I have some bad news. The mortgage assistant is not able to calculate new transactions on a monthly basis. It is only able to calculate from the original set point.
>
> There have been discussions about this in the past, and I believe that the underlying issue is that GnuCash does not have a function to calculate a balance as of a date. This would be necessary to recalculate a mortgage repayment schedule.
>
> Personally, I dropped the whole business and enter the correct amounts manually from statements. A pain, but less of a pain than always remembering to change the automatically created transaction after the fact.
>
> David
>
> On Sep 26, 2014, at 4:01 PM, John Ralls <jralls at ceridwen.us> wrote:
>
> >
> > On Sep 26, 2014, at 2:03 PM, Scott Roe <scott384 at hotmail.com> wrote:
> >
> >> Hi John:
> >>
> >> Just a quick note to thank you again for your assistance below. The initial cause of my errors with split entry were the two currencies, and from there I discovered, through further investigation, and some trial and error, that I was making several other small errors, and many of the split entries were in the imbalance folder, and I was able to clear them all off.
> >>
> >> I have another issue and I've been trying to make it work with no success, so hope you don't mind me asking. I have a mortgage that I've been paying for 8 years. Originally a 20 year mortgage, I've made some extra payments over time. I would now like to set up the loan recurring payments in gnucash to save manually entering them and be able to calculate my interest paid at the end of the year for my tax filing rather then to ask the Bank every year to give me the figure. I was attempting to take the remaining principal, the interest rate, the payment frequency, and payment amount to set up the recurring. It is a weekly paid mortgage, and when I complete the mortgage loan wizard, the principal and interest are the monthly amounts although I've entered weekly everywhere that I can.
> >>
> >> Any assistance appreciated,
> >
> > Scott,
> >
> > Please use the mailing list for all questions. There are more developers there along with a bunch of expert users, so you'll have a better chance of getting a useful answer from the list than from a single developer. That's especially true in this case, as I'm not particularly familiar with the Mortgage Assistant.
> >
> > The setting for how often the scheduled transaction runs is set on the editor's Frequency tab, but changing that isn't going to help much if the Mortgage Assistant insists on calculating the monthly amount. Is that the case?
> >
> > Regards,
> > John Ralls
> >
> > _______________________________________________
> > 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: 9
> Date: Sat, 27 Sep 2014 10:22:29 +0200
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: gnucash-user at gnucash.org
> Subject: Re: Request assistance for importing invoice/bill payments
> Message-ID: <2117508.7kU26prH12 at legolas.kobaltwit.lan>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Nelson,
>
> That's an interesting approach you are trying there.
>
> The qif importer unfortunately does not know anything about invoices or
> payments. It only understands transactions.
>
> To get to your final goal of linking payments with invoices/bills I see
> two options
>
> - either you forget about the qif importer altogether and instead
> experiment with the csv invoice importer. I have no experience with it
> myself though, so perhaps this is not a reasonable approach.
>
> - or you can effectively use the "Assign as payment" option. You say it
> doesn't do anything which is not my experience.
> What did you try, what happened and what were you expecting ?
>
> Geert
>
> On Saturday 27 September 2014 08:56:46 Nelson Handcock wrote:
> > Bump
> >
> > Thanks & Regards,
> >
> > Nelson Handcock
> > 0409 149919
> >
> > http://www.linkedin.com/in/nelsonhandcockaustralia
> >
> > On Sat, Sep 20, 2014 at 10:12 AM, Nelson Handcock
> > <nelson.handcock at gmail.com
> > > wrote:
> > >
> > > Hi,
> > >
> > > Could someone please advise on how best to import transactions into
> > > Gnucash, so that invoices are paid?
> > >
> > > I'm running Version 2.6.3, Windows 8.1, Asus Laptop
> > >
> > >
> > > I have documented the procedure that I followed to import the QIF
> > > file that was generated from the bank transactions - they are
> > > imported successfully into the nominated accounts, but they are not
> > > associated as payments to the invoices and I can't see how to get
> > > this to occur.
> > >
> > > When I run a customer report, the transactions do not appear - I
> > > assume this is because they are not considered as payments, and I'm
> > > trying to get this to occur.
> > >
> > >
> > > A copy of the QIF file I used as a test is here...
> > > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYKa
> > > ?dl=0
> > >
> > > A copy of screenshots of the import and the results is here...(Word
> > > 2007)
> > > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYK
> > > a?dl=0
> > >
> > > When I look at the imported transactions, there does not appear to
> > > be any way to change the "Ref" or the "Action" columns. (The
> > > transactions in the screenshot that do have these columns set were
> > > processed manually)
> > >
> > > There seems to be a menu option "Assign as Payment..." but this does
> > > not appear to do anything. I think this may be listed as a problem
> > > already.
> > >
> > >
> > > Any advice would be appreciated!
> > >
> > >
> > > Thanks & Regards,
> > >
> > > Nelson Handcock
> >
> > _______________________________________________
> > 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: 10
> Date: Sat, 27 Sep 2014 10:31:49 +0200
> From: "Kerspern Nicolas Wanadoo.fr" <kerspern.nicolas at wanadoo.fr>
> To: "'Geert Janssens'" <geert.gnucash at kobaltwit.be>,
> <gnucash-user at gnucash.org>
> Cc: gnucash-fr at gnucash.org
> Subject: RE: Manual in French
> Message-ID:
> <!&!AAAAAAAAAAAYAAAAAAAAAMww/uorQfBIgcujJo6HwgIilzYBEAAAALdkVTuh54lBjw5vBcgNo8YBAAAAAA==@wanadoo.fr>
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Guys,
>
> Oups, oh sorry, I understand now better and that changes everything, I had
> never done courses accountant or treasurer.
>
> Thanks @Johon and Thanks @Geert
>
> Nicolas
>
> -----Message d'origine-----
> De?: Geert Janssens [mailto:geert.gnucash at kobaltwit.be]
> Envoy??: lundi 22 septembre 2014 19:23
> ??: gnucash-user at gnucash.org
> Cc?: Kerspern Nicolas Wanadoo.fr; 'John Ralls'; gnucash-fr at gnucash.org
> Objet?: Re: Manual in French
>
> Hi Nicolas,
>
> You are confusing bank terminology with accounting terminology.
>
> A bank will call a deposit to your bank account a credit and a
> withdrawal a debit. That is because that's how the bank has to book
> these transactions in *the bank's books*.
>
> When you deposit money on your bank account the bank owes you that
> money, which makes it a liability for the bank. In accounting
> terminology increasing a liability is a credit.
>
> In *your books* however, the money you put on your bank account is an
> asset. And increasing an asset is a debit.
>
> Your second screen shot uses the terms your bank would use which are the
> proper terms for their books. For your books things are different.
>
> If you find this confusing I can agree it is. That's why gnucash offers
> the alternative names "D?p?t" and "Retrait" because most people that are
> not accountants find these more intuitive.
>
> Hopefully this explains it a bit better.
>
> Geert
>
> On Saturday 20 September 2014 16:39:40 Kerspern Nicolas Wanadoo.fr
> wrote:
> > Hi John
> >
> >
> >
> > I?m always understand and I seem I?m not alone, you send that it?s
> > good see figure 1, but I found on tutorial in French see figure 2 and
> > it?s true good
> >
> >
> >
> >
> > Figure 1 :
> >
> >
> >
> >
> >
> > Figure 2 :
> >
> >
> >
> >
> >
> > Thanks
> >
> >
> >
> > Nicolas
> >
> >
> >
> > _____
> >
> > De : John Ralls [mailto:jralls at ceridwen.us]
> > Envoy? : jeudi 14 ao?t 2014 02:21
> > ? : Kerspern Nicolas Wanadoo.fr
> > Cc : gnucash-user at gnucash.org
> > Objet : Re: Manual in French
> >
> >
> >
> >
> >
> > On Aug 13, 2014, at 12:02 PM, Kerspern Nicolas Wanadoo.fr
> > <kerspern.nicolas at wanadoo.fr> wrote:
> >
> >
> >
> >
> >
> > Hi
> >
> >
> >
> > I agree with you but this result show us than :
> >
> >
> >
> >
> > "Utiliser la terminologie comptable" : off
> >
> > <image002.jpg>
> >
> >
> >
> >
> > "Utiliser la terminologie comptable" : on
> >
> > <image003.jpg>
> >
> >
> >
> >
> >
> >
> >
> > Can you tell me that it?s good or not ?
> >
> >
> >
> > It's good.
> >
> >
> >
> > Regards,
> >
> > John Ralls
> >
> >
> >
> >
> >
> > On Aug 13, 2014, at 1:01 AM, Kerspern Nicolas Wanadoo.fr
> >
> > <kerspern.nicolas at wanadoo.fr> wrote:
> > > Hi
> > >
> > >
> > >
> > > @John, thanks
> > >
> > >
> > >
> > > @users,
> > >
> > > From gnucash-2.6.3 (01-04-2014) Windows,
> > >
> > > I seem that the translation made a mistake:
> > >
> > >
> > >
> > > When:
> > >
> > > (in EN)
> > >
> > > In Preference>Account>Labels>Use formal accounting labels > Set
> > >
> > > And (in FR)
> > >
> > > Pr?f?rence>Comptes>Labels>Utiliser la terminologie comptable> Cocher
> > >
> > >
> > >
> > > Dysfunction:
> > >
> > > We found, in account/bank list, two columns which switched may be
> > >
> > > wrong in French:
> > >
> > > (D?bit => D?p?t) and (Cr?dit => Retrait)
> > >
> > >
> > >
> > > Please switch:
> > >
> > > (D?bit => Retrait) and (Cr?dit => D?p?t)
> > >
> > >
> > >
> > > And not:
> > >
> > > (D?bit => D?p?t) and (Cr?dit => Retrait)
> >
> > By default GnuCash uses (in English) "Deposit" and "Withdraw" for
> > Accounts of type BANK. Those are translated in French to "D?p?t" and
> > "Retrait". If you want to see "D?bit" and "Cr?dit" ("Debit" and
> > "Credit" in English), please go to Preferences>Accounts and check the
> > "Utiliser la terminologie comptable" box.
> >
> >
> >
> > Note that in formal accounting adding money to an asset account is a
> > debit and removing it is a credit. Please see
> > <http://fr.wikipedia.org/wiki/Comptabilit%C3%A9_d%27entreprise#D.C3.A9
> > bit_.2 8Dt.29.2C_cr.C3.A9dit_.28Ct.29>
> > http://fr.wikipedia.org/wiki/Comptabilit%C3%A9_d%27entreprise#D.C3.A9b
> > it_.28 Dt.29.2C_cr.C3.A9dit_.28Ct.29
> >
> >
> >
> > Regards,
> >
> > John Ralls
>
>
>
>
> ------------------------------
>
> Message: 11
> Date: Sat, 27 Sep 2014 10:46:33 +0200
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: gnucash-user at gnucash.org
> Cc: gnucash-fr at gnucash.org
> Subject: Re: Manual in French
> Message-ID: <8560435.kPOVkCSPik at legolas.kobaltwit.lan>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Saturday 27 September 2014 10:31:49 Kerspern Nicolas Wanadoo.fr
> wrote:
> > Hi Guys,
> >
> > Oups, oh sorry, I understand now better and that changes everything, I
> > had never done courses accountant or treasurer.
> >
> > Thanks @Johon and Thanks @Geert
> >
> > Nicolas
> >
> You're welcome.
>
> My only education on accounting comes from university where only the
> basics were covered. Not these subtleties in debit and credit notations.
> And I failed that course by the way :( Lack of interest at the time.
>
> I learned most of what I know later in a real business context and the
> shared knowledge here in the GnuCash community. It's such a rich
> resource :)
>
> Geert
>
> > -----Message d'origine-----
> > De : Geert Janssens [mailto:geert.gnucash at kobaltwit.be]
> > Envoy? : lundi 22 septembre 2014 19:23
> > ? : gnucash-user at gnucash.org
> > Cc : Kerspern Nicolas Wanadoo.fr; 'John Ralls'; gnucash-fr at gnucash.org
> > Objet : Re: Manual in French
> >
> > Hi Nicolas,
> >
> > You are confusing bank terminology with accounting terminology.
> >
> > A bank will call a deposit to your bank account a credit and a
> > withdrawal a debit. That is because that's how the bank has to book
> > these transactions in *the bank's books*.
> >
> > When you deposit money on your bank account the bank owes you that
> > money, which makes it a liability for the bank. In accounting
> > terminology increasing a liability is a credit.
> >
> > In *your books* however, the money you put on your bank account is an
> > asset. And increasing an asset is a debit.
> >
> > Your second screen shot uses the terms your bank would use which are
> > the proper terms for their books. For your books things are
> > different.
> >
> > If you find this confusing I can agree it is. That's why gnucash
> > offers the alternative names "D?p?t" and "Retrait" because most
> > people that are not accountants find these more intuitive.
> >
> > Hopefully this explains it a bit better.
> >
> > Geert
> >
> > On Saturday 20 September 2014 16:39:40 Kerspern Nicolas Wanadoo.fr
> >
> > wrote:
> > > Hi John
> > >
> > >
> > >
> > > I?m always understand and I seem I?m not alone, you send that it?s
> > > good see figure 1, but I found on tutorial in French see figure 2
> > > and
> > > it?s true good
> > >
> > >
> > >
> > >
> > > Figure 1 :
> > >
> > >
> > >
> > >
> > >
> > > Figure 2 :
> > >
> > >
> > >
> > >
> > >
> > > Thanks
> > >
> > >
> > >
> > > Nicolas
> > >
> > > _____
> > >
> > > De : John Ralls [mailto:jralls at ceridwen.us]
> > > Envoy? : jeudi 14 ao?t 2014 02:21
> > > ? : Kerspern Nicolas Wanadoo.fr
> > > Cc : gnucash-user at gnucash.org
> > > Objet : Re: Manual in French
> > >
> > >
> > >
> > >
> > >
> > > On Aug 13, 2014, at 12:02 PM, Kerspern Nicolas Wanadoo.fr
> > > <kerspern.nicolas at wanadoo.fr> wrote:
> > >
> > >
> > >
> > >
> > >
> > > Hi
> > >
> > >
> > >
> > > I agree with you but this result show us than :
> > >
> > >
> > >
> > >
> > > "Utiliser la terminologie comptable" : off
> > >
> > > <image002.jpg>
> > >
> > >
> > >
> > >
> > > "Utiliser la terminologie comptable" : on
> > >
> > > <image003.jpg>
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Can you tell me that it?s good or not ?
> > >
> > >
> > >
> > > It's good.
> > >
> > >
> > >
> > > Regards,
> > >
> > > John Ralls
> > >
> > >
> > >
> > >
> > >
> > > On Aug 13, 2014, at 1:01 AM, Kerspern Nicolas Wanadoo.fr
> > >
> > > <kerspern.nicolas at wanadoo.fr> wrote:
> > > > Hi
> > > >
> > > >
> > > >
> > > > @John, thanks
> > > >
> > > >
> > > >
> > > > @users,
> > > >
> > > > From gnucash-2.6.3 (01-04-2014) Windows,
> > > >
> > > > I seem that the translation made a mistake:
> > > >
> > > >
> > > >
> > > > When:
> > > >
> > > > (in EN)
> > > >
> > > > In Preference>Account>Labels>Use formal accounting labels > Set
> > > >
> > > > And (in FR)
> > > >
> > > > Pr?f?rence>Comptes>Labels>Utiliser la terminologie comptable>
> > > > Cocher
> > > >
> > > >
> > > >
> > > > Dysfunction:
> > > >
> > > > We found, in account/bank list, two columns which switched may be
> > > >
> > > > wrong in French:
> > > >
> > > > (D?bit => D?p?t) and (Cr?dit => Retrait)
> > > >
> > > >
> > > >
> > > > Please switch:
> > > >
> > > > (D?bit => Retrait) and (Cr?dit => D?p?t)
> > > >
> > > >
> > > >
> > > > And not:
> > > >
> > > > (D?bit => D?p?t) and (Cr?dit => Retrait)
> > >
> > > By default GnuCash uses (in English) "Deposit" and "Withdraw" for
> > > Accounts of type BANK. Those are translated in French to "D?p?t" and
> > > "Retrait". If you want to see "D?bit" and "Cr?dit" ("Debit" and
> > > "Credit" in English), please go to Preferences>Accounts and check
> > > the
> > > "Utiliser la terminologie comptable" box.
> > >
> > >
> > >
> > > Note that in formal accounting adding money to an asset account is a
> > > debit and removing it is a credit. Please see
> > > <http://fr.wikipedia.org/wiki/Comptabilit%C3%A9_d%27entreprise#D.C3.
> > > A9 bit_.2 8Dt.29.2C_cr.C3.A9dit_.28Ct.29>
> > > http://fr.wikipedia.org/wiki/Comptabilit%C3%A9_d%27entreprise#D.C3.A
> > > 9b it_.28 Dt.29.2C_cr.C3.A9dit_.28Ct.29
> > >
> > >
> > >
> > > Regards,
> > >
> > > John Ralls
>
>
>
>
> ------------------------------
>
> Message: 12
> Date: Sat, 27 Sep 2014 07:23:45 -0400
> From: Renea Marie <reneamarie at gmail.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Balance a Sheet Report
> Message-ID:
> <CAOMEG0LG38Pakx9ofmrG1i9J1yL-5Wt1oVd93ys28SiMXSP+HA at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> How can I run a balance sheet with a start and end date? Options only
> offers an end date, so it's pulling all data from the previous account
> years. My fiscal year runs from September 1 - August 31.
>
>
> ------------------------------
>
> Message: 13
> Date: Sat, 27 Sep 2014 06:43:39 -0500
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Setting up recurring mortgage payment
> Message-ID: <5426A2EB.1000909 at gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 9/26/2014 9:47 PM, David T. wrote:
> > Scott,
> >
> > If I understand your question correctly, I have some bad news. The mortgage assistant is not able to calculate new transactions on a monthly basis. It is only able to calculate from the original set point.
> >
> > There have been discussions about this in the past, and I believe that the underlying issue is that GnuCash does not have a function to calculate a balance as of a date. This would be necessary to recalculate a mortgage repayment schedule.
> >
> > Personally, I dropped the whole business and enter the correct amounts manually from statements. A pain, but less of a pain than always remembering to change the automatically created transaction after the fact.
> >
> > David
> >
> > On Sep 26, 2014, at 4:01 PM, John Ralls <jralls at ceridwen.us> wrote:
> >
> >> On Sep 26, 2014, at 2:03 PM, Scott Roe <scott384 at hotmail.com> wrote:
> >>
> >>> Hi John:
> >>>
> >>> Just a quick note to thank you again for your assistance below. The initial cause of my errors with split entry were the two currencies, and from there I discovered, through further investigation, and some trial and error, that I was making several other small errors, and many of the split entries were in the imbalance folder, and I was able to clear them all off.
> >>>
> >>> I have another issue and I've been trying to make it work with no success, so hope you don't mind me asking. I have a mortgage that I've been paying for 8 years. Originally a 20 year mortgage, I've made some extra payments over time. I would now like to set up the loan recurring payments in gnucash to save manually entering them and be able to calculate my interest paid at the end of the year for my tax filing rather then to ask the Bank every year to give me the figure. I was attempting to take the remaining principal, the interest rate, the payment frequency, and payment amount to set up the recurring. It is a weekly paid mortgage, and when I complete the mortgage loan wizard, the principal and interest are the monthly amounts although I've entered weekly everywhere that I can.
> >>>
> >>> Any assistance appreciated,
> >> Scott,
> >>
> >> Please use the mailing list for all questions. There are more developers there along with a bunch of expert users, so you'll have a better chance of getting a useful answer from the list than from a single developer. That's especially true in this case, as I'm not particularly familiar with the Mortgage Assistant.
> >>
> >> The setting for how often the scheduled transaction runs is set on the editor's Frequency tab, but changing that isn't going to help much if the Mortgage Assistant insists on calculating the monthly amount. Is that the case?
> >>
> >> Regards,
> >> John Ralls
> >>
> >> _______________________________________________
> >> 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.
> >
>
> It is not too difficult to build a spreadsheet that can give you a
> fairly good estimate if you understand the underlying math, or you might
> find a template spreadsheet on line if you search.
>
> David C
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 138, Issue 36
> *********************************************
More information about the gnucash-user
mailing list