John Ralls-2 wrote
> That's an interesting way of handling an RoC. The only downside for those
> of us with different tax rates depending on how long we hold an investment
> is that it resets the purchase date, and if we're not paying attention
> might make one think at tax time that the $500 RoC
John Ralls-2 wrote
> IIUC the transaction that you're creating is between IPE and AUD. That
> will cause trading account splits as they operate between any differing
> commodity pair, not just between currencies.
Right, that's what I would expect.
John Ralls-2 wrote
> The example doesn't show
Hi! Thanks for the feedback. Let me try to answer both your and John's
questions and perhaps a few details along the way.
> Let's say there is $1000 in 100 shares in IPE account.
2000-01-01 * Bought IPE
Assets:Investments:Broker:Shares:IPE100 IPE {10.00 USD} [2000-01-01]
@ 10.00 USD
I'm trying to record the recommended transaction as
2019-04-01 * Return of capital
Assets:Investments:Broker:Cash 500.00 USD
Assets:Investments:Broker:Shares:IPE100 IPE { 5.00 USD} [2000-01-01]
@ 5.00 USD
Assets:Investments:Broker:Shares:IPE -100 IPE {10.00 USD}
Hi,
I'm trying to run some reports with ledger but have hit the wall at the very
beginning. The return-of-capital transactions are reported as invalid.
I'm following the instructions for recording this type of transaction and
the $ amount goes from IPE account to Cash. Unfortunately, ledger does
Mark, please report issues with CSV importer as you run into them. Either
here or in Bugzilla.
One thing that's hindering my CSV import efforts is exactly the length of
time it takes to complete. I'm not sure what exactly is taking the time -
I'm suspecting it's the search for duplicates - but it
Thanks, Maf. That's some useful info for Mac users. I'll add this to the wiki
(section on restoring the backups).
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To
GnuCash - User mailing list wrote
> Is there any way to import a QIF and disable GnuCash transaction
> matching.
I'd second making this step optional on import (for both QIF and CSV). It
would significantly reduce the import time and allow a convenient way of
integrating GnuCash with additional
Hi, Devlin,
Considering you posted in GnuCash Users group, I gotta ask a question - do
you really want to build GnuCash or you just want to run it? Cause there is
now a binary (Flatpak) version available (even though still in testing
stages) but that might be an easier option in case GnuCash is
Hi, Harry,
What I do is simply create a transaction which subtracts shares from one
accounts and puts them into the other.
This, of course, does not track the original prices. For that you'd need to
do something similar to what scrubbing does. Note that I don't use scrubbing
as I found it makes
AC wrote
> Version 2.3.0 (2018-01-10)
> Improved #696: QIF files are now always zipped regardless of the export
> destination
Which would be fairly easy to diagnose by simply opening the troublesome
.qif file, as advised several times in this thread.
--
Sent from:
Not sure if this will help your particular issue but I have not experienced
any issues with QIF files when moving from GnuCash v2 to v3.
I am, however, using MoneyManagerEx for Android to export .qif files and
that has not changed in the meantime.
You should be able to open the generated .qif
Do you have anything in the Application Event Log?
--
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:
John Ralls-2 wrote
> I don’t know offhand. I didn’t find any bug reports about it, but
> https://bugs.gnucash.org/show_bug.cgi?id=635583
> https://bugs.gnucash.org/show_bug.cgi?id=635583; and
> https://bugs.gnucash.org/show_bug.cgi?id=784606
> https://bugs.gnucash.org/show_bug.cgi?id=784606;
John Ralls-2 wrote
> It’s because you’re trying to force the 1.4011 AUD/USD exchange rate.
> 86.82 * 1.4011 = 121.6478, which GnuCash rounds up to 121.65. Enter the
> amounts and let GnuCash calculate the exchange rate.
Hm, I was prompted by the exchange rate dialog a few times while entering
the
Actually, that didn't work so I have to leave the 0.01 at Imbalance-AUD.
This type of transaction is quite difficult to create and enter as a
scheduled transaction. I have to do it manually every time (fortunately not
that often but still).
--
Sent from:
of course, forgot to link the GC transaction:
https://imgur.com/ANoGpG0
--
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
It seems I'm unable to enter the numbers as reported on the statement.
Here is the statement: https://imgur.com/GA250qz
When I try to enter the split into Gnucash, it always gives me 121.64 in the
trading:AUD and 0.01 orphan (?!).
I changed manually the account to trading:AUD so that the balances
You may want to subscribe to this issue and add any extra information you
find useful:
https://bugs.gnucash.org/show_bug.cgi?id=788474
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
Geert Janssens-4 wrote
> I am considering taking over maintenance of the flatpak manifest. That's
> also
> how flathub envisions it should be. And it would allow us to make nightly
> flatpaks in addition to release versions.
That would be great! After I replaced Windows with Linux, I figured
Plutocrat wrote
> On a related note, it seems that as flatpak is available across all
> distributions, perhaps the way forward for gnucash, would be to make a
> single, gnucash-sanctioned flatpak version available that would run
> anywhere on any distribution, and just focus on keeping that up to
As a matter of fact, I've just extracted the price downloading modules into a
separate project: https://github.com/MisterY/finance-quote-python
so that it can be utilized by other packages independently of the Price
Database project.
--
Sent from:
floppy5.25 wrote
> Can you please let me know how to check out your python code?
Sure. Glad you're interested.
This is one of the reasons I did not continue with the original F::Q. It
would require installing Python *and* Perl for this fairly simple
functionality. And I'm running all my Python
floppy5.25 wrote
> Anyone out there in the same boat?
Well, kind of. But what's not going to help much is the fact that I wrote
price downloaders in Python for the providers I use (Morningstar, Vanguard
Australia, etc.), and store the prices in a separate database in order not
to pollute the GC
Adrien Monteleone-2 wrote
> Roger that. Curious though if this issue should be addressed in
> documentation, or bugzilla. It’s probably a bug if the format can’t make
> use of them. They likely should not be generated at all.
For those interested:
https://bugs.gnucash.org/show_bug.cgi?id=795393
Stephen M. Butler wrote
> Then I think this next section can disappear entirely:
>
> ...
> Gnucash uses the SQL back end to load the entire data store into memory in
> the same manner as the XML back end.
> ...
Steve, and others,
I find this piece of information valuable and would vote for
Adrien Monteleone-2 wrote
> There were some early issues with data but those seem to have been solved
> by 3.2. (I’m using the sqlite3 backend, and had to switch to XML during
> the interim but am back to normal with the 3.2 release) Sure there are a
> few annoyances with the 3.x series so far,
If all you want is a quick workaround, I'd look at the Guide online:
https://www.gnucash.org/docs/v3/C/gnucash-guide/index.html
This should circumvent any issues you might have with reading the help
files.
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
If you're on Windows, the adjustment is already available in the nightly
builds. Or you can wait for 3.3 as John suggested.
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
pj42uk wrote
> Your posting promped me to try this, and starting with the sample
> GTK-3.0.css, having read the wiki 3 times, I've got it working and changed
> some colours. It is actually quite easy, even for a 76-year-old.
> Thank you.
Thank you for the feedback! That's really heart-warming.
Well, Tom, it's certainly an interesting discussion in general. :)
I'd like to make two points:
- You keep referring to Windows and I'm not sure why. At the moment I'm
using GnuCash on both Windows and Linux and can't say that there is much
difference if we talk about changing visual appearance.
I also want to thank the devs for the amount of bugs squashed in the latest
release! That's really impressive.
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To
Perhaps Geert's were not clear enough. The theming in GnuCash relies (more or
less) completely on GTK framework. This framework, in version 3, has moved
completely to open standards (read CSS) for styling, allowing many more
people to customize the visual appearance of GTK applications.
Also, if
In addition to all the other replies, I'd like to add that I would not
normally expect the user to compile the software and add all the development
dependencies.
For this reason, among others, I've added a feature request for the creation
of AppImage:
Thanks, Chris. I've added this info to the GTK3 page
(https://wiki.gnucash.org/wiki/GTK3).
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription
Dennis Powless wrote
> You could use a cloud based storage service, with all computers linked,
> such as Dropbox.
> You can have GC on as many computers as you see fit, each using the same
> GC data file.
> That way you’re not depending on a usb drive that could get misplaced
> etc
> Dennis
Keith Keller wrote
> Also, if in the future I should decide to switch to a different format,
> is it a fairly straightforward process to convert?
It seems fairly straightforward to me - Save As will save the current book
in the newly selected format. Hence you can try them out and see if they fit
Chris, you might wanna have a look at the GTK3 page on the wiki. It contains
a lot of information on customization of styles (you may contribute some
styles if you identifiy them) as well as keyboard shortcuts.
Cheers
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
GnuCash - User mailing list wrote
> You have to suffix the stock abbreviation with the code for the bourse.
> For example, an Australian stock, say, ABC is to be encoded as ABC.AX as
> it is listed on the ASX
That suggestion is a bit misleading. The coding standard suggested is the
one applied by
pj42uk wrote
> So, how do I create a custom CSS file for Windows 10.
For this and similar questions you can always search the wiki:
https://wiki.gnucash.org/wiki/GTK3
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
Hi,
If you look at http://gnucash.1415818.n4.nabble.com/ you should notice at
least a dozen threads with the same or quite similar titles, expressing
issues with starting GnuCash 3.0 on Windows (10 usually).
That should give a fair indication of what can be expected. Of course, it
should be
Phillip Walsh wrote
> Ok. Will the problem be fixed in the next release?
Are you willing to try a nightly release?
https://code.gnucash.org/builds/win32/maint/
I am using the build from 2018-04-19, which resolved the issue(s) I had.
Your mileage may vary.
--
Sent from:
Hi, Norbert,
If I understand your message well, this is exactly how GnuCash works. Here's
a screenshot from my book that seems to confirm your expectation:
https://imgur.com/yMh45Qw
Hope this helps. At least it should confirm your expectations and then you
can look around for anything that
Just in case someone may find it useful, here's my Python backup script for
the GnuCash sqlite book:
https://gist.github.com/MisterY/260f45fbcd7cec00acaa5284811eb41b
For the moment, I run it manually every time I create a few transactions I
would prefer not to lose. The script will copy the
Geert Janssens-4 wrote
> The save button is permanently disabled when using an sql based book.
>
>> So, from what I understand, the whole point of .log files is to help
>> prevent
>> losing changes if there's a crash before the user clicks Save with an xml
>> book?
>>
> Yes.
Oh, OK. So the Save
John Ralls-2 wrote
> With a database, including a SQLite3 file, the storage is under the
> control of the database engine. In order for GnuCash to make a backup it
> would need to explicitly copy the SQLite3 file; even that wouldn’t
> necessarily be possible for a MySQL or Postgresql database.
stevec...@gmail.com wrote
> Where is the "launcher" for GNUCash and/or how do I build that. As of now
> I have to navigate to the
> bin subdirectory where GNUCash was installed and invoke it from there.
> Is there a launcher and how do I tell Ubuntu about it?
>From what I understand, this might
David Carlson-4 wrote
> Since it is not yet available in any repo, that is why he wants to try
> wine. It seems that he
> is not in a position to wait for packaged versions of 3.1.
Ah, yes, thanks. As on the new installation of OpenSuse Tumbleweed, GnuCash
v3 was installed by default, I thought
Hm, this thread now seems to be all over the place. Probably due to the tags
in the subject? It seems that email clients do some magic there.
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
While I was using xml backend in the past couple of weeks, I finally realized
how backup files and .log files work. I really like the scheme as, before
that, I had a script that creates backups of sqlite book in the same manner
(and deletes the .log files).
Now, back to using sqlite book, I
As Geert provided a nice summary of the configuration locations for v3, I
created a new page for this purpose and also added a few links to it at
places that refer to these locations.
The idea is to have this information at one place, separated by OS, GnuCash,
and GTK versions, as it can get
Roger Miskowicz wrote
> in Linux 16.04 this is where I have:
>
> ~/.local/share/gnucash/accelerator-map
Yes, that's it. Thank you very much!
Using search in file manager yesterday did not find it. Perhaps because it
is a hidden folder.
--
Sent from:
Hm, now I'm trying to set up an accelerator by creating accelerator-map file
in ~/.config/gnucash and it has no effect.
Also, setting it manually like this
GNC_DOC_PATH=~/.config/gnucash gnucash
does not change anything.
There is definitely nowhere in my user directory tree any mention of
Maf. King wrote
> However, I don't have that variable in my environment either. Maybe the
> default is ~/.config unless overridden? I have plenty of stuff in
> ~/.config!
Thanks for the info, Maf. Yes, it should be ~/.config (and it probably is)
but there was no gnucash folder there. I've now
Continuing from another thread, this is a separate issue.
On my OpenSuse system, I see no XDG_CONFIG_HOME variable when I do
`printenv`. Echoing the variable itself also displays nothing.
This would not be a problem on its own but I see no ~/.config/gnucash folder
in order to do some GTK styling
On Linux (OpenSuse w/ Cinnamon) in GnuCash 3.0, I've set the default currency
to EUR:
https://imgur.com/Pk9JEyi
but the list of columns in the Accounts view still displays GBP as the only
option, i.e. Balance, Balance (GBP). There is no Balance (EUR) option.
On Windows this worked well, as far
If you do decide to go down that route, it would probably be much easier to
save the file as an SQLite database (or a few other SQL options) and then
modify the data using SQL.
Note the disclaimer about making backups, being responsible for any damaga,
yada, yada.
However, if you are comfortable
As I've noticed that a few people out there use phrases of type "I am not a
developer", I'd like to share a wonderful TED talk below:
https://www.youtube.com/watch?v=TK1mBqKvIyU
Please, watch at least the first five minutes if you don't have more time.
There is a very useful message and perhaps
The bug has been reported earlier. Interested users can subscribe at
https://bugzilla.gnome.org/show_bug.cgi?id=794755
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
Hi, George,
Please have a look at https://wiki.gnucash.org/wiki/GTK3
and do write back with your results so that the page can be updated if
needed, and eventually help other users.
Cheers,
Alen
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
I just experienced this message so I'll share the scenario. Not sure if this
should be reported as a bug (it could).
Windows, GC 3.0, XML backend.
- Using Save As option
- select an existing file (book.sql.gnucash)
- leave backend on xml (accidentally)
- click Save As
The reported message pops
Hi, Paul,
While this may not directly and completely answer your question, there is
now a wiki page dedicated to this topic:
https://wiki.gnucash.org/wiki/Quicken_Migration
I am in the same boat as you and I have (so far) converted only the current
financial year to GnuCash so that I can run
I have just copied the instructions from the FAQ page into a separate page on
the GnuCash wiki, dedicated to Quicken migration:
https://wiki.gnucash.org/wiki/Quicken_Migration
This is a general hint to anyone considering or performing an actual
migration from Quicken to GnuCash, to consult the
Guys, you might be affected by this
https://bugzilla.gnome.org/show_bug.cgi?id=792105
So, just see if you have the same symptoms and, if so, follow the progress
on the issue of slow loading and contribute some new facts.
This issue currently affects sqlite (in some cases?) and that may or may
I find a bit confusing as to where to find the latest version for Windows.
The maintainance releases are apparently going out but somehow I can't
figure out what the flow is.
The main www.gnucash.org page points to
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.19-1.setup.exe
Hi, Dennis,
I don't think that scheduled transactions can even be exported from Quicken
into .qif file. Therefore, it is almost certain that they won't be found in
GnuCash after import. This only depends on what you consider the scheduled
transactions to be.
If you are using Bill and Income
Hi, David,
Whether PyCash is for an average user really depends on what you consider
the average user to be. It is a Python library and, if you don't expect an
average user to know how to write Python code then no - it is not for an
average user.
What it offers, though, is a pure Python interface
John, you do not necessarily have to use the GnuCash for Android app to
achieve what you want. You can use practically any app that will export
transactions into a .qif file. For example, I'm using Money Manager Ex for
Android (to which I also contribute in development, just like with GnuCash
for
68 matches
Mail list logo