Unable to close a Share/Equity account - SOLVED

[Michael Calder]

G'day Thomas, Jack and the list,

Apologies for, I suspect, not posting correctly but problem solved.

Looking at the documentation from the "broker"/CHESS Sponsor I saw that they advised thus:

25 Feb 11*Adjustment*  due to Reconstruction of Capital (Balance) 1802,*(Off) 1201*, (Balance) 601.

Focussing on the word OFF I decided to try Remove Shares (1201) instead of Split 1 for 3.

BINGO! When I went to INVESTMENTS the stock/Equity showed Value - $0.00, Quantity - 0.
AND Close account was now an option in the Account drop down. Account is now closed.

I don't understand the subtleties of what I did but it was a "cashless" transaction.
May be there needs to be a modification in the The KMyMoney Handbook - for KMyMoney version 5.0.

Anyway, problem solved and thanks for your help.

Cheers,

Mike.

Michael Calder

On 20/11/23 00:51, Michael Calder wrote:
>
>
> G'day again,
>
> And thanks for your replies and help.
>
> I have found HOW to open the Database - RTFM 😳
>
> BUT - 1. It is a DB;*SQLCipher Version 3 (encrypted SQLite)*
> and I do not have a PASSWORD. The file was Created on 28/07/2010, 13 years ago!
> I do not recall ever creating a PW and although I have earlier recorded PWs on a
> PW protected file created 2018 which I managed to "remember" (fluke) the PW there is
> nothing that works on my DB. Was there ever a default PW?
>
> 2. Regarding the stock split transaction, I think I did that before I did the fiddle of
> the original 1802 to 1803 but will do another delete of the split and then re-enter the details.
>
> I deleted the split entry and also the original Buy 1802 which was an Off Market Transfer when the stock,
> which I had inherited from my mother some years previously, was transferred into Joint names.
> (Comment:The transfer generated capital gains on which Tax was paid; so all done legally)
> I then shut down the computer - waited and restarted - and then re-entered an Off Market transfer Buy
> for 1803 on 29/7/2002 and the 1 for 3 split of 601 on 25/2/2011.
>
> The "books" all balance and the stock now shows Value $0.00 and Quantity 0, as it should.
> Unfortunately Right Click on the stock in Investments - Equities still has "Close account' greyed out.
>
> To prove KMyMoney is all OK I did a Sell (all) on another stock I will be selling soon and had no
> problem Closing the account and then Reopen account and cancelling the Sell.
>
> Any more ideas on how to look inside the Database.
>
> Mike.
> On 18/11/23 23:00, kmymoney-request at kde.org wrote:
>> Today's Topics:
>>
>>     1. Re: KMyMoney Digest, Vol 155, Issue 2 (Michael Calder)
>>     2. Re: Unable to close a Share/Equity account (Jack)
>>     3. Re: Unable to close a Share/Equity account (Thomas Baumgart)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Sat, 18 Nov 2023 07:09:48 +1100
>> From: Michael Calder<michaelcalder at iinet.net.au>
>> To:kmymoney at kde.org
>> Subject: Re: KMyMoney Digest, Vol 155, Issue 2
>> Message-ID:<d1679cea-10a1-47e0-87a0-9e619d61313d at iinet.net.au>
>> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>>
>>
>> G'day ,
>>
>> Correction - the second price should also be*$5.85*  - Sorry.
>>
>> Mike.
>>
>> On 17/11/23 23:00,kmymoney-request at kde.org  wrote:
>>> Today's Topics:
>>>
>>>      1. Unable to close a Share/Equity account (Michael Calder)
>>>
>>>
>>> ----------------------------------------------------------------------
>>>
>>> Message: 1
>>> Date: Fri, 17 Nov 2023 16:39:10 +1100
>>> From: Michael Calder<michaelcalder at iinet.net.au>
>>> To:kmymoney at kde.org
>>> Subject: Unable to close a Share/Equity account
>>> Message-ID:<b11817a8-a004-4589-b42c-0be96221fa92 at iinet.net.au>
>>> Content-Type: text/plain; charset=UTF-8; format=flowed
>>>
>>>
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:<http://mail.kde.org/pipermail/kmymoney/attachments/20231118/db14fc09/attachment-0001.htm>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Fri, 17 Nov 2023 16:10:21 -0500
>> From: Jack<ostroffjh at users.sourceforge.net>
>> To:kmymoney at kde.org
>> Subject: Re: Unable to close a Share/Equity account
>> Message-ID:<Z3MSZGJU.IUPSL6GG.6R4NH3WW at 3JJOBUNM.SAR64GGH.Q3LDWJJB>
>> Content-Type: text/plain; charset=us-ascii; DelSp=Yes; Format=Flowed
>>
>> On 2023.11.17 00:39, Michael Calder via KMyMoney wrote:
>>> 	I have a similar problem to that in KMyMoney Digest, Vol 155,
>>> Issue 1 - "delete loan account (Jochen)"
>>> Since 2010 I handled Investments without problems, except for the
>>> recent Online "yahoo" one which is currently OK.
>>> My current Investments show 23 Equity accounts of which 9 were closed
>>> without problems.
>>> 	I recently sold all shares in an equity which had been SPLIT
>>> (consolidated) on a 1 for 3 basis on 18/2/11.
>>> The original holding was 1802 which resulted in 601 being sold at
>>> 5.85 each BUT! The Investments view showed
>>> a "residual" Value of -$1.95 with Quantity 0 and Price $5.80. As
>>> expected I cannot "Close account" as the value is not zero.
>>> 	Examining the figures 1.95/5.85 is 0.3333333 and the problem
>>> stems from the 1 for 3 consolidation back in 18/2/2011.
>>> I have tried a "fiddle" by increasing the original 1802 to 1803 and
>>> this results in the Value changing to the desired $0.00
>>> but "Close account" remains greyed out.
>>> 	How do I find "a copy of your data file"?
>> It is possible that the residual is indeed due to a rounding problem,
>> which I believe was fixed some time ago.  As the split is a likely
>> candidate, the first, quick, thing I would try is to edit and save that
>> stock split transaction.  That should apply the newer rules to the
>> calculation of the number of shares.  There is also a perl script to
>> help identify such transactions, but I've got to hunt for it and then
>> figure out how to use it.
>>
>> In terms of finding your data file, its name is shown on the title bar
>> of the program, and if you do a File/Open... it should show you the
>> directory where the file is located.  (If you are using an SQL back
>> end, then you don't have a "data file" you have a "data database.")
>>
>> Jack
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Sat, 18 Nov 2023 10:21:05 +0100
>> From: Thomas Baumgart<thb at net-bembel.de>
>> To: KMyMoney Users' mailing list<kmymoney at kde.org>
>> Subject: Re: Unable to close a Share/Equity account
>> Message-ID: <12345378.O9o76ZdvQC at sy-346-nb>
>> Content-Type: text/plain; charset="utf-8"
>>
>> On Freitag, 17. November 2023 22:10:21 CET Jack via KMyMoney wrote:
>>
>>> On 2023.11.17 00:39, Michael Calder via KMyMoney wrote:
>>>> 	I have a similar problem to that in KMyMoney Digest, Vol 155,
>>>> Issue 1 - "delete loan account (Jochen)"
>>>> Since 2010 I handled Investments without problems, except for the
>>>> recent Online "yahoo" one which is currently OK.
>>>> My current Investments show 23 Equity accounts of which 9 were closed
>>>> without problems.
>>>> 	I recently sold all shares in an equity which had been SPLIT
>>>> (consolidated) on a 1 for 3 basis on 18/2/11.
>>>> The original holding was 1802 which resulted in 601 being sold at
>>>> 5.85 each BUT! The Investments view showed
>>>> a "residual" Value of -$1.95 with Quantity 0 and Price $5.80. As
>>>> expected I cannot "Close account" as the value is not zero.
>>>> 	Examining the figures 1.95/5.85 is 0.3333333 and the problem
>>>> stems from the 1 for 3 consolidation back in 18/2/2011.
>>>> I have tried a "fiddle" by increasing the original 1802 to 1803 and
>>>> this results in the Value changing to the desired $0.00
>>>> but "Close account" remains greyed out.
>>>> 	How do I find "a copy of your data file"?
>>> It is possible that the residual is indeed due to a rounding problem,
>>> which I believe was fixed some time ago.  As the split is a likely
>>> candidate, the first, quick, thing I would try is to edit and save that
>>> stock split transaction.  That should apply the newer rules to the
>>> calculation of the number of shares.  There is also a perl script to
>>> help identify such transactions, but I've got to hunt for it and then
>>> figure out how to use it.
>> That is located e.g. at
>>
>> https://invent.kde.org/office/kmymoney/-/blob/master/contrib/getsplitpart.pl?ref_type=heads
>>
>> and contains a bit of documentation how to use it.
>>
>>> In terms of finding your data file, its name is shown on the title bar
>>> of the program, and if you do a File/Open... it should show you the
>>> directory where the file is located.  (If you are using an SQL back
>>> end, then you don't have a "data file" you have a "data database.")
>> The above mentioned script does not work with an SQL back end
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20231123/c9af025a/attachment.htm>