Banking Balance Sheet Report with Reconciled/Cleared Transactions

Options
MHG
MHG Member

I recently took over as Treasurer for a Boy Scout Troop and created a new Quicken Classic file (Windows). I cannot create a Banking Report that shows the bank balance with ONLY "reconciled/cleared transactions" so I can easily compare the Bank's online balance to Quicken's balance. I want to verify the balances throughout the month and NOT just when statements are published.

Prior Quicken versions had check boxes to select a combination of Uncleared/Cleared/Reconciled transactions for Balance Sheet Reports in the Customization settings. That option no longer appears in Quick Classic that I can find. For my older Quicken files (oldest was created in 1991), I have a saved report that allows me to quickly verify the Bank balance quickly. Class can generate the saved report in older files, but cannot create the report for newly created files.

Two Questions: First - can I create this report in Quicken Classic, and if so how? Second - if I cannot create this report in Quicken Classic, when will you ADD this capability that has been in PRIOR versions of Quicken for many years?

Tagged:

Comments

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Options

    On the Advanced tab of REPORTS, Banking, Transaction do you not have these options?

    If not, what Q product are you running?

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Options

    Extending my prior reply. I don't understand why, for example, checks that you've written but haven't yet cleared the bank shouldn't be included in your balances.

    Also, you can print the Reconciliation report to show what's in Q vs. the bank statement.

    And, you can always click on the CLR column header in the account register to sort the account by "R" txn, followed by "c" txn, followed by " " txn to get the info you're wanting. Then clicking on the DATE header to re-sort.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • MHG
    MHG Member
    Options

    I am looking for a Balance Sheet Report which does NOT have the options above.
    The Banking Transaction report does have that screen, but it generates a list of transactions - not a balance sheet. But for the Balance Sheet report, the ONLY "advanced" option is "include unrealized gains"

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Options

    Try the Banking Summary Report, Rows = Accounts. Other customization as applicable. The Advanced tab includes those options.