date:20200407

I’m not certain, maybe someone else can help, but knowing which file format 
makes a difference to the devs, thanks.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 7:20 PM, Giuseppe Quinn  wrote:
> 
> I’ve been using OFX
> 
> Is there a pfile or something that might be corrupted that I can set aside to 
> test and or start over?
> 
> Thanks for the help!
> 
>> On Apr 7, 2020, at 1:11 PM, Adrien Monteleone 
>>  wrote:
>> 
>> What type of import? QIF, CSV?
>> 
>> Regards,
>> Adrien
>> 
>> p.s. —please be sure to ‘reply-list’ or ‘reply-all’ so others can benefit 
>> from the discussion and/or offer help.
>> 
>>> On Apr 7, 2020 w15d98, at 2:01 PM, Giuseppe Quinn  
>>> wrote:
>>> 
>>> Yea, I’ve done them over and over in the import window, to no avail.
>>> 
>>> 
> On Apr 7, 2020, at 12:54 PM, Adrien Monteleone 
>  wrote:

 Make sure you are doing those assignments within the import window. If 
 you import first, then edit transactions to correct Imbalance-xyz to 
 proper accounts, the importer never gets to learn.

 Regards,
 Adrien

> On Apr 7, 2020 w15d98, at 1:45 PM, Giuseppe Quinn  
> wrote:
> 
> Is there a way to improve category matching of imported transactions? 
> Every session I have to tell GC which category grocery store 
> transactions, CC payments, and every other repeating transaction, which 
> category they go into. 

___
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] Improve imported transaction category matching

2020-04-07 Thread Giuseppe Quinn

I’ve been using OFX

Is there a pfile or something that might be corrupted that I can set aside to 
test and or start over?

Thanks for the help!

> On Apr 7, 2020, at 1:11 PM, Adrien Monteleone 
>  wrote:
> 
> What type of import? QIF, CSV?
> 
> Regards,
> Adrien
> 
> p.s. —please be sure to ‘reply-list’ or ‘reply-all’ so others can benefit 
> from the discussion and/or offer help.
> 
>> On Apr 7, 2020 w15d98, at 2:01 PM, Giuseppe Quinn  
>> wrote:
>> 
>> Yea, I’ve done them over and over in the import window, to no avail.
>> 
>> 
 On Apr 7, 2020, at 12:54 PM, Adrien Monteleone 
  wrote:
>>> 
>>> Make sure you are doing those assignments within the import window. If you 
>>> import first, then edit transactions to correct Imbalance-xyz to proper 
>>> accounts, the importer never gets to learn.
>>> 
>>> Regards,
>>> Adrien
>>> 
 On Apr 7, 2020 w15d98, at 1:45 PM, Giuseppe Quinn  
 wrote:
 
 Is there a way to improve category matching of imported transactions? 
 Every session I have to tell GC which category grocery store transactions, 
 CC payments, and every other repeating transaction, which category they go 
 into. 
> 
> 
> ___
> 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] GNUCash beginner setup

Denz,

Do you use the 'Basic Ledger View'?  In that view you do not see any split
lines, only an indication that they exist.  Switch to either one of the
other views to see the split lines.

On Tue, Apr 7, 2020 at 6:02 PM David Carlson 
wrote:

> Maybe I should have mentioned that I do that accidentally all too
> often...😐
>
> On Tue, Apr 7, 2020 at 5:59 PM David Carlson 
> wrote:
>
>> Michael, in fact, you *Can* change the "home' account line.  You will
>> know that it worked when the transaction disappears from the register view.
>>
>> I don't recommend that because you cannot see what you just did and there
>> is no warning that the transaction will disappear or chance to discard the
>> edit.
>>
>> On Tue, Apr 7, 2020 at 5:45 PM Michael or Penny Novack <
>> stepbystepf...@comcast.net> wrote:
>>
>>> On 4/7/2020 4:30 PM, jess wrote:
>>> > The opening balance in the previous message refers to the current
>>> balance I
>>> > have on my bank account in real life.
>>> >
>>> > I was able to solve this too. It works for resolution if the imbalanced
>>> > transactions are assigned an account inside the checking account
>>> transaction
>>> > list. If you try to assign the account in the "Imbalanced" account, it
>>> does
>>> > not work.
>>> >
>>> > Why does this happen?
>>>
>>> I think I understand what is confusing you.
>>>
>>> You can enter transactions working from any of the accounts affected (if
>>> more than one, then it is a "split" transaction. You can specify/change
>>> (if editing the transaction) anything about the transaction EXCEPT the
>>> account you chose to work in. If you think about that for a second it
>>> may become obvious why that should be so.
>>>
>>> Which means  If you are trying to correct a transaction that has an
>>> account of "Imbalance" (an account was not specified; gnucash used the
>>> default account "Imbalance") you can't fix that from within the
>>> "Imbalance" account. Sure, you find these transactions that need fixing
>>> by seeing what transactions, if any, are in the "Imbalance" account.
>>> Then in each one see the other (or of a split, others) and go to that
>>> transaction there. NOW you can specify the correct account instead of
>>> "Imbalance".
>>>
>>> You were probably looking for/expecting a different process. What
>>> gnucash is doing is letting "Imbalance" be just like any other account,
>>> no special process.
>>>
>>> Michael D Novack
>>>
>>>
>>>
>>> ___
>>> 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
>>
>
>
> --
> David Carlson
>


-- 
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] GNUCash beginner setup

I’ve done this many times, but on purpose. (I’m in the middle of such an 
exercise right now)

From time to time, I refactor some expenses to better reflect how I want to 
keep track of things. I may only need to move a subset of transactions from one 
account to another.

I do a Find to obtain my working list and then start re-assigning splits. As I 
complete each one, they disappear from my Find results. When the result tab is 
empty, I’m done.

Of course, when doing this, I work more carefully and pay more attention when I 
commit the change. I usually have the affected registers open so I can view 
them to see the resulting change if needed.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 6:02 PM, David Carlson 
>  wrote:
> 
> Maybe I should have mentioned that I do that accidentally all too often...😐
> 
> On Tue, Apr 7, 2020 at 5:59 PM David Carlson 
> wrote:
> 
>> Michael, in fact, you *Can* change the "home' account line.  You will know
>> that it worked when the transaction disappears from the register view.
>> 
>> I don't recommend that because you cannot see what you just did and there
>> is no warning that the transaction will disappear or chance to discard the
>> edit.
>> 
>> On Tue, Apr 7, 2020 at 5:45 PM Michael or Penny Novack <
>> stepbystepf...@comcast.net> wrote:
>> 

___
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 beginner setup

Maybe I should have mentioned that I do that accidentally all too often...😐

On Tue, Apr 7, 2020 at 5:59 PM David Carlson 
wrote:

> Michael, in fact, you *Can* change the "home' account line.  You will know
> that it worked when the transaction disappears from the register view.
>
> I don't recommend that because you cannot see what you just did and there
> is no warning that the transaction will disappear or chance to discard the
> edit.
>
> On Tue, Apr 7, 2020 at 5:45 PM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
>> On 4/7/2020 4:30 PM, jess wrote:
>> > The opening balance in the previous message refers to the current
>> balance I
>> > have on my bank account in real life.
>> >
>> > I was able to solve this too. It works for resolution if the imbalanced
>> > transactions are assigned an account inside the checking account
>> transaction
>> > list. If you try to assign the account in the "Imbalanced" account, it
>> does
>> > not work.
>> >
>> > Why does this happen?
>>
>> I think I understand what is confusing you.
>>
>> You can enter transactions working from any of the accounts affected (if
>> more than one, then it is a "split" transaction. You can specify/change
>> (if editing the transaction) anything about the transaction EXCEPT the
>> account you chose to work in. If you think about that for a second it
>> may become obvious why that should be so.
>>
>> Which means  If you are trying to correct a transaction that has an
>> account of "Imbalance" (an account was not specified; gnucash used the
>> default account "Imbalance") you can't fix that from within the
>> "Imbalance" account. Sure, you find these transactions that need fixing
>> by seeing what transactions, if any, are in the "Imbalance" account.
>> Then in each one see the other (or of a split, others) and go to that
>> transaction there. NOW you can specify the correct account instead of
>> "Imbalance".
>>
>> You were probably looking for/expecting a different process. What
>> gnucash is doing is letting "Imbalance" be just like any other account,
>> no special process.
>>
>> Michael D Novack
>>
>>
>>
>> ___
>> 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
>


-- 
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] GNUCash beginner setup

