Transaction Reports have rows with account and category switched

jross's Avatar

jross

21 May, 2020 09:58 PM

I made a list of last year's transactions with a category of "Household" (and all subcategories).
I want to see them all, across all accounts.

I can get that report, but the results are peppered with certain transactions with negative amounts and reversed account and category names.

1) I have carefully compared each reversed transactions to nearby normal transactions, and can see no important differences in the register
2) I am aware that CC accounts have negative values for a charge, but other charges in the same account are not shown as negative in the report
3) I am using Copy to Clipboard into Excel, but I did paste it into a text editor as well and the data is reversed right from the application

I'm not sure what to do here. I have some reports for taxes that need to be done pretty quickly. Any advice?

  1. 1 Posted by dwg on 21 May, 2020 10:12 PM

    dwg's Avatar

    I'm a fellow user.

    "I can get that report," What report?

    For category reporting you would normally use an Income and Expense report and if you want to see individual items you would choose the Detailed version of this report.

  2. 2 Posted by jross on 21 May, 2020 10:34 PM

    jross's Avatar

    The original report was "Transaction Filter".

    Ok, I see how "Income and Expenses, Detailed" could get me those transactions. Unfortunately each category and subcategory are in a header and I will need to cut-paste it back to into each row, Also there is no filter so it will have every transaction for the whole year regardless of category. It will take an hour each time but I guess I can work with that, thanks. You may have saved the weekend!

    The problem with the "Transaction Filter" report's "Include Sub-Accounts" checkbox (should say sub-categories?) is that the records for the root category are queried like a transaction, but the records in sub-categories are queried with the amount sign flipped and the account / category reversed. Then they are all listed together. That has to be a bug.

    Of course I could just add a subcategory called "Household:Uncategorized" for all "Household" records so all results would be reversed in the same way.

  3. 3 Posted by dwg on 21 May, 2020 11:08 PM

    dwg's Avatar

    If you go to the bottom of the parameter screen in the Income and expense reports you can change it the By Individual and select only the categories you want reported on.

    I'm not following you on how you are using the Transaction filter report, or on what your overall aim is.

  4. 4 Posted by sth on 22 May, 2020 12:25 AM

    sth's Avatar

    This is double entry bookkeeping and you are seeing both sides of a transaction, both from and account to a category and a category to an account. These are negative and opposite transactions. Make sure your filters are set for only the accounts you want.

  5. 5 Posted by jross on 22 May, 2020 08:05 PM

    jross's Avatar

    Thanks for your replies.

    I want to dump all the transactions for last year that are in my "Household" category, or sub-categories under "Household" (like "Household:Electricity") into Excel. I want all transactions regardless of the account. That way I can sort and review items that may partially apply to my home office.
    I would also use exports like this to sanity check my categories and review for errors. I did it in Quicken and Money before that, so its a biannual thing for me.

    dwg:
    I don't think I am looking at the same dialog as you are. I've attached a screenshot of what I see when I click "Edit" and I don't see "by individual", nor any way to supply more than one account or category except the "Include Sub-Accounts" option.

    sth:
    I'm aware of double entry accounting (dimmly!) but what I'm seeing does not seem to reflect two sides. I just set Account/Category to "Household" (a category) and checked Include Sub-Accounts because that is the only way to supply multiple categories that I can see.
    The transactions from Household are displayed properly, those in sub-categories are shown in reverse/sign flipped, and I do not see matching transactions for the same date with values in the correct order.

    Thanks again for your help!

  6. Support Staff 6 Posted by Ethan on 22 May, 2020 08:25 PM

    Ethan's Avatar

    Based on what you've described, I'd suggest that the Income and Expenses, Detailed report may display the information you want. You're not seeing the options dwg suggested because your screenshot is for the setting for the Transaction Filter report. I've attached a screenshot of the settings window for the Income and Expenses, Detailed report. My mouse is over the By Individual button dwg mentioned, on the right side of the window just above the box that takes up the bottom third of the window. Once you click on that, that box will show all of your categories and subcategories. You can then choose just the ones you want to include in the report, which sounds like your Household category and every category under that.

    Ethan Infinite Kind Support

  7. 7 Posted by sth on 23 May, 2020 01:34 AM

    sth's Avatar

    What version of MD are you using? What OS?
    I don't get doubled versions with Mac OS 10.11 and MD 2019.4 (1903)
    But my transaction filter pages does not look quite like yours. You can also try the transactions report as well it is basically a simplified version of the filter.
    If you look at Tools->Accounts do you see "Household" in that list, the difference between a category and an account is fairly subtle.

    Note that your screen shot shows Account/Category as the drop down and mine only lists Account.

    I get a reasonable report with the following:

  8. 8 Posted by jross on 23 May, 2020 03:41 AM

    jross's Avatar

    sth:
    Yep that's how mine is set! I am on Windows 10, ver 2019.3 (1880)

    I'm pretty sure there is a bug in the Transactions report for my version, but I did find a work around (below). Do you happen to have a mix of transactions categorized in the Household category as well as subcategories? If so do they look as you would expect?

    Ethan:
    Thanks, I see now the difference in the report dialogs. The Income and Expense report would contain the data I want, but since I want to sort it in Excel that would be a lot of manual work to copy and paste the section's header to every detail line.

    My workaround was to move all transactions with category "Household" to a new category "Household:Misc". Now all the records are displayed the same way in the report and I got the job done.

    I feel very strongly this report should be fixed. Can I submit a defect report somewhere, or is this it?

  9. 9 Posted by sth on 23 May, 2020 11:19 PM

    sth's Avatar

    That is odd that our versions are so close together but there are differences in the window labels. There may be a bug fix and you should try the latest preview version. Preview versions are quite stable and this one has been out for awhile. There is nothing in the change notes that would suggest a fix.

    I have items in subcategories and don't think I have any just "household". But the report looks like I expect. It is weird that you only get some transactions reversed and I am wondering if you have confused accounts and categories in your database? Is there any consistency to those transactions "peppered" through your reports.

    This is how to report a bug. It would help to show more data of exactly how the bug is triggered. If you can make a simple MD file that demonstrates it and attach it to this discussion it would certainly help. Or you can mark the discussion private (and it dissapears from all us users) and attach your actual data file. Ethan marked with the big orange bar above is the only official support person here.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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