Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
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.
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.
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"
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:
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.
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?
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.
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.
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.
Thanks!
The CLR column is exactly what I needed and couldn't figure out how to get it.
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:
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!
I have similar problem. When I run the report no check marks show up in the Clr column even though they have been cleared.
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:
If you see these results:
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.
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?
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here