Re: [GNC] Restricted funds and other charitable / not-for-profit specifics
On 25/11/2019 18:33, Michael or Penny Novack wrote: On 11/24/2019 6:17 AM, Wm via gnucash-user wrote: Is anyone interested in resurrecting the possibility of gnc dealing with restricted funds and other charitable / not-for-profit / whatever they are called where you live accounting better? What do you mean? Gnucash can deal with restricted funds. AFAIK, there aren't any packages that deal with some of the issues specific to non-profits (pledge tracking, unified member statements combining receivable and due but non-receivable amounts, etc.) That is NOT saying that I could not get gnucash to do some of these things (but maybe needing multiple sets of books) Why do you think gnc shouldn't? Do you think it is something charities should pay for because they're undeserving or some weirdness? -- 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On 01/12/2019 15:36, John Ralls wrote: On Nov 30, 2019, at 12:58 PM, Wm via gnucash-user wrote: On 24/11/2019 23:07, Richard Ullger wrote: On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: Which OS and perl version are you on? At the moment it is looking like gnc might need a more recent version of strawberry perl on Win but I can't quite work out why. If you (or anyone else) let me know your version stuff I'll try and work it out and take it up in the dev list or with the FQ people as appropriate. I'm running gnucash on Arch Linux, perl version 5.30.1 https://www.perl.org/ Getting a more up to date perl on Win sorted it out. I'll put this on the bug-list as it seems gnc on Win has no way of working out when it needs a new perl. Perl 5 is very stable in terms of language features and mstaruk.pm has had only a couple of string changes--no code--since it was first contributed 6 years ago. The problem was more likely that something was wrong with the perl instance: Either it got corrupted or Microsoft pushed a subtly incompatible change to one of its dependencies. Did you try reinstalling the same version of perl that you had? Nope, I generally prefer a newer working perl What is your resistance to a nice new perl if there is some oddity in a previous one? Some people don't like change. -- 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On 01/12/2019 15:36, John Ralls wrote: On Nov 30, 2019, at 12:58 PM, Wm via gnucash-user wrote: On 24/11/2019 23:07, Richard Ullger wrote: On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: Which OS and perl version are you on? At the moment it is looking like gnc might need a more recent version of strawberry perl on Win but I can't quite work out why. If you (or anyone else) let me know your version stuff I'll try and work it out and take it up in the dev list or with the FQ people as appropriate. I'm running gnucash on Arch Linux, perl version 5.30.1 https://www.perl.org/ Getting a more up to date perl on Win sorted it out. I'll put this on the bug-list as it seems gnc on Win has no way of working out when it needs a new perl. Perl 5 is very stable in terms of language features and mstaruk.pm has had only a couple of string changes--no code--since it was first contributed 6 years ago. The problem was more likely that something was wrong with the perl instance: Either it got corrupted or Microsoft pushed a subtly incompatible change to one of its dependencies. Did you try reinstalling the same version of perl that you had? are you seriously expecting me to go back to perl 5.5 and work out where it went wrong? do your own homework if you have a problem reading, JohnR In case anyone else gets to read this, the fight is unfair, someone else gets the last word. Sigh. -- 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On 24/11/2019 23:07, Richard Ullger wrote: On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: Which OS and perl version are you on? At the moment it is looking like gnc might need a more recent version of strawberry perl on Win but I can't quite work out why. If you (or anyone else) let me know your version stuff I'll try and work it out and take it up in the dev list or with the FQ people as appropriate. I'm running gnucash on Arch Linux, perl version 5.30.1 https://www.perl.org/ Getting a more up to date perl on Win sorted it out. I'll put this on the bug-list as it seems gnc on Win has no way of working out when it needs a new perl. Thanks for your help, R -- 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] Non-cash charity contributions
On 24/11/2019 18:26, Kevin Reid wrote: On Sun, Nov 24, 2019 at 10:14 AM Art Chimes wrote: I have an expense account called "charity:non-cash contributions" where I record these (potentally tax-deductible) donations, but I don't know how best to record the other side of the transaction. … Note: I do not want to be tracking the purchase cost of every item I donate, and don't want to muck about in the pond of depreciation either. But I can't imagine I'm the only person who has wondered about this. Since you are not tracking the items as assets, their value must be counted as income or expense, as part of the donation transaction. Heh, don't know if you've been contributing a lot Kevin but you are way ahead of Art in working this out. The answer is, of course, that this is a local and national tax issue rather than an accounting issue. You could record them as income, because you are bringing something into your accounting that wasn't already there. Or, you could record them as negative expenses — if you donate, say, food, record them against your expense account for food. This second option seems reasonable to me because the sum of your expense account will then more closely track the amount of food you purchased for your own use, excluding the donated food. I buy a can of tomatoes is that an expense or an increase in assets? I suggest an expense for most people unless you are buying crates of the stuff for trade, etc. I gift that same can of tomatoes to a charitable organization was it an asset in the first place? probably not If I have given the gift *in order* to alter my tax profile i think the tax lady would say you were a naughty person. If I have gifted the can of toms in the same way that I would have eaten them (I bought two cans and gave one to a poor person) then it shouldn't be recorded at all [1] [1] accounting presumes some ordinary consumption after all You should make your own choice based on what seems useful to you — which balances you want to be able to see easily. Either will work and either is an improvement on leaving things in the Orphan account. Leaving it in the Orphan is lazy thinking. -- 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.
[GNC] Restricted funds and other charitable / not-for-profit specifics
Is anyone interested in resurrecting the possibility of gnc dealing with restricted funds and other charitable / not-for-profit / whatever they are called where you live accounting better? -- 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On 23/11/2019 20:12, Richard Ullger wrote: I get (on Saturday evening)... gnc-fq-dump -v mstaruk GB00B4PQW151 Finance::Quote fields Gnucash uses: symbol: GB00B4PQW151 <=== required date: 11/22/2019 <=== recommended currency: GBP <=== required last: 215.21 <=\ nav: 215.21 <=== one of these price: 215.21 <=/ timezone: <=== optional [snip] Thanks for that, Richard. Some thunking later ... gnc-fq-dump mstaruk works on cygwin but not on Windows 8.1 for me (both on the same system so it isn't the connection that is b0rked). gnc-fq-dump alphavantage works on both. Which OS and perl version are you on? At the moment it is looking like gnc might need a more recent version of strawberry perl on Win but I can't quite work out why. If you (or anyone else) let me know your version stuff I'll try and work it out and take it up in the dev list or with the FQ people as appropriate. -- 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] Vanguard investments module for Gnucash / Finance ::Quote
On 19/11/2019 16:27, Derek Robinson via gnucash-user wrote: Vanguard investors using GnuCash may be frustrated that many Vanguard products (like their 529 portfolios, any 401(k) / 403(b) products with the word "Trust" in the title) do not have prices that are easily obtainable from one of the regular price sources. The attached module extracts prices from the Vanguard price history page and adds them to the GnuCash price database. VanguardSite.pm will retrieve the most recent daily closing price (NAV) for Vanguard investments (funds, collective investment trusts, 529 portfolios ...) using Finance::Quote and add it to the GnuCash price history. Instructions Drop VanguardSite.pm into path\to\Strawberry\perl\site\lib\Finance\Quote Make path\to\Strawberry\perl\site\lib\Finance\Quote.pm writable Add VanguardSite to the @modules array in the new sub of Quote.pm. Save. Make Quote.pm read-only. Open gnucash. Add a Vanguard security. Attributes: - Full name, Display symbol, ISIN don't matter. - Type is FUND - Fraction traded is 1/1000 for most Vanguard investments - check your statement if in doubt. - Symbol/abbreviation must be the INTERNAL VANGUARD FUND ID (like 0052), NOT the ticker (like VGHCX). - Check Get Online Quotes, select the "Unknown" radio button, and select "vanguardsite" from the dropdown. - Timezone doesn't matter. Get online prices. You should see a price entry from the last full business day with type = nav. Feel free to message me with questions. I had a look at the code and I like it. Thing is Vanguard isn't just USA these days as you should know if you follow bogleheads My suggestion is you make Vanguard USA distinct from Vanguard in future. That way the rest of the world (the actual majority) needn't be arsed with parochial code [1] [1] I'm hitting harder than I intend there, DerekR, I am aiming at people that don't realize there are people outside their immediate environ. -- 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On 25/08/2019 00:06, Richard Ullger wrote: On 23/08/2019 14:26, Wm via gnucash-user wrote: heads up, folks morningtstar.co.uk (and possibly other European versions) have changed some stuff that mean some F::Q requests have stopped working. This isn't gnc's fault. If you use a quote source such as mstaruk expect it to fail until the F::Q folks catch up. Would people with appropriate access let us know if the German / French / Italian / Scandinavian / etc versions of morningstar are similarly affected. I'm using Morningstar, GB as it appears in the quote source dropdown list for a couple of funds and am not seeing any issues. Prices have successfully loaded up to Friday 23/08/19. Works using mstaruk in gnc-fq-dump too. Hmmmn. Apols for time passing, etc What do you (or anyone else interested) get for === gnc-fq-dump -v mstaruk GB00B4PQW151 === I get === Finance::Quote fields Gnucash uses: symbol: GB00B4PQW151 (deduced) <=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock GB00B4PQW151 stock field value - - - GB00B4PQW151 errormsg: Error - failed to retrieve fund data MSTARUK_LOOK_UP http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB00B4PQW151 GB00B4PQW151 last: **missing** GB00B4PQW151nav: **missing** GB00B4PQW151 price: **missing** GB00B4PQW151success: 0 === Note: the extra detail in the "errormsg:" is because I worked out where mstaruk was breaking for me and I'm trying to work out what is wrong. The URL without the extra dot before the ISIN works, for clarity === http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB00B4PQW151 = vs = http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=GB00B4PQW151 === GB00B4PQW151 is Vanguard LifeStrategy 80% which I think more than one person here might own a bit of. -- 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.
[GNC] Finance::Quote morningstar uk (and europe?) have changed stuff
heads up, folks morningtstar.co.uk (and possibly other European versions) have changed some stuff that mean some F::Q requests have stopped working. This isn't gnc's fault. If you use a quote source such as mstaruk expect it to fail until the F::Q folks catch up. Would people with appropriate access let us know if the German / French / Italian / Scandinavian / etc versions of morningstar are similarly affected. -- 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] Bookkeeping for a club's charity account - use business features?
On 23/08/2019 09:24, Michael Hendry wrote: First, Adrien makes some very valid points which I think you should consider. As previously mentioned on the list, I’ve just become Treasurer of our local Rotary Club, which has two sets of books, one relating to the business of running the club (annual subs, insurance, secretarial support, etc) and the other to the club’s charitable activities. The club part is straightforward, and has no need for the business features. The charity accounts are different in that although the bulk of the income comes from the general public, some of it is extracted from members with particular charitable destinations in mind. Charitable organisations have some quite specific accounting requirements in the UK and most countries. Don't let the other people fool you about where the money is going to and from. For example, the price of the meals at meetings is rounded up to the nearest pound, and the remainder is earmarked for “Charity Choice”. Not all members attend every meeting, and some members skip the meal and make a token payment to Charity Choice. There are several such income headings to deal with. Sounds like crap to me. Think about this: I went to dinner with my mates, said it cost more than it did and said the difference was for charity. Would you believe me? The difficulty is that it must be possible to document each individual member’s contributions over the year in order to make a Gift Aid claim to Her Majesty’s Revenue and Customs (HMRC), which tops up the members’ contributions by 25%. OK, it sounds to me like you're being asked to cheat HMRC. Are you prepared to do that? I have set up a series of accounts of the form: Income:Destination1:member1 … Income:Destination1:memberN … Income:DestinationX:member1 … Income:DestinationX:memberN don't do it like that, think of income as a source not a person, "where are we getting our income from?", "who are we paying our expenses too?", "are we washing money?" which allows me to report on the total income for each destination easily, but makes it harder to pick out individual members’ contributions. Changing the hierarchy to Income:memberN:DestinationnX would make it easy to pick out the Gift Aid detail per member, but harder to report on the total raised for each destination. gnc is unusually flexible in that you can change the hierarchy on the fly and report on that (you should also look at the buglist if you find altering, editing or creating accounts turns out to be a problem). It occurs to me that it might be easier to treat members as customers, who would “purchase” Gift-Aid-Claimable (as well as non-claimable) items. In the case of “Foundation Dinners”, members commit in advance to pay for a meal at another member’s home - this commitment would be equivalent to an order payable on delivery of the goods. I wouldn’t anticipate issuing invoices, but a monthly list of defaulters would allow me to issue gentle reminders. This is a classic charitable issue. Our american friends have their answers but they only work in some states and not others. I think you'll find your Rotary Club might have been breaking the charitable reporting rules for a while. It might well be easier to deal with some of these reporting tasks using spreadsheets, but I’d much prefer to have a single point of entry for each transaction. The problem isn't a gnc one, start here https://www.gov.uk/government/organisations/charity-commission depending on how much money you are processing you may or may not need to report some stuff. It’s been the usual practice for Treasurers to serve for five years, so slow-but-sure is preferable to fast-and-dirty. I’d appreciate the advice of the list - especially from anyone with practical experience of my situation. This isn't about gnc, this is about understanding the rules about charities. Having a dinner with friends and declaring it a charitable contribution is a bit last century. Hitting a women is also regarded as wrong. Voting a stupid man president or a buffoon prime minister is, however, allowed in some countries. HTH 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] Gnucash bug
On 09/07/2019 03:45, John Ralls wrote: On 8 juil. 2019, at 08:55, R. Victor Klassen wrote: Perhaps this has been fixed. I’m using 2.6.21 for production. Using SQLite I am expecting every transaction to hit disk immediately. Saturday we had a power failure and lost about five days’ worth of transactions including at least 10 invoices and three new customers. I think I can reconstruct. But I wouldn’t expect this to have happened. Were those 5 days worth of transactions all entered together or over the 5 days? Do the transaction logs reflect the "lost" transactions? If so you can at least recover them by playing the transactions back https://www.sqlite.org/howtocorrupt.html might shed some insight on what happened. I think === I’m using 2.6.21 for production. === is more likely to be the problem. -- 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
On 22/02/2019 15:34, John Ralls wrote: 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. Nods, in theory. 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. That's where it gets weird. 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). Yikes! I haven't seen anyone I consider responsible doing that recently The API is complex and the documentation ranges from pretty good to nonexistent; it can be found at https://code.gnucash.org/docs/MAINT. in truth only a handful of people have a vague clue. 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. yes, the importer is improving, it is getting close to being able to read it's own tx. when it can do that well, you can introduce your own tx to the stream. -- 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
On 21/02/2019 21:03, Adrien Monteleone wrote: Otherwise, if you have a case of say, high volume day trading, you are probably limited to tracking most of the activity outside of GnuCash, generating daily net transactions and just entering/importing those. Good advice, Adrien. The gnc data model fails if you push it too hard. -- 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] How to handle bounced check
On 02/02/2019 04:24, Mike Alexander wrote: A few weeks ago I received a check in payment for an invoice I had sent to a customer. I recorded the payment and deposited the check. A couple of weeks later I got notice from my bank that the check had bounced. My question is how to record this. I want to “unpay” the invoice and charge the amount back to the customer, but I can’t find a good way to do this. I tried entering a transaction to debit Accounts Receivable and credit the bank account after which I manually added the split in A/R to the lot for that invoice. my opinion is you are overthinking this >This sort of worked, but the invoice is still marked paid in the customer report. I can, however, select it in the “Process Payment” dialog to pay it again and it shows up as unpaid in the receivables aging report. Can I do better than this? The accounting is ordinary, the customer owes you the money from the original date. The invoice, payment, bounce sequence is a record of events. I think this should show in your accounts, other people think it shouldn't, dunno why, it is a reflection of the person that didn't pay, not you. Ordinary solution? Make a new invoice and let the person know you expect it to be paid. -- 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] Stock Quotes
On 03/01/2019 19:03, nvsoar wrote:
On 01/02/19 08:51, Dave Cooper via gnucash-user wrote:
Hi gnucash
I have returned to gnu-cash having not used it for several years so
please bear with me.
I have reloaded the system and set it up to get some UK stock prices
(LSE) using Alphavantage
Unfortunately I get poor results - only 25% - 50% prices are returned
- I assume this is caused by time outs
As a temporary fix I now use yahoo - json which gets results every
time so far, but I have to manually adjust these prices because the
return is in pence not pounds
Is there a parameter or easy way to fix this?
I note that yahoo are having problems due to their historical data for
UK is in pounds - not that I am going there.
Cheers
Dave
A solution to AlphaVantage limits is in Ameet Sengar's message;
available here.
https://lists.gnucash.org/pipermail/gnucash-user/2018-September/079698.html
It has been my experience that the AlphaVantage.pm file is read only.
Change file properties to read write to modify; then back to read
only. (Notepad++ worked well for me on a Win10 system.)
Because Quote.pm is hard coded to use Alphavantage for exchange rates it
is also useful to put a delay in there if you have more than a few
currencies.
..\perl\site\lib\Finance\Quote.pm
I put it in just before the call to the outside world
===
my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
return undef unless ( defined $ALPHAVANTAGE_API_KEY );
sleep(15);
my $reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
. "_currency=" . ${from}
. "_currency=" . ${to}
. "=" . ${ALPHAVANTAGE_API_KEY} );
===
Own risk, etc.
--
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] Backup
On 01/11/2018 16:40, Ronal B Morse wrote: I don't see any reason to change the Wiki. People who already have a backup plan in place know what they need to do. So long as no-one is ever allowed to say "I followed your instructions and lost my data" I agree. I am waving and saying, "I have pointed this out, what you do is up to you, gnc". I used to be more co-operative. -- 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] Backup
On 01/11/2018 09:27, Geert Janssens wrote: Op woensdag 31 oktober 2018 17:09:27 CET schreef Wm via gnucash-user: On 31/10/2018 01:24, D via gnucash-user wrote: Check out https://wiki.gnucash.org/wiki/Backup You should not point people to incorrect and misleading links What's misleading about that link ? I have just read it and as far as I can see it's correct. Linux and Windows: HOME\.gnucash - most of your preferences, adjusted report settings, column withs, window positions, etc. -- 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] Capital losses in Advanced Portfolio Report
On 21/10/2018 11:18, José A. Fernández Troncoso wrote: Yes, when I create a sale transaction on the stock, a capital loss is calculated automatically by the report and shown as a negative amount in the Realized Gain column. That's fine by me. It presumes a tax regime, unfortunately. The problem is that when I add a split to record the loss manually on the Expenses:Capital Loss acount, the amount recorded on the stock acount split (in the Total Sell column) is then added to the Income column of the report, as if it were a dividend. The general problem is that the report presumes you are merkin and have few external tx The other way is to go for Trading Accounts, but that means thinking -- 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] Unable to retrieve quotes for these items:, CURRENCY:EUR
On 21/10/2018 10:32, rsbrux via gnucash-user wrote: Dear John, Thanks for the tip! After a bit of experimentation, it seems that the problem has to do with the number of currency exchange rates requested. If I reduce the number to five or fewer, the price update works. I guess this has to do with the limitations of AlphaVantage, which I have seen discussed elsewhere. Thanks again for your support! I'm not seeing an obvious solution to this other than allowing some time between requests which raises other issues, like, the currency trader jockey pressing "get my price now" every minute. [1] I have an odd currency pair that only works in the early hours in european time. That is sort of OK for me because I know when it works and it is when that market is open. I sort of feel sorry for anyone providing free prices these days. So many tiny people wanting so much for free. [1] I am known for saying that gnc should not be used for trading as it isn't suitable. For starters it records a price per day, think about the significance of that for an intra day trader. Duh! -- 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] Can't assign payment to multiple invoices
On 01/11/2018 10:39, Wail Yahyaoui wrote: Wm: If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. > > I wanted to clean the unpaid invoice list. # > What do you mean by "tidy it up occasionally"? If the person that is paying isn't specific (i.e. they don't say, I am paying 100 for this invoice and 50 for that) you are within your rights to allocate the payments as you see fit so long as you tell them. I'm presuming no dispute about services done, offered, etc. The normal accounting way is to allocate the payments to the oldest invoice, produce statements and keep communicating. This isn't gnc specific, the "tidy up occasionally" exercise should result in a statement of account, the number at the bottom being what you expect to be paid. If your client / customer / whoever disagrees with your allocation of payments then you have a conversation, this is generally a good thing. -- 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] Question about sub accounts
On 29/10/2018 16:49, Adrien Monteleone wrote: We’ve discussed envelope budgeting quite a bit here on the list. Do a list restricted search to find the threads. I’ve tried it myself in the past, and currently have the account tree set up to use, but honestly, it is probably better to use an outside piece of software to manage the budgeting and just use GnuCash for the actual real accounting. (GnuCash has a budget module, but it is not envelope based) There are several methods and lots of pitfalls. The least of which is nearly double the work in entering transaction splits. I think it is a envelope budget hangover. Finally, there are plenty of good standard accounting textbooks online for free. Here’s one I’ve found pretty useful as a quick reference: https://www.principlesofaccounting.com/ (I have a college textbook I kept that is probably better, but that copy is on paper and this is at my fingertips) All of your questions though were not accounting questions, but GnuCash mechanics questions. We don’t give accounting advice here, but can offer some basic generic example help and can point you in the right direction, but if the question is “how do I do ‘x’ with GnuCash” like you’ve asked, that’s what we’re here for. You are sort of right and sort of wrong, the OP wants something that gnc can do with effort but if you have brains you don't bother with. Envelope budgeting is, oddly, something Trump voters pay for. Weird. -- 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] Question about sub accounts
On 29/10/2018 14:55, Eric Gwin wrote: Hi, I'm pretty new to to application, and have basically 0 accounting background. I've setup my books and all is working pretty well, but I am running into an issue with subaccounts I hope I'm doing something wrong, but if not I'd also like to know so I can post a suggestion. Scenario: I have a checking account I am using as an accumulator for multiple other purposes (it is a "sinking" fund account I use to "save" for expected/budgeted non-monthly expenses) I have set it up like this: *assets:current assets:sinking checking* is then has sub accounts to track deposits to and deductions from various categories *assets:current assets:sinking checking:AutoMaint* *assets:current assets:sinking checking:Clothing* *assets:current assets:sinking checking:HairCare* *assets:current assets:sinking checking:HomeMaint* *assets:current assets:sinking checking:KidActivity* On a bi-monthly basis, I deposit a fixed amount to the "sinking checking" and a split transaction allocates it to the various sub-accounts. Then as payments need to be made I use that checking for the payment and track it using an entry against the sub-account. This works pretty well as it solves the major problem of maintaining each sub-accounts spending and balances. However, in order to reconcile the checking account I need to see all the transactions to each sub account listed in the register for the "sinking checking" along with the running balance for the account. I'm missing the point a bit, you have really specific accounts. I've been able to limp by so far by specifying every transaction as a split with no amount to *assets:current assets:sinking checking * and the actual transaction amount to the sub-account: *assets:current assets:sinking checking:AutoMaint* -135.45 *Expenses:Sinking:AutoMaint * 135.45 That at least creates an entry in the "singing checking" register and the "Accounts" tab does show the current balance for "sinking checking", but there is no running total, nor does the transaction amount show in that account's register. Setting "Sinking checking" as a placeholder seems to simply mean GNUCash won't allow you to view the register or enter a transaction against the account. We are aware of envelope accounting as a theory and don't really think of it as accounting, it is a budgeting method and hope you realise that. Your budget is your business, gnc can help you but it isn't going to do it for you. gnc is for grown ups not the average Trump voter. Is there a way to set up an account of this type where the account maintains the transactions (as it should for reconciliation) and each sub-account also "inherits" transactions for their type: or the sub accounts get the transaction entries as I'm doing, but the parent account register lists (but doesn't total) the sub account transactions? Yes, spend at the lowest level and report at the highest level and drill down until you see what you do (or don't) want to see. BTW, this sort of Budgeting won't work in gnc so don't even try. Micro management of personal finance is best done in another way, I'd go so far as to suggest not doing it on social media. -- 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] Backup
On 31/10/2018 01:24, D via gnucash-user wrote: Check out https://wiki.gnucash.org/wiki/Backup You should not point people to incorrect and misleading links -- 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] Backup
On 31/10/2018 00:52, Bob Hammons wrote: I have been using Gnucash since the first of the year. The data files are in a directory named gnucash and it save a lot of backups. I am using Windows 10. I open filer and control c the days files, sometimes as high as 20, and paste them to a thumb drive for backup. Is this all I need to backup or is there other files ? Can I take the thumb drive to a different computer, to my accountant, with gnucash installed and have the info he needs? no, you misunderstand what you need to back up entirely. fact is things have changed a lot recently and it is all a mess, you can't even trust the website at the moment :( -- 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] Can't assign payment to multiple invoices
On 27/10/2018 19:24, wail wrote: Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. So I need to assign a payment to two or three invoices. I just want to assign each payment to the oldest unpaid invoice(s). I was able to add a few payments to multiple invoices then it stopped working, that is, if I select two payments in the "Process payment" window and click ok, then only the last selected invoice will receive the payment. If I edit the payment again, only one invoice is selected. That may be unrelated but sometimes the right click menu on a transaction shows "edit payment" and sometimes it shows "assign as payment" instead (typically after I edit the payment once and it gets split). Also, in the "Process payment" window, when there are multiple invoices for a given date, the list of invoices does not always appear in order of invoices number. The list is ordered by Date but it would be better if it could be ordered by invoice number in a given date. If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. -- 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] How to run GNUcash in portable fashion?
On 27/10/2018 13:46, Kim Wood wrote: Here is another suggestion that works for me. I use the most recent PortableApps build, and simply delete the \PortableApps\GnuCashPortable\App\gnucash directory, and replace it with my more recent c:\Program Files (x86)\gnucash directory. Works fine for me, and has since the PortableApps version of GnuCash was first released some time ago. If I understand what you are doing, you're relying on PA to keep your book and its meta-data together rather than gnc itself. That makes sense as gnc fucked up when they went the MS way. However I think you should test your backup and restore procedures as things might not be where you (or JTH) expect them to be since gnc 3.x This should allow you to use the nightly build maint versions too if you want to stay on the bleeding edge. I understand that any significant change in GnuCash could break this hack - so I only use the latest PortableApps 3.2.0 version of GnuCash Portable. That only got fixed because I made a noise in these forums and elsewhere and is one behind. Note: This is a hack for you Windows users only. Further, I then run the PortableApps Installer generator tool to create a fresh new installer for a future installation should I need it. I also prefer a different GnuCash splash screen and PortableApp icons for my portable version. All very easily done and all works fine. This might be a better solution for you, as the PortableApps folks appear to have done a pretty good job with their portabilization. The PA people are very good at what they do and understand the weirdness of where MS want things to be much better than the gnc leaders [1], the problem is JTH needs to be kept on his toes about changes to apps and wasn't expecting the dir structory change. [1] they develop an app, I understand Win users are a nuisance -- 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] How to run GNUcash in portable fashion?
On 27/10/2018 09:34, Geert Janssens wrote: Agreed. And on several occasions I have been thinking about adjusting the gnucash code and its Windows installer to make this universally possible. It never really happened so far due to lack of time and other priorities. the .gnucash folder model was better than the current model, at least they were nearby in a folder structure. It can be near impossible to find all associated meta data on Windows now. There is a lot to be learned from the way PortableApps uses folder and registry as an impairment of Windows rather than a feature. -- 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] How to run GNUcash in portable fashion?
On 26/10/2018 21:36, Paul Kinzelman wrote: Not ideal of course, but if you install GC on all the computers you want to run on, you could just put the data on the flash drive and plug it in to whatever computer you want and have already installed GC and then start GC. Wrong! the clever people at gnc towers decided to follow the MS idiocy model and put significant stuff in user / computer specific folders :( So what you suggest won't work. Gr! -- 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] How to run GNUcash in portable fashion?
On 26/10/2018 21:27, aeneas wrote: Very nice reply! It looks like knowing about GNC_DATA_HOME goes a long way toward solving my problem. From what I can see I'm not using AQBANKING. Also, I'd speculate that my scheme may not be be completely fool-proof. I did search the registry for "gnucash" and found some KEYS. This causes me to think that there could be some interference if different instances (i.e., different thumb drives with different peoples versions) of GNUcash were run on the same computer. While I might expect some behavioral irregularity I'd also be inclined to think that this should NOT risk contamination of the files used to store the actual accounting records. Just for the record I notice that the portableapps version of GNUcash (3.2) has a directory named GTKDataHome in addition to GNCDataHome. In my case the GTKDataHome directory is still empty. However, I am wondering if I could/should make some accommodation for whatever purpose that serves? Also, there is another directory named settings which contains files that appear to be exported from the registry. To the extent that portableapps handles registry keys properly it is a better solution than my home grown hack. However, another feature my technique provides is the installation of a new version without making any change to an existing version that is working just fine. There are many circumstances under which preserving the ability to revert to, or for that matter switch back and forth between, a prior version is quite helpful and this can extend across several versions. Anyway many thanks for the help. It looks like my flash drive installation is now somewhat portable and I also appreciate learning about some other aspects of GNUcash which may be helpful in the future. You are likely to make a mistake rolling your own gnc portable. The portableapps.com model is good but not always up to date, e.g. the problem with Portableapps was that they didn't notice when gnc moved stuff around [1] If you really do need your gnc to be portable stick with PortableApps model and get them to follow changes, losing bits of closely integrated accounting data is generally not fun. [1] a bad move in portable and non-portable terms, think disjointed backups. -- 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] Feature request: Stock currency setting
On 27/10/2018 13:30, rsbrux via gnucash-user wrote: You can just move the account, but the transaction currency is immutable so you will have to delete and re-create the transaction. As for adding a trading currency to the security editor, it’s possible but the code for creating transaction currency is kind of splattered around (register, transfer dialog, scheduled transactions, importers, maybe more) so getting it right would be a bit of work. << Thanks for the response. To get the desired results, I found it necessary to delete the account I had created for transactions in that security and then > recreate each of the transactions using the "orphaned" transactions as a model. Don't use the orphans for long, *always* move the tx to an appropriate account unless you are the sort of person that throws all their financial documents in a drawer and sorts them out only when they have to. > If currency is a property of a transaction, would it be easier to provide a way to change a transaction's currency than that of a security? Not really. A transaction is between two accounts, gnc's model uses a commodity per account, nothing wrong or right about that, you just have to build your CoA appropriately. That would have at least made it possible for me to reuse the previously entered transactions, by changing their currency and assigning them to the new account. It isn't even clear to me that currency *is* a security property. In the price editor I found prices for the security in question in both CHF and USD. Transactions are cheap, accounts more expensive :) gnc rewards building a good CoA, it is all to do with double entry and good practice, if you come from a single entry finance world it can be more formal than you expect. Anyway, in the real world stock ABCD bought in two currencies is almost certainly actually two holdings of that stock not one *unless* there was a currency exchange before the purchase, in which case why not reflect that in your accounts? A parallel is people owning stock ABCD in a retirement account and an investment account, same stock, two separate holdings, gnc recognizes the separation even though you may not acknowledge it. In general, use a CASH or BANK type account of CURRENCY CCC to buy a commodity priced in that currency, I do something like this. ASSET mixed stuff below GBP <-- or whatever your book currency is \ USD account \ shares, etc in USD \ EUR account \ shares, etc in EUR It isn't really limiting, all you have to do is put a "plain" account on top of the more complex underlying asset, that way most transactions and reports will work as expected. And if you think about it, gnc is reflecting reality, when you buy a RUB asset using CHF there are two exchanges, CHF => RUB => commodity. -- 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: Integrating Profit and Loss Report into a set of books and the trial balance
On 07/03/2018 23:14, Stan Brown wrote: On Wed, Mar 7, 2018, at 10:56 AM, John Wilson wrote: Stan, Thank you for your prompt help. Attached is my first P statement which shows an income of $1,458.23 but when I run a trial balance it does not appear in Earnings, which Equity:Earnings account that I set up. Correct. The Trial Balance shows every account, so they will always be balanced and therefore everything on there is a real account. I was talking about the Balance Sheet. the Balance Sheet shows all asset, liability, and equity accounts, but it does not show revenue and expense accounts. Instead, it shows the aggregate of all revenues minus all expenses (which of course is net income) as an equity item, and calls it Retained Earnings. This is not an account (even if you have an account by that name), just a line item on the Balance Sheet that aggregates all accounts in the income and expense categories. Have you looked at the eguile BS ? :) It sounds to me like you are saying stuff without knowing much about gnc, Stan Brown. [snip] I would welcome your opinion You just picked a report different from the one I was talking about. It's not hard to do -- there are many reports and many have similar names. said the man that didn't spot what the eguile balance sheet shows. -- 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: Account Report/Register Report
On 06/03/2018 01:25, Robin Chattopadhyay wrote: Hi- Using Linux Mint 18.3, Gnucash 2.6.19... There's a report I like to use called Account Report. You can get to it after opening a register. I use this report to see what gnc has as the cost basis for an investment. I'm not sure that was how it was meant to be used so it may be that it is occasional that it is producing the number you expect or want :) Because of the way my 401(k) provider calculates cost basis, I have found that the only way to properly track realized gains/losses in gnc is to manually make the entries myself. So I use this report and set the options to Amount = SINGLE and tick the 'Value' option. The net Value Change neatly reflects my cost basis (assuming there are no filters and all transactions in the account are visible). That sounds good. My question is: Can I go somewhere and change the defaults for this report so that I don't have to select them every time? For any other report, I would save the report to ~/.gnucash/saved-reports-2.4 and just select the account I wanted to report on. I can save a register report on windows, I haven't tried on another OS to see if it is different there. But this report doesn't have an option to select the account so my next thought was to change the defaults. Are you, perhaps, trying to make a report do something it wasn't intended to do ? If so why ? Is there anything unusual that you think might be preventing you from saving it for reuse other than not understanding what is being reported? -- 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: Integrating Profit and Loss Report into a set of books and the trial balance
On 06/03/2018 15:13, jcnw wrote: I am setting up a set of books for a small church and need to run a month profit and loss report. How do I enter the Net Income for the Period into the books so it shows up in the balance sheet? I have set up the books with Income, Expense, Asset and Liability accounts. Do I need to set up a P account. Thanks for help and consideration John You've had two answers presenting different philosophies. I suggest not closing the book ever. If you want to do it as a test, copy the file and see what happens, it just creates an entry that you can delete later so isn't really significant unless you want to be old school. Now for my attempt at an answer. Presuming your church (and this probably applies to most charitable organisations regardless of religion and hopefully not abusing people in the third world or obeying the idiot Trump) isn't about maximising profits you want three basic reports. Reports / Inc & Exp / Equity Statement it tells you where you are and where you were before. Play with the dates so they match what your god(s) expect :) Reports / Assets & Liabilities / Balance Sheet [1] you want at least two of these, one at the start of the period and one at the end. Sometimes it is good to offer a third BS dated "today" if things have changed significantly since the end of the period you were asked to report on. [1] which balance sheet you use is dependant on your audience, the easier to understand one is just called Balance Sheet, the more interesting one is the eguile one but it has been known to confuse folk as it is a non-traditional BS. Reports / Income & Expense / Income Statement To tidy things up you want an Income Statement (or a P, same thing in gnc but IS probably makes more sense for a church) use the same dates as for the Equity Statement and the start and end balance sheets, this is so people can see why and what changed. In plain terms people usually want to know: where were we then where are we now what happened in between and does it all add up and match what was expected If you are able to report honestly on those things you'll do your community a good service. Best wishes. -- 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: Reporting based on search criteria and exprting transactions to excel. It's simple!
On 03/03/2018 03:27, Mike Stillingfleet wrote: I have used GNUCash for a couple of years now. in recent days I have come across a couple of features or tricks which have completely transformed the value of GNUCash to me. Yet neither of these features are in the help pages. Or if the are in the help pages I have consistently missed them in my efforts to find ways of reporting sensibly from GNUCASH. The first is that I have gone through all sorts of hoops to report on transactions based on a particular search criteria. I now find that this is simply achieved by doing a find from the edit menu. With the resultant search result tab open you can select the reports menu, account report and GNUCASH will create a report from those search results. The second is that you can get your report into a spreadsheet very simply. Export the report as an html file. Open excel. Open the html file. I usually just use copy and paste Simpler, quicker, easier for most report type data That's it. No converting pdf files to excel. No crazy export of transactions and importing CSV files etc etc. I have to ask why is the combination of procedures not clearly spelt out in the help files. It has taken two years to discover this. I have posted several threads trying to achieve this. I think it has been possible all the time. Now the information I have in GNUCash is suddenly an invaluable resource. I am no longer entering data in two or more places. I am no longer exporting transactions and manipulating them outside GNUCash. A minor note to point out is that the values imported to excel initially appear as links through to the original transaction. Copying the column and pasting as values takes seconds and then off you go. I think you could probably also set up a macro to do this step for you. if you copy and paste as I suggest you avoid the problem. I am astonished that this is so simply achieved. There are hundreds of threads on this forum with people obviously trying to achieve this. So obviously users are not getting appropriate instructions from the help files. It it would be great and save everyone thousands of hours if it were to be included in the help clearly and obviously. The background problem is people expecting everything to be in exactly the format they want in one program. There are ongoing arguments about this, try checking if gnc's budgets are are ideal for you (they won't be) -- 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: Transaction report ?? currency symbol
On 05/03/2018 15:23, Adrien Monteleone wrote: I see then my first guess was wrong. I’ve never played with Docker so I wasn’t aware you had to specify locales when creating the image. Glad to see you got it worked out and thanks for posting the solution for posterity! Getting the locale right is a general solution rather than a gnc specific one, A -- 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: Printing no longer works on Windows 10 Pro
On 22/02/2018 07:53, David Carlson wrote: I seem to recall that GnuCash uses a different printing system dialog than most other windows programs. Perhaps a developer knows where to look for this problem. I'd prefer a developer to spend 0 time on a problem that can be solved by copy and paste into a spreadsheet. -- Wm Never trust a man that thinks teachers having a shoot out with someone that wants to kill their pupils is a good idea or one that doesn't understand metal exchanges. ___ 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: General Ledger
On 03/03/2018 13:47, Stan Brown wrote: On 2018-03-02 13:47, Wm via gnucash-user wrote: On 23/02/2018 12:52, Adrien Monteleone wrote: And unfortunately, this filter change is not sticky. You’ll have to reset it each time you load the GL. This is already a filed bug. AdrienM, it is not a bug if you have many years of tx, promise. I like the narrow time window. There is a checkbox, "Save filter", in the filter-defining window. What is that meant to do? I think what it is *meant* to do is fairly obvious and I may be wrong but I don't think that is stored or saved. -- 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: How to get summary journal entries
On 28/02/2018 23:24, Stefan Riha wrote: I'm a beginner and I'd like to examine how sales and expenses change assets and liabilities (a.k.a ."summary journal entry", see e.g. Accounting workbook for dummies by J. Tracey, link to google books below). cash sale or sale on account ? expense on account or cash purchase ? I found that the cash flow report almost gets me there, but not quite. If I choose the income accounts I'm interested in, it lists the affected assets, but it doesn't show how much each income account is contributing individually (if I understand correctly, the sum of selected income accounts should then equal the difference between "Money In" and "Money Out".) Not really. Is there a way to get summary journals in gnucash? Probably, but no one really does that these days. If not, would it be easy to implement this in the existing cash flow reports? I wouldn't bother. Thanks for your help! I sometimes disagree with AdrienM but he has actually given you a superb response. Read it. The main problem is, I think, that you are trying to translate manual bookkeeping into computerised accounting and not understanding that if they translated directly one or the other would be redundant :) In computerised double entry computing you just make sure the transaction is balanced, it is best if you get it right first time but you can always fix it later. *then* you report income and expenditure, your balance sheet and whatever else may be required by management. -- 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: General Ledger
On 26/02/2018 18:16, Greg Feneis wrote: I keep seeing this email subject line and imagine you guys are discussing a lesser known war hero Thank you, Mr Feneis, I'm not sure what this thread is really about either but commend your humour. It doesn't really matter what the damn thing is called so long as you know what is in it and what it is for. Remember: a good proportion of people will be seeing whatever it gets called in translation anyway so stop picking at the scab! -- 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: General Ledger
On 02/03/2018 16:22, Leo Bolta wrote: Not to keep the thread alive but these are photos of select pages of the 1882 High School bookkeeping text book, I referred to earlier and promised to distribute. Several of the previous commenter's may have been quite accurate in regards to the historical progression but these pages are just for those who might be interested on how it was expressed before the turn of the last century. Thank you for sharing that. Have you got the books under Assets:Chattels:Books in your gnc ? :) > Also take note of the penmanship from the personal notes of the student included in the last attachment...today's penmanship is a shame by comparison. My father can write like that, I'd have been a failure if it wasn't for computers by comparison. My apologies for portions of text which are slightly blurred. Don't apologise, I found it interesting, the slightly blurred bits didn't spoil the view for me. -- 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: General Ledger
On 23/02/2018 21:52, Buddha Buck wrote: I suspect that GnuCash terminology regarding journals and ledgers is somewhat confused and non-standard. yeah, they are convenience terms My basic understanding of classical accounting is that transactions were first entered into journals, and then posted into ledgers, one per account. The collection of ledger books was the "general ledger", while the nominal time-ordered collection of journal entries was the "general journal" (or the "general journal" was the journal in which transactions which didn't belong in the sales journal, purchase journal, etc were recorded). that has varied between countries historically in some it was "everything goes in the big book and you pull out the sales" and in others it was "you enter everything in the sales book and then transfer it to the big book" gnc and other transaction streams supersede those views. In GnuCash terms, a classical account ledger would correspond to a GnuCash account register. And the classic general journal would correspond to GnuCash's general ledger. The classic general ledger might even be a GnuCash book as a whole. Depending on where you learned your accounting :) I don't know what GnuCash is calling a general journal. C'mon GnuCash is a transaction stream application with a few tweaks. It isn't calling anything. -- 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: General Ledger
On 23/02/2018 12:52, Adrien Monteleone wrote: And unfortunately, this filter change is not sticky. You’ll have to reset it each time you load the GL. This is already a filed bug. AdrienM, it is not a bug if you have many years of tx, promise. I like the narrow time window. -- 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: Big thanks, Windows version, multi-currency symbol bug ?
On 01/03/2018 18:02, Y B wrote: Having problems posting: someone included paypc.com on the spam assassin list. we are innocent ! Hello ! Following the suggestion of Fred Perrin to set Tools>Security Editor>Show National Currencies, I'm posting here. Thanks also to Mike Alexander for his pioneering work !!! The issue is the flag to display currencies. The Linux version appears to work and explicitly show $HKG, $CAN, $US and the other 10 or so "dollar" currencies. Hooray ! I tried the same in Windows 2.6.19 git rev c1b5e6c+ on 2017-12-17 and explicit currency display does not seem to work. Needless to say in a globalised economy this is not small matter. I would also suggest that a flag be allowed to explicitly set date format rather than inherit from the OS. I find the American date format utterly confusing and highly conducive to creating errors. Thanks to everyone for GUCash. You cannot image how relieved I am to be able to get away from the ad-bloated, captive Quicken and their refusal to allow import of QIF except via their $10 a month behind closed doors deal with the major banks who mostly seem to only give about 60 days of transactions if you are lucky. I'd buy you all a beer and send it down the wire if I could. I think I have already replied to this on the user list. If you really want to see the symbols in your own odd way you change them in Tools / Security editor You don't get a different answer on the devel list if the answer on the user list was correct. -- 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: Liabilities / Accounts
On 27/02/2018 17:53, Adrien Monteleone wrote: James, Everyone has their own methods, but the Tutorial & Concepts Guide has a suggestion that I’ve followed and it’s served me well. I always enter transactions working in the account register the money is coming FROM. I never use the General Journal/Ledger. In the case of a liability/expense situation, consider entering it in the particular liability register (Rent Due in your case) since it’s the liability that is ‘paying’ the expense until you actually fork over the cash. (and then enter that final payment transaction from the cash/checking register) This way you will always keep the splits straight. Money always moves from one account to another, and if you're already in the FROM account, the TO account is much simpler to figure out. Also, since this is likely to be a recurring transaction and the amount is likely to remain stable, consider learning how to use the Scheduled Transaction feature. You can have these weekly transactions automatically created for you. (with the ability to review and adjust them first) Then you’d only need to manually enter the actual payment each month when you make it. I agree about the rent but also think the payments should be made regular too. It just makes life easier. If I look at all the future stuff in the general ledger once a week or once a month I have a close to real future transaction flow. I commend accounting in advance when it is obvious. -- Wm It would make sense if Trump *planned* to lose people as he loses them so often. But does that makes him an asset stripper or just careless as he is losing his son-in-law too ? ___ 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: Reports balance sheet - with explicit dual currency for "$"
On 24/02/2018 18:05, Vin Ordinaire wrote: Dollars are great - pick one of many flavours USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others. The problem is reporting a balance sheet multiple currency assets. I located in the Windows version Options>Commodities>Show Foreign Currencies that does indeed show the "other" value in whatever currency I post the asset in. However, when pairing USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others, the "$" is highly ambiguous and confusing. I pair AUD, USD and HKG and have assets in all three currencies. Is there a way (or in the future) for Reports to have a check box "Explicitly show iso-4217 currency designation" to show side by side in the reports like this under assets: Widgit $HKG 8000 $USD 12000 Bluto $AUD 1000 $USD 770 Overall a great alternative to Quicken and its bloatware and its behind the scenes business deals with banks to restrict access to data for users (and why most US banks do not widely use OFX and have plenty of data as opposed to say 90 days) - I suppose license fees, subscription and captivity play a huge role in this. Ideas and apologies in advance if this is a newbie RTFM type question, though I see Frédéric Perrin and Derek Atkins and others having a dialogue. If I understand your query correctly you can edit the symbols via Tools / Security editor (make sure you have "Show national currencies" ticked / Currencies you can change them to anything you want. I think most people use the 3 letter symbols rather relying on the $ -- Wm time passes while mods ponder ___ 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: A predictive bar graph needed
On 12/02/2018 19:11, Cliff McDiarmid wrote: Thanks Adrien I thought as much. That's a shame everything else is what I need. I don't know what a predictive bar graph is so, unsurprisingly, I'm not missing one. Hint: using terms you are familiar with and other people aren't usually leads to misunderstanding. cf Would you like to vote for Donald Trump and Would you like to leave the EU -- 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: Trading Accounts
On 12/02/2018 17:12, Les wrote: I use, in addition to USD. AUD, HKD, CAD, CNY and SGD. I buy in tranches for average cost. So, not sure that means I have complicated trades but I make sure I never have any orphan accounts. I checked my test file for capital and it did not list any. Although, at the bottom of my accounts list, there is a list of currencies and exchanges with totals for each. But, again, there isn't any difference in income and expenses. Trading Accounts may well help you given the mix of currencies. -- 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: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share
On 08/02/2018 14:28, David Carlson wrote: If you want to create a fictional stock and manually enter prices from time to time that is easy. Just use the security editor and invent a name and symbol, possibly under the group called Fund. Do not set an online quote source. Then manually use the price editor to enter prices for whatever dates you like. I think you'll find it is the value that alters not the supposed price which is probably a nominal 1 for the OP. gnc deals well with the price changes but not so well with value changes. -- 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: p2x modelling in gnc, help me think, please
On 07/02/2018 18:17, Adrien Monteleone wrote: Go to Preferences > General > Numbers. You can increase your decimal precision. Did that solve the small fraction issue? That isn't a good way to go if your base currency is a 2 decimal one. Creating a commodity with the appropriate number of decimals and using that is better. By chance there is another more recent but simpler thread === Subject: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share === it is the same basic problem. "put the other leg in equity" doesn't work for me and the variance is actually the value not the price which is what makes them different to traded investments which gnc deals with well as you can just put the the date and price in for market traded things. As for modeling the investment, I’m not familiar with p2x. I’ll let someone else chime in who is. On that note, I tried looking it up but didn’t come up with anything useful explaining it. Do you have a few info links I could pour over? Once I understand what it is, I might be able to help modeling it in Gnucash. The only related thing I found was Peer-to-Peer lending but that didn’t involve negative interest rates as far as I could tell. peer to peer is now p2x in common terms because the second peer is no longer an individual in most cases and almost all lending goes through an intermediary. very few actual p2p transactions happen. the lending can now involve: personal loans (how it started), mortgages, agriculture loans, 3rd world specific investments, invoice factoring, business loans, pawnbroking, etc and possibly some other stuff you and I probably don't want to know about or get involved in :) I stick to reliable exchanges. Perhaps I should have left out the word "interest" if it is confusing. A non zero return occurs if you buy an interest bearing instrument at anything other than par. You are buying someone else's interest (a premium) or getting some of their interest because they don't want the risk of the principle (a discount). There are loads of other reasons for buying and selling, of course. The point is interest and other returns are *traded* and I'm not finding it obvious how to do this in gnc as part of a composite tx. gnc likes simple investment returns one leg asset receiving one leg income to balance third leg asset to join them up or similar. Maybe I should change the way I work so that I produce 3 tx per month asset change income and the one gnc wants I'm certain my tx is right in accounting terms but somehow it isn't being "seen" by gnc for what it is. Anyway, it has been useful to me to explain so no harm done. Who knows I may wake up with the answer tomorrow, I am certainly closer in my own mind. -- 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.
p2x modelling in gnc, help me think, please
Background: I am a p2x investor, I like it, it is fun and may do some good to far away people and get me a better return on my money than more conventional investments ... or I could lose it all. Ho hum. the gnc point is how best to model a p2x investment. my p2x investments involve hundreds of fractional (or more than 2 decimal) transactions a month, gnc doesn't like dealing with 0.0001 EUR because gnc takes the view than an EUR is meant to be used in chunks of 9.99 and it is sort of right because there isn't a smaller unit of an EUR than a cent in coins and paper. Detail: I run the actual p2x transactions through ledger-cli and get that to produce a journal per month (or whenever I'm interested) that I then enter into gnc, this works well in accounting terms but fails because gnc doesn't see the p2x asset as an investment for reporting purposes. I thought the solution would be to make the asset account where the actual bonds live a Mutual Fund with a security of its own equivalent to 1GBP or 1EUR etc as appropriate but that didn't work because the interest doesn't get recognised (possibly because I'm presenting the income as part of a tx with 8 splits to reflect the real world). My understanding (which I now think might be broken) of how gnc works out what is an investment or not then fell apart. In summary: my modelling of p2x in gnc isn't working out as I expected. how are other people dealing with similar modern or unconventional investments ? is the concept of negative interest income really that unusual (it happens all the time in real markets so why don't gnc reports know about it ?) maybe I'm behaving stupidly and I just need a clue <-- let's hope it is this :) -- 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: export general ledger
On 18/12/2017 18:13, Adrien Monteleone wrote: Jeff, If I recall correctly from other discussion, the General Ledger is not it’s own entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This is probably why there is no export option for it. You recall incorrectly. The general ledger is (as the name suggests) actually about as pure a view as the UI gives of the entirety of a gnc set of accounts as is available. gnc does not actually have separate account ledgers at all, it belongs to the stream of transactions accounting family. GnuCash takes the opposite approach from paper books. that may be correct or incorrect, depending on where you learned accounting. With paper, you enter everything in a General Journal and then later post the proper amounts to T-accounts. Not in UK accounting you don't. In UK accounting you do it the other way :) With GnuCash, you skip the Journal and enter directly to the accounts. The General Ledger was provided for the benefit of those who were used to the paper method and wanted the option to see all transactions in chronological order regardless of accounts used. Bollocks. But I don’t see why you can’t combine the files after the fact. That’s an easy concatenation command. Oh, for fuck's sake. There are no separate files, it is a stream of transactions. It is curious that you can’t export ‘all’ transactions and have to choose only one hierarchy at a time. Yes, that is a bit weird, but it is probably like that because someone had the same misunderstanding as you about separate account ledgers 15 or more years ago. -- Wm ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: export general ledger
On 18/12/2017 13:16, Sébastien de Menten wrote: To export a gnucash book to a ledger-cli output, you may be interested by the piecash python module and the related script https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py I already said that, you just have to wait longer for my messages while someone checks if I have said something that one person in a faraway land of innocence might consider rude :) -- Wm ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: export general ledger
On 18/12/2017 10:32, Jeff Abrahamson wrote: 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. But I'd like to have all transactions in the csv file. I think I see how to do this using python (the example script account_analysis.py in the examples is instructive). But this seems so basic I suspect I'm missing something. Many thanks for any pointers. May be easier to do a transaction report or similar and copy and paste that into a spreadsheet. Alternatively there are a number of scripts that can take gnc files of some flavour and produce ledger-cli / beancount compatible files which are generally mores useful than csv files for accounting data anyway. Ah, ledger-cli and beancount are neat, thanks for the pointer. This sort of export is something I want to be able to do frequently. I'll have a look around for scripts to automate it. The database formats of both gnc and the text accounting tools are pretty stable so once you get an export that works you won't have to fiddle with it much. Only major decision is that you might have to switch to an sqlite backend if you are using xml at the moment (but the long term plan is for sqlite to be the default store anyway). I've probably used most of the conversion scripts over time, let me know the gist of what you're trying to achieve and I'll dig through the ones I've used. If you can read python it'll be plain sailing and the best place to start is probably Sebastien's work https://piecash.readthedocs.io/en/latest/ he has a ledger-cli conversion and ledger-cli to csv (or gnc to csv if that is what you really want) is simple. The point about using text accounting as an intermediary is that damn near everyone has had a kick at it so there is little you can't make it do or get out of (or into) it. As an e.g. of frequent use (but probably in the opposite direction) I used ledger-cli to black box per month everything that happens for one of my p2p accounts that produces hundreds of transactions of less than a few pennies and with more than 2 decimal significance and just isn't worth replicating in gnc; ledger-cli produces a summary journal per month and I put *that* into gnc -- Wm ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: export general ledger
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. But I'd like to have all transactions in the csv file. I think I see how to do this using python (the example script account_analysis.py in the examples is instructive). But this seems so basic I suspect I'm missing something. Many thanks for any pointers. May be easier to do a transaction report or similar and copy and paste that into a spreadsheet. Alternatively there are a number of scripts that can take gnc files of some flavour and produce ledger-cli / beancount compatible files which are generally mores useful than csv files for accounting data anyway. -- Wm ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: GnuCash: Docs: Where to document?
On 13/12/2017 00:57, brad wrote: I would like to see something on this in the wiki. Just because Mac & windows don't have python and sql by default doesn't mean that the knowledge base should be dumbed down. It is not a case of dumbing down. Building gnucash with python on windows is genuinely difficult. It involves exact versions of a whole load of supporting bits and pieces and as soon as any of those change you have to start again. -- Wm ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: Finance-Quote Price Issue
On 20/11/2017 00:37, Richard Ullger wrote: There is an issue with prices for UK funds and investment trusts downloaded on a Saturday and Sunday which are appearing 100 times too small. When these prices are retrieved Monday to Friday they are correct. Prices for stocks and bonds are not affected. The issue is affecting the two quote sources I am using, alphavantage and mstaruk. Is there any news on this? I am getting it too except in my case it is LSE traded ETFs at all times. Unless someone has an update I'll try explaining it my way, possibly in a new thread with more detail. Meanwhile, when I first saw this I thought it was a GBX issue (i.e. the decimal was being shifted the wrong way in an attempt to make it GBP) but that didn't explain some of the other phenomena. My instinct suggests the problem is outside of the gnc universe but I haven't been able to work out who is doing what yet. In practical terms this isn't a big deal for me, I update prices once a week at most and have 3 stocks that are affected and I just edit the prices by hand by shifting the decimal point to the correct place. For someone else this could be a genuine PITA. -- Wm ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: For UK users: Will gnucash get ready for Making Tax, Digital ?
On 23/08/2017 18:11, mike.m...@gmx.net wrote: A little more reading. [1]https://www.cchdaily.co.uk/lords-probe-software-companies-lack-readiness-m aking-tax-digital Please note that this link is mostly outdated, espcially the deadlines mentioned are not any more applicable. The general gist of the linked article is worth reading though. HMRC's official statements, last updated 13 July 2017, are here. https://www.gov.uk/government/publications/making-tax-digital/overview- of-making-tax-digital References 1. https://www.cchdaily.co.uk/lords-probe-software-companies-lack-readiness-making-tax-digital I think this is a non-issue for gnc and most people that need to account for themselves and other people to HMRC.# Why make gnc do something when the government haven't even said what they want in a spreadsheet. Fellow travellers, this is not a big issue for the vast majority of UK users of gnc (the grand body doesn't exist) -- Wm ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
