Re: [GNC] multiple currencies in one transaction

> > David Carlson > > On Tue, Aug 20, 2019 at 2:36 AM Jeff Abrahamson <mailto:j...@p27.eu>> wrote: > > It's not entirely unuseful that some of the discussion happens here on > the user list.  User input may be of interest. > > I'll add only one p

Re: [GNC] multiple currencies in one transaction

a currency register the transaction currency value and the exchange >> rate between the register currency and transaction currency are hidden that >> can be difficult, especially in split view where the user is responsible for >> getting the (possibly invisible) values right. The

Re: [GNC] multiple currencies in one transaction

nto two transactions, one to ‘fund’ the CHF, > then another to spend that on Coffee. > > Note, that I tried doing this from the Expense account, but it was messy. I > also couldn’t find a way to get GnuCash to calculate the EUR price of the > transaction for me using the fetche

Re: [GNC] multiple currencies in one transaction

On 15/08/2019 18:55, John Ralls wrote: >> On Aug 15, 2019, at 7:38 AM, Jeff Abrahamson wrote: >> >> Somewhat related, I thought to import historical currencies, as I'm back >> filling some data for analysis purposes. I grabbed 10 years of daily >> quotes and

Re: [GNC] multiple currencies in one transaction

  5.70 512452_Transferwise CHF    5.70 51245_Transferwise 5.70    2.80 And that 2.80 is rather odd. Jeff Abrahamson On 15/08/2019 16:38, Jeff Abrahamson wrote: > I purchased a coffee in Switzerland using my

[GNC] multiple currencies in one transaction

