Re: [GNC] New Financial Year

2021-03-28 Thread Peter Williamson
Hi Derek
Thanks very much
Peter

> On 29 March 2021 at 12:40 Derek Atkins  mailto:de...@ihtfp.com > wrote:
> 
> 
> Hi,
> 
> If you have a data file called, say Books-2020, and then you do:
> Save
> and then
> Save-As
> and name the new one Books-2021, then you'll have "archived" Books-2020
> and GnuCash will, by default, open Books-2021 until you tell it otherwise.
> 
> -derek
> 
> On Sun, March 28, 2021 7:09 pm, Peter Williamson wrote:
> 
> > > I don't need to "close books" but would like to create a new 
> gnucash file
> > at the beginning of a financial year and archive the previous years 
> > file.
> > 
> > > 
> > > Can I do this by just doing a "save as" with an appropriate file 
> name for
> > the new financial year?
> > 
> > > 
> > > Would this then leave the previous financial years records intact 
> under
> > the previous year's file name?
> > 
> > > 
> > > Regards
> > 
> > > 
> > > Peter
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org mailto: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.
> > 
> > > 
> --
> Derek Atkins 617-623-3745
> de...@ihtfp.com mailto:de...@ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
> 
___
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] New Financial Year

2021-03-28 Thread Derek Atkins
Hi,

If you have a data file called, say Books-2020, and then you do:
Save
and then
Save-As
and name the new one Books-2021, then you'll have "archived" Books-2020
and GnuCash will, by default, open Books-2021 until you tell it otherwise.

-derek

On Sun, March 28, 2021 7:09 pm, Peter Williamson wrote:
> I don't need to "close books" but would like to create a new gnucash file
> at the beginning of a financial year and archive the previous years file.
>
> Can I do this by just doing a "save as" with an appropriate file name for
> the new financial year?
>
> Would this then leave the previous financial years records intact under
> the previous year's file name?
>
> Regards
>
> Peter
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] New Financial Year

2021-03-28 Thread Peter Williamson
I don't need to "close books" but would like to create a new gnucash file at 
the beginning of a financial year and archive the previous years file.

Can I do this by just doing a "save as" with an appropriate file name for the 
new financial year? 

Would this then leave the previous financial years records intact under the 
previous year's file name? 

Regards

Peter
___
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 4.5 Released

2021-03-28 Thread John Ralls
The GnuCash development team announces GnuCash 4.5, the sixth release in the 
stable 4.x series

Between 4.4 and 4.5, the following bugfixes were accomplished:

• Bug 783283 - Multi-Currency payments use wrong date
Also properly handles the user clicking the cancel button on the transfer 
dialog. It will now just return to the payment window, waiting for further user 
input. 

• Bug 797621 - GnuCash freezes temporarily and sometimes crashes when 
selecting Sales Tax Table in Invoices
• Bug 797630 - Check for missing dependencies of 'Get Quotes' to avoid 
Gnucash crash.
• Bug 797906 - GnuCash data file is locked after a "save-as" to mysql 
database.
It's more general, any save-as to a different backend type, i.e. xml->sql or 
sql->xml, left the previous book locked.

• Bug 797924 - Crash when searching for customer to process payment.
• Bug 797997 - File gnucash could note be found
On Microsoft Windows when run from a CMD shell and passing a path that contains 
non-ASCII characters.

• Bug 798019 - Currency rates in OFX file are ignored
Use currency_rate information from OFX file if available. Requires LibOFX v 
0.10.0 or later. 

• Bug 798044 - Adding splits to a lot is extremely slow
• Bug 798060 - Invoices are missing on Customer report after upgrade
• Bug 798070 - Opening balance does not update when creating account 
from Account Hierarchy
• Bug 798078 - Report 'Income Chart' prints stacktrace when end date 
before start date
• Bug 798085 - Incorrect transactions import of entires with large 
number amount
Quicken 2005 introduces U amount which sometimes differs from T amount. U 
amount has larger range, and must override T amount whenever they're not equal. 

• Bug 798093 - Changing the symbol/abbreviation of a security after the 
trading account was created breaks GnuCash.
Makes it possible for the user to rename trading accounts or securities 
independent of each other.

• Bug 798096 - can't duplicate TX previous to red line threshold
• Bug 798098 - Crash popup show when have 3 Windows in OSX
• Bug 798100 - Equity totals calculating incorrectly
Prevents creation of non-currency opening balance accounts. 

• Bug 798101 - Do not #undef __STRICT_ANSI__
Remove defines and undefines for Windows, they were needed with MinGW classic 
but are not with MinGW-w64. 

• Bug 798104 - Menu item for "Import Account" is wrong in danish
• Bug 798112 - An error occurred while processing mysql ...
A "Feature" of MYSQL is that it allows C-style backslash escapes in string 
constants and replaces them with the actual character (e.g. \n is converted to 
0x0a). This causes round trip problems if the escape is one of the allowed ones 
and a MYSQL error if it isn't. Disable the feature so that MYSQL follows the 
SQL standard. 

