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 beh

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

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

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

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 c

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 s

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

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

2019-02-22 Thread Stephen M. Butler
Welcome aboard Oli.  In the recent past I owned an apartment complex and utilized a property management company to sit between me and the tenants.  In my case, I had the agency pay the utility bills and handle the maintenance.  Don't know if you offer that service in addition to collecting the ren

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 poss

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

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 wit

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 fi

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

2019-02-22 Thread Geert Janssens
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 > support for *writing* to the db from anything other than GnuCash, it should > only be read. (this will be possible eventually) I can't remember we ev

Re: [GNC] Strange keyboard behaviour with new version

2019-02-22 Thread Wm via gnucash-user
On 21/02/2019 14:18, Adam Funk wrote: On 2019-02-13, Colin Law wrote: On Wed, 13 Feb 2019 at 13:02, Geert Janssens wrote: ... There have been additional keyboard fixes in gnucash 3.4 which I believe may fix your problem. So my suggestion: find a way to install gnucash 3.4. Just confirming t

[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." T