e price editor thinks it knows. Is there a limit on FX rates?  (This is about 4000, which doesn't strike me as terribly large.) -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing

Re: [GNC] Importing FX rates into gnucash

Aha, thanks! Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 11/08/2019 19:55, John Ralls wrote: > >> On Aug 11, 2019, at 10:37 AM, Jeff Abrahamson wrote: >> >> I have a table of historic FX rates I'd like to import into gnucash. I >> don't see ho

Re: [GNC] FX fetching strangeness

ould be three plus an error.  So I presume it's not that.  Except that if I first do a single quote from the commandline, gnucash then fails on two of the four instead of three of the four.  So it's looking like rate limit. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 11/

[GNC] Importing FX rates into gnucash

it doesn't. ;-) Thanks! -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https

Re: [GNC] FX fetching strangeness

Thanks. Jeff On 11/08/2019 19:20, Jeff Abrahamson wrote: > > That was it.  Thanks. > > I've also filed this: > > https://bugs.gnucash.org/show_bug.cgi?id=797343 > > Jeff Abrahamson > http://p27.eu/jeff/ > http://transport-nantes.com/ > > &

Re: [GNC] FX fetching strangeness

That was it.  Thanks. I've also filed this: https://bugs.gnucash.org/show_bug.cgi?id=797343 Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 04/08/2019 21:39, John Ralls wrote: > Do you have an Alphavantage key set in $ALPHAVANTAGE_API_KEY (for command > line

[GNC] FX fetching strangeness

<=== one of these price:  <=/      timezone:  <=== optional ** This stock quote cannot be used by GnuCash! jeff@birdsong:~ $ Any suggestions on what to do or what to test? -- Jeff Abrahamson +33 6 24 40 01 57 +44

[GNC] representing shared accounts (personal)

, and it shouldn't be sticking around in my net worth (equity) when my spouse reimburses himself. Any suggestions?  This is personal accounting, but I still like to try to do things in a way that respects the half millennium of experience that accountants have in modeling these things. -- Jeff Abrahamson

Re: [GNC] Dimensions in Accounts

ash-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. -- Jeff Abrahamson +33 6 24 40 01 57 +44

Re: [GNC] sqlite error from gnucash 2.6.19

On 27/04/2019 23:44, John Ralls wrote: >> On Apr 27, 2019, at 10:00 AM, Jeff Abrahamson wrote: >> >> I opened a gnucash file (sqlite, gnucash v2.6.19, built from version >> c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace >> >>* 18:36:09

[GNC] sqlite error from gnucash 2.6.19

isn't helping me know what to do about it.  Something gnucash specific?  Use sqlite tools directly?  Other? -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 https://www.p27.eu/jeff/ https://www.transport-nantes.com/ ___ gnucash-user mailing list

Re: [GNC] Column Width

Double-click the centre of the column header. This may very well be a function of your OS, however, since gnucash is written on toolboxes that behave slightly differently depending on context.  In my context, ubuntu linus (and 2.6, in case that matters), this works. Jeff Abrahamson https

Re: [GNC] Suggesting simple interface changes

below.  You can mostly copy/paste, you've described them pretty well. Of course, as a mostly volunteer project, one's influence over other volunteers is minimal.  But having the bug / feature enhancement to point to improves chances. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com

Re: [GNC] US Bans Free tax Software

e going to start talking about anti-competitive laws, this might not be the most influential place to start. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 11/04/2019 07:28, Stuart McGraw wrote: > On 4/10/19 10:33 PM, David Cousens wrote: >> Just noticed this post. >

Re: [GNC] search

Ah, yes, it didn't occur to me that it wouldn't search through the split memos. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 07/04/2019 18:48, John Ralls wrote: > Since it works when you search the whole book and fails when you search only > one account, I mu

Re: [GNC] search

The list strips images, so information was lost. I have an entry with a memo field containing the word (text string) "=JUSTIFICATIF". J On 07/04/2019 18:05, Jeff Abrahamson wrote: > [This is gnucash 2.6.19 on linux.  Some day I'll upgrade to 3.x.] > > I have some transaction

[GNC] search

ange that the search is different depending on where I initiated it, given that all the results are in the one bank account. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnuc

[GNC] shared accounts

int-ventures.html> for accounting for joint ventures.  This might just be overkill for my house and a shared bank account. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 https://www.p27.eu/jeff/ https://www.transport-nantes.com/ ___ gnucash-user mailin

Re: [GNC] I would like different Preference settings for different files, same user

s.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] I would like different Preference settings for different files, same user

I'd happily +1 a bug report that it should be a book preference rather than a user preference.  It makes no sense to me to force a user to see the same fiscal year everywhere s/he looks but then to let multiple users see the same book with different fiscal years. Jeff Abrahamson http://p27.eu

Re: [GNC] How to handle bounced check

action number of the returned cheque (the X... in my world). Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 02/02/2019 06:06, David Cousens wrote: > Mike > > Simnply delete the payment transaction. This will leave the invoice open and > still awaiting payment. &

Re: [GNC] GNUCash becoming unusable ..v3.4

either but selected 'all accounts'' by > mistake while editing options. > > My guess is the core code is designed for Linux, porting across to Windows > may not be ideal? > > > > > Jeff Abrahamson wrote >> I've been doing reports with python scripts (not an officially supporte

Re: [GNC] GNUCash becoming unusable ..v3.4

I've been doing reports with python scripts (not an officially supported technique, also requires the backend be sqlite, which is easy).  My reports run in a snap.  That said, maybe I have less data than you. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 01/02/2019 09:07

[GNC] reconcile history

, is there any log kept of when I reconcile?  I know the last reconciled balance is available, but a log of "reconciled to this date and this amount at this time" would also be of use. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-

Re: [GNC] new to gnucash

this quite weird when you first start using proper accounting language. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 05/01/19 17:41, Mike Kerstetter wrote: > Hello all. I'm brand new to gnucash. I want it to do just the basics > of keeping a register and reconciliation of a

Re: [GNC] How to automate $ value on the contra account when editing a transaction

er > 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. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255

Re: [GNC] Accounting Modules

code. Jeff Abrahamson https://www.p27.eu/jeff/ https://www.transport-nantes.com/ On 27/11/18 04:00, Adrien Monteleone wrote: > Stephen, > > You can learn it directly. My university didn’t even offer C except as part > of their Operating Systems Design course. They start eve

Re: [GNC] Is GnuCash the right application for me?

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. -- Jeff Abraha

Re: [GNC] moving multiple transactions

On 01/10/18 09:15, David Cousens wrote: > Jeff, >> Point well taken. I'll have a think and file a bug. > I was on bugs.gnucash.org this afternoon fixing another problem and created a > bug report for > the feature enhancement -No 796874. Thanks! -- Jeff Abrahamson +33 6 24

Re: [GNC] moving multiple transactions

. What is needed is a feature request Bug report > at bugs.gnucash.org. If you raise a Bug request and describe how you would > like it to work it will then at least be assigned a priority in the list of > fixes. Point well taken.  I'll have a think and file a bug. -- Jeff Abrahamson +33 6 24 40 01

[GNC] moving multiple transactions

arisen.  But maybe I'll go brew a cup of tea and get on with it. ;-) -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] QIF import is empty

sportifs, Stages du club) $-6001.00 ^ Notably, I needed to use full hierarchical names and add an N field to the !account section (rather than !Account:).  Or at least, this worked, I'm not fully certain my explanation is correct. Jeff Abrahamson On 29/09/18 16:03, Jeff Abrahamson wrote

[GNC] compiling 3.2 on linux (ubuntu)

ng this was a caching problem, I removed and recreated ./build-3.2/.  Same problem. Any pointers? -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org

[GNC] QIF import is empty

2151. Any suggestions why I'm seeing neither an error nor importing transactions? Thanks in advance. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@g

Re: [GNC] Help required for debugging gnucash to find Segmentation fault error when saving from mysql to xml

code at the commandline. Note that I don't have experience debugging gnucash but I have plenty with gdb. Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ On 19/09/18 23:19, Uli Hansen wrote: > Dear All, > > please be aware that I ru

Re: [GNC] How do I enter a transaction with an account not in the Gnucash ledger?

It's just an expense report, the same as if you have paid employees who pay something out of pocket and ask for reimbursement. Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ On 09/09/18 20:59, Mark Phillips wrote: > How do I en

[GNC] mysql backend, second user (lock, for example)

being only a single user.  I'm not overly inclined, however, as the project smells of "good enough for the author but not fully production ready".  And I don't want to maintain a django application as well.    https://github.com/nylen/gnucash-django -- Jeff Abrahamson +33 6 24 40 01 57 +4

[GNC] importing (QIF/OFX)

pedia page that describes the format. Thanks! -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.o

Re: importing splits

the spreadsheet is > just the headings you want and the data you want in columns > - doing the import on a new test gnucash file first if you have a lot of data > already in your gnucash book. Just in case. > > Good luck! > > Thanks and regards, > Matt > > >

Re: One account for both Income and Expenses possible?

guess theo 1040F is similar). Our emails crossed.  I see what you mean, but I don't think the tax authorities would find that particularly legal here.  It would also make VAT computations impossible, I think, although we are exempt from VAT. Thanks for explaining clearly

Re: One account for both Income and Expenses possible?

y [cx] -> bank [dx] Except in this second case, only my balance sheet changes, not my P Did I miss something? (This is moving away from OP, but a common theme here and one that I'd like to understand.) -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ _

Re: One account for both Income and Expenses possible?

riately filtered income/expense report should be possible. But maybe that's not what mean.  Maybe you can let us know what need you want to satisfy this way. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ gnucash-

Re: info about action field in double-line view

sense in the context of accounting, not because I actually know what was in the developers' minds when they implemented it. Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 https://www.p27.eu/jeff/ purple.com -> p27.eu On 22/01/18 03:11, Dave H wrote: Yes, if you use the Reconcile proc

Re: Year end issues

thing gets accidentally entered or changed from a past year. Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ On 15/01/18 22:23, Ronal B Morse wrote: > This is what I do, but I'm only dealing with household and personal > accounts and smallish investment portfolios. Becau

can I make account names be left justified?

in France.  So seeing the left side is more important than seeing the right side.  (It also means that turning on the feature only to show leaf accounts works really well, because the account number already clearly indicates where in the account tree I am.) -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920

closing accounts and unreconciled transactions

g] 100 €  -->  [debit: equity]  (label: stuff) -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC

Re: export general ledger

rdless of accounts used. > > But I don’t see why you can’t combine the files after the fact. That’s an > easy concatenation command. > > It is curious that you can’t export ‘all’ transactions and have to choose > only one hierarchy at a time. > > Regards, > Adrien >

Re: export general ledger

On 18/12/17 03:26, Wm via gnucash-user wrote: > On 17/12/2017 19:31, Jeff Abrahamson wrote: >> I'd like to export the general ledger to a csv file.  When I use File -> >> Export, however, I'm offered a choice of exporting income, expenses, >> assets, or liabilities. 

export general ledger

ipt account_analysis.py in the examples is instructive).  But this seems so basic I suspect I'm missing something. Many thanks for any pointers. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ gnucash-user mailing list gnucash-u

accounting categories

I enter and then processing certain reports with python).  But it would be quite nice to stay within gnucash if I can. Thanks for any pointers. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ gnucash-user mailing list

Re: Translation...

nt" > usually means to try to empty it. > > HTH > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your