[GNC] namespaces vs import prices

Steven Anter anter.s at gmail.com
Mon Mar 22 00:26:04 EDT 2021


John
I  have 60 securities that I'd like to move from various namespaces to a
single namespace called "MISC".  Do I have to do them individually? Or is
there a way to do them all at once?

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Mar 21, 2021 at 8:56 PM John Ralls <jralls at ceridwen.us> wrote:

> Please don't reply when you want to start a new thread, especially not to
> a digest.
>
> No problem, you can arrange non-currency commodities in namespaces however
> you like and you can change a non-currency commodity's namespace in
> Tools>Security Editor.
>
> Regards,
> John Ralls
>
>
> > On Mar 21, 2021, at 7:09 PM, Steven Anter <anter.s at gmail.com> wrote:
> >
> > The newer releases of gnucash now require a namespace to import prices
> from
> > a csv file.  This is rather cumbersome because my securities are spread
> out
> > over a few namespaces.   The notion of  "namespace" is irrelevant to the
> > way I use gnucash; if I could bypass I would.  Perhaps there is a way I
> can
> > change all securities to have the same namespace of "MISC"   If there is,
> > please let me know
> >
> >
> > On Sun, Mar 21, 2021 at 7:40 AM <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:  Had to download application again (David Ridell)
> >>   2. Re:  CSV matching produces duplicates? (David Cousens)
> >>   3.  mortgage refinance (Parker Graham)
> >>   4. Re:  mortgage refinance (pyz01 at cox.net)
> >>   5. Re:  mortgage refinance (Parker Graham)
> >>   6. Re:  mortgage refinance (D)
> >>   7. Re:  mortgage refinance (Peter West)
> >>   8. Re:  mortgage refinance (Derek Atkins)
> >>   9. Re:  mortgage refinance (Derek Atkins)
> >>  10. Re:  mortgage refinance (Peter West)
> >>  11. Re:  mortgage refinance (pyz01 at cox.net)
> >>
> >>
> >> ----------------------------------------------------------------------
> >>
> >> Message: 1
> >> Date: Fri, 19 Mar 2021 12:57:19 -0400
> >> From: David Ridell <dsridell at aol.com>
> >> To: John Ralls <jralls at ceridwen.us>
> >> Cc: gnucash-user at gnucash.org
> >> Subject: Re: [GNC] Had to download application again
> >> Message-ID: <19E7DC05-6E5C-4E23-9CC5-FB238F5FE167 at aol.com>
> >> Content-Type: text/plain; charset=utf-8
> >>
> >> Thank you!
> >>
> >> David
> >>
> >> Sent from my iPhone
> >>
> >>> On Mar 19, 2021, at 12:30 PM, John Ralls <jralls at ceridwen.us> wrote:
> >>>
> >>> ?
> >>>
> >>>> On Mar 18, 2021, at 4:04 PM, David Ridell via gnucash-user <
> >> gnucash-user at gnucash.org> wrote:
> >>>>
> >>>> I had to reboot my MacBook Air. This caused my Gnucash
> >> application/program file (is that the correct description?) to be
> deleted.
> >> I had to re-download the application. Did I do something wrong when I
> >> re-booted?
> >>>>
> >>>> My Gnucash ?drive? appears to as an external drive??see attached
> screen
> >> shot.
> >>>
> >>> No, rebooting did not cause anything to be deleted. Your screenshot
> >> didn't come through, but your external drive comment leads me to guess
> that
> >> you were running GnuCash from the mounted disk image. You didn't need to
> >> re-download it, you could remount it by double-clicking on
> >> Gnucash-Intel-4.4-1.dmg in your Downloads folder.
> >>>
> >>> But GnuCash doesn't work all that well from the dmg (no mac application
> >> does) so you're supposed to drag it from there to the Applications
> folder
> >> before running it. Once you've done that you can eject the disk image
> >> (control click and select eject or use the eject symbol next to the disk
> >> image name in Finder's sidebar).
> >>>
> >>> Regards,
> >>> John Ralls
> >>>
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 2
> >> Date: Sun, 21 Mar 2021 01:09:25 -0500 (CDT)
> >> From: David Cousens <davidcousens at bigpond.com>
> >> To: gnucash-user at gnucash.org
> >> Subject: Re: [GNC] CSV matching produces duplicates?
> >> Message-ID: <1616306965440-0.post at n4.nabble.com>
> >> Content-Type: text/plain; charset=us-ascii
> >>
> >> The matching of the account names in the input records (whether transfer
> >> accounts or the main account for the transaction) to the GnuCash
> internal
> >> accounts only happens for the first time those accounts occur in an
> input
> >> data file. After that GnuCash remembers the assignment of external
> account
> >> names to its internal account names and will only bring that dialog up
> when
> >> it encounters an account name in the input file which has not previously
> >> been matched.
> >>
> >> The other part of the matching procedures looks for duplicates, matching
> >> records to be updated and when no transfer file has been imported in the
> >> data file it tries to find similar record imported in the past and will
> if
> >> it gets a sufficient match, assign the same transfer account to the
> record
> >> being imported
> >>
> >>
> >>
> >> -----
> >> David Cousens
> >> --
> >> Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 3
> >> Date: Sun, 21 Mar 2021 09:25:25 -0400
> >> From: Parker Graham <plg57 at gmx.com>
> >> To: gnucash-user at gnucash.org
> >> Subject: [GNC] mortgage refinance
> >> Message-ID: <0299be78-f152-cd88-b70a-db35383597da at gmx.com>
> >> Content-Type: text/plain; charset=utf-8; format=flowed
> >>
> >> Have mortgage set up in system but refinanced it and need help on how to
> >> payoff existing loan and set up new loan
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 4
> >> Date: Sun, 21 Mar 2021 06:36:55 -0700
> >> From: <pyz01 at cox.net>
> >> To: "'Parker Graham'" <plg57 at gmx.com>,  <gnucash-user at gnucash.org>
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID: <004501d71e57$431078e0$c9316aa0$@cox.net>
> >> Content-Type: text/plain;       charset="us-ascii"
> >>
> >> Several ways to do this.   Here is the easiest way I know:
> >>
> >> Mortgage Loan (start loan B)           Increase - Loan Amount
> >> Mortgage Loan (start loan B)            Decrease -Principal Amount
> >> remaining
> >> from Loan A
> >>
> >> Net result - New loan amount before first payment.  Now the two entries
> are
> >> actually the net result of a split transaction entry that comes right
> from
> >> the closing statement received from the mortgage company.  If you follow
> >> that statement - you should be good to go.
> >>
> >> Hope that helps.
> >>
> >>
> >> -----Original Message-----
> >> From: gnucash-user <gnucash-user-bounces+pyz01=cox.net at gnucash.org> On
> >> Behalf Of Parker Graham
> >> Sent: Sunday, March 21, 2021 6:25 AM
> >> To: gnucash-user at gnucash.org
> >> Subject: [GNC] mortgage refinance
> >>
> >> Have mortgage set up in system but refinanced it and need help on how to
> >> payoff existing loan and set up new loan
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -----
> >> 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, 21 Mar 2021 09:41:46 -0400
> >> From: Parker Graham <plg57 at gmx.com>
> >> To: pyz01 at cox.net, gnucash-user at gnucash.org
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID: <bb10bbd9-e45e-0e66-9909-8022f5bde4be at gmx.com>
> >> Content-Type: text/plain; charset=utf-8; format=flowed
> >>
> >> not following, please give me example such as original loan is
> >> 100,000.00 refi loan is 105,000.00
> >>
> >> thanks
> >>
> >> On 3/21/21 9:36 AM, pyz01 at cox.net wrote:
> >>> Several ways to do this.   Here is the easiest way I know:
> >>>
> >>> Mortgage Loan (start loan B)           Increase - Loan Amount
> >>> Mortgage Loan (start loan B)            Decrease -Principal Amount
> >> remaining
> >>> from Loan A
> >>>
> >>> Net result - New loan amount before first payment.  Now the two entries
> >> are
> >>> actually the net result of a split transaction entry that comes right
> >> from
> >>> the closing statement received from the mortgage company.  If you
> follow
> >>> that statement - you should be good to go.
> >>>
> >>> Hope that helps.
> >>>
> >>>
> >>> -----Original Message-----
> >>> From: gnucash-user <gnucash-user-bounces+pyz01=cox.net at gnucash.org> On
> >>> Behalf Of Parker Graham
> >>> Sent: Sunday, March 21, 2021 6:25 AM
> >>> To: gnucash-user at gnucash.org
> >>> Subject: [GNC] mortgage refinance
> >>>
> >>> Have mortgage set up in system but refinanced it and need help on how
> to
> >>> payoff existing loan and set up new loan
> >>>
> >>> _______________________________________________
> >>> gnucash-user mailing list
> >>> gnucash-user at gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 6
> >> Date: Sun, 21 Mar 2021 09:42:01 -0400
> >> From: D <sunfish62 at yahoo.com>
> >> To: Parker Graham <plg57 at gmx.com>
> >> Cc: "D. via gnucash-user" <gnucash-user at gnucash.org>
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID: <e14b8013-f2e2-4f28-958a-0be2277ca9ae at yahoo.com>
> >> Content-Type: text/plain; charset=UTF-8
> >>
> >> New loan gets a new liability account. Transaction from new loan top old
> >> loan pays off old loan. Old loan goes to zero, is reconciled, and can be
> >> set as placeholder and hidden, if desired. Future transactions pay new
> >> loan.
> >>
> >> On Mar 21, 2021, 09:26, at 09:26, Parker Graham <plg57 at gmx.com> wrote:
> >>> Have mortgage set up in system but refinanced it and need help on how
> >>> to
> >>> payoff existing loan and set up new loan
> >>>
> >>> _______________________________________________
> >>> gnucash-user mailing list
> >>> gnucash-user at gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 7
> >> Date: Mon, 22 Mar 2021 00:07:43 +1000
> >> From: Peter West <pbw at pbw.id.au>
> >> To: D <sunfish62 at yahoo.com>
> >> Cc: Parker Graham <plg57 at gmx.com>, "D. via gnucash-user"
> >>        <gnucash-user at gnucash.org>
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID: <A832C1DD-021B-4E25-BE9D-988E0322CEA9 at pbw.id.au>
> >> Content-Type: text/plain;       charset=utf-8
> >>
> >> What?s the other side of the new loan set-up? Cash at bank?
> >>
> >> So
> >> Liability       Loan A  100,000 Cr
> >> Liability       Loan B  105,000 Cr
> >> Asset   Bank    105,000 Dr
> >>
> >> Then
> >> Asset   Bank    100,000 Cr  -> 5,000 Dr
> >> Liability       Loan A  100,000 Dr -> Zero balance
> >> Liability       Loan B  105,000 Dr
> >>
> >> Like that?
> >>
> >> Peter
> >>
> >> ?
> >> Peter West
> >> pbw at ehealth.id.au
> >> ?Now is the judgment of this world; now will the ruler of this world be
> >> cast out.?
> >>
> >>> On 21 Mar 2021, at 11:42 pm, D via gnucash-user <
> >> gnucash-user at gnucash.org> wrote:
> >>>
> >>> New loan gets a new liability account. Transaction from new loan top
> old
> >> loan pays off old loan. Old loan goes to zero, is reconciled, and can be
> >> set as placeholder and hidden, if desired. Future transactions pay new
> >> loan.
> >>>
> >>> On Mar 21, 2021, 09:26, at 09:26, Parker Graham <plg57 at gmx.com> wrote:
> >>>> Have mortgage set up in system but refinanced it and need help on how
> >>>> to
> >>>> payoff existing loan and set up new loan
> >>>>
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>> To update your subscription preferences or to unsubscribe:
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> If you are using Nabble or Gmane, please see
> >>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>> -----
> >>>> 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
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> 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: Sun, 21 Mar 2021 10:08:19 -0400
> >> From: "Derek Atkins" <derek at ihtfp.com>
> >> To: "Parker Graham" <plg57 at gmx.com>
> >> Cc: pyz01 at cox.net, gnucash-user at gnucash.org
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID:
> >>        <bc68bc23aa4b7564a95ba580ac9243f5.squirrel at mail2.ihtfp.org>
> >> Content-Type: text/plain;charset=utf-8
> >>
> >> Let's say your old loan has $95,000 remaining.
> >> Your new loan is $105,000
> >> I am ignoring loan costs, interest prepays, escrow, etc.
> >>
> >> You would create a transaction:
> >>
> >>  Loan Payout       Old Loan       Debit   $95000
> >>                    New Loan       Credit $105000
> >>                    Cash           Debit   $10000
> >>
> >> I.e., you will Increase cash $10k, and then pay off the old loan and
> take
> >> out the new loan.
> >>
> >> -derek
> >>
> >> On Sun, March 21, 2021 9:41 am, Parker Graham wrote:
> >>> not following, please give me example such as original loan is
> >>> 100,000.00 refi loan is 105,000.00
> >>>
> >>> thanks
> >>>
> >>> On 3/21/21 9:36 AM, pyz01 at cox.net wrote:
> >>>> Several ways to do this.   Here is the easiest way I know:
> >>>>
> >>>> Mortgage Loan (start loan B)           Increase - Loan Amount
> >>>> Mortgage Loan (start loan B)            Decrease -Principal Amount
> >>>> remaining
> >>>> from Loan A
> >>>>
> >>>> Net result - New loan amount before first payment.  Now the two
> entries
> >>>> are
> >>>> actually the net result of a split transaction entry that comes right
> >>>> from
> >>>> the closing statement received from the mortgage company.  If you
> follow
> >>>> that statement - you should be good to go.
> >>>>
> >>>> Hope that helps.
> >>>>
> >>>>
> >>>> -----Original Message-----
> >>>> From: gnucash-user <gnucash-user-bounces+pyz01=cox.net at gnucash.org>
> On
> >>>> Behalf Of Parker Graham
> >>>> Sent: Sunday, March 21, 2021 6:25 AM
> >>>> To: gnucash-user at gnucash.org
> >>>> Subject: [GNC] mortgage refinance
> >>>>
> >>>> Have mortgage set up in system but refinanced it and need help on how
> to
> >>>> payoff existing loan and set up new loan
> >>>>
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>> To update your subscription preferences or to unsubscribe:
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> If you are using Nabble or Gmane, please see
> >>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>> -----
> >>>> 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
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>
> >>
> >> --
> >>       Derek Atkins                 617-623-3745
> >>       derek at ihtfp.com             www.ihtfp.com
> >>       Computer and Internet Security Consultant
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 9
> >> Date: Sun, 21 Mar 2021 10:13:25 -0400
> >> From: "Derek Atkins" <derek at ihtfp.com>
> >> To: "Peter West" <pbw at pbw.id.au>
> >> Cc: "D" <sunfish62 at yahoo.com>, "D. via gnucash-user"
> >>        <gnucash-user at gnucash.org>
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID:
> >>        <f22be8b24eedba4067b81c5a6b5ae5ec.squirrel at mail2.ihtfp.org>
> >> Content-Type: text/plain;charset=utf-8
> >>
> >> Peter,
> >>
> >> On Sun, March 21, 2021 10:07 am, Peter West wrote:
> >>> What?s the other side of the new loan set-up? Cash at bank?
> >>>
> >>> So
> >>> Liability     Loan A  100,000 Cr
> >>> Liability     Loan B  105,000 Cr
> >>> Asset Bank    105,000 Dr
> >>
> >> This is wrong -- your Debits and Credits don't sum to zero.
> >>
> >>>
> >>> Then
> >>> Asset Bank    100,000 Cr  -> 5,000 Dr
> >>> Liability     Loan A  100,000 Dr -> Zero balance
> >>> Liability     Loan B  105,000 Dr
> >>>
> >>> Like that?
> >>
> >> I think I understand what you are trying to say, and *I'm* very confused
> >> by what you are saying!!!
> >>
> >> -derek
> >>
> >>>
> >>> Peter
> >>>
> >>> ?
> >>> Peter West
> >>> pbw at ehealth.id.au
> >>> ?Now is the judgment of this world; now will the ruler of this world be
> >>> cast out.?
> >>>
> >>>> On 21 Mar 2021, at 11:42 pm, D via gnucash-user
> >>>> <gnucash-user at gnucash.org> wrote:
> >>>>
> >>>> New loan gets a new liability account. Transaction from new loan top
> old
> >>>> loan pays off old loan. Old loan goes to zero, is reconciled, and can
> be
> >>>> set as placeholder and hidden, if desired. Future transactions pay new
> >>>> loan.
> >>>>
> >>>> On Mar 21, 2021, 09:26, at 09:26, Parker Graham <plg57 at gmx.com>
> wrote:
> >>>>> Have mortgage set up in system but refinanced it and need help on how
> >>>>> to
> >>>>> payoff existing loan and set up new loan
> >>>>>
> >>>>> _______________________________________________
> >>>>> gnucash-user mailing list
> >>>>> gnucash-user at gnucash.org
> >>>>> To update your subscription preferences or to unsubscribe:
> >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>>> If you are using Nabble or Gmane, please see
> >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>>> -----
> >>>>> 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
> >>>> To update your subscription preferences or to unsubscribe:
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> If you are using Nabble or Gmane, please see
> >>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>> -----
> >>>> 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
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>
> >>
> >> --
> >>       Derek Atkins                 617-623-3745
> >>       derek at ihtfp.com             www.ihtfp.com
> >>       Computer and Internet Security Consultant
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 10
> >> Date: Mon, 22 Mar 2021 00:20:06 +1000
> >> From: Peter West <pbw at pbw.id.au>
> >> To: Derek Atkins <derek at ihtfp.com>
> >> Cc: D <sunfish62 at yahoo.com>, "D. via gnucash-user"
> >>        <gnucash-user at gnucash.org>
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID: <EEDB9B4B-BDE4-46A1-8198-09F9FB9DFCAD at pbw.id.au>
> >> Content-Type: text/plain;       charset=utf-8
> >>
> >>
> >>> On 22 Mar 2021, at 12:13 am, Derek Atkins <derek at ihtfp.com> wrote:
> >>>
> >>> Peter,
> >>>
> >>> On Sun, March 21, 2021 10:07 am, Peter West wrote:
> >>>> What?s the other side of the new loan set-up? Cash at bank?
> >>>>
> >>>> So
> >>>> Liability    Loan A  100,000 Cr
> >>>> Liability    Loan B  105,000 Cr
> >>>> Asset        Bank    105,000 Dr
> >>>
> >>> This is wrong -- your Debits and Credits don't sum to zero.
> >>
> >> Loan A is an existing loan, so that is just eh current balance on Loan
> A.
> >> I should have shown that somehow, but I was assuming an existing loan.
> >>
> >>
> >>>>
> >>>> Then
> >>>> Asset        Bank    100,000 Cr  -> 5,000 Dr
> >>>> Liability    Loan A  100,000 Dr -> Zero balance
> >>>> Liability    Loan B  105,000 Dr
> >>>>
> >>>> Like that?
> >>>
> >>> I think I understand what you are trying to say, and *I'm* very
> confused
> >>> by what you are saying!!!
> >>>
> >>> -derek
> >>>
> >>>>
> >>>> Peter
> >>>>
> >>>> ?
> >>>> Peter West
> >>>> pbw at ehealth.id.au
> >>>> ?Now is the judgment of this world; now will the ruler of this world
> be
> >>>> cast out.?
> >>>>
> >>>>> On 21 Mar 2021, at 11:42 pm, D via gnucash-user
> >>>>> <gnucash-user at gnucash.org> wrote:
> >>>>>
> >>>>> New loan gets a new liability account. Transaction from new loan top
> >> old
> >>>>> loan pays off old loan. Old loan goes to zero, is reconciled, and can
> >> be
> >>>>> set as placeholder and hidden, if desired. Future transactions pay
> new
> >>>>> loan.
> >>>>>
> >>>>> On Mar 21, 2021, 09:26, at 09:26, Parker Graham <plg57 at gmx.com>
> wrote:
> >>>>>> Have mortgage set up in system but refinanced it and need help on
> how
> >>>>>> to
> >>>>>> payoff existing loan and set up new loan
> >>>>>>
> >>>>>> _______________________________________________
> >>>>>> gnucash-user mailing list
> >>>>>> gnucash-user at gnucash.org
> >>>>>> To update your subscription preferences or to unsubscribe:
> >>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>>>> If you are using Nabble or Gmane, please see
> >>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>>>> -----
> >>>>>> 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
> >>>>> To update your subscription preferences or to unsubscribe:
> >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>>> If you are using Nabble or Gmane, please see
> >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>>> -----
> >>>>> 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 <mailto:gnucash-user at gnucash.org>
> >>>> To update your subscription preferences or to unsubscribe:
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >>>> If you are using Nabble or Gmane, please see
> >>>> https://wiki.gnucash.org/wiki/Mailing_Lists <
> >> https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
> >>>> -----
> >>>> Please remember to CC this list on all your replies.
> >>>> You can do this by using Reply-To-List or Reply-All.
> >>>>
> >>>
> >>>
> >>> --
> >>>      Derek Atkins                 617-623-3745
> >>>      derek at ihtfp.com <mailto:derek at ihtfp.com>
> www.ihtfp.com
> >> <http://www.ihtfp.com/>
> >>>      Computer and Internet Security Consultant
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 11
> >> Date: Sun, 21 Mar 2021 07:38:53 -0700
> >> From: <pyz01 at cox.net>
> >> To: "'Derek Atkins'" <derek at ihtfp.com>, "'Parker Graham'"
> >>        <plg57 at gmx.com>
> >> Cc: <gnucash-user at gnucash.org>
> >> Subject: Re: [GNC] mortgage refinance
> >> Message-ID: <005201d71e5f$eb54ab40$c1fe01c0$@cox.net>
> >> Content-Type: text/plain;       charset="UTF-8"
> >>
> >> Parker -- for the case I was demonstrating, the old loan amount is not
> >> pertinent since you have been paying it down.  I keep track of the
> >> principal balance still remaining in the loan - so if the original loan
> was
> >> $100,000, the actual principal amount still due is less than that since
> you
> >> have been paying the loan down.   Notice - in Derek case he is also not
> >> taking into account the old loan amount, since, the old loan amount is
> not
> >> pertinent; but instead talking about the remaining principal balance --
> >> which is very pertinent.
> >>
> >> So in my case - I have the exact principal amount due on my existing
> >> loan.  So keeping with Derek example, let's say, for your example, that
> >> amount is $95,000 remaining principal balance.
> >>
> >> Old Mortgage loan account --- Increase transaction - (new loan)
> $105,000.
> >> Since my mortgage account shows the $95,000 still remaining, this shows
> a
> >> temporary balance of $200,000 ( the amount of the new loan and the
> amount
> >> of the still remaining principal balance of the old loan).
> >>
> >> Now I credit this same account (decrease transaction) the amount the
> bank
> >> paid off from the old loan (the remaining principal balance of $95,000).
> >> The next result is the balance is now the total principal balance of the
> >> new loan $105,000.
> >>
> >> As I said, there are several way to do this and a lot depends on what
> >> accounts you have setup and how you have them setup.  For me, this is
> the
> >> easiest way to keep the same account, and just replace the old loan with
> >> the new loan.  The split transaction I have to do this includes various
> >> accounts and amounts for the expenses included in the closing statement
> --
> >> but the net affect is the mortgage account changes from the old
> outstanding
> >> principal balance to the new one.  And as I make payments in the future,
> >> the principal balance is decreased by the principal portion of my
> payment
> >> and the interest goes to an interest expense account to keep track of my
> >> deductible interest (in a separate account).
> >>
> >>
> >> This is the long answer to essentially say I just replace the old
> >> principal balance for the new principal balance.
> >>
> >>
> >>
> >> -----Original Message-----
> >> From: Derek Atkins <derek at ihtfp.com>
> >> Sent: Sunday, March 21, 2021 7:08 AM
> >> To: Parker Graham <plg57 at gmx.com>
> >> Cc: pyz01 at cox.net; gnucash-user at gnucash.org
> >> Subject: Re: [GNC] mortgage refinance
> >>
> >> Let's say your old loan has $95,000 remaining.
> >> Your new loan is $105,000
> >> I am ignoring loan costs, interest prepays, escrow, etc.
> >>
> >> You would create a transaction:
> >>
> >>  Loan Payout       Old Loan       Debit   $95000
> >>                    New Loan       Credit $105000
> >>                    Cash           Debit   $10000
> >>
> >> I.e., you will Increase cash $10k, and then pay off the old loan and
> take
> >> out the new loan.
> >>
> >> -derek
> >>
> >> On Sun, March 21, 2021 9:41 am, Parker Graham wrote:
> >>> not following, please give me example such as original loan is
> >>> 100,000.00 refi loan is 105,000.00
> >>>
> >>> thanks
> >>>
> >>> On 3/21/21 9:36 AM, pyz01 at cox.net wrote:
> >>>> Several ways to do this.   Here is the easiest way I know:
> >>>>
> >>>> Mortgage Loan (start loan B)           Increase - Loan Amount
> >>>> Mortgage Loan (start loan B)            Decrease -Principal Amount
> >>>> remaining
> >>>> from Loan A
> >>>>
> >>>> Net result - New loan amount before first payment.  Now the two
> >>>> entries are actually the net result of a split transaction entry that
> >>>> comes right from the closing statement received from the mortgage
> >>>> company.  If you follow that statement - you should be good to go.
> >>>>
> >>>> Hope that helps.
> >>>>
> >>>>
> >>>> -----Original Message-----
> >>>> From: gnucash-user <gnucash-user-bounces+pyz01=cox.net at gnucash.org>
> >>>> On Behalf Of Parker Graham
> >>>> Sent: Sunday, March 21, 2021 6:25 AM
> >>>> To: gnucash-user at gnucash.org
> >>>> Subject: [GNC] mortgage refinance
> >>>>
> >>>> Have mortgage set up in system but refinanced it and need help on how
> >>>> to payoff existing loan and set up new loan
> >>>>
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>> To update your subscription preferences or to unsubscribe:
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> If you are using Nabble or Gmane, please see
> >>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>>> -----
> >>>> 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
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>
> >>
> >> --
> >>       Derek Atkins                 617-623-3745
> >>       derek at ihtfp.com             www.ihtfp.com
> >>       Computer and Internet Security Consultant
> >>
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Subject: Digest Footer
> >>
> >> _______________________________________________
> >>
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >>
> >> ------------------------------
> >>
> >> End of gnucash-user Digest, Vol 216, Issue 45
> >> *********************************************
> >>
> >
> > <
> https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon
> >
> > Virus-free.
> > www.avast.com
> > <
> https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link
> >
> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>


More information about the gnucash-user mailing list