Re: [GNC] Advanced Portfolio Report - Brokerage Fees

[devaps]

Gilberto,

Instead of recording the taxes directly in the account register for mutual 
fund, you have to perform an intermediate step, such as -

In mutual fund register, record the gross sale value with appropriate income 
split for capital gain, but instead of transferring the sale proceeds directly 
to bank, place it in a temporary account, say $Cash.

Now open the $Cash account register and make a transfer to your bank with the 
net proceeds after including a split for the tax deducted.

This should fix your advanced portfolio report issue.

Cheers.

--

Date: Wed, 13 Sep 2023 19:13:19 -0300
From: Gilberto Reis Filho 
To: gnucash-user@gnucash.org
Subject: [GNC] Advanced Portfolio Report - Brokerage Fees
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Hello.

In my country whenever a person sells shares of a mutual fund the bank
has to calculate and pay taxes, on behalf of the investor, on capital
gains before making the funds avaliable to the investor. The investor
receives the funds in the brokerage account liquid of taxes.

I am recording these taxes in a split in the transaction where the
shares sold are recorded, however doing this makes the advanced
portfolio report recognize this tax as brokerage fees (well, they are
not fees, but taxes).

Is there any alternative to prevent this behavior and at the same time
keep things simple preferably without having to create separate
transactions?

Thanks.
Gilberto.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Adding A Business Activity (and integrating with old)

[devaps]

Eric,

I started out the same way, using gnucash for personal books and added my sole 
proprietorship business activity at a later date. 

Like you, even if I setup a new business bank account, I’d invariably have some 
expenses that would involve apportioning part of the expense to business side 
of things. It’s much easier to do this in a single book. If you wish, you can 
segregate the books, but it will constantly involve splitting business portion 
of the transactions to be duplicated in both books. If you do this, you would 
have to split the business portion of transactions to an equity account in 
personal books and source one side of transactions from a similar equity 
account in the business books. Given the tedium in maintaining copies of 
transactions in multiple books, I chose to keep it in a single book.

It’s easy enough to create an account hierarchy to include business side of 
things in your personal books and at report generation time, include the 
appropriate set of accounts for business or personal income or balance sheet 
information. 


There may be a case to separate the books if you anticipate selling your 
business at a future date, but that effort is worth it only if the business is 
large enough to spin off at a later date. Not worth its while for sole 
proprietorship. 

You can still separate the books at a later date (say if you register an LLP or 
a private company), if you deem it necessary to maintain separate books at that 
time. 

Cheers,
Deva

—
Date: Sat, 20 May 2023 14:21:15 -0500
From: "Eric H. Bowen" 
To: gnucash-user@gnucash.org
Subject: [GNC] Adding A Business Activity (and integrating with old)
Message-ID: <12b93fed-70cf-b7a6-a6a7-ca3e083d1...@ehbowen.net>
Content-Type: text/plain; charset=UTF-8; format=flowed

I've been using GnuCash for personal expenses and for a home-based hobby 
business for the past several years now. I'm about to add another 
business activity which will be more serious (I'm self-publishing a 
book). I'm planning to open a separate business banking account for this 
activity and I want to use an entirely separate GnuCash book to keep 
track of income and expenses. Note: This will be a sole proprietorship 
(at least for now) as is my current hobby business.

My question is: How do I integrate this with my current GnuCash 
register? It will be more than a year before I generate any 
(significant) income, even if things go well, so there's going to be a 
lot of crossover and funds transferred from my personal accounts, both 
cash and credit. There are also other items, such as telephone and 
Internet service, which can/should be expensed across both activities. 
I'm also wanting to track investment and net equity in this activity in 
the event that I eventually sell out to an established publisher or else 
formally incorporate the business.

I can/will speak with the accountant that I'm using for his 
recommendations, but he's completely unfamiliar with GnuCash; when I 
mentioned it his reaction was, "What...?" So I want to see how this can 
and should be done under the GnuCash interface.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Search and Replace

[devaps]

On your second point, there’s also  menu option Transaction-> Cancel 
Transaction to undo any unwanted changes. 

Cheers. 

--

From: Gyle McCollam 
To: "gnucash-user@gnucash.org" 
Subject: [GNC] Search and Replace
Message-ID:



Content-Type: text/plain; charset="iso-8859-1"

Now that V5.0 offers choices when you start typing in the description, I find 
errors in spelling and other differences in the way I've entered names.  I try 
to clean these up, but sometimes there are n excess of a hundred, because they 
were repeated when earlier versions showed suggestions.  In order to eliminate 
V5.0 offering this bad spelling along with the proper spelling the incorrect 
spelling needs to be changed.  It would be helpful if Gnucash offer a llokup 
and replace function.  I haven't found one, am I missing it or doesn't it 
exist.  If not I will suggest it for a future enhancement.

