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?

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

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

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 b

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

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

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

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

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 s

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

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 t

[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