Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

[David Cousens]

Long 

I have tried experimenting with the trading accounts. I confess to finding
the whole currency exchange dialog totally confusing along with the random
Imbalance amounts which are intoduced which you somehow have to get back to
zero. I am going to have to play and experiment a lot more when I have a bit
of spare time and work through the manual.

The best bet will be if someone who uses them guides you through it at this
point.



-
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:
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] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

[jess]

Personally, I do it because I can update with command line conveniently. It
gives me the App Store update experience and I am well embedded in the
homebrew eco-system.


John Ralls-2 wrote
> 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 <

> denzil@

> > wrote:
>> 
>>> 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 GnuCash 3.4+
>> 
>> No, your data is held in a .gnucash (or equivalent). You can open that
>> same
>> file in GNUCash.
>> 
>> 
>> 
>> --
>> Sent from:
>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> gnucash-user mailing list
>> 

> gnucash-user@

>> 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.
> 
> ___
> gnucash-user mailing list

> gnucash-user@

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





--
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:
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] "Capital Loss" is Expense or Income account ?

[Long]

GnuCash Documents :
https://www.gnucash.org/docs/v3/C/gnucash-guide/currency_invest1.html
- 12.5.2. Selling a currency investment
"you must account for the profit (or loss) as coming from an Income:Capital
Gains account (or Expenses:Capital Loss)"
---
Because in GnuCash Documents, it's only guided people how to record realized
Gains, not Realized Loss. So i posted this to find some help.

Should i create "Expense" Account to record Realized Loss OR record it as
negative amount into "Income" Account ?

Thanks in advance.



--
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:
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 Realized Gain/Loss when turned on trading account ?

[Adrien Monteleone]

You don’t touch the trading accounts directly.

Just make your transactions between your normal accounts. GnuCash will add 
splits for each currency in your transaction to make it balance.

Regards,
Adrien

> On Apr 11, 2020 w15d102, at 12:51 AM, Long  
> wrote:
> 
> You can't transfer amount to "Trading Account" Because when you do that, The
> amount auto transferring to "imbalance" account instead of "Trading
> Accounts"


___
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 Realized Gain/Loss when turned on trading account ?

[Adrien Monteleone]

David,

I’ve seen that problem if you try to fetch rates or let GnuCash use a rate from 
the price db when you know both the debit and credit in each currency to be 
exact.

Let’s take the example of purchasing an ounce of silver from a coin dealer for 
$17.34:

Dr. Assets:Precious Metals:Silver   XAG1.
  Cr. Assets:Cash   $17.34

This of course does not numerically balance. So GnuCash will throw the dialog 
for you to tell it how to balance. In this case, you know the exact price of 
the silver, so you use the 'credit amount' radio button and enter “17.34”. 
GnuCash will then indicate the price ratio and you can commit the dialog. Two 
extra splits will appear, one for XAG and one for USD in the respective trading 
accounts so the transaction will balance—e.g.,

Dr. Assets:Precious Metals:Silver   XAG1.
Dr. Trading:Currency:USD$17.34
  Cr. Assets:Cash   $17.34
  Cr. Trading:Currency:XAG  XAG1.


I’m sure there are use cases for the option to exist, but I can’t think of a 
real world scenario where you are recording a currency exchange where you don’t 
already know the exact price. So I’m not sure how useful it is to use the 
‘rate' radio button option. Maybe someone who uses it can chime in.

Let’s say you chose that option, but the most recent price (or the one you just 
fetched) was $17.09 per ounce.

Then GnuCash would create the two trading splits again, but this time *also* 
one or more Imbalance splits (maybe one for each currency) to balance the 
difference of $17.09 and $17.34.

Hope that helps.

Regards,
Adrien



> On Apr 11, 2020 w15d102, at 2:21 AM, David Cousens  
> wrote:
> 
> Long 
> 
> I have tried experimenting with the trading accounts. I confess to finding
> the whole currency exchange dialog totally confusing along with the random
> Imbalance amounts which are intoduced which you somehow have to get back to
> zero. I am going to have to play and experiment a lot more when I have a bit
> of spare time and work through the manual.
> 
> The best bet will be if someone who uses them guides you through it at this
> point.

___
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 Loss" is Expense or Income account ?

[Adrien Monteleone]

Record it in the income account.

Some people keep both a Capital Gain *and* a Capital Loss account. But you 
really only need the Capital Gain account for most purposes. (your local laws 
may require both however)

