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 <ante...@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-requ...@gnucash.org> wrote: > >> Send gnucash-user mailing list submissions to >> gnucash-user@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-requ...@gnucash.org >> >> You can reach the person managing the list at >> gnucash-user-ow...@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 (py...@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 (py...@cox.net) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Fri, 19 Mar 2021 12:57:19 -0400 >> From: David Ridell <dsrid...@aol.com> >> To: John Ralls <jra...@ceridwen.us> >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] Had to download application again >> Message-ID: <19e7dc05-6e5c-4e23-9cc5-fb238f5fe...@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 <jra...@ceridwen.us> wrote: >>> >>> ? >>> >>>> On Mar 18, 2021, at 4:04 PM, David Ridell via gnucash-user < >> gnucash-user@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 <davidcous...@bigpond.com> >> To: gnucash-user@gnucash.org >> Subject: Re: [GNC] CSV matching produces duplicates? >> Message-ID: <1616306965440-0.p...@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 <pl...@gmx.com> >> To: gnucash-user@gnucash.org >> Subject: [GNC] mortgage refinance >> Message-ID: <0299be78-f152-cd88-b70a-db3538359...@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: <py...@cox.net> >> To: "'Parker Graham'" <pl...@gmx.com>, <gnucash-user@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....@gnucash.org> On >> Behalf Of Parker Graham >> Sent: Sunday, March 21, 2021 6:25 AM >> To: gnucash-user@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@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 <pl...@gmx.com> >> To: py...@cox.net, gnucash-user@gnucash.org >> Subject: Re: [GNC] mortgage refinance >> Message-ID: <bb10bbd9-e45e-0e66-9909-8022f5bde...@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, py...@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....@gnucash.org> On >>> Behalf Of Parker Graham >>> Sent: Sunday, March 21, 2021 6:25 AM >>> To: gnucash-user@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@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 <sunfis...@yahoo.com> >> To: Parker Graham <pl...@gmx.com> >> Cc: "D. via gnucash-user" <gnucash-user@gnucash.org> >> Subject: Re: [GNC] mortgage refinance >> Message-ID: <e14b8013-f2e2-4f28-958a-0be2277ca...@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 <pl...@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@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 <p...@pbw.id.au> >> To: D <sunfis...@yahoo.com> >> Cc: Parker Graham <pl...@gmx.com>, "D. via gnucash-user" >> <gnucash-user@gnucash.org> >> Subject: Re: [GNC] mortgage refinance >> Message-ID: <a832c1dd-021b-4e25-be9d-988e0322c...@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 >> p...@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@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 <pl...@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@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@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" <de...@ihtfp.com> >> To: "Parker Graham" <pl...@gmx.com> >> Cc: py...@cox.net, gnucash-user@gnucash.org >> Subject: Re: [GNC] mortgage refinance >> Message-ID: >> <bc68bc23aa4b7564a95ba580ac9243f5.squir...@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, py...@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....@gnucash.org> On >>>> Behalf Of Parker Graham >>>> Sent: Sunday, March 21, 2021 6:25 AM >>>> To: gnucash-user@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@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@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 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> >> >> >> ------------------------------ >> >> Message: 9 >> Date: Sun, 21 Mar 2021 10:13:25 -0400 >> From: "Derek Atkins" <de...@ihtfp.com> >> To: "Peter West" <p...@pbw.id.au> >> Cc: "D" <sunfis...@yahoo.com>, "D. via gnucash-user" >> <gnucash-user@gnucash.org> >> Subject: Re: [GNC] mortgage refinance >> Message-ID: >> <f22be8b24eedba4067b81c5a6b5ae5ec.squir...@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 >>> p...@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@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 <pl...@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@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@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@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 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> >> >> >> ------------------------------ >> >> Message: 10 >> Date: Mon, 22 Mar 2021 00:20:06 +1000 >> From: Peter West <p...@pbw.id.au> >> To: Derek Atkins <de...@ihtfp.com> >> Cc: D <sunfis...@yahoo.com>, "D. via gnucash-user" >> <gnucash-user@gnucash.org> >> Subject: Re: [GNC] mortgage refinance >> Message-ID: <eedb9b4b-bde4-46a1-8198-09f9fb9df...@pbw.id.au> >> Content-Type: text/plain; charset=utf-8 >> >> >>> On 22 Mar 2021, at 12:13 am, Derek Atkins <de...@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 >>>> p...@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@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 <pl...@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@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@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@gnucash.org <mailto:gnucash-user@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 >>> de...@ihtfp.com <mailto:de...@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: <py...@cox.net> >> To: "'Derek Atkins'" <de...@ihtfp.com>, "'Parker Graham'" >> <pl...@gmx.com> >> Cc: <gnucash-user@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 <de...@ihtfp.com> >> Sent: Sunday, March 21, 2021 7:08 AM >> To: Parker Graham <pl...@gmx.com> >> Cc: py...@cox.net; gnucash-user@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, py...@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....@gnucash.org> >>>> On Behalf Of Parker Graham >>>> Sent: Sunday, March 21, 2021 6:25 AM >>>> To: gnucash-user@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@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@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 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> >> >> >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> >> gnucash-user mailing list >> gnucash-user@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@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@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.
