[GNC] Scheduled payment question

2020-04-09 Thread Adrian
Hi, I have several payments coming into my account on a regular basis. One of these comes in every 28 days and two others come in on the last banking day of the i.e. week day provided this is not a Public Holiday. At the moment I have set this to appear in GNU Cash on a monthly basis and

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-09 Thread David Carlson
Some users like me did a lot of mis-managed reconciling while importing old data into currently used accounts and just reconciling years of transactions as of the current month instead of trying to obsessively go back years and assign the transactions to years-old statements, especially when

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-09 Thread David Cousens
David T. Yes I did correct and eliminate the problem by editing the data file directly and I also agree this is not really viable for the average user. I only had one incorrectly entered date in one account and for users who have many years of data the situation could be considerably more

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-09 Thread David Cousens
- David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] QIF Importer does not work

2020-04-09 Thread fciani
Hi, I'm using https://code.gnucash.org/builds/win32/maint/gnucash-3.9-2020-04-03-git-3.9-5 -gbedc9631f+.setup.exe? MinGW64 upgraded gtk from 3.24.14 to 3.24.16 two days after the 3.9 release on Win 10. This fixed the dual monitor issue I had with 3.9, but now the QIF importer does not

Re: [GNC] Vendor Refund - Best Practice

2020-04-09 Thread Adrien Monteleone
I can’t speak to legal or tax requirements, but logistically, you can issue a Credit Note ‘from’ the vendor for the difference, then process one final ‘payment’ on the bill but instead of entering a payment amount, simply select the bill and the credit note. (which should be the same absolute

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

2020-04-09 Thread John Ralls
Yes, you can use Homebrew, but they just wrap the Gnucash.app that I build and distribute via https://www.gnucash.org so I don't see why you'd want to. Regards, John Ralls > On Apr 9, 2020, at 12:14 PM, jess wrote: > >> Is there an "Update" software function in the program somewhere, as I >

[GNC] Vendor Refund - Best Practice

2020-04-09 Thread M
I'm not very familiar with the Business functions of GnuCash and have been experimenting with them.  I'm looking for a "best practice" and how to accomplish this in GNC: I am treasurer for a non-profit PTA.  We issued a grant to the school.  Over time the school would use the grant and I

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

2020-04-09 Thread jess
> Is there an "Update" software function in the program somewhere, as I have not been able to see any obvious place to do this? macOS has homebrew which can be used to update. > I see there is GnuCash 3.9 version offered on the website, but will I > lose all existing data in my existing

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

2020-04-09 Thread Stephen M. Butler
While the non-profit I'm involved with does multi-currency transactions, ours is uni-directional and we don't treat it like an investment (stock).  So I don't have experience handling this. My suspicion is that you will need to utilize trading accounts and treat your US bank as an investment

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

2020-04-09 Thread Long
Hello, Picture here : replycomment-2.png Regards. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

2020-04-09 Thread Stephen M. Butler
Does your Profit/Loss report show zero profit/loss? On 4/9/20 10:13 AM, Long wrote: > Hello Stephen M. Butler, > > Here is my Picture : replycomment.png > > > Regards. > > > > -- > Sent from:

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

2020-04-09 Thread Long
Hello Stephen M. Butler, Here is my Picture : replycomment.png Regards. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

2020-04-09 Thread Stephen M. Butler
On 4/8/20 9:43 PM, Long wrote: > Hello Stephen M. Butler, > > You said that i'm doing the right way with my example ( i'm thinking like > that too ), when i transferred all my USD to VND Bank. Which mean, in > GnuCash, i don't have any USD, and all of it are now VND (in real life is > the same).

Re: [GNC] Help!

2020-04-09 Thread John Ralls
> On Apr 9, 2020, at 5:24 AM, Adrien Monteleone > wrote: > > If I’m not mistaken, 2.6.21 is 64bit. Nope. It's 32-bit. Not a problem of Evelyn, who's only going to 10.13. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: [GNC] How to change "Unrealized Gain/Loss" to "Readlized Gain/Loss" in Balance Sheet ?

2020-04-09 Thread Christopher Lam
I suggest you read https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html -- this is not hard accounting but simply rigorous mathematics. The author studied this using GnuCash so you'll be in good shape to understand the challenges of unrealized gains. On Thu, 9 Apr 2020 at 13:41, Long

[GNC] How to change "Unrealized Gain/Loss" to "Readlized Gain/Loss" in Balance Sheet ?

2020-04-09 Thread Long
Hello, I want to create new topic to write more clearly what i asked. Sorry if this annoying you. For this topic, i will attach some pictures for more information. (This topic created in Nabble website) First, i will have 2 Bank, VND Bank and USD Bank. and USD Rate is : 1USD = 2VND. Assets :

Re: [GNC] Help!

2020-04-09 Thread Fred Bone
On 09 April 2020 at 14:15, Evelyn Bleasdale said: > I am still using Yosemite on my macbookpro, and am very happy with GNU > cash 2.6.9 for our family accounts. Now I must upgrade to High Sierra, and > am worried about how that will affect my GNU cash. Will I need to upgrade > it as well? Any

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-09 Thread Adrien Monteleone
Sorry, I misunderstood your post. I agree, even if it was human error, the change breaks backward compatibility in a minor release. It should have at least waited till 4.0. Regards, Adrien > On Apr 9, 2020 w15d100, at 7:28 AM, D wrote: > > Adrien, > > I disagree. In earlier versions, a

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-09 Thread D via gnucash-user
Adrien, I disagree. In earlier versions, a transaction was only considered reconciled or not; its date of reconciliation was not considered. That a spurious date was entered for the reconciliation didn't affect the functionality of the software. Now, it does. That is a change in