With one account, both gains and losses are recorded in that same account. 
Gains will be credits to the account (since it is an Income account), Losses 
will be in the form of debits to the account. (reducing the gain) The balance 
at the end of your accounting period (usually one year) will determine if it is 
finally a gain or loss.

Note, this would be “realized” gains or losses because you are recording them 
specifically, not having GnuCash estimate what they might be. (which would be 
‘unrealized’)

Regards,
Adrien

> On Apr 11, 2020 w15d102, at 7:15 AM, Long  wrote:
> 
> GnuCash Documents :
> https://www.gnucash.org/docs/v3/C/gnucash-guide/currency_invest1.html
> - 12.5.2. Selling a currency investment
> "you must account for the profit (or loss) as coming from an Income:Capital
> Gains account (or Expenses:Capital Loss)"
> ---
> Because in GnuCash Documents, it's only guided people how to record realized
> Gains, not Realized Loss. So i posted this to find some help.
> 
> Should i create "Expense" Account to record Realized Loss OR record it as
> negative amount into "Income" Account ?
> 
> Thanks in advance.


___
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] Keeping Imported Transactions from Overwriting Data?

[Eric H. Bowen via gnucash-user]

I've been using GnuCash for my personal finances, and I've noticed one 
annoying problem. When I write a paper check, I put the payee's name and 
associate information in the "Description" and "Notes" field. But, when 
I import transactions from my credit union (usually with QFX) prior to 
reconciling, the data I entered is overwritten with "PAID CHECK 
" and "OFX ext. info: |Trans type:Check|Memo:Paid Check 
00", which is sorta less than helpful when I'm attempting to 
identify transactions later. For personal transactions I can usually 
reconstruct the data by going online, but it's a pain.


I'm concerned, though, because I'm wanting to implement GnuCash for our 
church's bookkeeping. I haven't yet tried downloading from our church's 
bank, but if it overwrites information, especially deposit information 
which we will use to keep track of offerings and contributions, it could 
be a disaster. Is there any way of still downloading to match and clear 
transactions, but to keep the download from overwriting manually entered 
data?


___
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] Keeping Imported Transactions from Overwriting Data?

[David Carlson]

In cases where I don't want GnuCash to overwrite existing transaction with
an imported one, I set the imported transactions as new.  I try to assign
the correct account if I know it.  This creates a duplicate so I need to
manually match them up and delete the ones that I don't want later.



On Sat, Apr 11, 2020, 10:12 AM Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I've been using GnuCash for my personal finances, and I've noticed one
> annoying problem. When I write a paper check, I put the payee's name and
> associate information in the "Description" and "Notes" field. But, when
> I import transactions from my credit union (usually with QFX) prior to
> reconciling, the data I entered is overwritten with "PAID CHECK
> " and "OFX ext. info: |Trans type:Check|Memo:Paid Check
> 00", which is sorta less than helpful when I'm attempting to
> identify transactions later. For personal transactions I can usually
> reconstruct the data by going online, but it's a pain.
>
> I'm concerned, though, because I'm wanting to implement GnuCash for our
> church's bookkeeping. I haven't yet tried downloading from our church's
> bank, but if it overwrites information, especially deposit information
> which we will use to keep track of offerings and contributions, it could
> be a disaster. Is there any way of still downloading to match and clear
> transactions, but to keep the download from overwriting manually entered
> data?
>
> ___
> 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.
>
___
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] Keeping Imported Transactions from Overwriting Data?

[D. via gnucash-user]

It's been a while since I imported transactions, but I seem to recall there 
being a point where you could tell the matcher to (R)econcile or (U)pdate the 
existing entry.  Choosing R should set the transaction to cleared and leave 
your manually-entered data intact. 

Now,  why that matcher defaults to overwriting your manually entered data is an 
entirely different question that always mystified me. Seems ass backward to me. 

David T.


 Original Message 
From: David Carlson 
Sent: Sat Apr 11 20:50:38 GMT+05:30 2020
To: "Eric H. Bowen" 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Keeping Imported Transactions from Overwriting Data?

In cases where I don't want GnuCash to overwrite existing transaction with
an imported one, I set the imported transactions as new.  I try to assign
the correct account if I know it.  This creates a duplicate so I need to
manually match them up and delete the ones that I don't want later.