While on the subject of enhancements, It would be helpful to have an undo and 
redo function as in Libre Office and many other spreadsheet programs.  I have 
sometimes accidentally changed a transaction or eliminated what is in a field 
and would like to exit the transaction with no changes.  Is there a way to do 
that now?


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Clarification of Total (Period) column

[devaps]

I’m not sure I understand. 

The period column isn’t tied to any fixed period. It is just showing current 
balances as of date. And if you have any future dated transactions in the same 
register, then the Total column shows the final future balance. 

My fiscal year runs Apr to Mar, so my future transactions will run till end of 
Mar. Each Apr, I update the register for all the future transactions. If your 
fiscal year ends in Dec, you can setup transactions until Dec, I suppose. 

There’s also one more distinction between the two. If you have securities in 
your books, the Period column shows the no. of shares, but the Total column 
gives you its current market value (assuming your price DB is up to date).

Cheers. 

On 04/01/23 at 9:08 PM, Kalpesh Patel wrote:

> You are absolutely correct on the distinction between Total and
> Total(Period) columns and their creative use. My question was a bit about
> whether Total (period) column supposed to take configurable period or is it
> fixed for current year.
> 
> This stems from worry that if fiscal year that doesn't correspond to that
> "fixed" coded period, which is likely to be true for businesses, then how do
> you deal with that situation.
> 
> My thinking is in line with Adrien as here which still would by default
> would permit to use it in the fashion you mentioned.  
> 
> 
> --
> 
> Message: 1
> Date: Wed, 4 Jan 2023 07:48:11 +0100
> From: dev...@asia.com
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Clarification of Total (Period) column
> Message-ID:
>   
>  01>
>   
> Content-Type: text/plain; charset=UTF-8
> 
> I think one shows total as of today and the other shows total for today and
> beyond?
> 
> This distinction helps me and I don?t think it?s a bug. For my use case, I
> setup any future known income or future tax payments till the end of my tax
> year., by entering all those future transactions at the beginning of the
> year itself. 
> 
> So if my current balance is 100, that?s shown in Total (Period) column. But
> in the register I have future dated entries for all the interest incomes due
> during the year as well as any taxes owed by year end. Let?s say the future
> income is 20 and future tax liability is 5, then my total column will show -
> 
> 100+20~5 = 115.
> 
> This distinction tells me how much I have at my disposal to spend till end
> of year. 
> 
> I think the budget report can be used to do something similar, but this is
> easy enough for me to track and understand. 
> 
> Cheers. 
> 
> --
> > 
> > Date: Tue, 3 Jan 2023 15:28:57 -0600
> > From: Adrien Monteleone 
> > To: gnucash-u...@lists.gnucash.org
> > Subject: Re: [GNC] Clarification of Total (Period) column
> > Message-ID: 
> > Content-Type: text/plain; charset=UTF-8; format=flowed
> > 
> > Hmmm... I'm seeing the same thing.
> > 
> > It appears to default to 'this year' regardless of the setting.
> > 
> > I'd call that a bug.
> > 
> > Regards,
> > Adrien
> > 
> > On 1/3/23 3:14 PM, Kalpesh Patel wrote:
> > > I have added a column called ?Total (Period)? in the accounts view 
> > > page but I am not sure what that period is? I made changes to it in the
> ?Edit ?
> > > Preference ? Accounting Period? but didn?t change the value there so 
> > > I don?t think the ?period? denoted is in anyway reflected from 
> > > there. I am curious to know what that ?period? entails, if that is 
> > > something changeable and if so where.
> > 
> 
> 
> 
> --
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Clarification of Total (Period) column

[devaps]

I think one shows total as of today and the other shows total for today and 
beyond…

This distinction helps me and I don’t think it’s a bug. For my use case, I 
setup any future known income or future tax payments till the end of my tax 
year., by entering all those future transactions at the beginning of the year 
itself. 

So if my current balance is 100, that’s shown in Total (Period) column. But in 
the register I have future dated entries for all the interest incomes due 
during the year as well as any taxes owed by year end. Let’s say the future 
income is 20 and future tax liability is 5, then my total column will show -

100+20~5 = 115.

This distinction tells me how much I have at my disposal to spend till end of 
year. 

I think the budget report can be used to do something similar, but this is easy 
enough for me to track and understand. 

Cheers. 

