Re: [GNC] - File Path for associated files

[Adrien Monteleone]

Perhaps someone else who’s come across this might offer some tips, but here’s 
how I’d approach it:

Your data file (if using the default backend) is just an XML file that is 
compressed.

Uncompress it (with tar) and use either your favorite text editor or sed 
command to conduct a find

If you’re using one of the SQL backends, you can run an UPDATE command to 
replace the given text. (research this command well for your particular backend 
before proceeding)

You only need to replace the “G:/documents” or whatever you used part of the 
file path, not the actual pdf file name. If the bulk of the path is the same as 
before, just say mounted on /media instead of G:/ then you only need to replace 
“G:” with “/media” (the slash left over after “:” will continue the path)

In any case, I’d work on a copy of your data file and then check it out to make 
sure everything is fine. Then perhaps store the non-modified copy as an extra 
backup just in case you find a problem down the road.

Don’t forget to change your default path in GnuCash preferences.

Regards,
Adrien

> On Sep 11, 2018, at 7:00 PM, John Sears via gnucash-user 
>  wrote:
> 
> When using the associate files function  for a transaction within
> GNUCash on Windows, I stored all of my pdfs on an  external USB/ SD
> card. Windows  mapped this address  with a letter, G, in this case.  ( I
> also store my accounts on this same card now)
> 
> So my files were all stored on G:/documents/xxx.pdf
> 
> Now that I have transferred to Linux, this path is not recognised - "
> GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf"
> 
> Is there a way to bulk edit the paths of all the  links so that Linux
> will recognise  the SD path?  I would prefer not to go  into every
> single transaction to do this, as I have a lot of linked files.
> 
> Or is there someway ( and this might be more of a Linux question) to map
> the SD card to the "file:///G" terminology.
> 
> Thanks!
> 
> 
> ___
> 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] - File Path for associated files

[John Sears via gnucash-user]

When using the associate files function  for a transaction within
GNUCash on Windows, I stored all of my pdfs on an  external USB/ SD
card. Windows  mapped this address  with a letter, G, in this case.  ( I
also store my accounts on this same card now)

So my files were all stored on G:/documents/xxx.pdf

Now that I have transferred to Linux, this path is not recognised - "
GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf"

Is there a way to bulk edit the paths of all the  links so that Linux
will recognise  the SD path?  I would prefer not to go  into every
single transaction to do this, as I have a lot of linked files.

Or is there someway ( and this might be more of a Linux question) to map
the SD card to the "file:///G" terminology.

Thanks!


___
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] Advanced Portfolio Report - Fund managment fees

[Richard Ullger]

On 11/09/2018 19:57, hal@tutanota.com wrote:
> Unfortunately no, this doesn't work.
> I also tried to create a dummy "buy" split for 0 shares + the fees. This 
> works well for the brokerage fees when buying new shares. But buying 0 share 
> simply doesn't work...
> 11. Sep 2018 19:55 by sunfis...@yahoo.com :
>>
>> Does creating a transaction that credits your brokerage account in the 
>> amount of the fee and directs it to Expenses:Investing:Brokerage Fees not 
>> result in what you seek?
>>

You need to enter a normal sell transaction with the proceeds going to
the cash account and include a split for the charge going from the cash
account to the charge expense account. Otherwise the charge won't get
included in Brokerage Fees on the report.

--

Richard
___
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] Advanced Portfolio Report - Fund managment fees

[hal.lol]

Unfortunately no, this doesn't work.
I also tried to create a dummy "buy" split for 0 shares + the fees. This works 
well for the brokerage fees when buying new shares. But buying 0 share simply 
doesn't work...
11. Sep 2018 19:55 by sunfis...@yahoo.com :
>
> Does creating a transaction that credits your brokerage account in the amount 
> of the fee and directs it to Expenses:Investing:Brokerage Fees not result in 
> what you seek?
>
___
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] Advanced Portfolio Report - Fund managment fees

[David T. via gnucash-user]

Whether a gain is taxable or not is a separate issue from whether a sale 
results in gain, and the usual way (AFAIK) of handling taxed versus untaxed 
anything is to have separate accounts for each (Income:Realized Gains:Taxable 
and Income:Realized Gains:Untaxed).

