When the transactions are downloaded (added or matched) via Bank Feeds they immediately are marked CLEARED.  After the banks are reconciled, the transactions that were checked during the reconciliation are marked as RECONCILED.  All Other transactions will be left UNCLEARED.

So, I would like to show you how to produce an UNCLEARED transactions report, that basically shows all the bank transactions that are neither CLEARED nor RECONCILED.  First Step is go to the reports section:

Screen Shot 2014-02-15 at 11.52.52 PM


And open a Balance Sheet Report:



Screen Shot 2014-02-15 at 11.53.07 PM



And then double click on the total balance of bank accounts to see all the bank transactions both RECONCILED/CLEARED and UNCLEARED:

Screen Shot 2014-02-15 at 11.55.30 PM



Then, customize the report to only show UNCLEARED Transactions, by click on Customize button on the top-left corner, and scrool down to the Status section and look for “Cleared / All” click on the drop down menu and change it from All to Uncleared.

Screen Shot 2014-02-15 at 11.53.42 PM


After you click on Run Report, you can save the report by clicking on Save Customizations on the top of the report

Screen Shot 2014-02-15 at 11.55.59 PM



Give it a name such as “Uncleared Transactions” and you will be able to see it in the Reports section under My Custom Reports, and pull it whenever you need.

Screen Shot 2014-02-15 at 11.56.14 PM




Share →

Leave a Reply

Your email address will not be published. Required fields are marked *

For More Information

Call us to 1-800-819-6307 or email: info@quickbooks-training.net