[GNC] namespaces vs import prices
John Ralls
jralls at ceridwen.us
Sun Mar 21 23:55:56 EDT 2021
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.
More information about the gnucash-user
mailing list