Re: [GNC] Help!

2020-04-09 Thread Adrien Monteleone
I don’t think you have to but there have been lots of bug fixes since 2.6.9. That is several years old. If you want to run the latest, upgrade to 2.6.21 first, save a backup of your data file. Then upgrade to 3.x (currently 3.9). 2.6.21 can read files opened/edited by 3.x. Older versions of

[GNC] Help!

2020-04-09 Thread Evelyn Bleasdale
I am still using Yosemite on my macbookpro, and am very happy with GNU cash 2.6.9 for our family accounts. Now I must upgrade to High Sierra, and am worried about how that will affect my GNU cash. Will I need to upgrade it as well? Any help would be greatly appreciated. Also what does *** Please

Re: [GNC] GNUCash beginner setup

2020-04-09 Thread Adrien Monteleone
Not sure, but that might simply be a screen update bug. I don’t often get an Imbalance situation (usually hitting [Enter] at the wrong time) but when I do, I almost always edit from the Imbalance transaction and never had a balance issue. I don’t recall if the real target account register was

Re: [GNC] Getting Report Error

2020-04-09 Thread Adrien Monteleone
See the wiki about checking the Tracefile and possibly try running from the command line as there may be some output there as well that will shed light on the error. Also, there is a new version of the report in the Experimental menu. Try that one and see if it works. (I think it first

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-09 Thread Adrien Monteleone
If I understood David correctly, the error was not caused by the change in the reconciliation code, but by David inadvertently entering a short year date. (“20” instead of “2018”, which became “2020”) In that case, since there is no facility to the user to edit reconcile dates, the only option

Re: [GNC] Suggestion: add "balance" variable for scheduled transactions

2020-04-09 Thread jeanl
Adding days is feasible, but I don't think it'll be very useful. It would only be useful if no other transaction was posted in between the scheduled ones. If you're interested in cases where the interested is compounded daily, this isn't the right solution, and I don't think gnucash has a solution

[GNC] Getting Report Error

2020-04-09 Thread Tom Balaban
Hi All, It's been a while since I've needed any help but that ship has sailed. Today I posted a new invoice to a customer. I then tried to run a customer report and got this error: Report error An error occurred while running the report. This only happens on this particular customer

[GNC] Bug 797668 - Reconcile Window opening with wrong starting balance ONLY after Import of account balance

2020-04-09 Thread Gunter (Solidaritaet GmbH)
I reported to https://bugs.gnucash.org/show_bug.cgi?id=797668 and it was recommended to me to share my Workaround here. I have about the same bug with bank accounts where I import transaction via HCBI/aqbanking. Behaviour since Update from 3.8. to 3.9: I import Bank transactions. Then I import

Re: [GNC] CSV import of fund transactions

2020-04-09 Thread Geert Janssens
Hi, I have fixed a bug wrt to this for gnucash 3.9. Can you retry with that version and report back whether it works now ? Regards, Geert Op donderdag 9 april 2020 08:04:07 CEST schreef Alaeddin Aydiner via gnucash-user: > Hello, > > I could not get the price of a mutual fund imported to

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

2020-04-09 Thread David Cousens
Long, In GnuCash reports the Unrealized Gains are simply a calculated quantity. I personally don't track my invetments in GnuCash because they are mainly long term secure securities so I am not that sure what is reported in the Balance Sheets. I was really outlining the traditional pen and paper

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

2020-04-09 Thread Geert Janssens
Op woensdag 8 april 2020 15:43:31 CEST schreef Adrien Monteleone: > I recall a recent thread about a similar problem with multi-currency import. > The resulting transaction also had an Imbalance that couldn’t be cleared > and the only solution was to manually enter the transaction. > > If a bug

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-09 Thread Geert Janssens
Op woensdag 8 april 2020 09:46:56 CEST schreef Frank H. Ellenberger: > Hi F, > > Am 08.04.20 um 09:17 schrieb F: > > Thank you Geert! > > > > There are a lot of errors, most of them - "source file newer than > > compiled". > > > > I have attached the output below. > > > > > > dfg@HP2760p:~$

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-09 Thread Geert Janssens
Op woensdag 8 april 2020 15:34:59 CEST schreef Frank H. Ellenberger: > Hi, > > Am 08.04.20 um 13:49 schrieb F: > > Hello Frank, > > > > []$ flatpak run org.gnucash.GnuCash > > > >  org.gnucash.GnuCash ~]$ locate /app/lib/guile/2.2/ccache/ > >  org.gnucash.GnuCash ~]$ > > That was not

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-09 Thread D via gnucash-user
So, David, you're saying you edited the data file directly in order to fix the new reconciliation problem? If so, that's a pretty strong indication to me that this change should get rolled back. There is no situation in which I think an end user should have to edit the data directly in order

[GNC] CSV import of fund transactions

2020-04-09 Thread Alaeddin Aydiner via gnucash-user
Hello, I could not get the price of a mutual fund imported to GnuCash 3.6 and 3.7 through a CSV. Everything else seems to get imported just fine. Has anyone managed to achieve this? The CSV looks like the following for a mini dividend reinvestment: Date,Description,Account,Deposit,Price