opening balances problem ( USD)

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

opening balances problem ( USD)

Nikos Charonitakis
I m trying to replicate my broker's statement in GnuCash and i ve
mostly succeeded :)
I have a problem with a transfer in opening balances.
I use Opening Balances and Opening Balances (USD) accounts.
I have some USD as money in the bank and the same amount appears in
Opening Balances (USD).
So far so good. Now i m trying a stock purchase in USD but the amount
of USD i spent refuses to appear in Opening Balances (USD) account.
What i did?
A) created security for the stock and set a price for it.
B) Created an account (Asset) named USstocks in USD with parent
account = investments
C) Created an account (stock) under USstocks
D) recorded the transaction
Now although the right value of the stock appears under the "Total"
column for the USstocks account,
i cant see the amount recorded in the Opening Balances (USD) account.

Any ideas
thanks in advance
Nikos
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: opening balances problem ( USD)

Derek Atkins
Mismatched commodities?  You can't have a Stock account denoted in USD.
So you didn't set a price on the "buy" transaction.

-derek

Quoting Nikos Charonitakis <[hidden email]>:

> I m trying to replicate my broker's statement in GnuCash and i ve
> mostly succeeded :)
> I have a problem with a transfer in opening balances.
> I use Opening Balances and Opening Balances (USD) accounts.
> I have some USD as money in the bank and the same amount appears in
> Opening Balances (USD).
> So far so good. Now i m trying a stock purchase in USD but the amount
> of USD i spent refuses to appear in Opening Balances (USD) account.
> What i did?
> A) created security for the stock and set a price for it.
> B) Created an account (Asset) named USstocks in USD with parent
> account = investments
> C) Created an account (stock) under USstocks
> D) recorded the transaction
> Now although the right value of the stock appears under the "Total"
> column for the USstocks account,
> i cant see the amount recorded in the Opening Balances (USD) account.
>
> Any ideas
> thanks in advance
> Nikos
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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.
>



--
       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
       [hidden email]                        PGP key available

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: opening balances problem ( USD)

Nikos Charonitakis
On 7/5/07, Derek Atkins <[hidden email]> wrote:
> Mismatched commodities?  You can't have a Stock account denoted in USD.
> So you didn't set a price on the "buy" transaction.
i dont have an stock account in USD, just the parent account of the
usd stock is an asset account in USD (it contains nothing but it shows
as total the right amount of USD i spent).

Nikos

>
> -derek
>
> Quoting Nikos Charonitakis <[hidden email]>:
>
> > I m trying to replicate my broker's statement in GnuCash and i ve
> > mostly succeeded :)
> > I have a problem with a transfer in opening balances.
> > I use Opening Balances and Opening Balances (USD) accounts.
> > I have some USD as money in the bank and the same amount appears in
> > Opening Balances (USD).
> > So far so good. Now i m trying a stock purchase in USD but the amount
> > of USD i spent refuses to appear in Opening Balances (USD) account.
> > What i did?
> > A) created security for the stock and set a price for it.
> > B) Created an account (Asset) named USstocks in USD with parent
> > account = investments
> > C) Created an account (stock) under USstocks
> > D) recorded the transaction
> > Now although the right value of the stock appears under the "Total"
> > column for the USstocks account,
> > i cant see the amount recorded in the Opening Balances (USD) account.
> >
> > Any ideas
> > thanks in advance
> > Nikos
> > _______________________________________________
> > gnucash-user mailing list
> > [hidden email]
> > 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.
> >
>
>
>
> --
>        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
>        [hidden email]                        PGP key available
>
>
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: opening balances problem ( USD)

Derek Atkins
Well, what's your opening balance transaction look like?  It would only
show up in Eq:O B  if you set that account in the transfer portion of
the transaction.  Can you show a screen shot of your transaction?

-derek

Quoting Nikos Charonitakis <[hidden email]>:

> On 7/5/07, Derek Atkins <[hidden email]> wrote:
>> Mismatched commodities?  You can't have a Stock account denoted in USD.
>> So you didn't set a price on the "buy" transaction.
> i dont have an stock account in USD, just the parent account of the
> usd stock is an asset account in USD (it contains nothing but it shows
> as total the right amount of USD i spent).
>
> Nikos
>
>>
>> -derek
>>
>> Quoting Nikos Charonitakis <[hidden email]>:
>>
>> > I m trying to replicate my broker's statement in GnuCash and i ve
>> > mostly succeeded :)
>> > I have a problem with a transfer in opening balances.
>> > I use Opening Balances and Opening Balances (USD) accounts.
>> > I have some USD as money in the bank and the same amount appears in
>> > Opening Balances (USD).
>> > So far so good. Now i m trying a stock purchase in USD but the amount
>> > of USD i spent refuses to appear in Opening Balances (USD) account.
>> > What i did?
>> > A) created security for the stock and set a price for it.
>> > B) Created an account (Asset) named USstocks in USD with parent
>> > account = investments
>> > C) Created an account (stock) under USstocks
>> > D) recorded the transaction
>> > Now although the right value of the stock appears under the "Total"
>> > column for the USstocks account,
>> > i cant see the amount recorded in the Opening Balances (USD) account.
>> >
>> > Any ideas
>> > thanks in advance
>> > Nikos
>> > _______________________________________________
>> > gnucash-user mailing list
>> > [hidden email]
>> > 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.
>> >
>>
>>
>>
>> --
>>        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
>>        [hidden email]                        PGP key available
>>
>>
>



