Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

How do I create a report of uncleared transactions in a credit card account?

We have about 30 transactions in a credit card account that don't appear on statements and they don't belong in other credit card accounts. I want to make a report of those transactions. I can't figure out how to customize a report to do that. I selected 2019, just that credit card account, included all categories and payees, and selected "not cleared" on the Advanced tab. I was told that there were no results using those filters. What am I doing wrong?

Thanks.

Answers

  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭
    It sounds like you are on the right track. Did you check all the other tabs in the report customization popup to make sure that something is being excluded that should be included, instead?  I would make sure the boxes for "Show (hidden categories)" on the Categories tab and for "Show (hidden tags)" on the Tags tabs are checked before clicking on "Select All".
    I find that the one tab that gives me the most issues because I tend to forget to thoroughly check it is the Advanced tab...especially related to transfers, subcategories and tax-related transactions.  I would think you would want the Advanced tab to look like this:
    Does any of this help?
    (QW Premier Subscription: R32.12 on Windows 10)
  • Frankx
    Frankx SuperUser ✭✭✭✭✭
    edited December 2020
    Hi @Nardar,

    It is difficult to understand exactly which selections you've made above - some of them seem to be on point, but it is not clear which type of "report" those steps are producing.  Also - I am wondering why you seem to limit the report to "2019" - is that because all the transactions you want to report on are in that year?

    To generate a report that will produce for all "uncleared" transactions in an account, you need to do the following:

    1) Open up the credit card account register (the one with the problem);
    2) Click on the "gear" icon in the upper right;
    3) Select "More Reports" > the click "Register Report";
    4) In the new pop-up window > click on the "Gear" icon and in the new pop-up window, select the "Advanced" tab;
    5) In the "Status" box - remove the check marks from both "Newly cleared" and "Reconciled" BUT leave the check mark for "Not cleared";
    6) Click  "OK"

    Let me know if this has produced the information you wanted or if you have followups.

    Frankx


    Quicken H&B-Subscription - Ver. R29.20 - Build 27.1.29.20  - Windows 10 Home - Ver. 2004
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you.  -
  • UKR
    UKR SuperUser ✭✭✭✭✭
    Other than trying to customize a report, have you worked with the Filter fields in the account register view?
    First set the 3rd filter field to "Unreconciled". That should filter the view to show all transactions not marked reconciled.
    Does that show you what you want to see?
    Set the 1st filter field from "All Dates" to "Last Year" (this will show 2019 transactions while we're still in 2020) or "Custom" and set a date range
    Once the view shows only the transactions you're interested in, press CTRL-P to generate a Transaction Report, optionally with Split category detail.
  • Rocket J Squirrel
    Rocket J Squirrel SuperUser, Windows Beta ✭✭✭✭✭
    I have a saved report just for this purpose to find uncleared transactions in my banking & spending accounts.
    Start with Reports > Banking > Transaction.
    Customize to include only the account(s) in question, the date range if you want to restrict it (I don't), and ensure only "Not cleared" status is checked on the Advanced customization tab.
    There shouldn't be anything more to it than that. Sometimes the critical factor is starting with the best report for the job.
    Quicken user since version 2 for DOS, now using QWin Premier Subscription on Win10 Pro.
Sign In or Register to comment.