Michael, in fact, you *Can* change the "home' account line.  You will know
that it worked when the transaction disappears from the register view.

I don't recommend that because you cannot see what you just did and there
is no warning that the transaction will disappear or chance to discard the
edit.

On Tue, Apr 7, 2020 at 5:45 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 4/7/2020 4:30 PM, jess wrote:
> > The opening balance in the previous message refers to the current
> balance I
> > have on my bank account in real life.
> >
> > I was able to solve this too. It works for resolution if the imbalanced
> > transactions are assigned an account inside the checking account
> transaction
> > list. If you try to assign the account in the "Imbalanced" account, it
> does
> > not work.
> >
> > Why does this happen?
>
> I think I understand what is confusing you.
>
> You can enter transactions working from any of the accounts affected (if
> more than one, then it is a "split" transaction. You can specify/change
> (if editing the transaction) anything about the transaction EXCEPT the
> account you chose to work in. If you think about that for a second it
> may become obvious why that should be so.
>
> Which means  If you are trying to correct a transaction that has an
> account of "Imbalance" (an account was not specified; gnucash used the
> default account "Imbalance") you can't fix that from within the
> "Imbalance" account. Sure, you find these transactions that need fixing
> by seeing what transactions, if any, are in the "Imbalance" account.
> Then in each one see the other (or of a split, others) and go to that
> transaction there. NOW you can specify the correct account instead of
> "Imbalance".
>
> You were probably looking for/expecting a different process. What
> gnucash is doing is letting "Imbalance" be just like any other account,
> no special process.
>
> Michael D Novack
>
>
>
> ___
> 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] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread John Ralls

Excellent that you're back in business. What was wrong with the transaction?

Regards,
John Ralls


> On Apr 7, 2020, at 12:15 PM,   wrote:
> 
> Many thanks for that, John.
> 
> I'd already got the same error when I opened the last backup file, which is
> why I assumed it was more than just a corrupt data file.
> 
> I had to go back 3 versions before I found the one that loaded, but I've
> then been able to import all the subsequent log files.
> 
> There was one transaction causing the problem, a foreign currency
> transaction. 
> 
> All now looks good.
> 
> Thanks again for your help.
> 
> Kind regards,
> Rob
> 
> -Original Message-
> From: John Ralls  
> Sent: 07 April 2020 18:34
> To: RobBruce 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] CRIT  [gnc_price_unref()] last unref while
> price in database
> 
> 
> 
>> On Apr 7, 2020, at 9:56 AM, RobBruce  wrote:
>> 
>> I'm running 3.4 on Windows 10.
>> 
>> Until this afternoon, it's been running very smoothly.
>> 
>> On trying to load GnuCash, I got a message that there was an error 
>> parsing the file E:\Documents\gnucash-rob\rob-gnucash.gnucash
>> 
>> I did look for solutions, and opened the trace log, which contains:
>> 
>> * 12:49:21  WARN  Could not spawn perl: Failed to 
>> execute child process (No such file or directory)
>> * 12:49:21  WARN  Could not read from compressed file 
>> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is:
>> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' 
>> (-3)
>> * 12:49:21  CRIT  parse failed at:
>> * 12:49:21  CRIT  [gnc_price_unref()] last unref while 
>> price in database
>> * 12:49:21  CRIT  [gnc_price_unref()] last unref while 
>> price in database 
>> * 12:49:21  WARN  [GncXmlBackend::load()] Syntax error in 
>> Xml File E:\Documents\gnucash-rob\rob-gnucash.gnucash
>> 
>> I'm not aware of having made any change to the file structure - is 
>> this recoverable, please?
> 
> It looks like you have a corrupted file. Try loading the last backup, which
> should be named something like rob-gnucash.gnucash.20200405154732.gnucash;
> the numbers in the middle are a date stamp, mmddhhmmss, for the
> subsequent save. Depending on what work you did in the last session you may
> be able to recover some of it by replaying the corresponding log file with
> File>Import>Replay log file.
> 
> You should also check the drive with `chkdsk` and `wmic diskdrive get
> status` to make sure that the corruption was something random like a cosmic
> ray and not the first sign of needing a new one.
> 
> Regards,
> John Ralls
> 
> 

___
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 beginner setup

2020-04-07 Thread Michael or Penny Novack


On 4/7/2020 4:30 PM, jess wrote:

The opening balance in the previous message refers to the current balance I
have on my bank account in real life.

I was able to solve this too. It works for resolution if the imbalanced
transactions are assigned an account inside the checking account transaction
list. If you try to assign the account in the "Imbalanced" account, it does
not work.

Why does this happen?


I think I understand what is confusing you.

You can enter transactions working from any of the accounts affected (if 
more than one, then it is a "split" transaction. You can specify/change 
(if editing the transaction) anything about the transaction EXCEPT the 
account you chose to work in. If you think about that for a second it 
may become obvious why that should be so.


Which means  If you are trying to correct a transaction that has an 
account of "Imbalance" (an account was not specified; gnucash used the 
default account "Imbalance") you can't fix that from within the 
"Imbalance" account. Sure, you find these transactions that need fixing 
by seeing what transactions, if any, are in the "Imbalance" account. 
Then in each one see the other (or of a split, others) and go to that 
transaction there. NOW you can specify the correct account instead of 
"Imbalance".


You were probably looking for/expecting a different process. What 
gnucash is doing is letting "Imbalance" be just like any other account, 
no special process.


Michael D Novack



___
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] Australian Foreign Investments Taxation

2020-04-07 Thread David H

Hi Ben,

Isn't Libre Office able to highlight a column and change the date format
from dd/mmm/ccyy to dd/mm/ccyy for instance ??

Cheers David H.

On Wed, 8 Apr 2020 at 00:54, Ben Stanley  wrote:

