Re: [GNC] Finance::Quotes stopped working for me
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." The funds are C,S,I. I have used this for at least several years and have not had any problems, this has been appearing recently. When I include the tsp funds in the security editor, it causes all of the other security quotes to fail, even those from other sources. Any clues as to what I should do next? Thank you very much ! GB -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] GnuCash for a Letting Agency (holding client money)
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 but my accountant if getting fed up with what is effectively a very disparate bespoke system and asked me to start using a proper accounting package. GnuCash looks good and I'd like to make it work for my business. I'm not an accountant and hence am not /au fait/ with accountancy terminology, but am learning fast. I think I've understood some of the basics of GnuCash (I've been playing with it all afternoon) but can see that setting things up correctly will be a major part of success or failure. My agency handles client money; a tenant will pay me their rent (£1000/month), I raise an invoice for my agency fees (£100) and pay the rest on to the landlord (£900). Am I best advised to set up each property as a separate account file or as a separate Account under "Current assets"? Bear in mind that of the rent payment above then only £100 of it is company money; £900 belongs to the landlord from the moment the payment is made to me. For what it's worth, my business has two bank accounts; one Clients Money Account (where the rent is paid into) and one Company Account (from which I pay bills from suppliers and so on). Other posts on here suggest that I should treat the payment as being £100 of income for my company and £900 of loan, and I pay off the loan to the landlord who exists as a creditor of mine. I understand this concept but am not sure how to set this up on GnuCash. I am sure I can learn, but helpful tips would be welcomed. Thanks in advance for any help. Oli. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Strange keyboard behaviour with new version
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 that those issues were fixed for me (on Ubuntu) be version 3.4 This link includes deb files that can be used easily to install 3.4 on Ubuntu 18.04/18.10 https://lists.gnucash.org/pipermail/gnucash-user/2019-February/082670.html I'll takee a look --- thanks! Hello, Adam Funk, didn't know you frequented this place. -- Wm ___ 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] Are there any add-on modules for Gnucash
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 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 possible. Take for example the simple constraint that transactions have to balance. There is no way to encode that in a db data structure. What we did state is that eventually multiple users can connect to the same database through separate gnucash instances. ... > > > On Feb 21, 2019, at 8:53 AM, Harry Foerster wrote: > > > > I'm currently running Gnucash 3.3 under Windows 10. Currently I would need > > to do a large amount of manual entering/editing to record some investment > > transactions I require. Are there any add-on modules available that > > manipulate transactions and/or what programming language would be required > > for my setup? On Windows you have limited extension options: - parts of gnucash are written in guile, a lisp-like functional programming language. You can write extensions in guile, however the possibilities to alter gui interactions are limited this way. - the other option is to write the changes you want in C(++). That will require you to recompile the application, which can be challenging depending on your programming experience. Regards, Geert ___ 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] GnuCash for a Letting Agency (holding client money)
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 fields, thus, you can find out where money is coming from (or also going to) based on the specific property even without using separate accounts. You mention having them as separate assets, but are they *your* assets? If there is a landlord, I’d say those properties are owned by that individual, not you. Thus, they aren’t your assets. (but they are a source of revenue) You can certainly have separate revenue accounts for each property if you like, but again, that might be overkill. It depends on how many properties you’re dealing with. As for handling the full rent, you can do this on an invoice, or with a combination of invoices and manual transactions. Which path you take would likely depend on if you actually invoice the tenant or not. You can have the following line items on your invoice: Revenue:Agency Fees £100 Liabilities:Rent Owing £900 This will create the following transaction: Dr. Assets:Accounts Receivable £1000 Cr. Revenue:Agency Fees £100 Cr. Liabilities:Rent Owing £900 When the tenant pays you, and you mark the invoice paid, this will be the result: Dr. Assets:Checking:Rental Escrow £1000 Cr. Assets:Accounts Receivable £1000 Then when you pay the landlord their portion: Dr. Liabilities:Rent Owing £900 Cr. Assets:Checking:Rental Escrow £900 And when you transfer money to your operating account: Dr. Assets:Checking:Operations £100 Cr. Assets:Checking:Rental Escrow £100 Of course, those last two can be aggregated across many properties. You want to reflect the real world transaction as closely as possible. Exactly how you handle the invoicing would depend on *who* your customer is, the tenant? or the Landlord? (I’d say it is the landlord since you’re providing them the service, but then you’ll have to think carefully about how you want to track rents due from, and paid by, tenants) You might even be able to treat both as customers if you handle it carefully. I would definitely *not* handle the pass-through rent to the landlord as a loan. It *is* a liability, similar to how sales taxes are generally handled. It isn’t your money. You’re just facilitating the collection of it for the landlord. Ask your CPA about this though for advice on your specific situation. Finally, pickup a copy of a university accounting textbook (introductory course) or find one online. There are plenty available. Not every part of the book will apply to your situation, but it will be an invaluable reference. (as is your CPA) Regards, Adrien > On Feb 21, 2019, at 12:34 PM, zcacogp wrote: > > 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 but my accountant if > getting fed up with what is effectively a very disparate bespoke system and > asked me to start using a proper accounting package. GnuCash looks good and > I'd like to make it work for my business. > > I'm not an accountant and hence am not /au fait/ with accountancy > terminology, but am learning fast. I think I've understood some of the > basics of GnuCash (I've been playing with it all afternoon) but can see that > setting things up correctly will be a major part of success or failure. My > agency handles client money; a tenant will pay me their rent (£1000/month), > I raise an invoice for my agency fees (£100) and pay the rest on to the > landlord (£900). Am I best advised to set up each property as a separate > account file or as a separate Account under "Current assets"? Bear in mind > that of the rent payment above then only £100 of it is company money; £900 > belongs to the landlord from the moment the payment is made to me. > > For what it's worth, my business has two bank accounts; one Clients Money > Account (where the rent is paid into) and one Company Account (from which I > pay bills from suppliers and so on). > > Other posts on here suggest that I should treat the payment as being £100 of > income for my company and £900 of loan, and I pay off the loan to the > landlord who exists as a creditor of mine. I understand this concept but am > not sure how to set this up on GnuCash. I am sure I can learn, but helpful > tips would be welcomed. > > Thanks in advance for any help. > > > Oli. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your sub
Re: [GNC] Are there any add-on modules for Gnucash
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 >> 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 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 possible. > Take for example the simple constraint that transactions have to balance. > There is no way to encode that in a db data structure. > > What we did state is that eventually multiple users can connect to the same > database through separate gnucash instances. ___ 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] Memorized Transaction List
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 without giving the user a > chance make a better choice. Fo me, I last used that feature about a > decade ago, so I could be wrong. The QIF import did lazy account creation -- it would only touch your actual account tree at the end, after you click "Finish". The Generic Importer, however, will make account modifications enroute, including creating new accounts. For QIF, new accounts wont get properly mapped into the tree, so you either need to pre-create the gnucash account and map it in the importer, or you need to modify the QIF to read, e.g.: LExpenses:Groceries instead of: LGroceries to properly place it in the tree. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- 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] Finance::Quotes stopped working for me
> 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" and received response of: > "No results found for stock C." The funds are C,S,I. I have used this for > at least several years and have not had any problems, this has been > appearing recently. When I include the tsp funds in the security editor, it > causes all of the other security quotes to fail, even those from other > sources. > > Any clues as to what I should do next? It looks like https://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml has an invalid redirect, so there's nothing to retrieve. Unless that's fixed you won't be able to use Finance::Quote to retrieve prices. I found https://www.tsp.gov/InvestmentFunds/FundPerformance/index.html where you can download a CSV that you might be able to import into GnuCash. Regards, John Ralls ___ 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] Are there any add-on modules for Gnucash
> 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 possible. > Take for example the simple constraint that transactions have to balance. > There is no way to encode that in a db data structure. Our position has always been and will likely always be that we support writing to a GnuCash file or database only through the GnuCash API. That's not the same thing as from inside of GnuCash. GnuCash's libraries expose their API through the C calling convention that can be linked by just about any compiled language. You'll need to get the sources for the headers. We also provide Python 3 and Scheme (via Guile) bindings for parts of the API, though the Python bindings aren't built in the Microsoft Windows or MacOS application bundles. Do bear in mind that the GnuCash libraries aren't bullet-proof and it's still possible to wreck your database even with the GnuCash API if you're not careful (or are carefully malicious). The API is complex and the documentation ranges from pretty good to nonexistent; it can be found at https://code.gnucash.org/docs/MAINT. On tho other hand, if you just want to create a bunch of transactions you might not need to code anything: The GnuCash 3.x CSV transaction importer is pretty capable. Regards, John Ralls ___ 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] Memorized Transaction List
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 > > needed a nudge to place it correctly into the account tree. I don't > think > > it dumped everything into some imbalance file without giving the user a > > chance make a better choice. Fo me, I last used that feature about a > > decade ago, so I could be wrong. > > The QIF import did lazy account creation -- it would only touch your > actual account tree at the end, after you click "Finish". The Generic > Importer, however, will make account modifications enroute, including > creating new accounts. > > For QIF, new accounts wont get properly mapped into the tree, so you > either need to pre-create the gnucash account and map it in the > importer, or you need to modify the QIF to read, e.g.: > > LExpenses:Groceries > > instead of: > > LGroceries > > to properly place it in the tree. > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >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] GnuCash for a Letting Agency (holding client money)
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 rent. Your CPA will be a big resource in setting up the specific Chart of Accounts (CoA) that will work well for both you and he/her. They may want you to show all of the collected monies as Revenue and then show payouts to the landlord as Expense. In the interim between receipt of funds and payout the money would sit in one of your accounts as an Asset and he would also have a Liability (not a loan) to the landlord of the portion due them. If you covered other expenses (like utilities) for the landlord, then the liability would be reduced by those amounts when they were paid. Again, your CPA is the best source for setting up the CoA. You might find a very small set of accounts will suffice depending on how much you do for each landlord. --Steve On 2/21/19 10:34 AM, zcacogp wrote: > 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 but my accountant if > getting fed up with what is effectively a very disparate bespoke system and > asked me to start using a proper accounting package. GnuCash looks good and > I'd like to make it work for my business. > > I'm not an accountant and hence am not /au fait/ with accountancy > terminology, but am learning fast. I think I've understood some of the > basics of GnuCash (I've been playing with it all afternoon) but can see that > setting things up correctly will be a major part of success or failure. My > agency handles client money; a tenant will pay me their rent (£1000/month), > I raise an invoice for my agency fees (£100) and pay the rest on to the > landlord (£900). Am I best advised to set up each property as a separate > account file or as a separate Account under "Current assets"? Bear in mind > that of the rent payment above then only £100 of it is company money; £900 > belongs to the landlord from the moment the payment is made to me. > > For what it's worth, my business has two bank accounts; one Clients Money > Account (where the rent is paid into) and one Company Account (from which I > pay bills from suppliers and so on). > > Other posts on here suggest that I should treat the payment as being £100 of > income for my company and £900 of loan, and I pay off the loan to the > landlord who exists as a creditor of mine. I understand this concept but am > not sure how to set this up on GnuCash. I am sure I can learn, but helpful > tips would be welcomed. > > Thanks in advance for any help. > > > Oli. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] citibank card OFX download FITID problems?
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 love to be proven wrong about that!) I use the citibank web site every week or two to download an OFX file with my credit card transactions. OFX import works fine for me with other banks, but I've had a small problem with citi for a year or two: Occasionally, say once every other month or two, a transaction I see on the web site (and which is present in the OFX file) does not show up in the gnucash window for me to accept or match. In the past few weeks, citi has been making changes to their web site and possibly to their OFX generating code, and this problem seems to be worse/more frequent. Figuring out what transaction(s) got lost and manually entering them is of course annoying. In addition, there is a new problem: The matching window often shows a handful of transactions that I know have been downloaded before. These at least automatically show the checkmark to match them, so dealing with this problem isn't too bad. Is anyone else seeing this issue? I think citi might be generating incorrect FITIDs, as follows: Looking at a freshly downloaded citi file with month-to-date transactions, the FITIDS in the file look like this: $ egrep FITID file.OFX 20190207090001 20190208090002 20190208090003 20190208090004 20190208090005 ... So they appear to append the 8 character date to "09" and then a 4 digit intra-file serial number. The date is the date of the charge (which is earlier than the date the file shows as DTPOSTED). I tried downloading an OFX from "last statement" rather than month-to-date, and the exact same pattern is used. I don't know what the "09" is, maybe it is a software version number? This naming convention seems safe enough if they generated a day worth of transactions at a time, but they do not; transactions trickle in. So sometimes a subsequent download will add transactions on a date that already has downloaded transactions. This is a problem because the ordering does not seem to keep the first-to-be-downloaded transactions first in subsequent downloads. For example, if you download the month-to-date transactions, on say the final date with any transactions, there might be just a single transaction T1. A day later you download, and an additional transaction T2 might show up with the same date. If that happens, if the new transaction came first in the file, T2 would get the same FITID that T1 had, ending in 0001, so T2 would incorrectly be ignored. And T1 would get a new FITID ending in 0002 and would incorrectly show up in the gnucash matching window (which a checkmark to match it). I do not normally save my OFX files after I load them, so I can't completely verify all this yet, but I tried googling and came up with this year-old issue that might be related: https://community.quicken.com/discussion/7647910/citibank-qfx-file-problems-causing-quicken-to-erroneously-disregard-some-transactions A few questions: First, is there a way for me to somehow inspect the list of FITIDs that my gnucash has seen before, and any meta data like when gnucash first saw them? If so, that would help me nail down cause of what I am seeing better. And possibly it could help me coming up with a workaround if the citi file is indeed broken and staying broken for the foreseeable future. Next, any advice on workarounds better than deducing what transaction(s) in the OFX file are being ignored and entering them manually? Finally, is this idea safe: I think I can save myself typing in the transaction details for any hidden transactions by editing the OFX to uniquify any new transaction that is hidden. If the OFX file rules allow, I could add a suffix like "2019021909forceload". Or maybe I should just edit the date to start with 1 instead of 2, i.e. change "2019021909" to "1019021909", which seems safe in that it won't collide with any future OFX download using that naming scheme. Thanks. --gary ___ 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] QIF import - Loss of sign
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 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 transaction but there is no indication of which entry is for the bank transaction and which is the one I have to assign to another GnuCash account (which is what I presume is what is required). The plus and minus signs in the QIF have disappeared. Am I missing something? In case this is not clear I’ll give actual numbers. The QIF files has entries such as: D26/06/18 T-38.50 PPAY ANYONE ANZxxxL EGGS 0139314487BILL ^ D01/07/18 T7.31 PINTEREST ^ This shows a deposit (interest) and a withdrawal from the bank account. When imported into GnuCash I end up with 4 lines in the “Account” page. Each transaction is listed twice – once with the amount under Increase and once with it under Decrease. And all have Account = “Bank account xxx” (under “transfer”). Is this because I specified “Bank Account xxx” somewhere during the import process? (I was not sure what GC was asking at each stage!). Can someone maybe explain in simple terms how to import bank data and use it to populate all transactions (rather than entering transactions and then assigning each transaction to an existing entry)? 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! Any help appreciated! -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] QIF import - Loss of sign
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 is not clear I’ll give actual numbers. The QIF files has > entries such as: > D26/06/18 > T-38.50 > PPAY ANYONE ANZxxxL EGGS 0139314487BILL > ^ > D01/07/18 > T7.31 > PINTEREST > ^ > This shows a deposit (interest) and a withdrawal from the bank account. > When > imported into GnuCash I end up with 4 lines in the “Account” page. Each > transaction is listed twice – once with the amount under Increase and once > with it under Decrease. And all have Account = “Bank account xxx” (under > “transfer”). > > Is this because I specified “Bank Account xxx” somewhere during the import > process? (I was not sure what GC was asking at each stage!). Yes. It means you specified the same GnuCash account as the source and destination of the transaction. I.e., you said "I took $100 from BANK and sent it to BANK". This is probably not what you intended. > Can someone maybe explain in simple terms how to import bank data and use > it > to populate all transactions (rather than entering transactions and then > assigning each transaction to an existing entry)? Yes. Let's say you have a QIF file called 'bank.qif'. GnuCash will assume this is for the QIF Account named 'bank'. All transactions in this file will be associated with 'bank', and then you need to map each transaction to the correct destination account. The Importer will first ask you to map the QIF Account "bank" to some GnuCash (asset) account. So for example, Assets:SunTrust:Checking. There may be other QIF accounts in the file, and those too should map to GnuCash Asset and Liability accounts. Then it will ask you to match the Categories, which you should map to GnuCash Income/Expense accounts. Finally, it will ask you to match the Payee/Memo lines (which is what you have here). These you will also need to map correctly to the Income/Expense accounts. So for example, you should map "INTEREST" to, e.g. Income:Interest and "PAY ANYONE ANZxxxL EGGS 0139314487BILL" to, e.g., Expenses:Groceries. Your mistake is that you mapped each of these payees/memos to the same (bank) account that you mapped bank to. > 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 on the exact account type. If you use a Bank, it will be Deposit and Withdrawal. If it's a credit card, Charge and Payment. Increase and Decrease are for generic Asset accounts. Edit the account in question and check on the account type. > Any help appreciated! Hope this helped, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- 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] citibank card OFX download FITID problems?
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 never needing to delete old OFX files so I can go back years and see what I imported and where from. I am also lucky that all my providers have produced compliant files. I believe that they all track the FITID's and always assign them permanently to each transaction so that the same transaction downloaded a year later will have the same FITID as originally downloaded. That said, I do not have a recommendation for you about what is your best course of action. One possibility that you did not suggest would be to download a companion QIF format import file at the same time as the OFX file and import that right after importing the OFX file. Hopefully, that would bring in any transactions missed in the OFX import. Of course, you would have to watch the matching very closely. Perhaps others have additional suggestions. David Carlson On Fri, Feb 22, 2019 at 2:42 PM wrote: > > 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 love to be proven wrong about that!) > > I use the citibank web site every week or two to download an OFX file > with my credit card transactions. OFX import works fine for me with > other banks, but I've had a small problem with citi for a year or two: > Occasionally, say once every other month or two, a transaction I see > on the web site (and which is present in the OFX file) does not show > up in the gnucash window for me to accept or match. In the past few > weeks, citi has been making changes to their web site and possibly to > their OFX generating code, and this problem seems to be worse/more > frequent. Figuring out what transaction(s) got lost and manually > entering them is of course annoying. > > In addition, there is a new problem: The matching window often shows a > handful of transactions that I know have been downloaded before. > These at least automatically show the checkmark to match them, so > dealing with this problem isn't too bad. > > Is anyone else seeing this issue? I think citi might be generating > incorrect FITIDs, as follows: > > Looking at a freshly downloaded citi file with month-to-date > transactions, the FITIDS in the file look like this: > > $ egrep FITID file.OFX > 20190207090001 > 20190208090002 > 20190208090003 > 20190208090004 > 20190208090005 > ... > > So they appear to append the 8 character date to "09" and then a 4 > digit intra-file serial number. The date is the date of the charge > (which is earlier than the date the file shows as DTPOSTED). > > I tried downloading an OFX from "last statement" rather than > month-to-date, and the exact same pattern is used. I don't know what > the "09" is, maybe it is a software version number? > > This naming convention seems safe enough if they generated a day worth > of transactions at a time, but they do not; transactions trickle in. > So sometimes a subsequent download will add transactions on a date > that already has downloaded transactions. This is a problem because > the ordering does not seem to keep the first-to-be-downloaded > transactions first in subsequent downloads. > > For example, if you download the month-to-date transactions, on say > the final date with any transactions, there might be just a single > transaction T1. A day later you download, and an additional > transaction T2 might show up with the same date. If that happens, if > the new transaction came first in the file, T2 would get the same > FITID that T1 had, ending in 0001, so T2 would incorrectly be ignored. > And T1 would get a new FITID ending in 0002 and would incorrectly show > up in the gnucash matching window (which a checkmark to match it). > > I do not normally save my OFX files after I load them, so I can't > completely verify all this yet, but I tried googling and came up with > this year-old issue that might be related: > > > https://community.quicken.com/discussion/7647910/citibank-qfx-file-problems-causing-quicken-to-erroneously-disregard-some-transactions > > A few questions: > > First, is there a way for me to somehow inspect the list of FITIDs that my > gnucash has seen before, and any meta data like when gnucash first > saw them? If so, that would help me nail down cause of what I am > seeing better. And possibly it could help me coming up with a > workaround if the citi file is indeed broken and staying broken for > the foreseeable future. > > Next, any advice on workarounds better than deducing what > transaction(s) in the OFX file are being
Re: [GNC] QIF import - Loss of sign
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 could do some matching when it gets to the "Match payees/memos to GC accounts" step. However my imported just skips that step and goes straight to "Tradable commodities". Any idea why? I then tried the import .CSV which seemed to have some Bayesian matching capability but that was only for matching with existing transactions. Again, any help appreciated!! -Russ -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] QIF import - Loss of sign
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 on the exact account type. If you use a Bank, it > will be Deposit and Withdrawal. If it's a credit card, Charge and > Payment. Increase and Decrease are for generic Asset accounts. > > Edit the account in question and check on the account type. Looked at the Account but could not see an option anywhere to specify "Account Type" - apart from "Asset", "Expense" etc. Does it depend on Account Code or Name (in some way)? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] QIF import - Loss of sign
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 transaction but there is no indication of which entry is for the bank transaction and which is the one I have to assign to another GnuCash account (which is what I presume is what is required). The plus and minus signs in the QIF have disappeared. Am I missing something? 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! Can someone explain. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Optimising migration via qif
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 thinking of starting afresh, and some advice would be much appreciated. I have explored the FAQ and forum but can't find answers I need. Specifically: 1) Is it better to set up the CoA before I start, or import first and then edit accounts later? I assumed the former, but not 100% sure. 2) Is it better to import one account at a time, or all together with multiple qif files? I have seen both suggested... 3) Would it help to import, say, one year of data to train the druid and then the rest? Thanks in advance for your help. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Cloud storage for shared access?
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 app to add expenses while "in the field"? Many thanks. Steve ___ 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] GnuCash for a Letting Agency (holding client money)
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 behalf of the owners. And yes, the landlords are my clients - not the tenants. Therefore in that example I cited with the rent of £1000 then the flow is thus; - Tenant pays me £1000 - I invoice the landlord £100 - I pay £900 on to the landlord and keep £100, effectively paying the invoice The £100 is company income but the £900 isn't; at no stage is it my money as it belongs to either the tenant or the landlord. (There is an argument to say that the money belongs to the tenant if they pay early, and it then belongs to the landlord at the moment the rent becomes due. However most tenants usually pay slightly late so this argument is moot!) Your comment about needing to think carefully how to treat this money is the nub of the issue; what is the best way of doing this? I don't put rent owing on an invoice to a landlord; I currently keep a separate excel spreadsheet for each property which shows all transactions for that property but on an invoice to a landlord I only list the items to be paid. These items are agency fees, handling fees for work commissioned and re-charges for bills I have paid on the landlord's behalf. There are two other potential sticking points, although I don't think they are biggies; - Occasionally I do one-off projects for people who are not landlords. This leads to a regular invoice being raised and the client paying me the amount owed. This is different from the 'usual' situation as there is no rent to consider, just an invoice being raised and then being paid. - I bill tenants for things, so they may be clients as well as tenants. Examples of this are when a tenant locks themselves out and I visit them to let them in. I would bill them for this and they would pay. They will often pay with their next rent payment. This could look like this: - Tenant locks themselves out. I let them in and charge £80 - I invoice the tenant £80. This is not paid immediately - Next month the tenant pays rent, plus £80, total £1080 - I invoice the landlord £100 - I pay the landlord £900 - I take payment for the invoices of £80 for the tenant and £100 for the landlord from the £1080 payment What is a CPA? Thanks again for your help. I expect I'll update this thread with a number of questions in due course. Oli. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
