[Kmymoney] Reconciliation report

[Jack]

On 2015.09.20 14:04, Phil Richardson wrote:
> I am attempting to use reporting to explore which accounts have not  
> been
> correctly reconciled for a while.
> 
> I store my data in a MySQL DB rather than flat file.
> 
> From the DB, the following raw applies to the sample report I am  
> working
> with.
> 
> From a configuration perspective, the only things I have done to  
> customise
> this report is to search for any transactions on any account at all,  
> that
> as a state of "Not Reconciled".
> 
> Only for some reason, this is not working.
> 
> 
> <REPORTS>
>   <REPORT includesprice="0" includesactuals="0" columnsaredays="0"
> includestransfers="0" loans="0" id="R000048" comment="Custom Report"
> rowtype="accountreconcile" name="Transactions by Reconciliation Status
> (Customized)" chartgridlines="1" includesaverageprice="0"
> includesmovingaverage="0" chartbydefault="0" skipZero="0"
> datelock="alldates" investments="0" charttype="none" favorite="0"
> chartdatalabels="1" convertcurrency="1" chartlinewidth="1"
> includeschedules="0" querycolumns="number,payee,category,balance"  
> tax="0"
> group="Transactions" includesforecast="0" includeunused="0"  
> mixedtime="0"
> type="querytable 1.14">
>    <STATE state="notreconciled"/>
>   </REPORT>
>  </REPORTS>
> 
> I have in total two liability accounts (Credit Cards) (0 closed), and  
> 17
> asset accounts in total (9 closed).
> 
> When I run the listed report, it shows me transactions that are long  
> ago
> cleared and more importantly, long ago reconciled.
> 
> For a sample credit card as an example. The ledger correctly reports  
> it was
> last reconciled on 20th Aug 2015. It correctly reports 1 cleared
> transaction and 1 uncleared transaction.
> 
> However, it also showed reports every other transaction on this card  
> ever,
> in a "Reconciled" header.
> 
> Another sample is a previously savings account that is now closed.  
> This
> account only ever received 4 transactions ever.
> 
> 1x payment in
> 2x interest payments
> 1x payment out
> 
> This account was reconciled prior to closure. However, all three
> transactions are displayed with no header (cleared, uncleared,  
> reconciled).
> Presumably because they all fall under one of reconciled.
> 
> Note: I showed 4 payments but only 3 in the report. I am aware that
> transfers register against the outgoing account, hence why it doesn't  
> show
> the incoming payment.
> 
> Is there any reason why this filter is not functioning correctly?

I have confirmed that this report seems to not correctly honor the  
state dropdown.  "All states" and "Cleared" work correctly for me.   
"Reconciled" shows both reconciled and cleared, and "Not reconciled"  
shows reconciled and not marked.  I have filed a bug:  
https://bugs.kde.org/show_bug.cgi?id=352954.

In addition, the transaction state dropdown in the ledger includes both  
"Not reconciled" and "Not marked".  If "Not reconciled" in the report  
is meant literally, then it should include both not marked and cleared  
transactions, and not just not marked, but it seems wrong in either  
case.

It is not clear to me whether your additional questions are related to  
this bug or completely separate - so if you could come up with a  
separate example, it might help.

Jack