Does creating a transaction that credits your brokerage account in the amount 
of the fee and directs it to Expenses:Investing:Brokerage Fees not result in 
what you seek?

David

> On Sep 11, 2018, at 12:21 PM,   
> wrote:
> 
>   
> Right,and I can agree with this. It is just a bit confusing because that'sa 
> “realized gain” not subject to taxation (AFAIK), wheras if the moneyended up 
> on my account instead, then it would be.
> But taxationis not my concern for now, and I can live with that. What I 
> reallyneed to figure out is how to add this to the brokerage fees.
> 
> 11. Sep 2018 15:40 by sunfis...@yahoo.com :
> 
> 
>> While I have no comment on how to get the Advanced Portfolio Report to 
>> categorize your fees as such, I will note that when you sell a 
>> commodity—regardless of the reason for which you sell it—you will have (in 
>> most cases) a capital gain element. The gain is there, even if you 
>> immediately turn the proceeds over to another entity. So, it seems to me you 
>> should enter a sell transaction, complete with gains information, and then 
>> enter a transfer to brokerage fees as a separate transaction. I don’t know 
>> how the report handles this.
>> 
>> David T.
>> 
>>> On Sep 11, 2018, at 8:30 AM, <>> hal@tutanota.com 
>>> >> > <>> hal@tutanota.com 
>>> >> > wrote:
>>> 
>>> Hello,
>>> I have a mutual fund account for which the management fees are paid for in 
>>> shares. That is to say, every years, some of my shares are used to pay for 
>>> the fees and my total amount of shares is therefore slightly reduced.
>>> I am trying to setup my accounts/transactions in such a way that early 
>>> management fees for the mutual fund will appear in the report as brokerage 
>>> fees, but so far I haven't been able to figure out the trick to do so. 
>>> First, is this even possible?
>>> If I simply express this by a normal 'sell' operation, where the money goes 
>>> to an expense account, the report shows some 'realized gain' and no 
>>> increase for the 'brokerage fees'. I would like the opposite: the money out 
>>> should be added to the 'brokerage fees' (it goes to an expense account 
>>> after all), and I shouldn't see any 'realized gain'. The total return and 
>>> return rate should of course also be updated accordingly.
>>> I am using Gnucash 2.6.16
>>> Thanks!
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> 
>>> If you are using Nabble or Gmane, please see >> 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>>> >>  for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advanced Portfolio Report - Fund managment fees

[hal.lol]

Right,and I can agree with this. It is just a bit confusing because that'sa 
“realized gain” not subject to taxation (AFAIK), wheras if the moneyended up on 
my account instead, then it would be.
But taxationis not my concern for now, and I can live with that. What I 
reallyneed to figure out is how to add this to the brokerage fees.

11. Sep 2018 15:40 by sunfis...@yahoo.com :


> While I have no comment on how to get the Advanced Portfolio Report to 
> categorize your fees as such, I will note that when you sell a 
> commodity—regardless of the reason for which you sell it—you will have (in 
> most cases) a capital gain element. The gain is there, even if you 
> immediately turn the proceeds over to another entity. So, it seems to me you 
> should enter a sell transaction, complete with gains information, and then 
> enter a transfer to brokerage fees as a separate transaction. I don’t know 
> how the report handles this.
>
> David T.
>
>> On Sep 11, 2018, at 8:30 AM, <>> hal@tutanota.com 
>> >> > <>> hal@tutanota.com 
>> >> > wrote:
>>
>> Hello,
>> I have a mutual fund account for which the management fees are paid for in 
>> shares. That is to say, every years, some of my shares are used to pay for 
>> the fees and my total amount of shares is therefore slightly reduced.
>> I am trying to setup my accounts/transactions in such a way that early 
>> management fees for the mutual fund will appear in the report as brokerage 
>> fees, but so far I haven't been able to figure out the trick to do so. 
>> First, is this even possible?
>> If I simply express this by a normal 'sell' operation, where the money goes 
>> to an expense account, the report shows some 'realized gain' and no increase 
>> for the 'brokerage fees'. I would like the opposite: the money out should be 
>> added to the 'brokerage fees' (it goes to an expense account after all), and 
>> I shouldn't see any 'realized gain'. The total return and return rate should 
>> of course also be updated accordingly.
>> I am using Gnucash 2.6.16
>> Thanks!
>> ___
>> 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] re-adding billable expenses to an invoice

