[Kmymoney] Reconciliation report

[Phil Richardson]

No, that pretty much confirms things.

Thanks.

On 20 September 2015 at 21:18, Jack <ostroffjh at frontier.com> wrote:

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