Capital Gains report gives incorrect info. Using Personal Plus.
I recently sold several parcels of shares. I estimated my profits of each on my excel spreadsheet as well as entering in Reckon.
I saw that the Realized Gains results in the Income and Expenditure report were vastly different to my spreadsheet results (Net proceeds minus original costs equals profit on sale).
Then I did a report - Investing - Capital gains.
There I saw that the date Bought was listed as 1 July 2015 for all the sales. For several sales I had not taken the average price but had handpicked the parcels I wanted to sell. The Bought dates of these parcels of shares was between 25/6/04 and 7/8/15. In my spreadsheet I listed the actual cost of each parcel on the date it was actually bought.
Sale Parcel 1 - 1000 shares Bought on 7/8/15 for $82,138.45
Sold 4/10/21 Net proceeds $105,373.40.
My spreadsheet has Profit on sale at $23,234.95
Reckon Capital Gains report shows:
1000 shares Bought 1 / 15 /15
Gross proceeds $105,373.40
Cost Basis $16,002.99
Realised Gain $89,370.41
Initially I thought Reckon had just used an average cost of all the shares in this security as a cost Basis, but that average is $19.38. That's the average cost of shares bought over 26 years.
I hope you can explain what's happening and help me correct it.
- All Categories
- 6.7K Accounts Hosted
- 6K Reckon Accounts (Desktop)
- 3.2K Reckon One
- 137 Reckon Payroll Upgrade for Reckon One 🚀
- 10 Reckon Invoices App
- 939 Reckon Payroll App & Web
- 21 Payroll App - Help Videos
- 18 Reckon Mate App
- 14 Reckon Insights
- 107 Reckon API
- 952 Payroll Premier
- 120 Payroll Premier upgrade to Reckon Payroll ⤴️
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 68 About Reckon Community