--
> 
> Date: Tue, 3 Jan 2023 15:28:57 -0600
> From: Adrien Monteleone 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Clarification of Total (Period) column
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Hmmm... I'm seeing the same thing.
> 
> It appears to default to 'this year' regardless of the setting.
> 
> I'd call that a bug.
> 
> Regards,
> Adrien
> 
> On 1/3/23 3:14 PM, Kalpesh Patel wrote:
> > I have added a column called ?Total (Period)? in the accounts view page but
> > I am not sure what that period is? I made changes to it in the ?Edit ?
> > Preference ? Accounting Period? but didn?t change the value there so I don?t
> > think the ?period? denoted is in anyway reflected from there. I am curious
> > to know what that ?period? entails, if that is something changeable and if
> > so where.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 is using 538MB

[devaps]

That’s not true, Adrien. When I first started using GnuCash, I thought I’d go 
with MySQL database and that’s where I found both debug and standard packages 
available for download. Of course, I settled on compressed xml later because I 
find it easier to backup one file instead of a database. 

Cheers. 

> --
> From: Adrien Monteleone 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] GNUcash is using 538MB
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> I don't think any such packages are pre-built, and they certainly aren't 
> available to mistakenly download.
> 
> Regards,
> Adrien
> 
> On 12/17/22 12:03 AM, dev...@asia.com wrote:
> > Not sure if this applies to gnucash app, but when I download certain 
> > software, I get an option to download standard or debug package. The latter 
> > is significantly larger in size. I?m guessing if one is running a debug 
> > packaged app, its RAM usage would be high.
> > 
> > I haven?t checked if gnucash offers the debug package. If OP is using a 
> > debug package, perhaps it?s hogging his RAM.
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 is using 538MB

[devaps]

Not sure if this applies to gnucash app, but when I download certain software, 
I get an option to download standard or debug package. The latter is 
significantly larger in size. I’m guessing if one is running a debug packaged 
app, its RAM usage would be high. 

I haven’t checked if gnucash offers the debug package. If OP is using a debug 
package, perhaps it’s hogging his RAM. 

Cheers. 
> --
> 
>
> Date: Thu, 15 Dec 2022 17:34:55 -0600
> From: Adrien Monteleone 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] GNUcash is using 538MB
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> If it is indeed RAM, and it gets worse over time, that is a memory leak, 
> and I'd bet the devs would like to know about it. A bug report would be 
> in order in such case.
> 
> Regards,
> Adrien
> 
> On 12/15/22 6:04 AM, David T. via gnucash-user wrote:
> > I'm guessing you're talking about RAM, though, as this can frequently 
> > happen (take a look sometime at how much RAM Chrome can use!). A restart 
> > usually clears that up.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for a pre-paid electronic toll card

[devaps]

   Glad to hear your problem is resolved, Tony.
   Cheers.
   Sent using the mobile mail app
   On 19/10/22 at 9:45 AM, Tony Vanson wrote:
   From: "Tony Vanson" 
   Date: 19 October 2022
   To: dev...@asia.com
   Cc: gnucash-user@gnucash.org
   Subject: Re: [GNC] Accounting for a pre-paid electronic toll card
   Thank you Devaps, that clears my head 洛
   On Tue, Oct 18, 2022 at 11:25 PM <[1]dev...@asia.com> wrote:

 You can treat it like a pre-paid card, so it resides under Assets.
 So you have -
 Assets->Bank Account
 Assets->Toll pre-paid card
 Expenses->Toll
 When you top up the card, record a transfer between the 2 asset
 accounts above.
 When you pay toll, record a transfer from Assets->Toll pre-paid card
 to Expenses->Toll.
 Cheers.
 > Date: Tue, 18 Oct 2022 22:54:28 +0700
 > From: Tony Vanson <[2]tonyvan...@gmail.com>
 > To: gnucash-user <[3]gnucash-user@gnucash.org>
 > Subject: [GNC] Accounting for a pre-paid electronic toll card
 > Message-ID:
 >
 <[4]CACnjAucZzeKyqrOOUrHg7Fkga7Nf7S0R_zLNDHYs74318GH_EQ@mail.gmail.c
 om>
 > Content-Type: text/plain; charset="UTF-8"
 >
 > I'm hoping that someone on this list can aid my befuddled brain to
 get to
 > grips with my problem.
 > The tolling system here is not the automated ones I'm used to.
 > Here one needs to obtain an electronic card and, once done, must
 be charged
 > with a cash value prior to travelling and topped up with cash on a
 regular
 > basis.
 > My question is what category is this card and how do I treat
 additions and
 > subtractions from it?
 > I initially thought it might be treated as a credit card but the
 way it
 > operates it's obviously not.
 > Any advice would be much appreciated
 > *Tony Vanson*
 >
 >
 ___
 gnucash-user mailing list
 [5]gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 [6]https://lists.gnucash.org/mailman/listinfo/gnucash-user
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.

   --
   Tony Vanson
   The older I get,
   the better I was