--
       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
       [hidden email]                        PGP key available

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: opening balances problem ( USD)

Nikos Charonitakis
On 7/5/07, Derek Atkins <[hidden email]> wrote:
> Well, what's your opening balance transaction look like?  It would only
> show up in Eq:O B  if you set that account in the transfer portion of
> the transaction.  Can you show a screen shot of your transaction?
sure
first screen (stock account): i enter 100 shares for the price of 23.66 usd
second screen (opening balance USD): we can see that balance remains
the same. 24103 USD in the bank and nothing recorded related to my
stock purchase...

>
> -derek
>
> Quoting Nikos Charonitakis <[hidden email]>:
>
> > On 7/5/07, Derek Atkins <[hidden email]> wrote:
> >> Mismatched commodities?  You can't have a Stock account denoted in USD.
> >> So you didn't set a price on the "buy" transaction.
> > i dont have an stock account in USD, just the parent account of the
> > usd stock is an asset account in USD (it contains nothing but it shows
> > as total the right amount of USD i spent).
> >
> > Nikos
> >
> >>
> >> -derek
> >>
> >> Quoting Nikos Charonitakis <[hidden email]>:
> >>
> >> > I m trying to replicate my broker's statement in GnuCash and i ve
> >> > mostly succeeded :)
> >> > I have a problem with a transfer in opening balances.
> >> > I use Opening Balances and Opening Balances (USD) accounts.
> >> > I have some USD as money in the bank and the same amount appears in
> >> > Opening Balances (USD).
> >> > So far so good. Now i m trying a stock purchase in USD but the amount
> >> > of USD i spent refuses to appear in Opening Balances (USD) account.
> >> > What i did?
> >> > A) created security for the stock and set a price for it.
> >> > B) Created an account (Asset) named USstocks in USD with parent
> >> > account = investments
> >> > C) Created an account (stock) under USstocks
> >> > D) recorded the transaction
> >> > Now although the right value of the stock appears under the "Total"
> >> > column for the USstocks account,
> >> > i cant see the amount recorded in the Opening Balances (USD) account.
> >> >
> >> > Any ideas
> >> > thanks in advance
> >> > Nikos
> >> > _______________________________________________
> >> > gnucash-user mailing list
> >> > [hidden email]
> >> > 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.
> >> >
> >>
> >>
> >>
> >> --
> >>        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
> >>        [hidden email]                        PGP key available
> >>
> >>
> >
>
>
>
> --
>        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
>        [hidden email]                        PGP key available
>
>

_______________________________________________
gnucash-user mailing list
[hidden email]
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.

Screenshot-*PORTFOLIO - RED HAT INC.png (82K) Download Attachment
Screenshot-*PORTFOLIO - Opening Balances (US).png (93K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: opening balances problem ( USD)

Derek Atkins
Looks like you're hitting http://bugzilla.gnome.org/show_bug.cgi?id=116353

Quoting Nikos Charonitakis <[hidden email]>:

> On 7/5/07, Derek Atkins <[hidden email]> wrote:
>> Well, what's your opening balance transaction look like?  It would only
>> show up in Eq:O B  if you set that account in the transfer portion of
>> the transaction.  Can you show a screen shot of your transaction?
> sure
> first screen (stock account): i enter 100 shares for the price of 23.66 usd
> second screen (opening balance USD): we can see that balance remains
> the same. 24103 USD in the bank and nothing recorded related to my
> stock purchase...
>>
>> -derek
>>
>> Quoting Nikos Charonitakis <[hidden email]>:
>>
>> > On 7/5/07, Derek Atkins <[hidden email]> wrote:
>> >> Mismatched commodities?  You can't have a Stock account denoted in USD.
>> >> So you didn't set a price on the "buy" transaction.
>> > i dont have an stock account in USD, just the parent account of the
>> > usd stock is an asset account in USD (it contains nothing but it shows
>> > as total the right amount of USD i spent).
>> >
>> > Nikos
>> >
>> >>
>> >> -derek
>> >>
>> >> Quoting Nikos Charonitakis <[hidden email]>:
>> >>
>> >> > I m trying to replicate my broker's statement in GnuCash and i ve
>> >> > mostly succeeded :)
>> >> > I have a problem with a transfer in opening balances.
>> >> > I use Opening Balances and Opening Balances (USD) accounts.
>> >> > I have some USD as money in the bank and the same amount appears in
>> >> > Opening Balances (USD).
>> >> > So far so good. Now i m trying a stock purchase in USD but the amount
>> >> > of USD i spent refuses to appear in Opening Balances (USD) account.
>> >> > What i did?
>> >> > A) created security for the stock and set a price for it.
>> >> > B) Created an account (Asset) named USstocks in USD with parent
>> >> > account = investments
>> >> > C) Created an account (stock) under USstocks
>> >> > D) recorded the transaction
>> >> > Now although the right value of the stock appears under the "Total"
>> >> > column for the USstocks account,
>> >> > i cant see the amount recorded in the Opening Balances (USD) account.
>> >> >
>> >> > Any ideas
>> >> > thanks in advance
>> >> > Nikos
>> >> > _______________________________________________
>> >> > gnucash-user mailing list
>> >> > [hidden email]
>> >> > 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.
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >>        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
>> >>        [hidden email]                        PGP key available
>> >>
>> >>
>> >
>>
>>
>>
>> --
>>        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
>>        [hidden email]                        PGP key available
>>
>>
>



--
       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
       [hidden email]                        PGP key available

_______________________________________________
gnucash-user mailing list
[hidden email]
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.