• Bug 798132 - Invoice Importing crashes when importing low quantity 
values.
• Bug 798135 - GtkEntry text with search list: shows selected entry 
again for no reason
• Bug 798147 - Notes entry crashes program 
• Bug 798149 - CSV transaction Import setting loses account name if it 
is changed after setting is memorized
Account guid is saved as well as the full account name and when recalled the 
account is looked up first by guid, if this fails the full account name is 
checked which if successful immediately updates the saved base account setting 
with the account guid for future use. If unsuccessful the account combo is 
blank with a error message as before. When save CSV settings button is used, 
both the Guid and full paths are saved so previous versions can still use the 
full path as before. 

• Bug 798150 - Error on report over time
Caused by incorrect handling of Daylight Savings beginning at midnight.

• Bug 798154 - Tooltips wrong when multiple charts in one report
The following fixes and improvements were not associated with bug reports:

• Fix building based on unix makefiles
• Make the chart on the report page icon larger to align better with 
the account page icon.
• Allow the context menu when GncCellRendererTextView is in edit mode.
• Restructure early locale initialization
• Move macOS specific bits to its own source file. As this is 
objective-c use .mm extension
• Use common function signature for macOS and Windows init 
function and include via common header file 
• Fix GncDateTime::format_zulu to emit the UTC timezone instead of the 
GncDateTime's timezone with the UTC timestamp. 
• Fix the implementations of gnc_foo_get_day_neutral. As implemented 
these returned 10:59 AM local on the day but neutral time is 10:59 UTC. 
• gnc_invoice_window_print_invoice return NULL if invoice is NULL.
• [dialog-invoice] invoice editor reuses invoice report tab.
• Allow for Header Bar use in CSV 

[GNC] Trading accounts functionality

2021-03-28 Thread zuperkoleoptera
I've been using gnucash since 2014, recording my personal finances and
investments. I am in Europe so my main currency is EUR.
Up until now my investments were in EUR currency as well as some
crypto, which are again expressed in EUR currency.

Lately I started building an investment portfolio in USD, so I started
exploring the trading accounts functionality. I have read both articles
from P. Selinger and browsed through the documentation and mailing
lists, for related subjects.
The problem I am facing is the following, after activating trading
accounts the system created the hierarchy for all the trading accounts,
but also created a bunch of splits in already recorded transactions. So
from the beginning the trading:currency:EUR account has a balance of
almost 2.300 eur and includes all my transactions related to my crypto
portfolio. 
Is this normal for the trading system to create splits in already
recorded transactions? And what does it mean for the
trading:currency:EUR to have a positive balance of 2.300 eur, is this
exchange realized gain?

___
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] asset discrepancy in change of year

2021-03-28 Thread David Cousens
Andrea,

Glad you have the problem worked out. I was working from your description of
your calculation. Appreciate the difficulties when you have a second
language and a lack of background. The good point about the user list is we
are all often  coming from different perspectives so all possibilities
generally end up being covered and one of them usually fits..

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.


Re: [GNC] asset discrepancy in change of year

2021-03-28 Thread Andrea Borgia



Il 27/03/21 23:23, David Cousens ha scritto:

As the (Income - Expense) is already recorded against Assets when you create
the transactions, you are including them twice in the total you are
calculating.


Please keep in mind that I am neither an accountant nor a native English 
speaker, therefore there are *at least* two layers of imprecision in my 
explanation attempts :)



However I don't think this is the case, here, because the difference is 
way smaller than (Income - Expense) and applies to this change of 
year alone.


As I just wrote in another reply, the issue lies with the mutual funds: 
unrealized gains / losses. I had seen it being mentioned from time to 
time but never properly understood because I had no mutual funds.



Thanks,

Andrea.


___
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] closing of books and multiple currencies: a question on exchanges

2021-03-28 Thread Andrea Borgia



Il 27/03/21 22:54, David Cousens ha scritto:

On the mutual fund purchase. It is most likely that the fund will  > have paid US taxes on its earnings so you are unlikely to be liable 
> for any tax in the US so there is likely little value in maintaining 
> US expense or income accounts. I base that un professional opinion > 
only on general principles
Indeed, the italian bank will handle the tax obligations on my behalf, 
be they in Italy or in the USA.


I'll modify this year too following this logic, now that I understand it.


We can really only give advice on the program and its operation and  > how to achieve a desired recording using GnuCash once you know what 
> recording is necessary and appropriate for your circumstances. God > 
luck!
While this might be true in a general sense, for my level of 
(non)expertise I find that this list quite often provides good informal 
guidance on the accounting basics and for this I'm grateful.



Thanks,

Andrea.




___
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] asset discrepancy in change of year

2021-03-28 Thread Andrea Borgia

Il 27/03/21 19:04, Michael or Penny Novack ha scritto:

Now we come to the end of the year, at which point let's say the 
exchange rate is $1.25/1 EUR. Those $1300 are no longer worth 1000 
Eur. They are worth 1040 EUR. Your equity has gone up by 40 EUR.


I will stop here because the issue of how "unrealized gains/losses 
from changes in exchange rate" will be treated is not a gnucash issue. 
It's exactly the same no matter what accounting software you use or 
even old fashioned pen and ink on paper.


Thanks, now I get it, I think. I don't have enough EUR/USD conversions 
for that to be the cause of my issue but I do have plenty of mutual 
funds and the logic is indeed the same.



Basically my options during the change of books are either:

1) setting a closing price for each fund that matches the original 
purchase / year opening price: this way it will appear to be unchanged


or

2) I post the value difference, either cumulative or per fund, as 
"unrealized gain / loss" and that's it.



Thanks,

Andrea.


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