date:20210321

Re: [GNC] namespaces vs import prices

2021-03-21 Thread Steven Anter

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?


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Mar 21, 2021 at 8:56 PM John Ralls  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  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 
> 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 
> >> To: John Ralls 
> >> 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  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 
> >> 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 nam

Re: [GNC] namespaces vs import prices

2021-03-21 Thread John Ralls

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  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  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 
>> To: John Ralls 
>> 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  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 
>> 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 
>> To: gnucash-user@gnucash.org
>> Subject: [GNC] mortgage refin

[GNC] namespaces vs import prices

2021-03-21 Thread Steven Anter

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  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 
> To: John Ralls 
> 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  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 
> 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 
> 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: 
> To: "'Parker Graham'" ,  
> Subject: Re: [GNC] mortgage refinance
> Message-ID: <004501d71e57$431078e0$c9316aa0$@cox.net>
>

Re: [GNC] mortgage refinance

2021-03-21 Thread pyz01

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  
Sent: Sunday, March 21, 2021 7:08 AM
To: Parker Graham 
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   $1

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  
>> 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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription prefer

Re: [GNC] mortgage refinance

2021-03-21 Thread Peter West


> On 22 Mar 2021, at 12:13 am, Derek Atkins  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
>> LiabilityLoan A  100,000 Cr
>> LiabilityLoan B  105,000 Cr
>> AssetBank105,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
>> AssetBank100,000 Cr  -> 5,000 Dr
>> LiabilityLoan A  100,000 Dr -> Zero balance
>> LiabilityLoan 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
>>>  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  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

___
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.

Re: [GNC] mortgage refinance

2021-03-21 Thread Derek Atkins

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 Bank105,000 Dr

This is wrong -- your Debits and Credits don't sum to zero.

>
> Then
> Asset Bank100,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
>>  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  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

___
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.

Re: [GNC] mortgage refinance

2021-03-21 Thread Derek Atkins

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   $1

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  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

___
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.

Re: [GNC] mortgage refinance

2021-03-21 Thread Peter West

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   Bank105,000 Dr

Then
Asset   Bank100,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  
> 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  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.

Re: [GNC] mortgage refinance

2021-03-21 Thread D via gnucash-user

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  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.

Re: [GNC] mortgage refinance

2021-03-21 Thread Parker Graham


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  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.

Re: [GNC] mortgage refinance

2021-03-21 Thread pyz01

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  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.

[GNC] mortgage refinance

2021-03-21 Thread Parker Graham


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.

Re: [GNC] namespaces vs import prices

Re: [GNC] namespaces vs import prices

[GNC] namespaces vs import prices

Re: [GNC] mortgage refinance

Re: [GNC] mortgage refinance

Re: [GNC] mortgage refinance

Re: [GNC] mortgage refinance

Re: [GNC] mortgage refinance

Re: [GNC] mortgage refinance

Re: [GNC] mortgage refinance

Re: [GNC] mortgage refinance

[GNC] mortgage refinance

12 matches

Site Navigation

Mail list logo

Footer information