How to Find Uncleared Transactions in QuickBooks Online

Author

Reads 976

A person inserting a US dollar bill into a vending machine slot, capturing a financial transaction moment.
Credit: pexels.com, A person inserting a US dollar bill into a vending machine slot, capturing a financial transaction moment.

Uncleared transactions in QuickBooks Online can be frustrating to deal with, but they're actually pretty easy to find.

To start, head to the "For Review" section of your QuickBooks Online account. This is where you'll find all the uncleared transactions that need your attention.

The "For Review" section is usually found on the left-hand menu, and it's a great place to start your search. Just click on it and you'll be taken to a list of all the transactions that require your review.

QuickBooks Online uses a color-coding system to indicate which transactions are uncleared, so keep an eye out for the red or yellow flags.

Finding Uncleared Transactions

Finding uncleared transactions in QuickBooks Online is easier than you think. You can easily see uncleared checks when you do your regular bank reconciliation in QuickBooks Online.

Uncleared checks are rows that are not greyed out and do not have a check mark on the right. These are the same transactions that were not cleared in your bank reconciliation.

Additional reading: Fund Accounting Reconciliation

Credit: youtube.com, QuickBooks Online: Cleaning up old uncleared transactions from bank or credit card reconciliation

Another way to locate uncleared checks is to look in the bank register. Entries that do not have a C or an R alongside them have not been cleared.

You can also filter the results of your bank report to pinpoint your uncleared checks. To do this, click the "Filter" button and select "Uncleared" under the "Cleared" box.

To create a report of uncleared checks, you can use the Balance Sheet report or the Statement of Financial Position report. Click on the Reports tab, then select Standard Reports and scroll down to find the Balance Sheet or Statement of Financial Position report.

Here are the steps to create a report for all uncleared checks:

  • Log into your QuickBooks Online account
  • Click on the Reports tab, then select Standard Reports
  • Scroll down to find the Balance Sheet or Statement of Financial Position report
  • Change the reporting period to All dates
  • Change the Accounting method to cash basis
  • Click run report
  • Customize the report to only show uncleared bank transactions by clicking the customize button
  • Group or sort the report by any of the displayed columns
  • Save the report by clicking on the save customization button

By following these steps, you can easily find and track uncleared transactions in QuickBooks Online.

Using Reports

To find uncleared transactions in QuickBooks Online, you can run a bank report. This is the easiest way to find uncleared checks in QuickBooks.

Credit: youtube.com, How to Find Uncleared Checks in QuickBooks Online (Fix Bank Balance Issues)

One way to run a bank report is by navigating to the Accounting menu, followed by Chart of Accounts, and then selecting the bank account for which you'd like to search for uncleared status.

You can also create a custom report to find uncleared transactions. To do this, you can create a Balance Sheet or Statement of Financial Position report, which is also known as a statement of financial position report for a nonprofit organization.

To customize the report, you can group or sort the report by any of the displayed columns and click run report to see the changes. For example, you can group the report by name or sort them by the name of the vendor.

Here are some steps to create a custom report:

1. Log into your QuickBooks Online account.

2. Click on the Reports tab, then select Standard Reports.

3. Scroll down to find the Balance Sheet or Statement of Financial Position report, then click on it to open the report.

4. Change the reporting period to All dates.

5. Change the Accounting method to cash basis, then click run report.

Expand your knowledge: Tradingview Long Position Tool

Credit: youtube.com, How to Clean Up Old Uncleared Transactions in Quickbooks Online (Full 2025 Guide)

6. Click on the total bank account line to open a transaction detail report.

7. Customize the report by clicking the customize button at the top right corner of the page.

8. Group or sort the report by any of the displayed columns and click run report to see the changes.

9. Save the report by clicking on the save customization button at the top.

10. Leave the name as the default because QuickBooks will automatically pick up the name you added earlier.

You can also filter the results of your bank report to pinpoint your uncleared checks. To do this, you can click on the Filter button and select the Cleared checkbox, then click on Uncleared.

Alternatively, you can sort by cleared status by going back to the Accounting menu and selecting Chart of Accounts, then selecting the bank account for which you are trying to find uncleared checks, and clicking View Register followed by Run report.

By using these methods, you can easily find uncleared transactions in QuickBooks Online and take steps to resolve the issue.

Managing Reports

Credit: youtube.com, QUICKBOOKS ONLINE | How to Find Uncleared & Unreconciled Transactions in QBO

To manage reports in QuickBooks Online, you can run a bank report by navigating to the "Accounting" menu, followed by "Chart of Accounts" and selecting the bank account for which you'd like to search for uncleared status.

You can also create a custom report by using the Balance Sheet or Statement of Financial Position report, which can be found in the Standard Reports section.

To customize the report, click on the total bank account line to open a transaction detail report, and then click the customize button at the top right corner of the page.

By grouping or sorting the report by any of the displayed columns, you can tailor the report to show only uncleared bank transactions.

Here are the steps to create a custom report:

  1. Log into your QuickBooks Online account.
  2. Click on the Reports tab, then select Standard Reports.
  3. Change the reporting period to All dates and the Accounting method to cash basis, then click run report.
  4. Customize the report by grouping or sorting the report by any of the displayed columns.
  5. Save the report by clicking on the save customization button at the top.

Once you've created the custom report, you can export it to PDF or Excel by clicking on the drop-down arrow next to the edit button.

Lillie Skiles

Writer

Lillie Skiles is a rising voice in the world of journalism, known for her in-depth coverage of financial and consumer-related topics. With a keen eye for detail and a passion for storytelling, Lillie has established herself as a trusted source for readers seeking accurate and informative articles. Her writing has been featured in various publications, with notable pieces including an exposé on Wells Fargo's banking issues, which shed light on the company's practices and their impact on customers.

Love What You Read? Stay Updated!

Join our community for insights, tips, and more.