share purchase cost base error
Comments
-
Hi Bob,
The cost base correctly includes commissions in its' calculation. Could you do a manual calculation - including commissions and see if you have a matching figure? If so, all is good!0 -
Bob,
Without disclosing personal information, would it be possible to provide more details of the error, so we can get a better understanding of the magnitude of the incorrect report ?
Eg date of transaction, number of shares, purchase price etc, then latest share price and date. Then provide the summary report values.
John
0 -
Thanks for your response Lesley and John. I have included the commissions when entering my total cost as I usually do so there is no problem there. The exact transaction is entered as follows: 18th Nov 2016 Bought 12,000 NXT for a total of $36,779.90 The Investing -- Overview -- Holding summary states: 12,000 NXT held with a cost base of $18,056.94 and market value of $37,320 (as of 22 Nov 2016) Bob0
-
Bob,
I assume you are looking at the Investing : Portfolio value screen.
There are a number of different Show: options. Are they all consistently showing this error ?
Your info indicates RPP estimates a purchase price of about $1.50 and a market price of $3.11.
Could it be RPP assumes purchased 24,000 shares, (purchase 12,000 and add 12,000) then removed 12,000, ie your correction transactions are causing the duplicate.
Security detail view should list all transactions.
0 -
Yes both Show options show the same error. There are no duplicate transactions in the Transaction List. Only the one. Also, I just tried a dummy sell transaction to see if the correct gain was recorded. When I clicked "Sell all Shares in this Account" It automatically entered 9,500 units not the correct 12,000. I have owned this stock in the past but last sold all units in May 2016.0
-
"It automatically entered 9,500 units not the correct 12,000"
I am a bit confused, but certainly the source of this problem is a good place to start.
0 -
I have had this cost bas error many times over the 15 years I have used various versions for this program with multiple files and thousands of transactions. Some of the cost base errors can be resolved by refreshing a transaction e.g. the very first transaction, some can be resolved by deleting and re-entering certain transactions, one has to try and pick the timing of the offending transactions. It is common to find when a stock has been sold down to a zero balance there is a residual negative cost base when one runs the portfolio value and cost report. There are crazy entries in the Capital Gains records as a result, resulting in an over estimation of capital gains. I have analyzed some of these for hours, reported the bug to Reckon 10 years back but no response. I am convinced there is a bug somewhere in the background programs and that is why I am moving my high volume portfolios to another platform, as the hours I chew up correcting these cost base errors could buy 5 alternative packages. And yes, I make sure buys are entered before sells to avoid selling shares that are not their in Reckon to be sold. Pity as the software has some good features,
0 -
The number of shares reported is a bit surprising as number of shares is a key report for most screens. You would have seen this for years.
The way RPP manages change to the capital base could be a problem, especilly when deleting sell transactions.
I would suggest you try to export all transactions for this account and this security and carefully understand and recreate the capital calculations for all sales. Could it have carried capital from previous sales, especially if RPP has an incorrect estimate of your zero share holding event.
0 -
Thanks for the suggestion John. In some cases we are talking scores of transactions per security so that is one painstaking task for recovery, but not prevention of recurrence.
0 -
Having read these comments it would appear that changing the cost basis for shares cannot occur.My experience is that the cost basis error only occurs when part of a share portfolio is sold and then further purchases and sales occur.Also the system does not account for the situation where no cost is involved as a result of an overall profit from selling part of the portfolio and still retaining shares. As an example buy 10000 shares @ say $1 (total cost $10000, sell 5000 of those shares at say $3 (proceed received $15000) The remaining shares in effect cost nothing.Any suggestions anyone.
0 -
Barrie,
If you purchase say 10,000 @ $1 then sell 6,000 shares @ $3, this should result in removal of 6,000 shares and $6,000 of capital base + $12,000 of capital gain, with $4,000 remaining capital base.
If the purchase history is more complex, you have the ability to select which (purchase) lots are allocated for the sale, which identifies the capital base allocated to the sale.
Managing the capital base becomes more complex if a return of capital occurs, especially where multiple lots are purchased. I have forgotten how RPP handles this transaction, but this could be the source of the problem. This occurred for me with RPP when Singtel restructured many years ago. The capital return exceeded the capital base and I had a negative capital base remaining. ( I can't recall how I entered the return of capital)
0
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 📢 Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 36 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 28 Reckon Mate App
- 2.7K Reckon One
- 12 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 22 Reckon Insights
- 100 Reckon API
- 309 Point of Sale
- 1.9K Personal Plus and Home & Business
- 69 About Reckon Community