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 <[email protected]> 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 <[email protected]> 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 <[email protected]> > wrote: > > > >> Send gnucash-user mailing list submissions to > >> [email protected] > >> > >> To subscribe or unsubscribe via the World Wide Web, visit > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> or, via email, send a message with subject or body 'help' to > >> [email protected] > >> > >> You can reach the person managing the list at > >> [email protected] > >> > >> When replying, please edit your Subject line so it is more specific > >> than "Re: Contents of gnucash-user digest..." > >> > >> > >> Today's Topics: > >> > >> 1. 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 ([email protected]) > >> 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 ([email protected]) > >> > >> > >> ---------------------------------------------------------------------- > >> > >> Message: 1 > >> Date: Fri, 19 Mar 2021 12:57:19 -0400 > >> From: David Ridell <[email protected]> > >> To: John Ralls <[email protected]> > >> Cc: [email protected] > >> Subject: Re: [GNC] Had to download application again > >> Message-ID: <[email protected]> > >> Content-Type: text/plain; charset=utf-8 > >> > >> Thank you! > >> > >> David > >> > >> Sent from my iPhone > >> > >>> On Mar 19, 2021, at 12:30 PM, John Ralls <[email protected]> wrote: > >>> > >>> ? > >>> > >>>> On Mar 18, 2021, at 4:04 PM, David Ridell via gnucash-user < > >> [email protected]> 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 <[email protected]> > >> To: [email protected] > >> Subject: Re: [GNC] CSV matching produces duplicates? > >> Message-ID: <[email protected]> > >> 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 <[email protected]> > >> To: [email protected] > >> Subject: [GNC] mortgage refinance > >> Message-ID: <[email protected]> > >> 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: <[email protected]> > >> To: "'Parker Graham'" <[email protected]>, <[email protected]> > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: <[email protected]> > >> 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 <[email protected]> On > >> Behalf Of Parker Graham > >> Sent: Sunday, March 21, 2021 6:25 AM > >> To: [email protected] > >> 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 > >> [email protected] > >> 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 <[email protected]> > >> To: [email protected], [email protected] > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: <[email protected]> > >> 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, [email protected] 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 <[email protected]> On > >>> Behalf Of Parker Graham > >>> Sent: Sunday, March 21, 2021 6:25 AM > >>> To: [email protected] > >>> 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 > >>> [email protected] > >>> 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 <[email protected]> > >> To: Parker Graham <[email protected]> > >> Cc: "D. via gnucash-user" <[email protected]> > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: <[email protected]> > >> 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 <[email protected]> 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 > >>> [email protected] > >>> 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 <[email protected]> > >> To: D <[email protected]> > >> Cc: Parker Graham <[email protected]>, "D. via gnucash-user" > >> <[email protected]> > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: <[email protected]> > >> 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 > >> [email protected] > >> ?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 < > >> [email protected]> 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 <[email protected]> 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 > >>>> [email protected] > >>>> 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 > >>> [email protected] > >>> 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" <[email protected]> > >> To: "Parker Graham" <[email protected]> > >> Cc: [email protected], [email protected] > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: > >> <[email protected]> > >> 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, [email protected] 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 <[email protected]> > On > >>>> Behalf Of Parker Graham > >>>> Sent: Sunday, March 21, 2021 6:25 AM > >>>> To: [email protected] > >>>> 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 > >>>> [email protected] > >>>> 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 > >>> [email protected] > >>> 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 > >> [email protected] www.ihtfp.com > >> Computer and Internet Security Consultant > >> > >> > >> > >> ------------------------------ > >> > >> Message: 9 > >> Date: Sun, 21 Mar 2021 10:13:25 -0400 > >> From: "Derek Atkins" <[email protected]> > >> To: "Peter West" <[email protected]> > >> Cc: "D" <[email protected]>, "D. via gnucash-user" > >> <[email protected]> > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: > >> <[email protected]> > >> 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 > >>> [email protected] > >>> ?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 > >>>> <[email protected]> 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 <[email protected]> > 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 > >>>>> [email protected] > >>>>> 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 > >>>> [email protected] > >>>> 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 > >>> [email protected] > >>> 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 > >> [email protected] www.ihtfp.com > >> Computer and Internet Security Consultant > >> > >> > >> > >> ------------------------------ > >> > >> Message: 10 > >> Date: Mon, 22 Mar 2021 00:20:06 +1000 > >> From: Peter West <[email protected]> > >> To: Derek Atkins <[email protected]> > >> Cc: D <[email protected]>, "D. via gnucash-user" > >> <[email protected]> > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: <[email protected]> > >> Content-Type: text/plain; charset=utf-8 > >> > >> > >>> On 22 Mar 2021, at 12:13 am, Derek Atkins <[email protected]> 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 > >>>> [email protected] > >>>> ?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 > >>>>> <[email protected]> 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 <[email protected]> > 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 > >>>>>> [email protected] > >>>>>> 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 > >>>>> [email protected] > >>>>> 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 > >>>> [email protected] <mailto:[email protected]> > >>>> 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 > >>> [email protected] <mailto:[email protected]> > www.ihtfp.com > >> <http://www.ihtfp.com/> > >>> Computer and Internet Security Consultant > >> > >> > >> > >> ------------------------------ > >> > >> Message: 11 > >> Date: Sun, 21 Mar 2021 07:38:53 -0700 > >> From: <[email protected]> > >> To: "'Derek Atkins'" <[email protected]>, "'Parker Graham'" > >> <[email protected]> > >> Cc: <[email protected]> > >> Subject: Re: [GNC] mortgage refinance > >> Message-ID: <[email protected]> > >> 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 <[email protected]> > >> Sent: Sunday, March 21, 2021 7:08 AM > >> To: Parker Graham <[email protected]> > >> Cc: [email protected]; [email protected] > >> 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, [email protected] 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 <[email protected]> > >>>> On Behalf Of Parker Graham > >>>> Sent: Sunday, March 21, 2021 6:25 AM > >>>> To: [email protected] > >>>> 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 > >>>> [email protected] > >>>> 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 > >>> [email protected] > >>> 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 > >> [email protected] www.ihtfp.com > >> Computer and Internet Security Consultant > >> > >> > >> > >> > >> ------------------------------ > >> > >> Subject: Digest Footer > >> > >> _______________________________________________ > >> > >> gnucash-user mailing list > >> [email protected] > >> 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 > > [email protected] > > 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 [email protected] 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.