[Christoph R]

> I THOUGHT the query was created every time, but it's possible the query
> only includes the chargeback items before it is posted the first time.
> If you've posted and then unposted the invoice, it's certainly possible
> the logic will not include new chargebacks.

Adding chargebacks to an posted and then unposted invoice worked for me in 
Gnucash 3.2

Cheers,
Christoph

> Am 11.09.2018 um 17:25 schrieb Derek Atkins :
> 
> Hi,
> 
> Matthew Pounsett  writes:
> 
>> On 6 September 2018 at 12:04, Derek Atkins  wrote:
>> 
>>Matthew Pounsett  writes:
>> 
>>> I accidentally flubbed some keyboard entry while putting together an
>>> invoice and messed up a billable expense item which had been
>>automatically
>>> added when the invoice was created.  Since there is no "Undo" the best
>>> option seemed to be to delete the entry and start over, but I can't find
>>a
>>> way to instruct GnuCash to add billable items to an invoice.  It seems
>>to
>>> do it automatically at invoice creation, and no other way.
>>> 
>>> Am I missing something?
>> 
>>When you are editing the invoice, just click in the "Billable" column
>>when adding the line-item to mark it as billable.
>> 
>> I think you've misunderstood the question.   There are already billable
>> expenses in the system.  I'm generating the invoice in which those billable
>> items will be passed on to the client.
> 
> Yes, clearly I did...
> 
>> I need to re-add the billable expenses to the invoice.  There doesn't appear
>> to be a way to do that... it looks like they are only added when the invoice
>> is first created.. I can't find any button, menu, or anything else that would
>> trigger adding billable expenses to an existing invoice.
> 
> I honestly don't recall if there is a way to add additional billable
> charge-back items to an already-created invoice.  I wrote that original
> code over 15 years ago; I'd have to search through it again to remind
> myself how it works (and see what changes may have been made).
> 
> The way it is supposed to work is that when the invoice is opened for
> the correct customer (or correct job), it will find all items and
> chargebacks.  Then you need to manually "add" those chargebacks to this
> particular invoice by clicking on the "included" column.
> 
> I THOUGHT the query was created every time, but it's possible the query
> only includes the chargeback items before it is posted the first time.
> If you've posted and then unposted the invoice, it's certainly possible
> the logic will not include new chargebacks.
> 
> Also, make sure the chargeback == invoice owner (customer and/or job).
> If the chargeback is to a job but the invoice is a customer, it
> definitely wont show up.
> 
> -derek
> 
> -- 
>   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>   Member, MIT Student Information Processing Board  (SIPB)
>   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>   warl...@mit.eduPGP key available
> ___
> 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] re-adding billable expenses to an invoice

[Derek Atkins]

Hi,

Matthew Pounsett  writes:

> On 6 September 2018 at 12:04, Derek Atkins  wrote:
>
> Matthew Pounsett  writes:
>
> > I accidentally flubbed some keyboard entry while putting together an
> > invoice and messed up a billable expense item which had been
> automatically
> > added when the invoice was created.  Since there is no "Undo" the best
> > option seemed to be to delete the entry and start over, but I can't find
> a
> > way to instruct GnuCash to add billable items to an invoice.  It seems
> to
> > do it automatically at invoice creation, and no other way.
> >
> > Am I missing something?
>
> When you are editing the invoice, just click in the "Billable" column
> when adding the line-item to mark it as billable.
>
> I think you've misunderstood the question.   There are already billable
> expenses in the system.  I'm generating the invoice in which those billable
> items will be passed on to the client.

Yes, clearly I did...

