Some transactions are not showing up in reports

pete4sure

When I run a report for transaction under a certain category, they don't show up. This causes problems when I'm trying to get my budget in order.

For example, I want to track my spending for student loans and I use a category for them. They don't show up in the transaction report for category nor do they show up in my budgeted items. Any suggestions?

jacobs

Two questions:

(1) Which report are you using? That is, are you starting from Create Transaction Report or one of the other named reports on the main menu, or are you using the old Category Summary (which in the latest update is now under the Other Reports heading)? You should be doing the former, not the latter; the old Category Summary report is known to have some bugs which can result in missing transactions.

(2) You say you used a category for the loan payments. Aren't these transactions Transfers to the loan account (or a split with a Transfer to the loan account and a split for interest expense)? Transfers don't have expense categories. Are the loan payments which are missing from your report transfers to the loan account? Transfers won't show up in reports unless you specifically set up your report to include transfers. You can do this in the report's Customize screen by setting it to not include the Loan account, so only the transfer from your checking account to the Loan account . (If you don't take this step the transfer to the loan account and the transfer from the checking account cancel each other out.) Then go to the Advanced tab and select "Include only transfers with accounts outside of report. Your transfers should now be visible in your report.

DauARPY

I wish I had an answer for pete4sure, but I am having the same issue where transactions are not included in Category Transaction reports. I am using "Create Transaction Report" and for example I want to run a simple report for "Utilities" that has 8 subcategories (i.e. water, gas, electricity, etc.). When I customize for date, and all accounts, only 2 of the 8 categories are included. PG&E should be listed under the subcategory "Electricity" in my case, but that subcategory is not included in the report, nor are the 6 others. However, if I search a register for PG&E all transaction are listed. Similarly, if I try to run a Payee Summary report, that payee is not found. I have replicated this issue for several category and payee reports where transactions are included. I am using Mac Premier 2020 5.16.1. I have been a Quicken user since 1992 and recently (finally) converted from QMac 2007. It is my goal to reconstruct all of my memorized reports from QMac 2007 to Premier 2020 before upgrading to Catalina. Thanks in advance for any insight on this issue.

jacobs

Two questions:

(1) Which report are you using? That is, are you starting from Create Transaction Report or one of the other named reports on the main menu, or are you using the old Category Summary (which in the latest update is now under the Other Reports heading)? You should be doing the former, not the latter; the old Category Summary report is known to have some bugs which can result in missing transactions.

(2) You say you used a category for the loan payments. Aren't these transactions Transfers to the loan account (or a split with a Transfer to the loan account and a split for interest expense)? Transfers don't have expense categories. Are the loan payments which are missing from your report transfers to the loan account? Transfers won't show up in reports unless you specifically set up your report to include transfers. You can do this in the report's Customize screen by setting it to not include the Loan account, so only the transfer from your checking account to the Loan account . (If you don't take this step the transfer to the loan account and the transfer from the checking account cancel each other out.) Then go to the Advanced tab and select "Include only transfers with accounts outside of report. Your transfers should now be visible in your report.

DauARPY

I wish I had an answer for pete4sure, but I am having the same issue where transactions are not included in Category Transaction reports. I am using "Create Transaction Report" and for example I want to run a simple report for "Utilities" that has 8 subcategories (i.e. water, gas, electricity, etc.). When I customize for date, and all accounts, only 2 of the 8 categories are included. PG&E should be listed under the subcategory "Electricity" in my case, but that subcategory is not included in the report, nor are the 6 others. However, if I search a register for PG&E all transaction are listed. Similarly, if I try to run a Payee Summary report, that payee is not found. I have replicated this issue for several category and payee reports where transactions are included. I am using Mac Premier 2020 5.16.1. I have been a Quicken user since 1992 and recently (finally) converted from QMac 2007. It is my goal to reconstruct all of my memorized reports from QMac 2007 to Premier 2020 before upgrading to Catalina. Thanks in advance for any insight on this issue.

pete4sure

jacobs-
Thanks for the insight. The information popped right up when I ran the report you suggested.

Now, what about the issue with the budget? I show zero actual money for the category. How do I budget for a loan payment?

jacobs

Ah yes, budgeting for loan payments; I meant to address that…

You can't. Currently, there's no way to include fund transfers, such as loan principal payments, in a budget. Some people have come up with workarounds like dummy transactions, but the real solution awaits an update from the developers. The good news: they've acknowledged this as a significant need, and further, promised it's being worked on. In fact, the ability to selectively include transfers in reports, which was added in the past half year, was a necessary step on the way to providing similar functionality for budgets. The bad news: this and several other budget requests mean the developers have to do major re-writing of the budgeting code in Quicken Mac, and it's taking longer than it seems they originally expected. There have been a few hints that this functionality may be coming in the months ahead, but we don't know when they'll release new features.

DauARPY

Just in case someone stumbles across my " issue where transactions are not included in Category Transaction reports” similar to pete4sure’s issue, I wanted to explain how I solved the problem. As a recent convert from QMac 2007 to subscription QMac Premier 2020, with over 100 accounts, and thousands of transactions, I have been reconciling, testing, tweaking and running parallel for 2 of 3 months. In QMac 2007, I used a leading space to name several of my most used accounts so they would appear at the top of the “Accounts List” and the “Registers List". Apparently, when the data was converted to QMac Premier 2020, the leading space caused these accounts to be hidden in the “In reports" feature in subscription QMac Premier 2020. They were included “In “lists” but not in reports. Once I changed the account names to omit the leading space and changed the account settings to NOT hide “In reports”, all of the transactions from these accounts were included in Category Transaction and Payee reports as expected. In hindsight I should have reviewed all accounts immediately after converting to assess the “hide and show” statuses in both lists and reports.