> Hello Gnucash Users,
>
> I have now downloaded the foreign exchange rates from the Reserve Bank
> of Australia:
> https://rba.gov.au/statistics/historical-data.html#exchange-rates
>
> Note that the exchange rate data is published in an Excel .xls file. I
> used LibreOffice to save it as a .csv for import into GnuCash.
>
> In this file, the dates are formatted as DD-Mon-. For example:
> 18-May-2019
>
> GnuCash cannot understand dates formatted this way. (I tested against
> git 3.9-19 on branch maint.)
>
> I made some modifications to gnucash/libgnucash/engine/gnc-datetime.cpp
> that allow GnuCash to import the RBA data with word date months. The
> changes are very rough, and do not include any internationalisation. I
> would appreciate constructive feedback. Flames -> /dev/null.
>
> I note here that I have not tested this patch with dates of format
> DD-MM-.
>
> Perhaps I should sign up to the gnucash-devel mailing list...
>
> Ben.
>
> On 7/4/20 7:28 pm, Christopher Lam wrote:
> > Yes, you can do that. File import prices from CSV.
> >
> > On Tue, 7 Apr 2020, 5:22 pm Ben Stanley,  > > wrote:
> >
> > I can get a CSV file of daily exchange rate data. Is there a way
> > of importing it into the price database?
> >
> > On 7 April 2020 7:17:54 pm Christopher Lam
> > mailto:christopher@gmail.com>>
> wrote:
> >
> >> The only report which is capable of using closest-to-date
> >> conversion is the Transaction Report from the
> >> Income:Dividends(USD) and Income:CapGains(USD) accounts, using a
> >> Report Currency of AUD. It will choose the USD/AUD price from the
> >> price editor list closest to each transaction's posting date.
> >>
> >> You'll have to ensure the price list has prices at your desired
> >> dates manually.
> >>
> >> On Tue, 7 Apr 2020 at 09:13, Ben Stanley  >> > wrote:
> >>
> >> Hello Gnucash people,
> >>
> >> This question may be more suited to Gnucash developers, but
> >> lets try it
> >> here first.
> >>
> >> I need to perform a tax calculation in accordance with
> >> instructions from
> >> the Australian Taxation Office. All foreign income,
> >> deductions and
> >> foreign tax paid must be converted to Australian Dollars for
> >> tax purposes.
> >>
> >>
> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/
> >>
> >> The conversion used must correspond to the transaction date.
> >>
> >> In Gnucash, it would appear that the price editor could be
> >> used to enter
> >> the necessary conversion data, if it were easy to see all of
> >> the dates
> >> where conversions are required. However, this is tedious.
> >>
> >> Far better would be to use Finance::Quote to fetch the necessary
> >> conversion data for the dates it is required for. However, it
> >> seems that
> >> Finance::Quote is only capable of fetching "recent" data. (The
> >> documentation that I looked at seemed to be very old.)
> >>
> >> http://finance-quote.sourceforge.net/documentation.html
> >>
> >> What is needed is the ability to pass a date, or a range of
> >> dates, and
> >> request Finance::Quote to fetch prices for that date or date
> >> interval.
> >> This would make Finance::Quote far more useful than just
> >> fetching the
> >> most recent price data.
> >>
> >> Is there some feature in Gnucash that I have missed that
> >> would allow me
> >> to generate a report, with dividends and Capital Gains
> >> converted from
> >> USD -> AUD using the currency conversion as at the
> >> transaction dates?
> >>
> >> Thanks,
> >> Ben Stanley.
> >>
> >>
> >> ___
> >> 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/mailma

Re: [GNC] GNUCash beginner setup

In any register view you can highlight the account name in a split line if
you are in the Auto-split ledger or transduction journal view, right click
and select any account name in the drop-down list.  If you happen to be in
the only split line of a transaction that is the same as the current
account register, it may take a short time for the program to react, but
the transaction will eventually disappear from that register view because
it no longer has a split assigned to that account.

On Tue, Apr 7, 2020 at 3:33 PM jess  wrote:

> The opening balance in the previous message refers to the current balance I
> have on my bank account in real life.
>
> I was able to solve this too. It works for resolution if the imbalanced
> transactions are assigned an account inside the checking account
> transaction
> list. If you try to assign the account in the "Imbalanced" account, it does
> not work.
>
> Why does this happen?
>
>
>
> --
> 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.
>


-- 
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] Starting Balance in Reconciliation Window wrong

2020-04-07 Thread David Cousens

Thanks Maf,

Yes it does shed a bit of light. Funny when I searched the bug list on
reconciliation it didn't throw up
Christopher Lam's feature 797640  or the earlier 797040 as well as Dave
Reiser's thread. I am in discussion With Christopher Lam about the situation
in Bugzilla (bug 797668).

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] GNUCash beginner setup

2020-04-07 Thread jess

The opening balance in the previous message refers to the current balance I
have on my bank account in real life.

I was able to solve this too. It works for resolution if the imbalanced
transactions are assigned an account inside the checking account transaction
list. If you try to assign the account in the "Imbalanced" account, it does
not work. 

Why does this happen?



--
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] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread rgwbruce

Many thanks for that, John.

I'd already got the same error when I opened the last backup file, which is
why I assumed it was more than just a corrupt data file.

I had to go back 3 versions before I found the one that loaded, but I've
then been able to import all the subsequent log files.

There was one transaction causing the problem, a foreign currency
transaction. 

All now looks good.

Thanks again for your help.

Kind regards,
Rob

-Original Message-
From: John Ralls  
Sent: 07 April 2020 18:34
To: RobBruce 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] CRIT  [gnc_price_unref()] last unref while
price in database

> On Apr 7, 2020, at 9:56 AM, RobBruce  wrote:
> 
> I'm running 3.4 on Windows 10.
> 
> Until this afternoon, it's been running very smoothly.
> 
> On trying to load GnuCash, I got a message that there was an error 
> parsing the file E:\Documents\gnucash-rob\rob-gnucash.gnucash
> 
> I did look for solutions, and opened the trace log, which contains:
> 
> * 12:49:21  WARN  Could not spawn perl: Failed to 
> execute child process (No such file or directory)
> * 12:49:21  WARN  Could not read from compressed file 
> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is:
> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' 
> (-3)
> * 12:49:21  CRIT  parse failed at:
> * 12:49:21  CRIT  [gnc_price_unref()] last unref while 
> price in database
> * 12:49:21  CRIT  [gnc_price_unref()] last unref while 
> price in database 
> * 12:49:21  WARN  [GncXmlBackend::load()] Syntax error in 
> Xml File E:\Documents\gnucash-rob\rob-gnucash.gnucash
> 
> I'm not aware of having made any change to the file structure - is 
> this recoverable, please?

It looks like you have a corrupted file. Try loading the last backup, which
should be named something like rob-gnucash.gnucash.20200405154732.gnucash;
the numbers in the middle are a date stamp, mmddhhmmss, for the
subsequent save. Depending on what work you did in the last session you may
be able to recover some of it by replaying the corresponding log file with
File>Import>Replay log file.

You should also check the drive with `chkdsk` and `wmic diskdrive get
status` to make sure that the corruption was something random like a cosmic
ray and not the first sign of needing a new one.

Regards,
John Ralls

___
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 3.9 Flathub stucks

Geert offered the command(s). Try that first.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 1:55 PM, Finfort  wrote:
> 
> Thank you Adrien.
> Maybe it is better to build it myself from the last source?
> 
> 
>> On Apr 7, 2020 at 21:38,  wrote:
>> 
>> That’s why I mentioned ’flatpak specifics’. Search for 'how to launch a 
>> flatpak app from the command line'. Sorry, I don’t use them so I don’t know 
>> the syntax right-off.
>> 
>> Regards,
>> Adrien
>> 
>> > On Apr 7, 2020 w15d98, at 1:26 PM, Finfort  wrote:
>> >  
>> > Thank you, but what is the command to start it?
>> > Just "gnucash" does not work...
>> >  
>> >  
>> >> On Apr 7, 2020 at 19:36,  wrote:
>> >>  
>> >> Not sure about Flatpak specifics, but I would start it from the command 
>> >> line and see if there is any output that lends some clues.
>> >>  
>> >> Regards,
>> >> Adrien
>> >>  
>> >> > On Apr 7, 2020 w15d98, at 6:28 AM, Finfort  wrote:
>> >> >   
>> >> >   
>> >> >   
>> >> >   
>> >> > Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10 
>> >> > when starting. After that shows it’s logo,boots and works normally.
>> >> >   
>> >> > Sometimes it freezes all the system when starting and all you can do is 
>> >> > only cold restart.
>> >> >   
>> >> >   
>> >> >   
>> >> > Does anybody have the same problem?


___
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] Improve imported transaction category matching

What type of import? QIF, CSV?

Regards,
Adrien

p.s. —please be sure to ‘reply-list’ or ‘reply-all’ so others can benefit from 
the discussion and/or offer help.

> On Apr 7, 2020 w15d98, at 2:01 PM, Giuseppe Quinn  wrote:
> 
> Yea, I’ve done them over and over in the import window, to no avail.
> 
> 
>> On Apr 7, 2020, at 12:54 PM, Adrien Monteleone 
>>  wrote:
>> 
>> Make sure you are doing those assignments within the import window. If you 
>> import first, then edit transactions to correct Imbalance-xyz to proper 
>> accounts, the importer never gets to learn.
>> 
>> Regards,
>> Adrien
>> 
>>> On Apr 7, 2020 w15d98, at 1:45 PM, Giuseppe Quinn  
>>> wrote:
>>> 
>>> Is there a way to improve category matching of imported transactions? Every 
>>> session I have to tell GC which category grocery store transactions, CC 
>>> payments, and every other repeating transaction, which category they go 
>>> into. 