> I need to re-add the billable expenses to the invoice.  There doesn't appear
> to be a way to do that... it looks like they are only added when the invoice
> is first created.. I can't find any button, menu, or anything else that would
> trigger adding billable expenses to an existing invoice.

I honestly don't recall if there is a way to add additional billable
charge-back items to an already-created invoice.  I wrote that original
code over 15 years ago; I'd have to search through it again to remind
myself how it works (and see what changes may have been made).

The way it is supposed to work is that when the invoice is opened for
the correct customer (or correct job), it will find all items and
chargebacks.  Then you need to manually "add" those chargebacks to this
particular invoice by clicking on the "included" column.

I THOUGHT the query was created every time, but it's possible the query
only includes the chargeback items before it is posted the first time.
If you've posted and then unposted the invoice, it's certainly possible
the logic will not include new chargebacks.

Also, make sure the chargeback == invoice owner (customer and/or job).
If the chargeback is to a job but the invoice is a customer, it
definitely wont show up.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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] FinanceQuote install broken on OSX

[David T. via gnucash-user]

Take a look at two questions in the FAQ at 
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F 


Are you using Yahoo!? Do you have an Alphavantage API key?

The executables for terminal use are embedded in the app bundle, usually at 
/Applications/Gnucash.app/Contents/Resources/bin

You must be in that folder to run them at the terminal. Note also that you have 
to set the shell ENV to include your Alphavantage API key.

David T.

> On Sep 11, 2018, at 4:33 AM, gnucash.dg...@ncf.ca wrote:
> 
> Hi,
> 
> I am using Gnucash 3.2 on OSX 10.13.6 with the latest Xcode.
> 
> I’ve been using Gnucash for about 5 years. The FinanceQuote module stopped 
> working some time mid 2017. I’m only getting around to looking into it now.
> 
> During the last several Gnucash/FinanceQuote updates, I have had errors with 
> the FinanceQuote update script timing out trying to download certain 
> components. Unfortunately, I did not make a note of which ones. I would then 
> have a broken FinanceQuote, and trying to run fc scripts, w.g. 
> 
> gnc-fq-dump 
> 
> or 
> 
> perl gnc-fq-dump 
> 
> return file not found errors. i have tried:
> 
> mdfind gnc-fq-dump
> 
> and confirmed that I don’t have gnc-fq-dump. Presumably the other scripts are 
> missing too.
> 
> 
> I just tried updating again, but now the script tells me FinanceQuote is up 
> to date and their is nothing to do (although it never did run without 
> timeouts on downloads). 
> 
> Can anyone suggest what the solution might be?
> 
> Thanks.
> ___
> 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] FinanceQuote install broken on OSX

[gnucash . dgr9z]

Hi,

I am using Gnucash 3.2 on OSX 10.13.6 with the latest Xcode.

I’ve been using Gnucash for about 5 years. The FinanceQuote module stopped 
working some time mid 2017. I’m only getting around to looking into it now.

During the last several Gnucash/FinanceQuote updates, I have had errors with 
the FinanceQuote update script timing out trying to download certain 
components. Unfortunately, I did not make a note of which ones. I would then 
have a broken FinanceQuote, and trying to run fc scripts, w.g. 

gnc-fq-dump 

or 

perl gnc-fq-dump 

return file not found errors. i have tried:

mdfind gnc-fq-dump

and confirmed that I don’t have gnc-fq-dump. Presumably the other scripts are 
missing too.


I just tried updating again, but now the script tells me FinanceQuote is up to 
date and their is nothing to do (although it never did run without timeouts on 
downloads). 

Can anyone suggest what the solution might be?

Thanks.
___
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] Advanced Portfolio Report - Fund managment fees

[David T. via gnucash-user]

While I have no comment on how to get the Advanced Portfolio Report to 
categorize your fees as such, I will note that when you sell a 
commodity—regardless of the reason for which you sell it—you will have (in most 
cases) a capital gain element. The gain is there, even if you immediately turn 
the proceeds over to another entity. So, it seems to me you should enter a sell 
transaction, complete with gains information, and then enter a transfer to 
brokerage fees as a separate transaction. I don’t know how the report handles 
this.

David T.

