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

sorting reconciliation report by amount

Hi, does anybody know how to sort a reconciliation report by amount in Windows Quickbooks desktop? I used to use Mac Quickbooks desktop and it can be sorted by clicking "amount" but Windows one is different. It doesn't work that way. Please advise. Thank you.

6 Comments 6
LieraMarie_A
QuickBooks Team

sorting reconciliation report by amount

Hope you're doing well, @05Greathead.

 

Being able to sort the Reconciliation report would be helpful as it would be quicker and easier to find values. You may consider exporting it in spreadsheet software. Then, you can sort a range or table of data on one or more columns.

 

Here's how:

  1. Go to the Reports menu.
  2. Choose Banking and select Previous Reconciliation.
  3. Select an account and a type of report.
  4. Choose Transactions cleared plus any changes made to those transactions since reconciliation and click Display.
  5. Select the Excel on the toolbar. 
  6. To create a new Excel workbook, select Create New Worksheet.
  7. When you’re ready to export, select Export.

 

You can also read though our guide for your convenience: Export reports as Excel workbooks.

 

Furthermore, there are various financial reports available in QuickBooks that give you snapshots of different areas of your business. You can also customize them and focus on the details that matter the most to you.

 

Keep in touch with me here should you need further assistance in customizing your reports. I'm always available to help.

05Greathead
Level 1

sorting reconciliation report by amount

Thank you for the reply. So, it is impossible to sort the report by amount without exporting to an excel spreadsheet, correct?

RenjolynC
QuickBooks Team

sorting reconciliation report by amount

That is correct, 05Greathead.

 

In the meantime, you can follow the steps provided by my colleague LieraMarie_A. Then, manually edit the report to sort the amount from the Excel spreadsheet. 

 

You can also share this suggestion to our product developers. They'll review this idea and might consider updating it in the future.

 

Here's how:

 

  1. Go to Help > Send Feedback Online > Product Suggestion.
  2. Enter your request and click Send Feedback.

Aside from the articles shared by my colleague above, I'd like to add this link on how you can customize other reports in QuickBooks Desktop: Customize reports in QuickBooks Desktop.

 

If you have any additional questions regarding the reports or other concerns, please let me know in your reply. We'd be happy to assist you again. Take care.

05Greathead
Level 1

sorting reconciliation report by amount

Got it. Thank you so much.

BigRedConsulting
Community Champion

sorting reconciliation report by amount

Sorting by amount in Desktop works fine for me. I just click on the Amount column:

 

Capture.JPG

 

BigRedConsulting
Community Champion

sorting reconciliation report by amount

@RenjolynC 

@LieraMarie_A 

RE: Being able to sort the Reconciliation report would be helpful as it would be quicker and easier to find values. You may consider exporting it in spreadsheet software. Then, you can sort ...

 

Yes, that's why QuickBooks has had the sorting feature for many years. Why would you tell a customer that sorting isn't possible when it is possible and has been for many years?

 

Capture.JPG

Need to get in touch?

Contact us