Tag Summary report does not include all tagged transactions
I am using build 792 on Mac OS 10.6.8
Noticed that some tagged transaction are left out in the Tag
Summary Report.
I have 11 tags set up. One of the tags is Q5. So far this year, I
have one $1,500 credit card transaction on 7/1/11 tagged Q5. When I
run the default Tag Summary report ytd, with All Accounts, I see
the Q5 tag showing $0.00.
When I edit the report to include only that credit card account,
the tagged transaction shows up.
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Ben Spencer on Sep 01, 2011 @ 03:12 AM
The important thing to remember about tags is that the two sides of a transaction can have different tags, or one side can be tagged and not the other.
When you tag a transaction in a bank register the tag is applied to the other side of the transaction.
Make sure that the transactions are tagged in the bank account not in the expense/income registers.
Ben Spencer
Moneydance Support
2 Posted by Fred on Sep 01, 2011 @ 04:33 AM
Ben,
I looked at the other side of this transaction and the tag is there too.
Having checked this, i need to say that I really don't understand your feedback. With your logic, how do you explain that the Tag Summary does show this transaction if I limit the report to show that credit card account only, but not show it if the report includes all accounts?
As i said in my post, i entered a credit card transaction (not sure if in your world a credit card would equate to a bank account) and included a tag - the other side of this transaction is an Asset account (it' s downpayment on a car order).
Moreover, I am really puzzled by your feedback. In a double-entry bookkeeping system as invented several hundred years ago by the Medici's and as adopted by Moneydance, one should expect that when one enters a transaction, whatever gets entered in one side gets carried over into the other side, including memos and tags. I am glad to see that this happened as expected with this entry, but now your feedback worries me as to where my entries could get truncated on the other side ... I hope this is not true/never happens.
But again, this wouldn't even explain what I am seeing.
Regards
Fred
3 Posted by Ben Spencer on Sep 01, 2011 @ 11:26 AM
Double entry book keeping has nothing to say on the subject of tags. Double entry book keeping tells us that if you enter a debit in one account it must be balanced by credit in another account and vice versa. There is no requirement for descriptions or memos on either side of the transaction to be equal only that the amounts balance.
The topic tags is somewhat more controversial. Lets take your transfer as an example. If you enter a transfer form the credit card account to the asset account, you have two transactions one in each account. The value of the credit card account is reduced and the value of the asset is increased. (lets say the transaction is for $1000 for this example) If both sides were tagged and you ran a tag summary that summed up all transactions with that tag what should the total be? Should it be 1000 or -1000 or 0.
My point is that if you were to tag both sides of every transaction, since every transaction has an opposite balancing entry the sum of every tag summary (if run on all accounts) would be zero. This is why tags are only applied to one side
It is not ideal and I have discussed alternatives at length with the developers and we are not certain what the ideal solution should be.
Ben Spencer
Moneydance Support
4 Posted by Fred on Sep 02, 2011 @ 01:48 AM
Ben,
I understand your explanation. This makes the present Tag Summary report useless, doesn't it? To achieve what one would expect from a "Tag Summary" report, should i then only select Bank Accounts and Credit Card accounts and deselect everything else? Or, with other words, how can I get a report which shows the totals of all Income & Expenses for a selected tag?
While playing with this report, another question came up: when I am in the "Edit" mode of a report, below the "Grouping by" area is a window topped with selection buttons - how are these used. In my sample case, where the other side of the transaction is an Asset, I tried to generate a new report by simply deselecting Assets in this bottom window, but nothing changed in the resulting report. I had to Remove the Asset from the Account list in the upper part of the dialogue window to get the expected result.
Thanks for your valued help.
5 Posted by Ben Spencer on Sep 02, 2011 @ 03:41 AM
I don't think the tag summary report is useless rather I think it doesn't make much sense to tag transactions that are transfers. (for the reasons stated above) Tagging transactions that are categorised as income or expenses however is fine.
If you want to get a report which shows the totals of all Income & Expenses for a selected tag I recommend the Income and expense report. This report has a "Filter by tag" option.
With regard to your second question I am not quite certain what your objective is. What data do you want to see?
Ben Spencer
Moneydance Support
System closed this discussion on Mar 31, 2015 @ 03:38 PM.