___
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 3.9 Flathub stucks

2020-04-07 Thread Finfort

  
  

 Thank you Adrien.
  
Maybe it is better to build it myself from the last source?
  

  
  

  
  
>   
> On Apr 7, 2020 at 21:38,   (mailto:adrien.montele...@lusfiber.net)>  wrote:
>   
>   
>   
>  That’s why I mentioned ’flatpak specifics’. Search for 'how to launch a 
> flatpak app from the command line'. Sorry, I don’t use them so I don’t know 
> the syntax right-off. Regards, Adrien  >  On Apr 7, 2020 w15d98, at 1:26 PM, 
> Finfortwrote:  >   >  Thank you, but what is the 
> command to start it?  >  Just "gnucash" does not work...  >   >   >>  On Apr 
> 7, 2020 at 19:36,wrote:  >>   >>  Not sure about 
> Flatpak specifics, but I would start it from the command line and see if 
> there is any output that lends some clues.  >>   >>  Regards,  >>  Adrien  >> 
>   >>   >  On Apr 7, 2020 w15d98, at 6:28 AM, Finfort
> wrote:  >>   >   >>   >   >>   >   >>   >   >>   >  Gnucash 3.9 Flathub 
> stucks for about 5 minutes on Ubuntu 18.04, 19.10 when starting. After that 
> shows it’s logo, boots and works normally.  >>   >   >>   >  Sometimes it 
> freezes all the system when starting and all you can do is only cold restart. 
>  >>   >   >>   >   >>   >   >>   >  Does anybody have the same problem? 
> ___ 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] Improve imported transaction category matching

Make sure you are doing those assignments within the import window. If you 
import first, then edit transactions to correct Imbalance-xyz to proper 
accounts, the importer never gets to learn.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 1:45 PM, Giuseppe Quinn  wrote:
> 
> Is there a way to improve category matching of imported transactions? Every 
> session I have to tell GC which category grocery store transactions, CC 
> payments, and every other repeating transaction, which category they go into. 

___
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] Improve imported transaction category matching

2020-04-07 Thread Giuseppe Quinn

Is there a way to improve category matching of imported transactions? Every 
session I have to tell GC which category grocery store transactions, CC 
payments, and every other repeating transaction, which category they go into. 


___
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 3.9 Flathub stucks

2020-04-07 Thread Geert Janssens

Try

flatpak run org.gnucash.GnuCash

Or even better

flatpak run org.gnucash.GnuCash --logto stdout

The latter will print all logs to the console rather than to an inaccessible 
trace file.

Regards,

Geert

Op dinsdag 7 april 2020 20:31:55 CEST schreef Adrien Monteleone:
> That’s why I mentioned ’flatpak specifics’. Search for 'how to launch a
> flatpak app from the command line'. Sorry, I don’t use them so I don’t know
> the syntax right-off.
> 
> Regards,
> Adrien
> 
> > On Apr 7, 2020 w15d98, at 1:26 PM, Finfort  wrote:
> > 
> > Thank you, but what is the command to start it?
> > Just "gnucash" does not work...
> > 
> >> On Apr 7, 2020 at 19:36,  wrote:
> >> 
> >> Not sure about Flatpak specifics, but I would start it from the command
> >> line and see if there is any output that lends some clues.
> >> 
> >> Regards,
> >> Adrien
> >> 
> >> > On Apr 7, 2020 w15d98, at 6:28 AM, Finfort  wrote:
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10
> >> > when starting. After that shows it’s logo,boots and works
> >> > normally.
> >> > 
> >> > Sometimes it freezes all the system when starting and all you can do is
> >> > only cold restart.
> >> > 
> >> > 
> >> > 
> >> > Does anybody have the same problem?
> 
> ___
> 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] Inability to import CSV files.

2020-04-07 Thread Geert Janssens

Hi Aixza,

It's proper to send your replies to the list (using e-mail address 
gnucash-user@gnucash.org) 
rather than sending to individuals. By keeping the conversation on the list 
others can benefit 
from the answers given or chime in whenever appropriate.

Having said that it's very unlikely "something has been erased". Please send us 
a screenshot (to 
gnucash-user@gnucash.org) of your import window as Adrien also asked.

You also didn't mention the version of gnucash you are using. Please be sure to 
test with the 
latest version which currently is 3.9.

Regards,

Geert

Op dinsdag 7 april 2020 19:30:57 CEST schreef aixza gonzalez:
> there are no column headings in the page of the importer in the program,
> only columns in the file that is to be imported, I think something has been
> erased in this version. Aixza B. González
> 
> On Tuesday, April 7, 2020, 12:15:19 PM GMT-3, Geert Janssens
>  wrote:
> 
> 
> Hi Aixza,
> 
>  
> 
> Did you try to click on the column headings for each column ? That is the
> way to define the type of each column.
> 
>  
> 
> Regards,
> 
>  
> 
> Geert
> 
>  
> 
> Op dinsdag 7 april 2020 09:46:45 CEST schreef Aixza Gonzalez via gnucash-user:
> > Although I am new to this program it is evident that something is missing
> > in
> > 
> > the program to attain the import of the CSV files. There is no way to
> > 
> > access and define the columns, specially in the transactions import. The
> > 
> > manual instructions cannot be implemented.
> > 
> > 
> > 
> > Sent from Mail for Windows 10
> > 
> > 
> > 
> > ___
> > 
> > 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] Gnucash 3.9 Flathub stucks

That’s why I mentioned ’flatpak specifics’. Search for 'how to launch a flatpak 
app from the command line'. Sorry, I don’t use them so I don’t know the syntax 
right-off.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 1:26 PM, Finfort  wrote:
> 
> Thank you, but what is the command to start it?
> Just "gnucash" does not work...
> 
> 
>> On Apr 7, 2020 at 19:36,  wrote:
>> 
>> Not sure about Flatpak specifics, but I would start it from the command line 
>> and see if there is any output that lends some clues.
>> 
>> Regards,
>> Adrien
>> 
>> > On Apr 7, 2020 w15d98, at 6:28 AM, Finfort  wrote:
>> >  
>> >  
>> >  
>> >  
>> > Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10 when 
>> > starting. After that shows it’s logo,boots and works normally.
>> >  
>> > Sometimes it freezes all the system when starting and all you can do is 
>> > only cold restart.
>> >  
>> >  
>> >  
>> > Does anybody have the same problem?

___
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 record "investment" in gnucash ?

Specifically to your example:

> On Apr 7, 2020 w15d98, at 4:43 AM, Long  wrote:
> 
> Hello,
> 
> First, i'm not accounting, and i don't know what i did is wrong or right. So
> please help me.
> ---
> /Example : this example is just assumed./
> - Jan : I bought a kg* "gold" *cost me *100$*.
> - Feb : My *"gold"* are decreasing from *100$* to *90$*.
> - Mar : My *"gold"* are increasing from *90$* to *120$*. And i want to sell
> it.
> ---

> /With that example, i will record it into gnucash by :/
> - Jan : I transfer *100$* from "*Assets:bank*" to "*Assets:Investment:gold*"

Correct, the transaction would look like:

Dr. Assets:Investment:gold  100
  Cr. Assets:bank   100

> - Feb : I transfer *10$* from "*Assets:Investment:gold*" to "*Equity*"

> - Mar : I transfer *30$* from "*Equity*" to "*Assets:Investment:gold*"

Nope. You don’t enter anything for these. These values are estimates (*if you 
would sell at that time*), not real yet because you haven’t sold it.

