Daily Reconciliation

Reconciling your bank statements is crucial for maintaining accurate financial records and ensuring proper management of your business's cash flow. It helps you catch any discrepancies early, whether due to errors or unauthorized transactions. No worries, Nicole. I'll lay down the measures to help you search for a check using the amount or date in QuickBooks Desktop (QBDT).

To make the process easier, a workaround is customizing and running a Transaction Detail or Check Detail report to locate the checks since there's no feature for directly searching them by date or amounts within the reconciliation window. Here's how:

Transaction Detail Report

1. Go to Reports and choose Custom Reports.
2. Pick Transaction Detail.
   
   
   
   
3. In the Modify Report pop-up window, choose the date period.
4. In the Columns section, ensure the Amount, Check #, and Date have a checkmark before them so they will show up in the report. 
   
   
   
   
5. Tap the Filters tab and click Transaction type. Then, choose Check from the dropdown.
   
   
   
   
6. You can also add the Account filter and pick a specific bank account from the dropdown.
   
   
   
   
   

You will now see the list of all checks with the respective dates and amounts. If you want to search for a specific amount, please refer to the steps below:

1. Click Customize Report.
2. Tap the Filters Tab. Select Amount in the FILTER area.
3. Tick the = sign and type the amount in the designated box.
4. Hit the OK button.
   
   
   

In finding a specific date of a check, here's how:

1. Select Customize Report.
2. Click the Filters tab. Then, tap Date from the FILTER box.
3. Choose Custom and pick the date in the From and To area.
4. Hit OK.
   
   
   

Alternatively, you may generate a Check Detail Report and make the same modifications in the previous report.

1. Go to Reports.
2. Choose Banking.
3. Select Check Detail.
   
4. For the modifications, you can refer to the steps provided in running a Transaction Detail report.
   
   

By implementing these strategies, you can enhance the process of finding specific checks, making it more manageable and efficient. Regular reconciliation, coupled with these techniques, will help you maintain  precise and consistent financial information. If you require further assistance running reports in QBDT, post a reply below. I'll be around to respond promptly, Nicole.

Although this is good information it doesn't really help the person that is reconciling. 

We have over 1000 entries so far this month.  When on the reconciliation page there is really no help on this screen to search a check or date range.  I feel like there can be more help on this screen besides "Sorting your data" Which can take forever if you are sorting by check# or Amount #.  It would be easier to do this every week then for us to have to wait till the end of month.  I'm wondering if there is a process that we can do weekly?