gnucash-user Digest, Vol 126, Issue 26

ennio maresca ennio.maresca at gmail.com
Thu Sep 19 23:46:18 EDT 2013 

Buongiorno, non ritrovo gli estimatori di gnucash- in lingua italiana.
Potreste inviarmi un Link degli aderenti in lingua italiana.
Ringrazio tanto per quanto sopra, cordialmente Ennio Maresca

2013/9/19, gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org>:
> Send gnucash-user mailing list submissions to
> 	gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> 	gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> 	gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>    1. RE: Cost Basis on Portfolio (Dat Data)
>    2. Re: My Sales Tax Tables are Multiplying (qubit)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 18 Sep 2013 10:48:55 -0700
> From: Dat Data <dat30 at hotmail.com>
> To: David Carlson <david.carlson.417 at gmail.com>,
> 	"gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: RE: Cost Basis on Portfolio
> Message-ID: <BAY171-W103A42FD1DDBCE0CEF3DDD9BD200 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
>
>
>
>
>
> Copying the list
>
> From: dat30 at hotmail.com
> To: david.carlson.417 at gmail.com
> Subject: RE: Cost Basis on Portfolio
> Date: Wed, 18 Sep 2013 08:30:30 -0700
>
>
>
>
> Hi David,
>
> I followed that steps and yet the Cost Basis for FIFO isn't correct. Here is
> what I see.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>   Bought
>   50.00
>    $18.00
>
>
>
>
>    $900.00
>
>
>
>
>
>
>
>
>
>
>   Bought
>   50.00
>    $17.00
>
>
>
>
>    $850.00
>
>
>
>
>
>
>
>
>
>
>   Sold
>   50.00
>    $16.00
>
>
>
>
>
>   $800.00
>
>
>
>
>
>
>
>
>
>
>   Shares
>   Price
>   Basis
>   Value
>   Money In
>   Money Out
>   Realized Gain
>   Unrealized Gain
>    Total Gain
>
>
>    FIFO
>    $50.00
>    $12.00
>    $50.00
>    $600.00
>    $1,750.00
>    $800.00
>    $(900.00)
>    $550.00
>    $(350.00)
>
>
>    Average
>    $50.00
>    $12.00
>    $875.00
>    $600.00
>    $1,750.00
>    $800.00
>    $75.00
>    $(275.00)
>    $(200.00)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Thx,
> Dat
>
>
>> Date: Mon, 16 Sep 2013 18:38:20 -0500
>> From: david.carlson.417 at gmail.com
>> To: gnucash-user at gnucash.org
>> Subject: Re: Cost Basis on Portfolio
>>
>> On 9/16/2013 5:27 PM, dat30 dat30 wrote:
>> > Hi,
>> >
>> > I have looked around the forum and played with GnuCash but I'm unable to
>> > make this work. So I thought I'd send an email.
>> >
>> > Bought 50 shares of ABC on 1/1/2013 for 18
>> > Bought 50 shares of ABC on 2/2/2013 for 17
>> > Sold 50 shares of ABC on 3/3/2013 for 16.
>> >
>> > A) The portfolio uses average cost basis by default. I changed that to
>> > FIFO, but it doesn't work correctly either.
>> >
>> > B) I thought, may be the I didn't specify the lot when I entered the
>> > Sell order. So, I did a Scrub Lot to identify which lot of 50 shares
>> > that I want to sell (the first one). That didn't help either.
>> >
>> > Finally on a separate note, there have been some funds sold as FIFO and
>> > some as average price. How do I reflect that on the basis?
>> >
>> > Thanks.
>> > Dat
>> >
>> >
>> >
>> >  		 	   		
>> > _______________________________________________
>> > gnucash-user mailing list
>> > gnucash-user at gnucash.org
>> > 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.
>> >
>> Chapter 8 of the Tutorial covers the mechanics of entering sale
>> transactions.  The gains or losses do not get automatically calculated
>> and entered.  They must be calculated and entered manually.  This has
>> been discussed frequently in the user maillist.
>> Your stockbroker should be able to give you the information that you
>> need for your tax return.
>>  You will find that the numbers will not exactly match what GnuCash does
>> unless you also track commissions and expenses separately in a way that
>> allows tracking the expenses by lots, which is not well documented in
>> the manual.  I personally use a spreadsheet for that part, other users
>> have their own favorite methods.
>>
>> David C
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
>  		 	   		
>
>  		 	   		
>
> ------------------------------
>
> Message: 2
> Date: Wed, 18 Sep 2013 10:34:26 -0700 (PDT)
> From: qubit <qubit at scottworks.net>
> To: gnucash-user at gnucash.org
> Subject: Re: My Sales Tax Tables are Multiplying
> Message-ID: <1379525666891-4664148.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Derek,
>
> What do you mean when you say the data is corrupted?  I've been looking
> through the database tables (postgresql); The only issue I see is that the
> duplicate tax tables are spread across the entries, taxtables and
> taxtable_entries tables. Since I only have 5 duplicate tax tables, I don't
> see as though it is that big of an issue to clean them up with some basic
> SQL. I also do not see any issues with posting bills or invoices with these
> duplicate tax tables, except that the duplicates will slowly increase.
>
> I've been using the SQL backend for about a year and a half and have to say
> that it is far easier to support across multiple workstations accessing
> from
> multiple locations (one workstation at a time) than the XML file on an NFS
> share. It also has greater potential than the XML in creating custom
> reports
> directly from the DB. I've a very rudimentary way of tracking inventory
> purchases and sales using the DB (query ONLY).
>
> BTW, I don't see any foreign key constraints to keep relational data from
> becoming inconsistent.
>
> I've been using GNUCash for about ten years and believe it to be the best
> open source accounting product. I'm hoping we can see more stability and
> support for database back-end since this is the most flexible way to go.
>
> -Br-
>
>
>
> --
> View this message in context:
> http://gnucash.1415818.n4.nabble.com/My-Sales-Tax-Tables-are-Multiplying-tp4662539p4664148.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> End of gnucash-user Digest, Vol 126, Issue 26
> *********************************************
>

More information about the gnucash-user mailing list