On Sat, Apr 11, 2020, 10:12 AM Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I've been using GnuCash for my personal finances, and I've noticed one
> annoying problem. When I write a paper check, I put the payee's name and
> associate information in the "Description" and "Notes" field. But, when
> I import transactions from my credit union (usually with QFX) prior to
> reconciling, the data I entered is overwritten with "PAID CHECK
> " and "OFX ext. info: |Trans type:Check|Memo:Paid Check
> 00", which is sorta less than helpful when I'm attempting to
> identify transactions later. For personal transactions I can usually
> reconstruct the data by going online, but it's a pain.
>
> I'm concerned, though, because I'm wanting to implement GnuCash for our
> church's bookkeeping. I haven't yet tried downloading from our church's
> bank, but if it overwrites information, especially deposit information
> which we will use to keep track of offerings and contributions, it could
> be a disaster. Is there any way of still downloading to match and clear
> transactions, but to keep the download from overwriting manually entered
> data?
>
> ___
> 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.
>
___
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.
___
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] Keeping Imported Transactions from Overwriting Data?

[David Carlson]

David T,

You are right.  I too am not sure why the (U)pdate option overwrites the
text of the existing transaction, but I think that it usually is offered as
the default when the date of the matched transaction is not the same as the
imported transaction, and possibly when the importer tries to match to a
transaction with a slightly different value.  Like you I usually prefer to
keep the existing text.

I get lazy with trying to match everything during the import when the clock
is running and Gnucash will soon be wanting to interrupt me with an
automatic save, so I often just let everything come in and sort it out
later.

On Sat, Apr 11, 2020 at 11:54 AM D.  wrote:

> It's been a while since I imported transactions, but I seem to recall
> there being a point where you could tell the matcher to (R)econcile or
> (U)pdate the existing entry.  Choosing R should set the transaction to
> cleared and leave your manually-entered data intact.
>
> Now,  why that matcher defaults to overwriting your manually entered data
> is an entirely different question that always mystified me. Seems ass
> backward to me.
>
> David T.
> --
> *From:* David Carlson
> *Sent:* Sat Apr 11 20:50:38 GMT+05:30 2020
> *To:* "Eric H. Bowen"
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: [GNC] Keeping Imported Transactions from Overwriting Data?
>
> In cases where I don't want GnuCash to overwrite existing transaction with
> an imported one, I set the imported transactions as new.  I try to assign
> the correct account if I know it.  This creates a duplicate so I need to
> manually match them up and delete the ones that I don't want later.
>
>
>
> On Sat, Apr 11, 2020, 10:12 AM Eric H. Bowen via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>  I've been using GnuCash for my personal finances, and I've noticed one
>>  annoying problem. When I write a paper check, I put the payee's name and
>>  associate information in the "Description" and "Notes" field. But, when
>>  I import transactions from my credit union (usually with QFX) prior to
>>  reconciling, the data I entered is overwritten with "PAID CHECK
>>  " and "OFX ext. info: |Trans type:Check|Memo:Paid Check
>>  00", which is sorta less than helpful when I'm attempting to
>>  identify transactions later. For personal transactions I can usually
>>  reconstruct the data by going online, but it's a pain.
>>
>>  I'm concerned, though, because I'm wanting to implement GnuCash for our
>>  church's bookkeeping. I haven't yet tried downloading from our church's
>>  bank, but if it overwrites information, especially deposit information
>>  which we will use to keep track of offerings and contributions, it could
>>  be a disaster. Is there any way of still downloading to match and clear
>>  transactions, but to keep the download from overwriting manually entered
>>  data?
>>
>> --
>>
>>  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.
>
>
> --
>
> 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.
>
>

-- 
David Carlson
___
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] Keeping Imported Transactions from Overwriting Data?

[Jim DeLaHunt]

Eric:

On 2020-04-11 10:10:20 -0500, "Eric H. Bowen"  wrote:

When I write a paper check, I put the payee's name and
associate information in the "Description" and "Notes" field. But, when
I import transactions from my credit union (usually with QFX) prior to
reconciling, the data I entered is overwritten with "PAID CHECK
" and "OFX ext. info: |Trans type:Check|Memo:Paid Check
00", which is sorta less than helpful when I'm attempting to
identify transactions later.…