*VERY IMPORTANT* - some laws require you to ‘mark to market’ certain assets. In 
that case, you *would* record this fluctuation. But that is generally not the 
case, and even then, only for certain business entities and then, only for 
certain types of investments/assets, and then, only at certain points of the 
year. If this is just for your own personal info, I outlined a better method in 
my other reply.

> - *When i sell it* : i transfer *120$* from "*Assets:Investment:gold*" to
> "*Assets:bank*"

Partly correct. The value in the gold account hasn’t changed before the sale. 
The actual transaction will look something like:

Dr. Assets:bank 120
  Cr. Assets:Investment:gold100
  Cr. Income:Capital Gain/Loss   20

> ---
> /For more information about *Gain and Lost* : /
> - If *Gain*, i transfer that *Money* from "*Income:Investment:gold*" to
> "*Equity*"

> - If *Lost*, i transfer that *Money* from "*Equity*" to
> "*Expense:Investment:gold*"

Only as a result of the sale transaction. There might be tax implications for 
that gain/loss. Your method avoids proper recording.

(Income accounts are technically temporary Equity accounts, so it doesn’t 
matter where you put them exactly as long as you are consistent and know what 
they are for. In GnuCash, Income accounts are set up to be outside of the 
Equity tree, so unless you have a really good reason for doing otherwise, like 
a legal requirement, I’d keep them separate)

Regards,
Adrien

___
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 3.9 Flathub stucks

2020-04-07 Thread Finfort

 Thank you, but what is the command to start it?

Just "gnucash" does not work...

>   
> On Apr 7, 2020 at 19:36,   (mailto:adrien.montele...@lusfiber.net)>  wrote:
>   
>   
>   
>  Not sure about Flatpak specifics, but I would start it from the command line 
> and see if there is any output that lends some clues. Regards, Adrien  >  On 
> Apr 7, 2020 w15d98, at 6:28 AM, Finfortwrote:  >   >   
> >   >   >  Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 
> 19.10 when starting. After that shows it’s logo, boots and works normally.  > 
>   >  Sometimes it freezes all the system when starting and all you can do is 
> only cold restart.  >   >   >   >  Does anybody have the same problem? 
> ___ 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 record "investment" in gnucash ?

I meant ‘investment’ in general terms, but the idea with regard to physical 
assets is the same.

Your local laws will determine when you book increases or decreases in value.

*Generally* this is only done at the sale, when the gain or loss is realized. 
Before a sale, you’re just guessing and estimating.

I have some physical silver on hand. I’ve set up an asset account to track my 
initial balance and later purchases. (I haven’t sold anything, yet)

I set the account currency to XAG (use XAU for Gold) and turned on Trading 
Accounts in File > Properties.

I then either periodically Get Prices, or enter pricing manually as needed.

GnuCash shows me the value of this account in ounces, and offers a USD (in my 
case) equivalent based on the current price. (or an average if that is what I 
chose in report Options, though I prefer ’nearest in time’)

I *only* record purchases in the account. I don’t record fluctuations in value. 
If I were to sell some silver, then and only then, would I record the sale at 
the purchase price, and any difference would be recorded to a gain/loss Income 
(or Equity) account—e.g,

Dr. Cash100
  Cr. Assets:Silver  80
  Cr. Income:Capital Gain20

or

Dr. Cash 60
Dr. Income:Capital Gain  20
  Cr. Assets:Silver  80

Once again, this is a *general* procedure. Your local laws might have specific 
requirements. If you aren’t concerned with official reporting and just want to 
see the current value of your asset, don’t bother with manual transactions, try 
the above method. It is much cleaner and simpler.

If you do have to worry about official asset reporting, talk to a local CPA 
first to find out what you need to do, then we can help with how to do it.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 1:04 PM, Long  wrote:
> 
> Hello,
> 
> Now, i am confusing, i'm talking about "Gold", maybe it look like "House" or
> "Painting", not "Stock". And GnuCash documents had talk about that. And i am
> doing in difference way (easier) to manager that.
> 
> And i am new and not an accounting. So please help me by guide me more if
> you can. Thank you.
> 
> Regards.

___
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 record "investment" in gnucash ?

2020-04-07 Thread Long

Hello,

Now, i am confusing, i'm talking about "Gold", maybe it look like "House" or
"Painting", not "Stock". And GnuCash documents had talk about that. And i am
doing in difference way (easier) to manager that.

And i am new and not an accounting. So please help me by guide me more if
you can. Thank you.

Regards.



--
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] GNUCash beginner setup

By ‘opening balance’ do you mean in the account register (1st transaction) or 
when doing a reconciliation?

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 10:14 AM, denz  wrote:
> 
> Thanks David and Adrian. I have an update for you. 
> 
> I was able to get things working now and categorisation works better and
> closer to my desirable behaviour. The only difference between earlier and
> now was the time sequence on how I imported the transactions.Earlier, I
> imported the statements in a backward time sequence. In the sense, I
> uploaded Q1 2020 followed with Q4 2019, Q3 2019 and so on. Now, I do it as
> Q1 2016, Q2 2016 and so on. I notice a clear difference if I use the serial
> sequence rather than the backward one. 
> 
> Now, I have one final question. I have imported transactions of both Bank1
> (1400 transactions over 4 years) and Bank2 (80 transactions over 1 year).
> Both, the account balances match. I do see however, 4 imbalanced
> transactions from Bank1. How do I exactly resolve this? All these
> transactions belong to Expense accounts. I tried assigning them to my
> Expense Accounts but if I do so, the opening balance for Bank1 does not
> match and is off my the sum of the 4 imbalanced transactions viz. €94,38. I
> understand the double entry nature of book keeping but I wonder why these 4
> transactions stood out and if I could resolve these imbalances without any
> "hack".
> 
> Thank you for your time!
> 
> 
> 
> Details 
> 
> GNUCash Version 3.9
> macOS 10.15.4 (Catalina)

___
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] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread John Ralls

> On Apr 7, 2020, at 9:56 AM, RobBruce  wrote:
> 
> I'm running 3.4 on Windows 10.
> 
> Until this afternoon, it's been running very smoothly.
> 
> On trying to load GnuCash, I got a message that there was an error parsing
> the file E:\Documents\gnucash-rob\rob-gnucash.gnucash 
> 
> I did look for solutions, and opened the trace log, which contains:
> 
> * 12:49:21  WARN  Could not spawn perl: Failed to execute
> child process (No such file or directory)
> * 12:49:21  WARN  Could not read from compressed file
> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is:
> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' (-3)
> * 12:49:21  CRIT  parse failed at:
> * 12:49:21  CRIT  [gnc_price_unref()] last unref while price in
> database
> * 12:49:21  CRIT  [gnc_price_unref()] last unref while price in
> database
> 
> * 12:49:21  WARN  [GncXmlBackend::load()] Syntax error in Xml
> File E:\Documents\gnucash-rob\rob-gnucash.gnucash
> 
> I'm not aware of having made any change to the file structure - is this
> recoverable, please? 

It looks like you have a corrupted file. Try loading the last backup, which 
should be named something like rob-gnucash.gnucash.20200405154732.gnucash; the 
numbers in the middle are a date stamp, mmddhhmmss, for the subsequent 
save. Depending on what work you did in the last session you may be able to 
recover some of it by replaying the corresponding log file with 
File>Import>Replay log file.

You should also check the drive with `chkdsk` and `wmic diskdrive get status` 
to make sure that the corruption was something random like a cosmic ray and not 
the first sign of needing a new one.

Regards,
John Ralls

___
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 record "investment" in gnucash ?

