Go Back   CDN Business Directory > Main Category > Taxes

 
 
Thread Tools Display Modes
  #6  
Old 03-30-2007, 08:15 AM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: Proper financial software

- quote -

> > Recently, I did a heck of a lot of trading in my sister's

> Dear esteemed Moderator,
> Did this slip through the cracks or is it a forgery?
> Moderator:
> I mistook it for a tax question when it is really a
> computer mathematics question. At least it is not spam.


It is a tax question, in the end, because certain programs
are miscalculating capital gains values, but that's for
anothe rthread.

In this thread, I was just looking for affordable software
recommendations.

I called the IRS yesterday to discuss the tax implication. I
expect that tey will return my call today. After I speak to
the IRS, I'll describe the capital gains issue in another
thread.

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
  #5  
Old 03-30-2007, 08:15 AM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: Proper financial software

Found what I wanted.

Section 1.1012-1 of 26 CFR Ch, 1 (4-1-06 Edition), on page
39, right-hand column gives an example using rounding "to
the nearest cent". So Fidelity is doing it right and several
programs are doing it wrong.

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
  #4  
Old 03-30-2007, 08:15 AM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: Proper financial software

"L K Williams" <lanny[at]loxinfo.co.th> wrote:

- quote -

> I disagree! The unit cost is relevant because this will be
> used to compute gain or loss on ultimate disposal. The
> equation Value = unit cost X number of shares MUST be valid.
> Your method can result in inaccuracies.


I am not affecting the calculation. The NAV is THE
historical price which cannot be derived from the other
values, so it needs to be saved

Neither the NAV nor the cost per share, for a given
transaction is relevant for calculations, but the NAV has
historical value.

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
  #3  
Old 03-28-2007, 09:53 PM
Ernie Klein
Guest
 
Posts: n/a
Default Re: Proper financial software

- quote -

> Recently, I did a heck of a lot of trading in my sister's

Dear esteemed Moderator,

Did this slip through the cracks or is it a forgery?

Moderator:
I mistook it for a tax question when it is really a
computer mathematics question. At least it is not spam.

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
  #2  
Old 03-28-2007, 09:53 PM
Harlan Lunsford
Guest
 
Posts: n/a
Default Re: Proper financial software

Howard Kaikow wrote:

- quote -

> Recently, I did a heck of a lot of trading in my sister's
> taxable account, so I thought that it might advantageous to
> get software that would determine whether it would be better
> to use actual cost or average cost to compute capital gains.
> I've been disappointed that most, if not all, of the
> programs suffer from the deficiencies described below. I'd
> be reluctant to trust their calculations.
> Are there portfolio management programs that do not suffer
> from the problems described below? The comments are about
> FundManger, similar comments apply to other programs.
> -------------
> 1. The total portfolio value is off by $.06 (too high). This
> is due to the incorrect rounding of the market value for
> each security. Market values are not to be rounded, they are
> always TRUNCATED to 2 digits to the right of the decimal
> mark. You can see this at the Fidelity web site.
> Such incorrect rounding accounts for $.05 of the error, the
> additional error of $.01 results from the adding of the
> security values.
> 2. When a transaction is entered, IF both the number and
> shares and the value are given, the price is irrelevant only
> of interest as an historical item. It is incorrect to
> compute the price if the user manually enters the price, or
> the price is downloaded from wherever.
> For example, on 16 Sept 2005, the NAV of FSPTX used for a
> purchase was $61.54. The amount purchased was $.97 resulting
> in the purchase of .016 shares. Fund Manager displays the
> price as $60.63. Manually correcting the price does not
> stick.


If you're talking about trading stocks or bonds, you don't
use the average cost. Mutual funds, it's another ballgame.

ChEAr$,
Harlan Lunsford, EA n LA

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
  #1  
Old 03-28-2007, 09:53 PM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: Proper financial software

"Howard Kaikow" <kaikow[at]standards.com> wrote:

- quote -

> 1. The total portfolio value is off by $.06 (too high). This
> is due to the incorrect rounding of the market value for
> each security. Market values are not to be rounded, they are
> always TRUNCATED to 2 digits to the right of the decimal
> mark. You can see this at the Fidelity web site.
> Such incorrect rounding accounts for $.05 of the error, the
> additional error of $.01 results from the adding of the
> security values.


I now believe that there is not an industry standard for
rounding dollars. There should be.

As recently as 24 Nov 2006, I did a transaction at Janus.
Amount was ROUNDED UP, where Fido would have TRUNCATED.

