Best Way to find Outstanding Checks in a Bank Statement

Today, you’ll learn how to find outstanding checks in a bank statement.

To identify outstanding checks in a bank statement, a systematic approach involves reconciling the cash book with the bank statement for the relevant period.

Starting the reconciliation

Initially, compile all credits recorded in the cash book and correspondingly list all debits reflected in the bank statement during the reconciliation period.

When reviewing book credits, it’s essential to note that they may encompass non-check disbursements.

However, it is advisable to exclude these non-check disbursements from the reconciliation process, as they are reconciled differently.

By doing so, you streamline the reconciliation procedure, avoiding potential confusion and maintaining a straightforward approach.

Similarly, when examining bank debits, it’s recommended to distinguish between check and non-check debits.

This separation enhances the clarity of the data and simplifies the reconciliation process.

By categorizing and dealing with checks and non-check debits separately, you reduce the complexity of the task, making it easier to identify discrepancies and ensuring a more accurate reconciliation.

This clear differentiation contributes to a more efficient and straightforward handling of financial data during the reconciliation process.

Comparison between two records

Subsequently, conduct a meticulous comparison between the recorded credits in the cash book and the debits in the bank statement, utilizing check numbers as a key reference point.

This step ensures a thorough examination of each transaction to pinpoint any disparities or discrepancies.

Using a tool – Excel

how to find outstanding checks in a bank statement? Use VLOOKUP.

For a more efficient and organized process, consider employing a tool such as Excel.

Utilizing functions like VLOOKUP can streamline the reconciliation by extracting values from the bank debits directly into the spreadsheet.

This not only enhances accuracy but also facilitates the identification of specific transactions associated with outstanding checks.

To further isolate outstanding checks, calculate the variance between the bank and book data.

Practical Method

A practical method is to use the VLOOKUP function in Excel, which returns #N/A for rows where there is no match between the check numbers in the cash book and the bank statement.

Any rows displaying #N/A can be indicative of outstanding checks that require further investigation and resolution.

This systematic approach, combining manual reconciliation and technological tools, ensures a comprehensive and efficient process for identifying outstanding checks in a bank statement.


When undertaking the reconciliation process, it is crucial to consider the presence of outstanding checks from previous months by Incorporating these outstanding checks into the reconciliation.

Outstanding checks from prior months often serve as common culprits for reconciliation errors.

In order to achieve a thorough and precise reconciliation, it is imperative to include previous months’ outstanding checks in the book credits.

Recommending our own tool

We invite you to explore our free reconciliation tool, Ubervalidate.

This tool is designed to efficiently reconcile two sets of data, revealing the specific items that align or differ between the two records.

By employing an index, Ubervalidate effectively highlights variations in the amounts recorded, aiding in the identification of discrepancies within the records.

Ubervalidate simplifies the reconciliation process by presenting a clear comparison of data, allowing users to easily discern variations in amounts between the two records.

The tool goes a step further by displaying any data that is not found in both sets, providing a comprehensive overview of both matching and non-matching items.

This straightforward presentation of information ensures a user-friendly experience, making it simpler for individuals to identify and address discrepancies in their records using Ubervalidate.

Jason John Wethe
Follow Me
Latest posts by Jason John Wethe (see all)
Scroll to Top