Re: How to assign transaction to accounts automatically.

On 2/20/2018 10:03 AM, Edward Bridges wrote: > If you downloaded the transactions in QIF format, you may find this tool > interesting: > > https://github.com/Kraymer/qifqif > > I have used for about a year now and it's really effective at categorizing > transactions to the correct account before

Re: Language change mystery

Roger, Do you have your data file in a user documents folder or sub-folder with full read and write privileges? Windows Defender should not be interfering with access to your data file. If that new Controlled Folder Access feature is that fussy... David C On Tue, Feb 20, 2018 at 9:07 PM, John

Re: Stock Spin-Out

On 02/20/18 11:35, Les wrote: There is a stock-split function in GC.  However it doesn't appear to do spin-outs.  In my case, the company doing the spin-out is doing a 5 to 1 and there are no fractional shares. I just assigned the cost at 0.00 per share. Les On 02/20/2018 01:27 PM, David

Closing Book causes Imbalance????

Hello, I was closing the book for 2017, and noticed it created an Imbalance account instead of putting things in the equity account I've selected. Is this a new bug in GNUCash? * Tools -> Close Book * Closing Date: 2017-12-31 * Income Total: Equity:Book Closing Transactions * Expense Total:

Re: Language change mystery

> On Feb 20, 2018, at 12:14 PM, rmom...@gmail.com wrote: > > Thanks Derek, > > I changed the OS language back to English and restarted the computer, > several times. This did not change the language back to English. > > Windows Defender Controlled Folder Access blocked GnuCash from making >

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

In order to use SQL on the Gnucash data, it needs to be saved in that format. This requires the particular backend drivers (sqlite3, MySQL) be installed already for the format to be available as a choice in the Save As dialog. See the installation notes on the wiki for more info. There is no

Re: Date changes

On 2018-02-19 09:22, parakr...@theacetechnologies.com wrote: > I downloaded Gnucash on 17th and tried to record transactions from > last year. However I found that the system does not show any date > before YESTERDAY, 17TH February 2018. > > My requirement is to record transaction from July

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Thanks Adrien, Regarding custom reports... I do SQL but am having gnuCash save account files in it's default XML format. Where would I get a list of the tables in gnuCash and their associated fields/columns? Is there a window I can open to just put in an SQL query or what? Can I create an SQL

Autocompletion problem

Hello, everyone. I'm on 2.6.18 running on Fedora 27. I'm experiencing the same problem as described here: https://lists.gnucash.org/pipermail/gnucash-user/2011-July/040365.html Autocompletion of account names tends to assume I want to pick the first option that is highlighted, usually when typing

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

You could leverage a multi-column report perhaps with a customer report in each column, that will get you invoice & payment detail, but no aggregate totals across all customers. (but each customer would have it’s own total) Then there is the P/Income Statement, but it will show you revenue by

Monthly Billings Report ? (How much business did we book/Invoice during month X)

I'm sure there is a way but I haven't found it yet... How do we run a report to see how much business we booked/invoiced for a particular month?Total and/or including a list of customers and amounts? Ditto for  a specified period of time... current quarter, last quarter, so far this year... so

Re: importing splits

The easiest way would be saving the spreadsheet to .csv format and importing that to Gnucash. Id recommend: - first removing any other text and stuff you have so that the spreadsheet is just the headings you want and the data you want in columns - doing the import on a new test gnucash file

RE: Language change mystery

Thanks Derek, I changed the OS language back to English and restarted the computer, several times. This did not change the language back to English. Windows Defender Controlled Folder Access blocked GnuCash from making changes to the data file. At first, it even blocked adding a new

Re: Date changes

Paul, I replied with a solution, I'm not searching for anything. You may want to address Parakrama, Kind regards, Greg Feneis On Tue, Feb 20, 2018 at 11:30 AM, Paul Konnersman wrote: > Greg, > > I think that you will find what you're looking for here: > >

Re: Stock Spin-Out

There is a stock-split function in GC.  However it doesn't appear to do spin-outs.  In my case, the company doing the spin-out is doing a 5 to 1 and there are no fractional shares. I just assigned the cost at 0.00 per share. Les On 02/20/2018 01:27 PM, David Carlson wrote: Les, Usually a

Re: aqbanking / ofx downloads to wrong account and can't straighten out

The mapping is done inside the account structure. The best way to handle this is to create a fake OFX import with a bogus account # -- then map that bogus account number to the account you want to reset (the one that is currently bound to your real OFX account #). Then, the next time you import

Re: aqbanking / ofx downloads to wrong account and can't straighten out

Hello all, Still no dice. I do have 4/5 accounts working properly, and used to have 5/5 until the fateful day I mis-assigned the one that received a new credit card number. The setup screen clearly shows that my aqbanking account is associated to the correct Gnucash account. And that

Re: How to assign transaction to accounts automatically.

If you downloaded the transactions in QIF format, you may find this tool interesting: https://github.com/Kraymer/qifqif I have used for about a year now and it's really effective at categorizing transactions to the correct account before importing. On Tue, Feb 20, 2018, at 10:09 AM, John

Re: How to assign transaction to accounts automatically.

Hi, Hans Deragon writes: > Greetings, > > New user here. I downloaded 500 transactions from my credit card bank > site, all assigned to 'Imbalanced-CAD'. Now, how can I set rules to > automatically assign transactions to a specific account? For instance, > any transaction

Re: Language change mystery

Hi, Roger Oliver writes: > I live in Mexico so when my tech works on my computer he changes the > operating language of Windows to Spanish. Somehow that changed the language > of GnuCash and I can't seem to get it to change back. The names of the > accounts are the names I

Re: Stock Spin-Out

Thanks for both replies.  I used a zero price and the number of shares with a description.  (John's procedure)  But I was not sure if the procedure I used was correct (best). Regards, Les On 02/19/2018 05:47 PM, nvsoar wrote: On 02/19/18 15:25, John Coppock wrote: This is what I have been

Re: How to assign transaction to accounts automatically.

> On Feb 20, 2018, at 4:39 AM, Hans Deragon wrote: > > Greetings, > > New user here. I downloaded 500 transactions from my credit card bank > site, all assigned to 'Imbalanced-CAD'. Now, how can I set rules to > automatically assign transactions to a specific account? For

Re: How to assign transaction to accounts automatically.

Excellent question! On Tue, Feb 20, 2018 at 7:39 AM, Hans Deragon wrote: > Greetings, > > New user here. I downloaded 500 transactions from my credit card bank > site, all assigned to 'Imbalanced-CAD'. Now, how can I set rules to > automatically assign transactions to a

How to assign transaction to accounts automatically.

Greetings, New user here. I downloaded 500 transactions from my credit card bank site, all assigned to 'Imbalanced-CAD'. Now, how can I set rules to automatically assign transactions to a specific account? For instance, any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

Hello Maybe I found something https://www.alpha-vantage.community/post/unable-to-get-the-response-when-using-currencyexchangerate-api-9654331 we are not alone... Best regards Adriano 2018-02-20 12:47 GMT+01:00 Adriano Baldi : > Hello Richard > > After

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

Hello Richard After doing countless tests I think that the problem is related to the management of the demands of Alphavantage. But I can not figure out where we are wrong. These are the declared performances: *>> What is the expected server-side performance (e.g., throughput time) for the API

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

I have this problem too (starting yesterday). I was going to do a post - then, late in the day, the problem went away! But now it's back again. I wonder if this is a connectivity issue with whatever GNUCash uses for currency sources? (This is hard-wired I think, and I'm not sure what that is).