I'm concerned, though, because I'm wanting to implement GnuCash for our
church's bookkeeping. I haven't yet tried downloading from our church's
bank, but …if it overwrites information, especially deposit information
which we will use to keep track of offerings and contributions, it could
be a disaster. Is there any way of still downloading to match and clear
transactions, but to keep the download from overwriting manually entered
data?


I am bothered by the same Gnucash behaviour. I don't see how to change 
it via user settings. I just filed a Gnucash issue ticket about it:


Bug 797678  - OFX 
importer should supplement, not replace, existing Notes (and Description 
and Memo) fields


I will add a summary of your comments, and a link to this thread, to 
that bug report. You are welcome to add comments there and/or subscribe 
to notifications about the bug.


If the GnuCash bug tracker is new to you, then 
 is one introduction.


Best regards,
  —Jim DeLaHunt, Vancouver, Canada

___
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] Gnucash and Windows 10 Aero snap feature

[ameet]

Hi All,

 

Is there a property in a gnucash config that I can edit to allow aero snap
control handed to windows 10? It seems gnucash 3.x series doesn't get along
with this feature. 

 

I have an ultrawide monitor. In default mode, if I snap gnucash to left or
right side, it snaps perfectly fine and allows me to select tiles to snap to
the opposing side.  However, if I snap another window first, then gnucash
will disappear. There is no gnucash tile to select. I have to bring gnucash
back to the visible screen by clicking its icon the toolbar and then
manually moving and sizing gnucash into place. 

 

The problem is more pronounced when I chop my display into 3 or 4 splits. In
this mode, gnucash will not snap to either side or middle splits. If I snap
other apps first, gnucash will again just disappear. If I change the order
of my splits, gnucash will not follow. It just floats in its spot or it ends
up disappearing behind other apps. 

 

Cheers,

Ameet

 

 

 

___
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 Realized Gain/Loss when turned on trading account ?

[David Cousens]

Long

 I found that setting up the transfers makes a lot more sense using the
toolbar Transfer icon or the Menu->Actions->Transfer as you are more easily
able to setup the debits, credits and the accounts and the exchange rate
seems to work a bit more naturally and uses a different dialog

I was then able to create a trading account balance with a transfer to USD
and back at a slightly different exchange rate, in my case a loss of 0.26
which showed up as Trading Losses in the Balance Sheet.  I think the Trading
accounts are protected against manual transaction entries to them
deliberately.  The values in them will automatically be recorded in the
Balance Sheet as Trading Gains or Losses and my guess is they are recorded
in the book currency in the Balance sheet.  If you then create an Income
Statement report the trading account balances will then show up in that as
Realized Gains and Losses.  It does work! I'll try and do the 5.1 table
exercise later.

GnucCash can be used in two ways. Accountants traditionally when using pen
and paper physically closed the book and created a new physical set of books
at the end of each accounting procedure. They used a close books procedure
in which one of the steps would have been to adjust any residual unrealized
gains to the actual gain during the recording of the sale  and then transfer
the actual gain and loss to a Realized gains and Losses Account. 

GnuCash can be operated in this manner with trading accounts turned off but
you have to manually generate all the entries and use a close books process
to transfer the income and expense account balance to an Equity:Retained
earnings account.

Because all of the data exists and can be easily manipulated in a program,
GnuCash can also be used in a mode where you dont carry out any close books
procedure and the program automatically calculates the balances for
unrealized gains and losses and includes them appropriately labelled in the
Balance Sheet and Income Statement (and other reports as appropriate). There
was some discussion a year or two ago about unrealized gains and how they
appeared in the balance sheet in either the DEV forum or the User forum.
Chris Lam was doing a rewrite and updating the user reports and creating a
lot of new reports at the time. There was a lot of effort to ensure the
reports were compatible with both ways of using GnuCash. If you search back
through the archives you might find that thread.

David



-
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:
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] GnuCash 3.10 Released

[John Ralls]

The GnuCash development team announces GnuCash 3.10, the eleventh release of 
the 3.x stable release series.
Changes

This is a snap release to reverse the changes to the reconcile window's 
filtering reconciled transactions with a reconcile date after the current 
statement date when computing the starting balance. It seems that many users' 
books have accounts with reconcile dates in the future that were suddenly 
filtered out, creating an incorrect starting balance and making it impossible 
to reconcile the book.

Between 3.9 and 3.10, the following bugfixes were accomplished:

