cancel
Showing results for 
Search instead for 
Did you mean: 
mike129
Level 1

0 Cleared transactions, please help

I've been using Desktop Pro for over 3 years. Normally I download transactions from my bank feeds, match them, and leave everything alone. After a few years and some checks which people have never deposited, balances have skewed. I don't really care about the discrepancy, I send the company file over to my CPA and they have their own system (I guess a company created by them) for handling everything. 

 

What I do need for myself is a report of uncashed checks, and according to QB, every single one of them is uncashed. I didn't realize matching them in bank downloads would leave them as uncleared. How do I generate a report of all checks printed since day one with no matching transaction from my downloads?

 

If I go to bank feeds --> Use Register, the ones which really did not clear are unmarked, but there's no way to export it out, or run a report. If I use the report creater, it thinks every check in the system is uncleared. The info I want is definitely there (based on what I can see in the register) but how do I get it out to excel, or something usable?

Solved
Best answer May 15, 2021

Best Answers
JessT
Moderator

0 Cleared transactions, please help

Hi Mike!

 

I've read the entire post, and I see that running a report that shows the cleared/reconciled and uncleared checks will really help you spot the cause of the balance issues over the years. I'll be sure to help you with this.

 

To achieve this, we can run a quick report of your business account and filter the check transactions. Then. we'll add the cleared (Clr) and the printing (Print) columns to see which of them are cleared, printed, or not for both.

  1. From the Lists menu, choose Chart of Accounts.
  2. Right-click on your business account and select QuickReport [account_name].
  3. Change the date range and click on Customize Report.
  4. Go to the COLUMNS section and search for Clr and put a checkmark beside it.
  5. Search for Print and put a checkmark beside it.
  6. Click the Filters tab.
  7. Below CHOOSE FILTER, search for TransactionType and click to highlight the result.
  8. In the TransactionType droplist, select Check.
  9. Click the OK button.

The final report will look like in the screenshot below. You can export your customized report to Excel and use Excel's functions to get the total of the uncleared checks or the ones that are not printed yet.

Account QuickReport.PNG

 

About your question on only making the matched transactions as reconciled, you may do this by going to each transaction in the register and changing the lightning bolt indicator (matched) to a checkmark (reconciled). However, this method will defeat the purpose of reconciliation, so I suggest going through the usual reconciliation process instead of manually doing it per transaction. And remember, create a backup before changing any transactions.

 

You can always mention my name if you need more help with this. I just want to make sure that you're all set.

View solution in original post

10 Comments 10
mike129
Level 1

0 Cleared transactions, please help

To add -- In the register (where it marks which transactions are not cleared and sorts) there is an option for quick report, but when I click it, I get an error "Quick Books Cannot generate a report without a name"

DivinaMercy_N
Moderator

0 Cleared transactions, please help

I'm glad to see you here, @mike129.

 

To get rid of the message Quick Books Cannot generate a report without a name, you have to make sure that there has a name specified on the selected transaction. Example the payee name. Here's how:

 

  1. Go to the Banking menu and select Use Register.
  2. Choose the account and click OK.
  3. Select a transaction and then click the QuickReport button. 
  4. To export the report, click the Excel drop-down and choose Create new worksheet.

 

You'll want to personalize and filter only the data you need when generating a report, feel free to customize them in QuickBooks. For more details, please see this article: Customize reports in QuickBooks Desktop.

 

Don't hesitate to post again here if you have further concerns accessing your reports. I'm just a post away to help. Take care always.

mike129
Level 1

0 Cleared transactions, please help

That almost works. 

 

When I click on a transaction, it generates a report of only that payee. Then I can modify the report and remove the payee filter to get it for everyone. The problem is, the report is grouping by payee, then giving a subtotal for each, and when I export it out to excel, there is no easy way to sum the totals. And, you still can't run it for only uncleared (or cleared) transactions. Setting it to cleared within the same filter does the same things as before -- returns zero results (or returns everyone for uncleared). If it weren't for the grouping and listing subtotals after each payee, I'd be able to export it out, sort in excel, find the point where cleared transactions start, then delete the rest and total what's left, but it doesn't work.

 

Let me ask something different, which would "make the system work" so that customs reports would generate what I need -- Is there a way to mark ONLY all of the matched transactions to my bank feed as reconciled / cleared? 

JessT
Moderator

0 Cleared transactions, please help

Hi Mike!

 

I've read the entire post, and I see that running a report that shows the cleared/reconciled and uncleared checks will really help you spot the cause of the balance issues over the years. I'll be sure to help you with this.

 