Also, GnuCash can show you what your investment is valued without booking 
actual transactions. Those are generally only done when the actual sale goes 
through.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 6:36 AM, Ben Stanley  wrote:
> 
> Hello,
> 
> Please check this page of the manual. It explains what you need to know here.
> 
> https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-buy-stock1.html
> 
> I hope that helps!
> 
> On 7 April 2020 7:45:17 pm Long  wrote:
> 
>> Hello,
>> 
>> First, i'm not accounting, and i don't know what i did is wrong or right. So
>> please help me.
>> ---
>> /Example : this example is just assumed./
>> - Jan : I bought a kg* "gold" *cost me *100$*.
>> - Feb : My *"gold"* are decreasing from *100$* to *90$*.
>> - Mar : My *"gold"* are increasing from *90$* to *120$*. And i want to sell
>> it.
>> ---
>> /With that example, i will record it into gnucash by :/
>> - Jan : I transfer *100$* from "*Assets:bank*" to "*Assets:Investment:gold*"
>> - Feb : I transfer *10$* from "*Assets:Investment:gold*" to "*Equity*"
>> - Mar : I transfer *30$* from "*Equity*" to "*Assets:Investment:gold*"
>> - *When i sell it* : i transfer *120$* from "*Assets:Investment:gold*" to
>> "*Assets:bank*"
>> ---
>> /For more information about *Gain and Lost* : /
>> - If *Gain*, i transfer that *Money* from "*Income:Investment:gold*" to
>> "*Equity*"
>> - If *Lost*, i transfer that *Money* from "*Equity*" to
>> "*Expense:Investment:gold*"
>> 
>> Thank you so much for spending time to help me.
>> 


___
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] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread RobBruce

I'm running 3.4 on Windows 10.

Until this afternoon, it's been running very smoothly.

On trying to load GnuCash, I got a message that there was an error parsing
the file E:\Documents\gnucash-rob\rob-gnucash.gnucash 

I did look for solutions, and opened the trace log, which contains:

* 12:49:21  WARN  Could not spawn perl: Failed to execute
child process (No such file or directory)
* 12:49:21  WARN  Could not read from compressed file
'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is:
'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' (-3)
* 12:49:21  CRIT  parse failed at:
* 12:49:21  CRIT  [gnc_price_unref()] last unref while price in
database
* 12:49:21  CRIT  [gnc_price_unref()] last unref while price in
database

* 12:49:21  WARN  [GncXmlBackend::load()] Syntax error in Xml
File E:\Documents\gnucash-rob\rob-gnucash.gnucash

I'm not aware of having made any change to the file structure - is this
recoverable, please? 
Thanks,
Rob





--
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] Gnucash 3.9 Flathub stucks

Not sure about Flatpak specifics, but I would start it from the command line 
and see if there is any output that lends some clues.

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 6:28 AM, Finfort  wrote:
> 
> 
> 
> 
> Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10 when 
> starting. After that shows it’s logo,boots and works normally.
> 
> Sometimes it freezes all the system when starting and all you can do is only 
> cold restart.
> 
> 
> 
> Does anybody have the same problem?

___
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] Inability to import CSV files.

Can you provide a screenshot? (attach, don’t paste in-line, or maybe just link 
to a hosting site)

The Help manual shows the import screen with drop downs to define each column.

See § "6.15.4 Import CSV” : 
https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#trans-import-csv

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 2:46 AM, Aixza Gonzalez via gnucash-user 
>  wrote:
> 
> Although I am new to this program it is evident that something is missing in 
> the program to attain the import of the CSV files.  There is no way to access 
> and define the columns, specially in the transactions import.  The manual 
> instructions cannot be implemented.
> 
> Sent from Mail for Windows 10

___
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] [GNC-dev] About 3.9 and reconciliation balances

I concur with this part. Rather than change the calculation, do a check for an 
errant ending date. Introduce some means to do a check on the whole file as a 
‘first run’ event on upgrading. Provide a means to edit the errant data 
directly rather than revert and re-reconcile. Reconciliation data should 
somehow be visible to the user if at least in the form of a report.

This may or may not dovetail with being able to correct a reconciliation that 
was blown up as a result of editing spelling in a Description where the 
transaction gets its flag changed. (I understand that is something different, 
but the correction mechanism might be able apply to both cases)

Regards,
Adrien

> On Apr 7, 2020 w15d98, at 5:20 AM, D. via gnucash-devel 
>  wrote:
> 
> Perhaps you should revert this change for the time being, until such time as 
> you figure out a solution that works for the user base. For example, give the 
> user an interface that allows them to see and fix the kinds of errors you've 
> already identified. 
> 
> As for your proposed safeguards, option 2 should better be implemented by 
> giving the user a listing of spurious reconciled txns, and giving them some 
> interface to set a proper date (or a better one) on a group or individual 
> basis, rather than arbitrarily creating a date that will cause the user to 
> question the quality of their data sometime down the road.  
> 
> David T.

___
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] Inability to import CSV files.

2020-04-07 Thread Geert Janssens via gnucash-user

Hi Aixza,

Did you try to click on the column headings for each column ? That is the way 
to define the type 
of each column.

Regards,

Geert

Op dinsdag 7 april 2020 09:46:45 CEST schreef Aixza Gonzalez via gnucash-user:
> Although I am new to this program it is evident that something is missing in
> the program to attain the import of the CSV files.  There is no way to
> access and define the columns, specially in the transactions import.  The
> manual instructions cannot be implemented.
> 
> Sent from Mail for Windows 10
> 
> ___
> 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] GNUCash beginner setup

2020-04-07 Thread denz

Thanks David and Adrian. I have an update for you. 

I was able to get things working now and categorisation works better and
closer to my desirable behaviour. The only difference between earlier and
now was the time sequence on how I imported the transactions.Earlier, I
imported the statements in a backward time sequence. In the sense, I
uploaded Q1 2020 followed with Q4 2019, Q3 2019 and so on. Now, I do it as
Q1 2016, Q2 2016 and so on. I notice a clear difference if I use the serial
sequence rather than the backward one. 

Now, I have one final question. I have imported transactions of both Bank1
(1400 transactions over 4 years) and Bank2 (80 transactions over 1 year).
Both, the account balances match. I do see however, 4 imbalanced
transactions from Bank1. How do I exactly resolve this? All these
transactions belong to Expense accounts. I tried assigning them to my
Expense Accounts but if I do so, the opening balance for Bank1 does not
match and is off my the sum of the 4 imbalanced transactions viz. €94,38. I
understand the double entry nature of book keeping but I wonder why these 4
transactions stood out and if I could resolve these imbalances without any
"hack".

Thank you for your time!



Details 

GNUCash Version 3.9
macOS 10.15.4 (Catalina)



--
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] Inability to import CSV files.


What version of GnuCash are you using?

On 7 April 2020 7:16:54 pm Aixza Gonzalez via gnucash-user 
 wrote:


Although I am new to this program it is evident that something is missing 
in the program to attain the import of the CSV files.  There is no way to 
access and define the columns, specially in the transactions import.  The 
manual instructions cannot be implemented.


Sent from Mail for Windows 10

___
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] Australian Foreign Investments Taxation


Hello Gnucash Users,

I have now downloaded the foreign exchange rates from the Reserve Bank 
of Australia:

https://rba.gov.au/statistics/historical-data.html#exchange-rates

Note that the exchange rate data is published in an Excel .xls file. I 
used LibreOffice to save it as a .csv for import into GnuCash.


In this file, the dates are formatted as DD-Mon-. For example:
18-May-2019

GnuCash cannot understand dates formatted this way. (I tested against 
git 3.9-19 on branch maint.)


I made some modifications to gnucash/libgnucash/engine/gnc-datetime.cpp 
that allow GnuCash to import the RBA data with word date months. The 
changes are very rough, and do not include any internationalisation. I 
would appreciate constructive feedback. Flames -> /dev/null.


I note here that I have not tested this patch with dates of format 
DD-MM-.


Perhaps I should sign up to the gnucash-devel mailing list...

Ben.

On 7/4/20 7:28 pm, Christopher Lam wrote:

Yes, you can do that. File import prices from CSV.

On Tue, 7 Apr 2020, 5:22 pm Ben Stanley, > wrote:


I can get a CSV file of daily exchange rate data. Is there a way
of importing it into the price database?

