Bank Reconciliation Report

Thanks for your prompt reply.  I guess I've been concentrating on the numbers and neglected to read!

The question was...

"Is there a way to keep "New Transactions" from printing on the Bank Reconciliation Report? "

These steps do not eliminate the NEW TRANSACTONS from being displayed on the reconciliation reports for the summary NOR the detail.

Because when information is in the books for months on end it makes the reconciliation reports too long. Therefore... I am also looking for the answer to this question. 

Thanks

Thank you for joining the thread, @Carrolp.

I'm here to help exclude the new transactions when printing the reconciliation report.

You'll want to display the Reconciliation report so you can customize the reporting date period before printing it. This way, you'll be able to eliminate the new transactions. Here's how:

1. From the Select Reconciliation Report window, select Summary, Detail, or Both.
2. Click the Display button.
3. In the report window, click the Customize Report button.
4. From the Report Date Range section, enter the date range of the report you want to show.
5. Click OK.
6. Then, select the Print button to print the report.

I'm adding this article to learn more about customizing reports: Customize reports in QuickBooks Desktop.

You might also want to learn more about the reconciliation workflow. This can help make sure the amounts match your real-life bank statements.

It’s nice to work with you, @Carrolp. Don't hesitate to click the Reply button below if you need further assistance running reports.

Thanks for your reply. This action do eliminate the new transactions from the reconciliation reports, but then it eliminates the beginning balance as well as items reconciled in the current period but the date is outside of the current period. This throws off the numbers in the reconciliation detail so my summary and detail don't match. 

Thanks for getting back to us, @Carrolp.

I have some information about the reconciliation beginning balance. The beginning balance shown in the reconciliation summary is the totals of your current reconciliation. However, the amount of the reconciliation detail report includes your transaction totals.

You'll want to click on the total ending balance of your reconciliation summary to view the match beginning balance.

Here's an article to in case you encounter issues in reconciling accounts: Fix issues when you're reconciling in QuickBooks Desktop.

If you still have questions about the report, please reply to this thread anytime. I'm more than happy to assist you some more. Take care and stay safe.

That doesn't work. When you set the dates for the reconciliation it leaves many transactions off the report, such as uncleared checks from a previous reconciliation, Cleared Balance, etc...

Likewise, the "Ending Balance" is not clickable.

All I want is for the reconciliation to print out only the items either 1.) entered during the reconciliation period and/or 2.) reconciled during the reconciliation period.

So if I'm printing January reconciliation, I don't want all of the checks for February, March, April to be in the report.

But I also want the report to show uncleared checks from the previous year that were reconciled in January.

There must be a way to do this without compromising the report. Any Suggestions?

I completely understand the importance of having accurate and comprehensive records, TKTrident. Let me assist you in pulling up that information.

In QuickBooks Desktop, you have the option to generate a customized report that includes transactions entered or reconciled within a specific reconciliation period. By utilizing special filters, we can quickly display the data you need for analysis or review. I'll walk you through the steps:

1. Head to the Reports menu.
2. Hover over Banking and select Previous Reconciliation.
3. Pick an account, then set the correct period and report type.
4. Click the Customize Report button.
5. Go to the Display tab, then set the appropriate date and accounting method.
6. Head to the Filters tab and select the Entered/Modified option.
7. Choose All from the drop-down menu and adjust the period to January.
8. Hit OK, then click the Print button.

Don't forget to memorize it to save the current customization settings. Furthermore, the process for viewing the previous year's uncleared checks that were reconciled is slightly different. We'll have to run the reconciliation report for the month you're currently working on and compare it to the previous period. 

1. Head to the Reports menu.
2. Hover over Banking and select Previous Reconciliation.
3. Pick an account, then Tick the Detail and Transactions cleared at the time of reconciliation radio buttons.
4. Select the statement ending date for December and January.
5. Keep in mind that the program will populate this report in a PDF format.
6. Under the Uncleared Transactions section, you'll see the uncleared checks and payments that were reconciled.
7. Click the Print icon at the top.

To ensure that you'll get the most out of QBDT's reporting capabilities, I recommend reading these articles:

• Set report preferences
• Customize reports

I'm still here if you have further questions about bank reconciliation. Just add the details below and I'll get back to you as soon as I can. Have a great rest of the day!