cancel
Showing results for 
Search instead for 
Did you mean: 
gloriadeb204
Level 3

reconciliation report

I have a large monthly bank statement to reconcile, averaging 400K to 600K deposits and withdrawals.

Compounding the issue - we not only write checks directly out of QB, but some employees carry pocket checkbooks and write checks when they need to. 

Is there a way to print what I have reconciled so far so I can compare things to try to find what I missed? 

17 Comments 17
katherinejoyceO
QuickBooks Team

reconciliation report

It's my pleasure to guide you in printing your reconciliation report, @gloriadeb204

 

Yes, you can. And please note that you can only get reports for the last 120 reconciliations in QuickBooks Desktop. 

 

Here's how you can print your previous reconciliation report: 

 

  1. Go to the Reports menu, then go to Banking and select Previous Reconciliation.
  2. Select the account you reconciled from the Account drop-down menu.
  3. Select the reconciliation period you want to review in the Statement Ending Date section. 
  4. Select Detailed or Both for the report type. We recommend Detailed if you're using the report to fix a reconciliation.
  5. Select which transactions you want to see on the report:
    1. Transactions cleared at the time of reconciliation: This gives you a snapshot. It only shows transactions in the account at the time of the reconciliation.
    2. Transactions cleared plus any changes made to those transactions: This shows transactions in the account at the time of reconciliation. It also shows where they currently are in your accounts.

 

Once done, select Display. Then, click the Print option at the top menu bar. 

 

For more insights, refer to this article: Get reports for previous reconciliations in QuickBooks Desktop.

 

Here's an article for your future reference in case you'll have trouble with previous bank reconciliation: Resolve common issues on Previous Reconciliation report.

 

Feel free to get in touch if you need anything else. I'm always around here to lend a hand. 

katherinejoyceO
QuickBooks Team

reconciliation report

Hi gloriadeb204,


Hope you’re doing great. I wanted to see how everything is going about the reconciliation report you had yesterday. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.


Looking forward to your reply. Have a pleasant day ahead!

LightingSales
Level 1

reconciliation report

Hello,

 

Could you please let me know how to get a Statement Ending Date past the oldest date provided on the Previous Reconciliation Report screen? The last transaction showing is 01/04/2021 and I need December of 2020. I did see that you can only receive the last 120 transactions, I would need just a few transactions past the 120 limit. If there is anyway to receive this information, I would greatly appreciate it. Does the QuickBooks ONLINE version have a limit of 120 as well? Or is there a higher limit/no limit for the ONLINE version? Going forward, I will save the reconciliations as a PDF file. 

 

I look forward to hearing back from you. Thank you!!!

JessT
Moderator

reconciliation report

Hi LightingSales,

 

In QuickBooks Desktop. You can only get the last oldest transaction (date) on the available reconciliation reports. Go to Reports > Banking > Previous Reconciliation.

 

In QuickBooks Online, you can only add 124 transactions per reconciliation as well.

 

Going forward, if you'll have more than 120 or 124 transactions per period, just split your reconciliation.

 

Let me know if you have other questions in mind.

Rainbolt
Level 2

reconciliation report

The  Statement Ending Date is not an option  - I am using QuickBooks Desktop Pro Plus 2021

Rainbolt
Level 2

reconciliation report

I do not have the option for selecting the Statement Ending Date, I used to have that option. Is there a setting that has changed? Can you help me get that option back?

JessT
Moderator

reconciliation report

Hi Rainbolt,

 

Thank you for taking the time to post today.

 

With the Pro/Pro Plus version, you can only see the most recent reconciliation report. That's why you don't see the "Statement Ending Date."  That option is only available in QB Premier and Enterprise. Please refer to this article: Get reports for previous reconciliations in QuickBooks Desktop.

 

With the absence of the said feature, I would recommend saving a copy of your reconciliation report right after you reconcile.

 

If you need more help with reports, feel free to go back to this thread. I'll be more than happy to assist you again.

angelinmo
Level 2

reconciliation report

not being able to reprint a report prior to the last reconciliation is a sad state of affairs.   This feature needs to be added.

SarahannC
Moderator

reconciliation report

.Hello there, angelinmo

 

We can send a product suggestion to able to reprint a report prior to the last reconciliation. Your suggestion will still be evaluated by our software team. Here's how you can share your thoughts about the feature you want:

 

  1. Within your company file, click Help.
  2. Select Send Feedback Online.
  3. Click Product Suggestion.
  4. Enter the information. Then, follow the on-screen instruction to complete the process.

 

I've collected some resources where you can get additional tips about handling report in your company file:

 

 

QuickBooks Team is always here if you have follow-up questions. Take care and stay safe, angelinmo.

Dean45
Level 1

reconciliation report

Hi,

I cannt download reconciliation report in Quickbook pro 2022. It happens from last week to now. I select recon report from report-bank. Please help.

 

Thanks,

julie 

Dean45
Level 1

reconciliation report

Hi,

 

I cannt download reconciliation report from Quickbook Pro 2022. it happens from last week to now. Please help.

 

Thanks,

Julie

MadelynC
Moderator

reconciliation report

Hello there, @Dean45.


I’ve seen that you’ve posted twice on the Community page. My colleague already addressed this download issue for you. You can visit the link to view her recommendation: https://quickbooks.intuit.com/learn-support/en-us/account-management/re-missing-reconciliation-repor...

 

If you encounter trouble in the future with your reconciliation report showing as blank or unclear, check out this article for some fixes: Resolve common issues on Previous Reconciliation report.


Please don’t hesitate to reach back out if you have any other questions or concerns besides downloading the reconciliation report. We’re always here to help.

Eusboeg
Level 2

reconciliation report

When will the feature to select time periods (up to 120+ going to be available in desktop pro plus?? Us non enterprise need companies are brushed off and cheated out of a pretty standard feature? Then, tell me where they are saved so they can be manually found and printed! We use advanced payroll etc. Our bank records/reports aren’t as important? Come on QB. This is a feature that is a no brainer function of an accounting system at the price that is now annual!! And no, you provide service and get this where needed. That’s what’s one big  selling feature of your new annual billing..!

Mark_R
Moderator

reconciliation report

We're taking notes of your feedback and suggestion, @Eusboeg.

 

I've come to share information on how feature requests are enforced in QuickBooks Desktop.

 

Please know that all suggestions are being considered by our product engineers based on the volume of requests and their influence on the user interface before they are implemented.

 

I understand that getting a report beyond 120 reconciliations is beneficial for you and your business. For now, I encourage submitting feedback directly to our product engineers. They may look into this suggestion and consider adding the option in the future update. To submit feedback, you can follow the steps provided by my colleague SarahannC above.

 

You may want to learn the reconciliation workflow in QuickBooks Desktop. This will help you fix reconciliation balances and edit completed reconciliations.

 

We're always here to listen if you have concerns regarding other features. You're welcome to post again or leave a reply below, @Eusboeg.

Eusboeg
Level 2

reconciliation report

You obviously didn’t read it thoroughly nor provide a solution.

Eusboeg
Level 2

reconciliation report

You obviously didn’t read my post thoroughly and did not provide a solution.

GlinetteC
Moderator

reconciliation report

I hear your sentiments, Eusboeg.

 

Concerning the feature of when to select periods beyond 120 reconciliations in QuickBooks Desktop Pro Plus, we're unable to give you a specific time frame when this option is added to the product. 

 

Here are reconciliation-related articles for additional reference and guide:

 

 

I'll be here to lend a hand if you have any other concerns. Take care!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us