> On Sep 11, 2018, at 8:30 AM,   
> wrote:
> 
> Hello,
> I have a mutual fund account for which the management fees are paid for in 
> shares. That is to say, every years, some of my shares are used to pay for 
> the fees and my total amount of shares is therefore slightly reduced.
> I am trying to setup my accounts/transactions in such a way that early 
> management fees for the mutual fund will appear in the report as brokerage 
> fees, but so far I haven't been able to figure out the trick to do so. First, 
> is this even possible?
> If I simply express this by a normal 'sell' operation, where the money goes 
> to an expense account, the report shows some 'realized gain' and no increase 
> for the 'brokerage fees'. I would like the opposite: the money out should be 
> added to the 'brokerage fees' (it goes to an expense account after all), and 
> I shouldn't see any 'realized gain'. The total return and return rate should 
> of course also be updated accordingly.
> I am using Gnucash 2.6.16
> Thanks!
> ___
> 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] Advanced Portfolio Report - Fund managment fees

[hal.lol]

Hello,
I have a mutual fund account for which the management fees are paid for in 
shares. That is to say, every years, some of my shares are used to pay for the 
fees and my total amount of shares is therefore slightly reduced.
I am trying to setup my accounts/transactions in such a way that early 
management fees for the mutual fund will appear in the report as brokerage 
fees, but so far I haven't been able to figure out the trick to do so. First, 
is this even possible?
If I simply express this by a normal 'sell' operation, where the money goes to 
an expense account, the report shows some 'realized gain' and no increase for 
the 'brokerage fees'. I would like the opposite: the money out should be added 
to the 'brokerage fees' (it goes to an expense account after all), and I 
shouldn't see any 'realized gain'. The total return and return rate should of 
course also be updated accordingly.
I am using Gnucash 2.6.16
Thanks!
___
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] Importing csv transactions

[Geert Janssens]

In addition to the other suggestions, does your csv file contain a line with 
column titles ? If so, you may have to configure the importer to skip that 
line.

Regards,

Geert

Op dinsdag 11 september 2018 02:10:40 CEST schreef David Carlson:
> Paul,
> 
> Actually, during the CSV format you can scroll down the data that you are
> about to import to see if there are any lines that will prevent the
> import.  Just scroll down the date column to see if there are any dates
> that do not match your selected date format.  From experience I can tell
> you that it is very easy to make a mistake in this column, as, at least in
> the release 2.6.xx family of GnuCash releases, the default did not match
> common usage in the US.
> 
> David C
> 
> On Mon, Sep 10, 2018 at 5:32 PM GTI .H  wrote:
> > Probably some date (maybe three) in your CSV file is in the wrong format.
> > Open your CSV file in an editor and check the format of the dates.
> > 
> > Regards
> > GTI
> > 
> > Em seg, 10 de set de 2018 às 18:19, Paul Konnersman 
> > 
> > escreveu:
> > > I'm new to Gnucash and trying to get set up. I successfully imported a
> > > couple of years worth of transactions into one account a few months ago
> > > when I was evaluating Gnucash. Now I'm trying to import more
> > > transactions
> > > into that same account without success.
> > > 
> > > My process:
> > > 1) Menu Bar> File> Input> Import Transactions from CSV
> > > 2) Navigate to CSV file to be imported
> > > 3) Set Date format to y-m-d
> > > 4) Set currency format to "period"
> > > 5) Map columns in imported file to columns in Gnucash
> > > 
> > >1. Date -> Date
> > >2. Num -> Num
> > >3. Description -> Action
> > >4. Account -> Transfer
> > >5. Notes -> C
> > >6. Deposit -> Debit Amount
> > >7. None -> Credit Amount
> > >8. None -> Balance
> > > 
> > > 6) I get a notice repeated three times that reads, "Date Column could
> > > not
> > > be understood."
> > > 
> > > Any suggestions will be appreciated.
> > > 
> > > Paul
> > > 
> > > --
> > > *Paul M. Konnersman*
> > > *konners...@gmail.com *
> > > *781-639-0616*
> > > ___
> > > 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.
> > 
> > --
> > Regards
> > GTI
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.