Splits for tax-deduction tagging without totalling the entire check amount in Transaction Reports?
How can I use splits to effectively split a transaction between tax deductible items and non-tax deductible items without it totalling the entire check amount in the Transactions report?
Let's say I go to Wal-Mart and spend $300 with my Visa. Now lets say $200 of that is family living expense, and NON tax-deductible, and $100 was spent on office supplies, which ARE tax deductible. What I want to do is (either with tags, or categories, I don't really care which) be able to generate a report for my transactions that shows me all my tax deductible expenses with an accurate subtotal at the bottom by month, for all accounts. I have been just tagging everything that's deductible, even in splits (only tagging those items within the split that are deductible, leaving the ones that aren't blank, and not specifying a tag for the entire check). This works fine, except for the subtotal being incorrect. In the Transaction report, it only lists the items that I have tagged as "Tax Deductible", but in fact subtotals the split items in the list for the WHOLE check amount on that transaction. So with my above example: It would add in $300 to the tax deductible transaction report, instead of only the $100 (the split of the transaction which I've tagged as deductible. Is this intended behavior or a bug, or perhaps I'm just not understanding the purpose of splits? Any insight would be greatly appreciated.
Let's say I go to Wal-Mart and spend $300 with my Visa. Now lets say $200 of that is family living expense, and NON tax-deductible, and $100 was spent on office supplies, which ARE tax deductible. What I want to do is (either with tags, or categories, I don't really care which) be able to generate a report for my transactions that shows me all my tax deductible expenses with an accurate subtotal at the bottom by month, for all accounts. I have been just tagging everything that's deductible, even in splits (only tagging those items within the split that are deductible, leaving the ones that aren't blank, and not specifying a tag for the entire check). This works fine, except for the subtotal being incorrect. In the Transaction report, it only lists the items that I have tagged as "Tax Deductible", but in fact subtotals the split items in the list for the WHOLE check amount on that transaction. So with my above example: It would add in $300 to the tax deductible transaction report, instead of only the $100 (the split of the transaction which I've tagged as deductible. Is this intended behavior or a bug, or perhaps I'm just not understanding the purpose of splits? Any insight would be greatly appreciated.
3
people have this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?The problems are multiple. Tags were poorly designed and never fully implemented. Tags only apply to the originating side of the transaction, not the other side. So why are tags even allowed on splits? Beats me. Also, MD's reporting capabilities are, unfortunately, poor. Only a few reports even enable filtering by tags. As a result, really the only way to report using tags is to find the report you want and fit your recordkeeping to the report.
Personally, I use separate categories in this case. For example, I need business expenses in separate categories anyway. Tags for me are for a cross-section: primarily separating expenses by client. As a result, I haven't run into the particular problem you did.
I agree that what you are asking for ought to work, but I'm not surprised that it doesn't.
Edward -
Inappropriate?I am a new Moneydance user and like the program very much. The lack of fully functional tags and not-very-useful reports is a problem, however. What would be the best way to request these be remedied?
-
Send a note to support@moneydance.com in order to add your name to the list of people requesting better tag handling. -
Inappropriate?Thanks, have done...
Loading Profile...