On 7 April 2020 7:17:54 pm Christopher Lam
mailto:christopher@gmail.com>> wrote:


The only report which is capable of using closest-to-date
conversion is the Transaction Report from the
Income:Dividends(USD) and Income:CapGains(USD) accounts, using a
Report Currency of AUD. It will choose the USD/AUD price from the
price editor list closest to each transaction's posting date.

You'll have to ensure the price list has prices at your desired
dates manually.

On Tue, 7 Apr 2020 at 09:13, Ben Stanley mailto:ben.stan...@gmail.com>> wrote:

Hello Gnucash people,

This question may be more suited to Gnucash developers, but
lets try it
here first.

I need to perform a tax calculation in accordance with
instructions from
the Australian Taxation Office. All foreign income,
deductions and
foreign tax paid must be converted to Australian Dollars for
tax purposes.


https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/

The conversion used must correspond to the transaction date.

In Gnucash, it would appear that the price editor could be
used to enter
the necessary conversion data, if it were easy to see all of
the dates
where conversions are required. However, this is tedious.

Far better would be to use Finance::Quote to fetch the necessary
conversion data for the dates it is required for. However, it
seems that
Finance::Quote is only capable of fetching "recent" data. (The
documentation that I looked at seemed to be very old.)

http://finance-quote.sourceforge.net/documentation.html

What is needed is the ability to pass a date, or a range of
dates, and
request Finance::Quote to fetch prices for that date or date
interval.
This would make Finance::Quote far more useful than just
fetching the
most recent price data.

Is there some feature in Gnucash that I have missed that
would allow me
to generate a report, with dividends and Capital Gains
converted from
USD -> AUD using the currency conversion as at the
transaction dates?

Thanks,
Ben Stanley.


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



Author: Ben Stanley   2020-04-08 00:32:32
Committer: Ben Stanley   2020-04-08 00:32:32
Parent: 2bdc9366958c243d9d3910921a0dc77ff3186cb7 (Merge Jean Laroche's '797006_subaccounts' into maint.)
Branch: GncDate_with_named_month
Follows: 3.9
Precedes: 

Add support for named months in GncDate.
This is useful for importing data from external sources.
This preliminary patch works for months named in English.
No internationalisation support has been added.
The burden of enumerating month names and conversion
should be delegated to the boost library. This may simplify
internationalisation.

-- libgnucash/engine/gnc-datetime.cpp --
index 2192ffd3f..641891145 100644
@@ -80,6 +80,9 @@ static constexpr auto ticks_per_second = INT64_C(100);
 static c

Re: [GNC] How to record "investment" in gnucash ?


Hello,

Please check this page of the manual. It explains what you need to know here.

https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-buy-stock1.html

I hope that helps!

On 7 April 2020 7:45:17 pm Long  wrote:


Hello,

First, i'm not accounting, and i don't know what i did is wrong or right. So
please help me.
---
/Example : this example is just assumed./
- Jan : I bought a kg* "gold" *cost me *100$*.
- Feb : My *"gold"* are decreasing from *100$* to *90$*.
- Mar : My *"gold"* are increasing from *90$* to *120$*. And i want to sell
it.
---
/With that example, i will record it into gnucash by :/
- Jan : I transfer *100$* from "*Assets:bank*" to "*Assets:Investment:gold*"
- Feb : I transfer *10$* from "*Assets:Investment:gold*" to "*Equity*"
- Mar : I transfer *30$* from "*Equity*" to "*Assets:Investment:gold*"
- *When i sell it* : i transfer *120$* from "*Assets:Investment:gold*" to
"*Assets:bank*"
---
/For more information about *Gain and Lost* : /
- If *Gain*, i transfer that *Money* from "*Income:Investment:gold*" to
"*Equity*"
- If *Lost*, i transfer that *Money* from "*Equity*" to
"*Expense:Investment:gold*"

Thank you so much for spending time to help me.



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




___
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.9 Flathub stucks

2020-04-07 Thread Finfort

  
  

 Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10 when 
starting. After that shows it’s logo,boots and works normally.
  
Sometimes it freezes all the system when starting and all you can do is only 
cold restart.
  

  
Does anybody have the same problem?
  

  
  

  
 
___
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] Australian Foreign Investments Taxation

2020-04-07 Thread pobox . deva

Ben,

I use the CSV Price Importer for loading stock/mutual fund prices every month 
(all in INR).

Though I haven’t used this in the context of currency exchange rates, I think 
it should be possible because you are essentially converting price from one 
commodity to another in both scenarios.

The CSV Price Importer works very well and it even has a Save Template option, 
which you can reuse on future imports.

Easy, peasy!

Cheers,
Deva

> On 07-Apr-2020, at 2:52 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Message: 12
> Date: Tue, 07 Apr 2020 19:22:19 +1000
> From: Ben Stanley mailto:ben.stan...@gmail.com>>
> To: Christopher Lam  >
> Cc: GnuCash users group  >
> Subject: Re: [GNC] Australian Foreign Investments Taxation
> Message-ID:
>   <17153f294f8.27d0.e122910561de4a0ea07b2811c86c2...@gmail.com 
> >
> Content-Type: text/plain; format=flowed; charset="us-ascii"
> 
> I can get a CSV file of daily exchange rate data. Is there a way of 
> importing it into the price database?
> 
> On 7 April 2020 7:17:54 pm Christopher Lam  > wrote:
>> The only report which is capable of using closest-to-date conversion is the 
>> Transaction Report from the Income:Dividends(USD) and Income:CapGains(USD) 
>> accounts, using a Report Currency of AUD. It will choose the USD/AUD price 
>> from the price editor list closest to each transaction's posting date.
>> 
>> You'll have to ensure the price list has prices at your desired dates 
>> manually.
>> 
>> 
>> 
>> On Tue, 7 Apr 2020 at 09:13, Ben Stanley > > wrote:
>> 
>> Hello Gnucash people,
>> 
>> This question may be more suited to Gnucash developers, but lets try it
>> here first.
>> 
>> I need to perform a tax calculation in accordance with instructions from
>> the Australian Taxation Office. All foreign income, deductions and
>> foreign tax paid must be converted to Australian Dollars for tax purposes.
>> 
>> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/
>>  
>> 
>> 
>> The conversion used must correspond to the transaction date.
>> 
>> In Gnucash, it would appear that the price editor could be used to enter
>> the necessary conversion data, if it were easy to see all of the dates
>> where conversions are required. However, this is tedious.
>> 
>> Far better would be to use Finance::Quote to fetch the necessary
>> conversion data for the dates it is required for. However, it seems that
>> Finance::Quote is only capable of fetching "recent" data. (The
>> documentation that I looked at seemed to be very old.)
>> 
>> http://finance-quote.sourceforge.net/documentation.html 
>> 
>> 
>> What is needed is the ability to pass a date, or a range of dates, and
>> request Finance::Quote to fetch prices for that date or date interval.
>> This would make Finance::Quote far more useful than just fetching the
>> most recent price data.
>> 
>> Is there some feature in Gnucash that I have missed that would allow me
>> to generate a report, with dividends and Capital Gains converted from
>> USD -> AUD using the currency conversion as at the transaction dates?
>> 
>> Thanks,
>> Ben Stanley.
>> 

___
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] How to record "investment" in gnucash ?

2020-04-07 Thread Long

Hello,

First, i'm not accounting, and i don't know what i did is wrong or right. So
please help me.
---
/Example : this example is just assumed./
- Jan : I bought a kg* "gold" *cost me *100$*.
- Feb : My *"gold"* are decreasing from *100$* to *90$*.
- Mar : My *"gold"* are increasing from *90$* to *120$*. And i want to sell
it.
---
/With that example, i will record it into gnucash by :/
- Jan : I transfer *100$* from "*Assets:bank*" to "*Assets:Investment:gold*"
- Feb : I transfer *10$* from "*Assets:Investment:gold*" to "*Equity*"
- Mar : I transfer *30$* from "*Equity*" to "*Assets:Investment:gold*"
- *When i sell it* : i transfer *120$* from "*Assets:Investment:gold*" to
"*Assets:bank*"
---
/For more information about *Gain and Lost* : /
- If *Gain*, i transfer that *Money* from "*Income:Investment:gold*" to
"*Equity*"
- If *Lost*, i transfer that *Money* from "*Equity*" to
"*Expense:Investment:gold*"