Ditto for trades at AIM in 2005.

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
 
Old 03-28-2007, 09:53 PM
L K Williams
Guest
 
Posts: n/a
Default Re: Proper financial software

"Howard Kaikow" <kaikow[at]standards.com> wrote:

- quote -

> Are there portfolio management programs that do not suffer
> from the problems described below? The comments are about
> FundManger, similar comments apply to other programs.
> -------------

snip

- quote -

> 2. When a transaction is entered, IF both the number and
> shares and the value are given, the price is irrelevant only
> of interest as an historical item. It is incorrect to
> compute the price if the user manually enters the price, or
> the price is downloaded from wherever.


I disagree! The unit cost is relevant because this will be
used to compute gain or loss on ultimate disposal. The
equation Value = unit cost X number of shares MUST be valid.
Your method can result in inaccuracies.

- quote -

> For example, on 16 Sept 2005, the NAV of FSPTX used for a
> purchase was $61.54. The amount purchased was $.97 resulting
> in the purchase of .016 shares. Fund Manager displays the
> price as $60.63. Manually correcting the price does not
> stick.


Maybe I'm missing something but I don't see your problem.
If you received 0.016 shares and paid $0.97, the per share
price is $60.63, not $61.54. Check the math!

Lanny K. Williams, CPA
Nawarat, Williams & Co., Ltd.
Income Tax Services for Expatriate Americans

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
  #-1  
Old 03-27-2007, 05:21 AM
Howard Kaikow
Guest
 
Posts: n/a
Default Proper financial software

Recently, I did a heck of a lot of trading in my sister's
taxable account, so I thought that it might advantageous to
get software that would determine whether it would be better
to use actual cost or average cost to compute capital gains.

I've been disappointed that most, if not all, of the
programs suffer from the deficiencies described below. I'd
be reluctant to trust their calculations.

Are there portfolio management programs that do not suffer
from the problems described below? The comments are about
FundManger, similar comments apply to other programs.
-------------
1. The total portfolio value is off by $.06 (too high). This
is due to the incorrect rounding of the market value for
each security. Market values are not to be rounded, they are
always TRUNCATED to 2 digits to the right of the decimal
mark. You can see this at the Fidelity web site.

Such incorrect rounding accounts for $.05 of the error, the
additional error of $.01 results from the adding of the
security values.

2. When a transaction is entered, IF both the number and
shares and the value are given, the price is irrelevant only
of interest as an historical item. It is incorrect to
compute the price if the user manually enters the price, or
the price is downloaded from wherever.

For example, on 16 Sept 2005, the NAV of FSPTX used for a
purchase was $61.54. The amount purchased was $.97 resulting
in the purchase of .016 shares. Fund Manager displays the
price as $60.63. Manually correcting the price does not
stick.

--
http://www.standards.com/; See Howard Kaikow's web site.

<< ================================================== ===== > << The foregoing was not intended or written to be used, > << nor can it used, for the purpose of avoiding penalties > << that may be imposed upon the taxpayer. > << > << The Charter and the Guidelines for submitting posts > << to this newsgroup as well as our anti-spamming policy > << are at www.asktax.org. > << Copyright (2006) - All rights reserved. > << ================================================== ===== >
 

Tags
financial, proper, software
Similar Threads
Thread Forum Replies Last Post
Financial Management Software Fees
Smith Family: I use 2006 Deluxe and for the first time I have been billed $9.95 as a monthly fee. Legacy Bank One customer, with accounts that have been opened...
Microsoft Money 5 03-18-2006 09:06 PM
How to get proper asset allocations
Dave: It seems that money is not capable of providing accurate asset allocations for mutual fund portfolios. OK.. I can accept that. Now, is their a way...
Microsoft Money 1 03-10-2006 11:11 PM
1040X: What are proper attachments?
Chris: Knowing I was getting a refund, I filed my 2004 taxes electronically (TurboTax online) in early February once I received all of my 1099s, W-2s,...
Taxes 6 04-15-2005 10:46 PM
Proper use of categories in invoicing?
Murray: I am a freelance web developer. I use Money to print and track my invoicing. Being a freelancer, I often have a wide variety of clients: there is...
Microsoft Money 4 07-05-2004 08:52 PM
New Question: Proper Way to use Budgeting?
HeadRusch: As a stem from an earlier thread I posted: Is there a way to allocate income to a particular income fund, that when I look at my expense...
Microsoft Money 2 02-05-2004 05:26 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 03:57 PM.