Re: [GNC] GnuCash for a Letting Agency (holding client money)

2019-02-22 Thread zcacogp
Adrien, Thanks for your detailed reply - I'm very grateful that you are engaging with the questions! I'll confess that I don't fully understand your answer but am learning more as I look at this matter more and more. Re-reading helps. The properties are not mine - I let and manage them on

[GNC] Cloud storage for shared access?

2019-02-22 Thread Stephen Mudge
Hi there. I am new to the list and as I am accessing this through my phone I am unable to see if my question has been asked before. If it has, I apologise. If I move the account I have set up on my pc to a cloud drive like Dropbox or Google drive, would I be able to access it through the mobile

[GNC] Optimising migration via qif

2019-02-22 Thread Jonathan Williams
I am trying to migrate from MS Money to GNC using qif files for each account, and am meeting problems with the importer. It asks me to check many hundreds of transactions, and if I skip this it results in hundreds of missing transactions (not duplicates, which would be easier to resolve). I'm

[GNC] QIF import - Loss of sign

2019-02-22 Thread Rustyc
Hi - Absolute newbie here trying to learn accounting techniques as well as GnuCash at the same time. Have read manuals, set up a chart of accounts and started by importing a QIF file of bank transactions thinking this would be the quickest way to get going. I end up with two entries for each

Re: [GNC] QIF import - Loss of sign

2019-02-22 Thread Rustyc
Derek - Second question re your response: Derek Atkins-3 wrote >> Also, the manual states that “Debit and Credit” terms can be replaced >> with >> “Deposit and Withdrawal” for newbies. However, Account view shows columns >> labelled “Increase and Decrease”. Confusing! > > The headings are based

Re: [GNC] QIF import - Loss of sign

2019-02-22 Thread Rustyc
Derek - Thanks for the explanation. I did sort out my "loss of sign" problem by re-importing and specifying different accounts. My problem now is that the QIF only has categories: DEP, WDL, JCR, JDR, TCR, TDR; which don't match to any one Account in my GC CofA. No big drama there as I thought I

Re: [GNC] citibank card OFX download FITID problems?

2019-02-22 Thread David Carlson
gary, I suspect that you are right that their scheme for assigning FITID's to transactions is faulty. I have heard in the past on this maillist about related problems with them or other banks where the reporter was trying without success to get them to mend their ways. I have had the luxury of

Re: [GNC] QIF import - Loss of sign

2019-02-22 Thread Derek Atkins
Hi, On Fri, February 22, 2019 8:03 pm, Rustyc wrote: > > Tried posting this yesterday before I was fully "registered" - Hope it > doesn't appear twice.  It will, once Liz clears the moderation queue.. Unless Liz recognizes the duplication. :) I wouldn't worry about it. [snip] > In case this

[GNC] QIF import - Loss of sign

2019-02-22 Thread Rustyc
Tried posting this yesterday before I was fully "registered" - Hope it doesn't appear twice.  Hi - Absolute newbie here trying to learn accounting techniques as well as GnuCash at the same time. Have done some “Intro to Accounting” exercises, read GnuCash manuals, set up a chart of accounts and

[GNC] citibank card OFX download FITID problems?

2019-02-22 Thread incoming-gnucash
I am using GnuCash 2.6.17 on Ubuntu 16.04, and I am having some problems with importing OFX files from the citcard web download. I'd love it if I could solve the problem by upgrading to a newer gnucash release, but I think the symptoms seem to point at the OFX file not being quite right (I'd

Re: [GNC] Memorized Transaction List

2019-02-22 Thread David Carlson
That is an incredibly useful tidbit! Thanks. David Carlson On Fri, Feb 22, 2019 at 7:40 AM Derek Atkins wrote: > David Carlson writes: > > > IIRC, the qif importer is (or was, in the 2.6.x series) somewhat clunky > > when it came upon an unknown 'other' account or category. It may have

Re: [GNC] Are there any add-on modules for Gnucash

2019-02-22 Thread John Ralls
> On Feb 22, 2019, at 12:38 AM, Geert Janssens > wrote: > > > I can't remember we ever said it would be possible to write to the GnuCash db > from outside of GnuCash. That would mean that **all** accounting constraints > should be encoded in the db data structure. I don't think that's

Re: [GNC] Finance::Quotes stopped working for me

2019-02-22 Thread John Ralls
> On Feb 20, 2019, at 7:06 AM, GB wrote: > > Thank you John Ralls, I think I've narrowed down the problem. > > I unchecked all of the securities that had source of "tsp" and I was able to > get all the quotes from yahoo_json. Then I used a terminal window to run > "./gnc-fq-dump -v tsp c"

Re: [GNC] Memorized Transaction List

2019-02-22 Thread Derek Atkins
David Carlson writes: > IIRC, the qif importer is (or was, in the 2.6.x series) somewhat clunky > when it came upon an unknown 'other' account or category. It may have > needed a nudge to place it correctly into the account tree. I don't think > it dumped everything into some imbalance file

Re: [GNC] Are there any add-on modules for Gnucash

2019-02-22 Thread Adrien Monteleone
Sorry for my misunderstanding. Certainly, I can see that limitation. Regards, Adrien > On Feb 22, 2019, at 2:38 AM, Geert Janssens > wrote: > > Op donderdag 21 februari 2019 22:03:11 CET schreef Adrien Monteleone: >> While there is the option to use a database backend, there is currently no

Re: [GNC] GnuCash for a Letting Agency (holding client money)

2019-02-22 Thread Adrien Monteleone
Oli, Welcome to GnuCash! As for setting up separate accounts for each property, that’s up to you. (some people even setup separate books for each) You can use the Description, Notes, or Memo lines for specifying a property as well and you can filter registers and run reports based off those

[GNC] GnuCash for a Letting Agency (holding client money)

2019-02-22 Thread zcacogp
Hi, First message here. Be gentle - thanks! First time user of GnuCash as well. AND, making things worse, I don't know much about accountancy either. Hence this post. I run a small letting agency, and have always done my accounts on a series of spreadsheets. It's worked for a number of years

Re: [GNC] Finance::Quotes stopped working for me

2019-02-22 Thread GB
Thank you John Ralls, I think I've narrowed down the problem. I unchecked all of the securities that had source of "tsp" and I was able to get all the quotes from yahoo_json. Then I used a terminal window to run "./gnc-fq-dump -v tsp c" and received response of: "No results found for stock C."