Thank you so much for spending time to help me.



--
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] Australian Foreign Investments Taxation

2020-04-07 Thread Christopher Lam

Yes, you can do that. File import prices from CSV.

On Tue, 7 Apr 2020, 5:22 pm Ben Stanley,  wrote:

> I can get a CSV file of daily exchange rate data. Is there a way of
> importing it into the price database?
>
> On 7 April 2020 7:17:54 pm Christopher Lam 
> wrote:
>
>> The only report which is capable of using closest-to-date conversion is
>> the Transaction Report from the Income:Dividends(USD) and
>> Income:CapGains(USD) accounts, using a Report Currency of AUD. It will
>> choose the USD/AUD price from the price editor list closest to each
>> transaction's posting date.
>>
>> You'll have to ensure the price list has prices at your desired dates
>> manually.
>>
>> On Tue, 7 Apr 2020 at 09:13, Ben Stanley  wrote:
>>
>>> Hello Gnucash people,
>>>
>>> This question may be more suited to Gnucash developers, but lets try it
>>> here first.
>>>
>>> I need to perform a tax calculation in accordance with instructions from
>>> the Australian Taxation Office. All foreign income, deductions and
>>> foreign tax paid must be converted to Australian Dollars for tax
>>> purposes.
>>>
>>>
>>> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/
>>>
>>> The conversion used must correspond to the transaction date.
>>>
>>> In Gnucash, it would appear that the price editor could be used to enter
>>> the necessary conversion data, if it were easy to see all of the dates
>>> where conversions are required. However, this is tedious.
>>>
>>> Far better would be to use Finance::Quote to fetch the necessary
>>> conversion data for the dates it is required for. However, it seems that
>>> Finance::Quote is only capable of fetching "recent" data. (The
>>> documentation that I looked at seemed to be very old.)
>>>
>>> http://finance-quote.sourceforge.net/documentation.html
>>>
>>> What is needed is the ability to pass a date, or a range of dates, and
>>> request Finance::Quote to fetch prices for that date or date interval.
>>> This would make Finance::Quote far more useful than just fetching the
>>> most recent price data.
>>>
>>> Is there some feature in Gnucash that I have missed that would allow me
>>> to generate a report, with dividends and Capital Gains converted from
>>> USD -> AUD using the currency conversion as at the transaction dates?
>>>
>>> Thanks,
>>> Ben Stanley.
>>>
>>>
>>> ___
>>> 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] Australian Foreign Investments Taxation

I can get a CSV file of daily exchange rate data. Is there a way of
importing it into the price database?

On 7 April 2020 7:17:54 pm Christopher Lam wrote:
The only report which is capable of using closest-to-date conversion is the
Transaction Report from the Income:Dividends(USD) and Income:CapGains(USD)
accounts, using a Report Currency of AUD. It will choose the USD/AUD price
from the price editor list closest to each transaction's posting date.

You'll have to ensure the price list has prices at your desired dates manually.

On Tue, 7 Apr 2020 at 09:13, Ben Stanley wrote:

Hello Gnucash people,

This question may be more suited to Gnucash developers, but lets try it
here first.

I need to perform a tax calculation in accordance with instructions from
the Australian Taxation Office. All foreign income, deductions and
foreign tax paid must be converted to Australian Dollars for tax purposes.

https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/

The conversion used must correspond to the transaction date.

In Gnucash, it would appear that the price editor could be used to enter
the necessary conversion data, if it were easy to see all of the dates
where conversions are required. However, this is tedious.

Far better would be to use Finance::Quote to fetch the necessary
conversion data for the dates it is required for. However, it seems that
Finance::Quote is only capable of fetching "recent" data. (The
documentation that I looked at seemed to be very old.)

http://finance-quote.sourceforge.net/documentation.html

What is needed is the ability to pass a date, or a range of dates, and
request Finance::Quote to fetch prices for that date or date interval.
This would make Finance::Quote far more useful than just fetching the
most recent price data.

Is there some feature in Gnucash that I have missed that would allow me
to generate a report, with dividends and Capital Gains converted from
USD -> AUD using the currency conversion as at the transaction dates?

Thanks,
Ben Stanley.

___
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] Australian Foreign Investments Taxation

2020-04-07 Thread Christopher Lam

The only report which is capable of using closest-to-date conversion is the
Transaction Report from the Income:Dividends(USD) and Income:CapGains(USD)
accounts, using a Report Currency of AUD. It will choose the USD/AUD price
from the price editor list closest to each transaction's posting date.

You'll have to ensure the price list has prices at your desired dates
manually.

On Tue, 7 Apr 2020 at 09:13, Ben Stanley  wrote:

> Hello Gnucash people,
>
> This question may be more suited to Gnucash developers, but lets try it
> here first.
>
> I need to perform a tax calculation in accordance with instructions from
> the Australian Taxation Office. All foreign income, deductions and
> foreign tax paid must be converted to Australian Dollars for tax purposes.
>
>
> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/
>
> The conversion used must correspond to the transaction date.
>
> In Gnucash, it would appear that the price editor could be used to enter
> the necessary conversion data, if it were easy to see all of the dates
> where conversions are required. However, this is tedious.
>
> Far better would be to use Finance::Quote to fetch the necessary
> conversion data for the dates it is required for. However, it seems that
> Finance::Quote is only capable of fetching "recent" data. (The
> documentation that I looked at seemed to be very old.)
>
> http://finance-quote.sourceforge.net/documentation.html
>
> What is needed is the ability to pass a date, or a range of dates, and
> request Finance::Quote to fetch prices for that date or date interval.
> This would make Finance::Quote far more useful than just fetching the
> most recent price data.
>
> Is there some feature in Gnucash that I have missed that would allow me
> to generate a report, with dividends and Capital Gains converted from
> USD -> AUD using the currency conversion as at the transaction dates?
>
> Thanks,
> Ben Stanley.
>
>
> ___
> 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] invisible checkboxes [Solved]

2020-04-07 Thread Graham Menhennitt

On /Apr 6 04:58:58 EDT 2020, Richard Ullger wrote:
/

On 05/04/2020 06:14, Graham Menhennitt wrote:
>>/Something very strange has happened to my GnuCash installation - I no />>/longer have any checkboxes. In dialogs
where I'd expect to see them, />>/there is just blank space. In the reconcile window, when I hover my />>/mouse over a
line, I can see a blank white square where the checkbox />>/would be. If I click the checkbox, the square changes to blue.
But />>/when I move the mouse away, it's invisible again. Other applications />>/seem unaffected. />//>/Sorry, I
forgot to say... I'm running GnuCash 3.8 on FreeBSD 12 with />/KDE5 as my desktop. /
There was a problem with the gtk theme in plasma causing checkboxes not
to be correctly rendered but this is fixed in more recent versions of
plasma.

I can't remember in which version it was fixed but it was working in
plasma 5.18.3. Current version is 5.18.4 and is working there too.

Richard

Thanks very much for replying, Richard.

I did have 5.18.3 and it wasn't working. But I upgraded to 5.18.4 and
it's now all ok.

Thanks for your help.

Regards,

Graham

[GNC] Inability to import CSV files.

2020-04-07 Thread Aixza Gonzalez via gnucash-user

Although I am new to this program it is evident that something is missing in 
the program to attain the import of the CSV files.  There is no way to access 
and define the columns, specially in the transactions import.  The manual 
instructions cannot be implemented.

Sent from Mail for Windows 10

___
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] Australian Foreign Investments Taxation