Bug 620848 - Transfer Funds window - add Notes field
Bug 797006 - Balance is misleading in open subaccounts when different 
currencies are involved
Bug 797318 - Amounts ending in zero displayed as fractions
Bug 797666 - libgnucash/engine/test/test-recurrence.c: In function 
'check_valid': 'result' may be used uninitialized
Bug 797676 - Register displays amount in transaction currency instead of 
register currency.
Bug 797674 - 3.9: "test-gnc-path-util" failed on Debian amd64

The following fixes and improvements were not associated with bug reports:

Update latest translation from the Translation project.
[window-reconcile] when reconciling, warn on splits having a reconcile date 
> statement_date
[window-reconcile] when inputing statement_date, warn if it's after today
[find-transactions] add search for reconciled date
Show transaction value, not amount, for registers with subaccounts.

If the register has subaccounts in different currencies and a transaction 
has splits in more than one, the transaction will incorrectly appear to be 
unbalanced if we total amounts because the balancing logic works on split 
values.
Add instance argument to Session constructor

Enables a python console to connect to the running GnuCash's session.
Make python console less noisy without --debug.
Provide locals and globals of calling context to the python console's shell 
on shell init
Merge Jean Laroche's '797006_subaccounts' into maint.
Add check to display warning dialog for mismatched commodities
Replicate changes in *2 files
Apply astyle to modified files
Merge Chris Mayo's iPython-fixes into maint.
Make pycons/ishell.py compatible with Python 3 and current IPython
[eguile-utilities] Prevent crash in balsheet-eg.scm
[eguile] escape-html -> gnc:html-string-sanitize
[qif-to-gnc] Properly mark intra-QIF internal transfers.

We have a revised Ukrainian translation.
Known Issues

The following are open bug reports to the 3.x series considered significant by 
the development team:

Bug 795383 - Gnucash crashes on import of a 1400-transaction (or more) CSV 
file
Bug 796955 - Import CSV - Single-line two-currency transactions can't be 
imported
Bug 796992 - gnucash --add-price-quotes can't parse drive letters on 
Windows.
Bug 796997 - Currency Conversion Dialog appears when recording transactions 
between same currency accounts.
Bug 797037 - Counter formats not saving
Bug 797064 - crash when try print report
Bug 797083 - Gnucash crashes when trying to rename budget
Bug 797092 - Save As fails: tries to save to reserved directory if path 
contains spaces
Bug 797113 - Scrubbing crashes when creating small splits that round to 
value 0.
Bug 797114 - Fixing an SX due to deleted account stuck in an error loop
Bug 797115 - Can't 're-activate' an expired SX
Bug 797211 - Very slow UI - dependent on window size
Bug 797220 - delete account allows move of all transactions to account 
having non-matching currency
Bug 797236 - Regression: Reconcile window transaction list resets to top 
when new transaction created in account
Bug 797264 - 3.5 can't use Chinese IME input
Bug 797283 - Permanent hang on clicking on report tabs
Bug 797285 - QIF import fails and then crashes
Bug 797293 - Crash when import "U+R" or "R"
Bug 797294 - Billing functions freezing
Bug 797325 - [Windows 7] Reports with charts will not load
Bug 797329 - Using Japanese IME to enter transactions results in unexpected 
field jumps
Bug 797334 - Crash on attempting to change account separator character
Bug 797335 - Crash on subsequent Open after accidentally Opening the 
current file
Bug 797336 - CSV Accounts import fails on UTF-8 e-acute in account name
Bug 797345 - Selecting item in tax table causes gnucash to crash
Bug 797348 - Wrong column order for RTL writing in GUI elements
Bug 797351 - General ledger register transaction becomes "zombie" after 
deletion
Bug 797363 - Consistent Silent Crash on Converting Saved Reports from 2.6 
to 3.6
Bug 797368 - Cannot download Quantity information from a CSV to a mutual
Bug 797384 - Gnucash doesn't handle commodity prices with big 
numerator/denominator properly
Bug 797385 - Report html files NOT opening in Reports tab or window due to

Re: [GNC] Gnucash and Windows 10 Aero snap feature

[John Ralls]

There's no config for that. AeroSnap isn't fully supported by Gtk. For a 
somewhat technical discussion of why and whether it will change in Gtk4, see 
https://gitlab.gnome.org/GNOME/gtk/issues/105.

Regards,
John Ralls