To achieve this, we can run a quick report of your business account and filter the check transactions. Then. we'll add the cleared (Clr) and the printing (Print) columns to see which of them are cleared, printed, or not for both.

  1. From the Lists menu, choose Chart of Accounts.
  2. Right-click on your business account and select QuickReport [account_name].
  3. Change the date range and click on Customize Report.
  4. Go to the COLUMNS section and search for Clr and put a checkmark beside it.
  5. Search for Print and put a checkmark beside it.
  6. Click the Filters tab.
  7. Below CHOOSE FILTER, search for TransactionType and click to highlight the result.
  8. In the TransactionType droplist, select Check.
  9. Click the OK button.

The final report will look like in the screenshot below. You can export your customized report to Excel and use Excel's functions to get the total of the uncleared checks or the ones that are not printed yet.

Account QuickReport.PNG

 

About your question on only making the matched transactions as reconciled, you may do this by going to each transaction in the register and changing the lightning bolt indicator (matched) to a checkmark (reconciled). However, this method will defeat the purpose of reconciliation, so I suggest going through the usual reconciliation process instead of manually doing it per transaction. And remember, create a backup before changing any transactions.

 

You can always mention my name if you need more help with this. I just want to make sure that you're all set.

mike129
Level 1

0 Cleared transactions, please help

Thanks!

The CLR column is exactly what I needed and couldn't figure out how to get it.

MJoy_D
Moderator

0 Cleared transactions, please help

You're welcome, @mike129. It's our pleasure to help.

 

I'm here to show you how to have the Clr column in your reports. 

 

You can have the Clr column when you run a QuickReport in QuickBooks Desktop. I'll show you how to generate this report from your Chart of Accounts. Follow the steps below:

 

  1. Go to the Lists menu and select Chart of Accounts.
  2. Right-click on the account and select QuickReport.
  3. Click the Customize Report button then filter the necessary information.
  4. Select OK.

 

To learn more about reports in QBDT and how to customize them, you can check out this article: Customize reports in QuickBooks Desktop

 

You can also export your report to Excel. This way it'll be easy to convert the report to your specified file format. See this article for more details: Export reports as Excel workbooks in QuickBooks Desktop.

 

Fill me in if you need more help with managing your transactions or anything else related to QuickBooks. Take care and have a great rest of the day!

RDW2
Level 1

0 Cleared transactions, please help

I have similar problem. When I run the report no check marks show up in the Clr column even though they have been cleared.

JoesemM
Moderator

0 Cleared transactions, please help

Thanks for joining this thread, @RDW2. Allow me to chime in and share additional information to get this resolve.

 

The steps shared by my colleague MaryJoyD should show the CLR column with checkmarks since the transactions are already cleared. That said, we can verify and rebuild your data in QuickBooks. By doing this, we can identify and resolve the most commonly known data issues within your company file.

 

Here's how:

 

  1. Select Window and then select Close All.
  2. Go to the File menu.
  3. Choose Utilities and then click Verify Data.

 

If you see these results:

 

  • QuickBooks detected no problems with your data, no further action is needed.
  • When there's a specific error message, you can search it in our QuickBooks Desktop support site for specific instructions.
  • Your data has lost integrity, which indicates that there's data damage, we can follow the steps below to correct the problem:
  1. Choose the File menu.
  2. Select Utilities and then choose Rebuild Data.
  3. You'll receive a notification to backup your company file, and then click OK.
  4.  Once done, the Rebuild Data utility will start.
  5. When you get the message, Rebuild has completed, Click OK.

 

Check out this article for reference: Resolve data damage. In the same link, you’ll find other data damage troubleshooting steps for Windows.

 

Let me also add these resources that you can use for guidance in managing your reports efficiently in QBDT: 

 

 

I'll be right here to continue helping if you have any other concerns or questions about managing reports,RDW2. Have a good one. 

RDW2
Level 1

0 Cleared transactions, please help

OK. So I ran the verify data and it reported no data issues. When I re-ran the quickreports or financial reports there is no information displayed under the column Clr. I go to customize report and check the Clr column. The header shows up on the reports but there is no checks in that column. If I click on an entry and visualize the check it is clearly marked as cleared.

Any helps?

Jovychris_A
Moderator

0 Cleared transactions, please help

Thanks for bringing us the update you have after following my peer's response, @RDW2.

 

Since there are no checkmarks found in the Clr column though clicking the entry visualizes clearly that the checks have been marked as cleared, I suggest contacting our QuickBooks Desktop Support team. They have the tools to review this behavior and investigate this further.

 

Here's how:

 

  1. In QuickBooks Desktop, press F1.
  2. Click Contact Us.
  3. Enter your concern and then hit Let's talk/Continue.
  4. Choose to start a Chat or get a Callback.

 

You can also check this link for more information and ensure to check their schedule section to know when agents are available: Contact QuickBooks Desktop support.

 

I'm adding this article to check more effective ways to filter the columns of each report: Customize reports in QuickBooks Desktop.

 

Please continue to update us here on how it goes. We're always ready to give our hand. If you have other questions about running reports, feel free to tag me. Take care.

Need to get in touch?

Contact us