[Kmymoney] Reconciliation report

[Phil Richardson]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20150920/84f775be/attachment.html>