Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Derek Atkins
Hi, On Tue, September 7, 2021 8:34 pm, Mom wrote: > Thank you Derek! You were exactly right. Joint checking was under assets. > It is so funny how GnuCash opened after the migration. I usually just keep > the joint checking account open and, like you, never enter transactions > via the

Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Mom
Thank you Derek! You were exactly right. Joint checking was under assets. It is so funny how GnuCash opened after the migration. I usually just keep the joint checking account open and, like you, never enter transactions via the income/expense accounts so the new-to-me view that came up really

Re: [GNC] QIF imports for security pricing

2021-09-07 Thread Kalpesh Patel
Oh! Sorry for not understanding it, David. My bad here. Appreciate that working framework and the sample your provided does work for publicly traded security as expected. By way of background … The reason is because the securities of concern are mutual funds and they are NOT publicly

Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Dale Alspach
Another possibility for finding the master checking is to go to an expense transaction that was paid from the master checking account. While on that transaction click on Jump (top toolbar) and the master checking account should open as a new tab. Dale On Tue, Sep 7, 2021 at 10:16 AM Derek Atkins

Re: [GNC] QIF imports for security pricing

2021-09-07 Thread D. via gnucash-user
I don't understand. Why would you need to KEEP importing prices? Once you've imported your transactions, you can simply update the price db separately using the process I described. I attach a Google sheet that gets prices for me. Run the Advanced Portfolio report for your books, select all,

Re: [GNC] QIF imports for security pricing

2021-09-07 Thread Kalpesh Patel
David & David – that was my next route. I can write a small program (using python or shell) to convert QIF prices into CSV format but I am tripped up with the "From Namespace" column details as I cannot move to next screen in the import process as it wants correct column identified for

Re: [GNC] QIF imports for security pricing

2021-09-07 Thread D. via gnucash-user
I've used csv imports for commodity prices many times. Because of problems with retrieving prices through Finance::Quote that started when Yahoo! deactivated its servers, I set up a process that worked pretty well to get weekly price updates into gnucash. I built a spreadsheet in Google

Re: [GNC] Adujsting A/R - currently inegative amounts

2021-09-07 Thread Nora
Thanks Dereck - I appreciate your quick response! Nora -Original Message- From: Derek Atkins [mailto:de...@ihtfp.com] Sent: September 7, 2021 1:03 PM To: Nora Cc: gnucash-user@gnucash.org Subject: Re: Adujsting A/R - currently inegative amounts HI, On Tue, September 7, 2021 12:54 pm,

Re: [GNC] Adujsting A/R - currently inegative amounts

2021-09-07 Thread Derek Atkins
HI, On Tue, September 7, 2021 12:54 pm, Nora wrote: > Hi Group and Derek > > I'm transferring from QB to Gnu Cash - > > I neglected to put in 2 amounts into my opening balance of the A/R > account. > > I entered the payments from these two QB invoices, (which are all included > in the opening

[GNC] Adujsting A/R - currently inegative amounts

2021-09-07 Thread Nora
Hi Group and Derek I'm transferring from QB to Gnu Cash - I neglected to put in 2 amounts into my opening balance of the A/R account. I entered the payments from these two QB invoices, (which are all included in the opening balances of income and tax) --- but since there were no invoices to

Re: [GNC] OFX Direct Connect Bank Settings Citi Credit Card

2021-09-07 Thread David Reiser via gnucash-user
On Sep 6, 2021, at 7:30 AM, Nicholas Rood wrote: > > If anyone is having a problem with Citi Credit Card direct connect > lately I have a solution that appears to be working. > The wiki entry at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#Citi_Credit_Card > worked until

Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Derek Atkins
Hi, On Tue, September 7, 2021 10:40 am, Mom wrote: > Hi Derek: > > Here is what I see. These are all income/expense detail accounts that > should all be under “Joint Checking,” the master file that I no longer > see. I am trying to use the account nomenclature in the user’s guide BTW. > > Like

Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Mom
Hi Derek: Here is what I see. These are all income/expense detail accounts that should all be under “Joint Checking,” the master file that I no longer see. I am trying to use the account nomenclature in the user’s guide BTW. Like you, I am optimistic that the data are all there, but at this

Re: [GNC] QIF imports for security pricing

2021-09-07 Thread David Carlson
Kalpesh, Have you tried to put together a way to get prices in a CSV file and import that? I will admit that I haven't tried that myself, so if any others could elaborate on a way to do that? On Tue, Sep 7, 2021 at 8:56 AM Kalpesh Patel wrote: > I am at version 4.4 (2020-12-28) and had to

Re: [GNC] QIF imports for security pricing

2021-09-07 Thread Kalpesh Patel
I am at version 4.4 (2020-12-28) and had to roll back to version 4.4 because it appears that the changes in the later versions of libofx included in the subsequent version of GnuCash is severely impacting OFX imports for investment accounts. Securities themselves exist under "FUND" section of

Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Derek Atkins
Anne, On Tue, September 7, 2021 9:13 am, Anne Giordani wrote: > thank you for these insights! I will get some help following up on these > tips. > > The “master” account was called “joint checking” and I no longer see it. I > see all the categories, like “insurance,” “taxes,” “VISA,” etc. and

Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Anne Giordani
thank you for these insights! I will get some help following up on these tips. The “master” account was called “joint checking” and I no longer see it. I see all the categories, like “insurance,” “taxes,” “VISA,” etc. and all the expenses paid in each category back to 2014–same with income

Re: [GNC] Lost my top level aka Master account

2021-09-07 Thread Michael Hendry
On 6 Sep 2021, at 15:49, Mom wrote: > > Dear All: > > I have been keeping my checkbook register on a Mac Powerbook computer via > GnuCash since at least 2014. I recently migrated to a new-to-me Mac and when > I open my GnuCash files, I no longer seem to have the top level account > (master)