References

   1. mailto:dev...@asia.com
   2. mailto:tonyvan...@gmail.com
   3. mailto:gnucash-user@gnucash.org
   4. mailto:cacnjauczzekyqroourhg7fkga7nf7s0r_zlndhys74318gh...@mail.gmail.com
   5. mailto:gnucash-user@gnucash.org
   6. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for a pre-paid electronic toll card

[devaps]

You can treat it like a pre-paid card, so it resides under Assets.

So you have -

Assets->Bank Account
Assets->Toll pre-paid card
Expenses->Toll

When you top up the card, record a transfer between the 2 asset accounts above.

When you pay toll, record a transfer from Assets->Toll pre-paid card to 
Expenses->Toll.

Cheers.

> Date: Tue, 18 Oct 2022 22:54:28 +0700
> From: Tony Vanson 
> To: gnucash-user 
> Subject: [GNC] Accounting for a pre-paid electronic toll card
> Message-ID:
>   
> Content-Type: text/plain; charset="UTF-8"
>
> I'm hoping that someone on this list can aid my befuddled brain to get to
> grips with my problem.
> The tolling system here is not the automated ones I'm used to.
> Here one needs to obtain an electronic card and, once done, must be charged
> with a cash value prior to travelling and topped up with cash on a regular
> basis.
> My question is what category is this card and how do I treat additions and
> subtractions from it?
> I initially thought it might be treated as a credit card but the way it
> operates it's obviously not.
> Any advice would be much appreciated
> *Tony Vanson*
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

[devaps]

Jim,

The default account hierarchy that’s provided when you choose investment 
accounts is just that. You can choose to have it per your tracking 
requirements. 

Like you, my parent brokerage account is a placeholder and I have a $Cash 
account under that which acts as a staging account for buys and sells. The 
default hierarchy is giving you all possible types of investments one usually 
has in a brokerage account. So my modified hierarchy looks like this -

Assets
..Investments
….Brokerage account
…..Stock
…...$Cash
…….ISIN 1
…….ISIN 2  and so on
….Mutual Fund
……Fund 1
……Fund 2 and so on

ETFs are technically mutual funds, but since they trade like stocks, I track 
them under stocks instead of mutual funds. From what I can tell, there’s no 
difference between account type stock and mutual fund. Perhaps they exist as 
two separate types to allow for different treatment in the future, if need 
arises. 

If you have bonds as well as stocks in your brokerage account, then you can 
move $Cash under brokerage account. 

I don’t invest in mutual funds through my brokerage account. I keep that just 
for stocks and ETFs. My mutual fund investments are done directly with the fund 
companies, so the structure I have makes the selection of accounts in report 
options easier. I can just select the parent placeholder Mutual Fund and say 
select all children to run a report on just mutual funds. 

So yes, there’s no harm in having AMZN directly under brokerage and use a $Cash 
account for staging purposes. I also don’t like to include transactions in 
parent accounts, so they are all placeholders for me like you described. This 
works well for me. 

Cheers,
Deva

<>

From: Jim DeLaHunt 
To: Gnucash Users 
Subject: [GNC] Why does the sample "investments" account tree have
intermediate "Bond", "Mutual Fund", and "Stock" accounts?
Message-ID: <009a32e9-b8bd-1547-cbec-0320661f1...@jdlh.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hello, folks:

I have been using GnuCash for a long time, starting with the GnuCash 
template account tree and modifying it gradually, but never thinking 
hard about it. Until now. I am adding a bunch of investment accounts. 
This makes me look more closely at the template account structure 
depicted in 
.

This structure is:

  * Assets
  o Investments
  + Brokerage account
  # Bond
  # Mutual Fund
  # Stock
  * AMZN

What is the reason for the template inserting the layer of subaccounts 
between "Brokerage account" and "AMZN" (for Amazon.com stock)? Why 
shouldn't the child accounts denominated in each security be directly 
under the "Brokerage account" account (as long as the parent account is 
denominated in the currency which the securities are priced in)?

For my own purposes, it seems simpler to me to have the per-security 
child accounts be directly under the "Brokerage account". Is there a 
rationale for the intermediate accounts which I am missing?

Also, in the template, the "Brokerage account" is of type "Bank", and is 
not a placeholder. That seems to imply that cash and cash-equivalent 
transactions should be applied directly to "Brokerage account". Somehow 
I ended up making a child account "Cash CAD" (or "Cash USD", or 
whichever), and applying all the cash-equivalent transactiosn there. My 
equivalent of "Brokerage account" has no transactions, and is often a 
placeholder account, and has account type "Asset" rather than "Bank".?? 
Is there a reason to put the cash transactions directly in the brokerage 
account, or is this a matter of personal preference? (In which case, I 
will keep the structure I have.)

Thank you in advance for your insight,
  ?Jim DeLaHunt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.