> On Apr 11, 2020, at 2:41 PM,   wrote:
> 
> Hi All,
> 
> 
> 
> Is there a property in a gnucash config that I can edit to allow aero snap
> control handed to windows 10? It seems gnucash 3.x series doesn't get along
> with this feature. 
> 
> 
> 
> I have an ultrawide monitor. In default mode, if I snap gnucash to left or
> right side, it snaps perfectly fine and allows me to select tiles to snap to
> the opposing side.  However, if I snap another window first, then gnucash
> will disappear. There is no gnucash tile to select. I have to bring gnucash
> back to the visible screen by clicking its icon the toolbar and then
> manually moving and sizing gnucash into place. 
> 
> 
> 
> The problem is more pronounced when I chop my display into 3 or 4 splits. In
> this mode, gnucash will not snap to either side or middle splits. If I snap
> other apps first, gnucash will again just disappear. If I change the order
> of my splits, gnucash will not follow. It just floats in its spot or it ends
> up disappearing behind other apps. 
> 
> 
> 
> Cheers,
> 
> Ameet
> 
> 
> 
> 
> 
> 
> 
> ___
> 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.

___
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 Realized Gain/Loss when turned on trading account ?

[Long]

David Cousens,

1 - Trading Accounts only show in the Balance Sheet, I tried to create
Income Statement Report, And there are no Accounts named "Realized Gains or
Loss" like you said. You should create a new file, and using the new version
GnuCash (newest version is 3.9).

2 - Like i said, There are no ways to transfer amount to "Trading Account"
(Trading Account was programing for that), Which mean if you practice follow
5.1 Table, It is impossible.

P/s :
**Remember that, i mean "Transfer" is : you are manual entering amount into
a register to transfer money from your accounts to "Trading accounts".
(Credit "Your account" => Debit "Trading Accounts" => It will transfer your
amount to "imbalance account")
**The "Trading Accounts" creates transactions and have value when you are
transfer from "a" currency to "b" currency. WIKI HAD TALK ABOUT THIS.
I will write this for sure that will be no misunderstanding.



--
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:
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 Realized Gain/Loss when turned on trading account ?

[David Cousens]

Long,

Balance Sheet and Income Statement are attached for a simple test which
involved a currencytransfer of 100 AUD to a USD account and then a transfer
back from the USD account to the AUD with a different exchange rate that
created a loss of 0.26 using trading accounts to record. I used the
menu->Action->Transfer ( or the Toolbar-> Transfer button to create the
transfer. I am using GnuCash 3.9.
Trading_test_balance_sheet.png

  
Trading_test_IncomeStatement.png

 
.

1. If you are using trading accounts, i.e. you have used the
File->Properties to get the book properties and selected the Use Trading
Accounts checkbox in the Accounts tab as described in the wiki
https://wiki.gnucash.org/wiki/Trading_Accounts trading accounts will be
created automatically whenever you do a multiple currency transfer if they
don't already exist. You do not create them manually. You do not have to
manually create the transactions to them when you do a currency transfer,
they are automaticall created.  These are special accounts and the user is
locked out of editing transactions to them. 
While experimenting I had a situation where an incorrect value was created
in a trading account and an Imbalance was created as a result. I  was unable
to edit the trading account value so the only way to fix it was to delete
the transaction completely and then start again.

2. There is no need while using the trading accounts in GnuCash to transfer
anything from the trading account balances to any sort of realized gains
account or unrealized gains account. These amounts are calculated
automatically for you in the Balance Sheet and Income Statement reports from
the values in the Trading accounts as per the above examples.

Selinger's article  predates the setting up of trading accounts in GnuCash.
While he illustrates the use of them in the painting sale AFAIK in GnuCash
they seem only to be setup for currency transfers at this point although it
is possible they may also work for other commodities (e.g.shares). I could
be wrong on that but I don't have time to explore it fully at the moment and
it is not a feature I currently use.

You could also manually setup trading accounts rather than using the inbuilt
GnuCash trading account type which is created automatically. In that case
you have to create all the transactions for unrealized gains and losses and
realized gains and losses manually rather than having them done
automatically which was where we started in this discussion. 

GnuCash is very flexible and there are often different ways you can achieve
the same objective which can sometimes be confusing for new users and even
for those of us who have been using it for a relatively long time (~2010 in
my case when I used it in case studies while doing a masters in accounting
and I am also a minor contributor to the development and documentation). 

David

  



-
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:
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.