[GNC] namespaces vs import prices
Jack Frillman
jcf_m_lists at me.com
Mon Mar 22 08:46:01 EDT 2021
You have to do it individually.
On 3/22/21 12:26 AM, Steven Anter wrote:
> 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>
> _______________________________________________
> 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.
--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
More information about the gnucash-user
mailing list