tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/68212-grouping-of-transactions-in-transactions-reportInfinite Kind: Discussion 2021-05-30T19:10:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-23T20:49:01Z2021-02-23T20:49:01ZGrouping of transactions in transactions report<div><p>I'm a fellow user.</p>
<p>I'm seeing a couple of small oddities in the subtotalling of this report.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-24T12:31:37Z2021-02-24T12:43:06ZGrouping of transactions in transactions report<div><p>How curious! I find I get the same. It seems to group separate transactions properly but break up split transactions. I have one split transaction - same category, different memos and amounts - that the report fragments into two groups, putting one part out of sequence in the alphabetic ordering by payee.<br>
I've just now managed to cause another break into two separate groups (but in correct alphabetic order this time) by splitting a transaction and assigning different memos. Give the two splits the same memo and they're properly grouped again.</p>
<p>PS I see the same in both the Transactions and the Transactions Filter reports.</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-24T14:13:20Z2021-02-24T14:13:20ZGrouping of transactions in transactions report<div><p>This has always been the case with this report (MD confuses the "Description" and "memo" fields and gives you a mixup of the two in reports that contain both non-split and split transactions). This also occurs in the Expenses Graph on the Summary Page. If you drill down from a category and then again to transactions, you'll see the same thing where sometimes a "Payee" will be shown (transactions that do not have splits) and other will show the memo entered for splits.</p>
<p>In this case, the Find and Replace Extension and a spreadsheet are your friend. In Find and Replace, make sure to check the box "Splits as Memos". In fact, if you watch the list of transactions as you check and un-check "Spits as Memos" you'll see the changes in the Description field for split transactions as it toggles between the main transaction Description and the split memos.</p>
<p>Hope that's not too confusing, but I think it has to do with the way MD handles transactions as double entry.</p>
<p>Art. Just another user - not MD support.</p></div>Arttag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-24T14:59:29Z2021-02-24T14:59:29ZGrouping of transactions in transactions report<div><p>Aha! I’d never quite figured out what “Splits as Memos” did, as memos aren’t displayed, but now I see: it toggles whether a split’s memo fields appear under descriptions. Thank you! You've clarified a lot (though I'm not convinced this is about double entry - yet. :) ) Now I can see why my tests gave haphazard results, so...</p>
<p>Eric, we have a possible solution, if it is indeed split transactions that are causing trouble in your reports. Put the same Payee in the Memo field of each line of the split. If you still need further info in the split's memos, add it after the payee (eg "My Party - dinner" and "My Party - auction" so that even though there'll be two groups in the report, at least they'll appear one after the other.</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-24T16:11:20Z2021-02-24T16:11:20ZGrouping of transactions in transactions report<div><p>All transactions consist of a 'Parent' and at least 1 split. The parent holds the Description and a 'Memo' field and the splits each hold the content of the actual txns:<br>
- e.g. the amount(s). - e.g. a memo/description field A single line entry actually has one split..</p>
<p>The split can only hold a single description field which actually appears as 'memo' when you view the split txn. The Parent holds the Description and also a memo..</p>
<p>It is entirely possible that a single split/line transaction can hold:<br>
- Parent Description - Parent Memo - Split 1: Description (which shows as a Memo)</p>
<p>If there was a 2nd split, then this can also hold a Split 2 Description - and so on...</p>
<p>Confused yet?! Now you can see why the reports have problems</p>
<p>I haven't analysed your problem, but if the report is trying to sort / Total including split data then this may be confusing the logic/output...</p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-24T20:14:11Z2021-02-24T20:14:11ZGrouping of transactions in transactions report<div><p>Thanks, that does make it clearer, especially considering that Split#1Description's populated with Parent Description (we don't usually see it but it appears when we split a transaction).<br>
A little more testing suggests that when set to Subtotal by Payee:<br>
Transaction Filter subtotals by SplitDescription, but labels the total with the Description of the last transaction in the group<br>
Transactions subtotals by SplitDescription+Description, but sorts by SplitDescription+Date.</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-25T20:26:39Z2021-02-25T20:26:39ZGrouping of transactions in transactions report<div><p>Thanks, Art. And to all others who’ve responded. Grateful to find this is a quirk of MD, not a quirk of my brain.</p>
<p>So, I’ve checked out the find and replace extension. Never would’ve occurred to me if it hadn’t been suggested. For the category I want to get a report on I get a list of transactions ordered by date.</p>
<p>There is one recurring transaction that is split. All the rest are not split. I don’t need to have the splits reported separately. Checking the “consolidate splits” box gives me what I want, the total expenditure.</p>
<p>I imported the date ordered list from the find and replace extension into a spreadsheet. There was some disorder in the imported list that was a result of inconsistent characterization of related transactions, It’s been a while since I worked with a spreadsheet so the mechanical reordering was a bit cumbersome process.</p></div>Eric Weirtag:infinitekind.tenderapp.com,2009-01-14:Comment/490524932021-02-28T19:05:14Z2021-02-28T19:05:14ZGrouping of transactions in transactions report<div class="ApplePlainTextBody">
<div class="ApplePlainTextBody"><br>
<blockquote type="cite">On Feb 24, 2021, at 9:59 AM, Ben <tender+d9cbf195a3@tenderapp.com> wrote:<br>
<br>
Eric, we have a possible solution, if it is indeed split transactions that are causing trouble in your reports. Put the same Payee in the Memo field of each line of the split. If you still need further info in the split's memos, add it after the payee (eg "My Party - dinner" and "My Party - auction" so that even though there'll be two groups in the report, at least they'll appear one after the other.<br></blockquote>
<br>
Thanks, Ben.<br>
<br>
Being retired with a relatively simple income stream I do not need to be very detailed in my accounting, e.g., I am ever unlikely to need to report splits separately. Checking the “consolidate splits” box gets a transaction list/report that meets my needs.<br>
<br>
------------------------------------------------------------------------------------------<br>
Eric Weir<br>
Decatur, GA USA<br>
eeweir@comcast.net<br>
<br>
"What does it mean...that the world is so beautiful?"<br>
<br>
- Mary Oliver<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br></div>
</div>Eric Weir