[GNC] namespaces vs import prices
Steven Anter
anter.s at gmail.com
Sun Mar 21 22:09:01 EDT 2021
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>
More information about the gnucash-user
mailing list