Issued Checks vs Cleared Checks: A Practical Reconciliation Guide

A business may record a check when it is written, but the corresponding amount does not leave the bank account until the recipient deposits the check and the bank processes it.

This creates two separate records:

• The issued-check register
• The cleared-check transactions in the bank account

Reconciling these records helps confirm that checks were cleared for the correct amounts and identifies checks that remain outstanding or are missing from one of the sources.

---

What is the difference between an issued check and a cleared check?

An issued check is a payment instrument that the business has prepared and provided to a payee.

A cleared check is a check that has been deposited, processed by the banking system, and charged to the business's bank account.

A check can therefore be:

• Issued but not yet cleared
• Issued and cleared correctly
• Issued and cleared for an unexpected amount
• Voided before clearing
• Replaced by another check
• Recorded by the bank but missing from the internal register

The reconciliation process determines which condition applies to each record.

---

Why is check reconciliation necessary?

The balance in an internal payment register may differ from the bank balance because issued checks do not always clear immediately.

Without reconciliation, a business may not know whether:

• A check is legitimately outstanding
• A payee has not received or deposited a payment
• A check was entered twice
• A check cleared for the wrong amount
• A voided check was presented
• A bank transaction is missing from the accounting records
• The available cash balance is overstated

Check reconciliation connects the internal payment process with the actual activity recorded by the bank.

---

Information required from each source

The issued-check file should ideally contain:

• Check number
• Issue date
• Amount
• Payee name
• Bank account
• Payment description
• Status
• Accounting reference

The bank file should ideally contain:

• Check number
• Cleared date
• Amount charged
• Account number or account identifier
• Bank transaction reference
• Transaction description

Not every source will contain every field. At a minimum, the check number and amount are usually required for reliable matching.

---

Recommended reconciliation logic

The appropriate rules depend on the quality and structure of the available data.

A common sequence is:

Rule 1: Exact check number and amount

Match the issued check with the bank transaction when both the check number and amount agree.

Rule 2: Check number match with amount difference

Identify transactions where the check number agrees but the amount does not.

These should be classified separately rather than treated as ordinary unmatched records.

Rule 3: Outstanding issued checks

Identify checks that appear in the issued-check register but cannot be found in the bank file.

Rule 4: Unrecorded cleared checks

Identify bank checks for which no corresponding issued-check record can be found.

Rule 5: Duplicate identification

Flag check numbers that occur multiple times within either source.

Using separate rules makes it easier to understand why a record did or did not reconcile.

---

Should the issue date match the cleared date?

No.

The issue date records when the business prepared the check. The cleared date records when the check was processed by the bank.

The difference between the two dates may range from one day to several weeks or longer.

Instead of requiring an exact date match, businesses can calculate the number of days taken for each check to clear.

This provides useful information for:

• Identifying long-outstanding checks
• Reviewing stale checks
• Understanding payment timing
• Estimating the effect of outstanding payments on cash balances

---

Common exceptions to investigate

Check issued but not cleared

This is often an ordinary outstanding check.

Further review may be needed when the check has remained outstanding beyond the expected period.

Check cleared but not issued

The bank has processed a check that is absent from the internal register.

This could result from incomplete records, an alternative check-writing process, incorrect source files, or an unauthorized transaction.

Different amounts for the same check number

The internal register and bank data contain the same check number but different amounts.

This should be reviewed using the original check image, accounting entry, and supporting payment documentation.

Same check number used more than once

Check numbers may repeat across different bank accounts or because of duplicate entry, reissuance, or historical inconsistencies.

The bank account should be included in the matching key whenever multiple accounts are involved.

Voided check appearing as outstanding

A voided check may remain in the issued-check export even though it is no longer expected to clear.

Void status should be preserved and considered during exception review.

Replacement check issued

A business may stop or void one check and issue another.

Without a reference connecting the original and replacement checks, both may appear as separate unresolved records.

---

How to reconcile issued and cleared checks in Excel

A basic reconciliation can be attempted in Excel using lookup formulas.

For example, the issued-check file can search for the same check number in the bank file. A second formula can compare the amounts.

However, spreadsheets become difficult to manage when:

• Check numbers are formatted differently
• Duplicate records exist
• There are multiple bank accounts
• Several years of history are involved
• Different exception categories are required
• Files must be processed every month
• Multiple team members need to review the result

Manual spreadsheet logic can also change between periods, producing inconsistent results.

---

How reconciliation software improves the process

Reconciliation software allows the business to define and reuse matching rules.

Instead of recreating formulas each month, the user can:

1. Upload the issued-check data
2. Upload the cleared-check data
3. Map the relevant columns
4. Run the saved matching rules
5. Review matched and unmatched transactions
6. Download the reconciliation result

The same logic can be applied to different reporting periods while preserving a consistent approach.

---

Reconcile issued checks and cleared checks with Cointab

Cointab can compare an issued-check file from a check provider, accounting system, ERP, or internal register with cleared-check data received from the bank.

The output can separate:

• Fully matched checks
• Outstanding checks
• Bank-only checks
• Amount mismatches
• Duplicate records
• Other user-defined exceptions

Cointab can also retain the matching configuration for future periods, making the process suitable for both historical cleanup and recurring monthly reconciliation.

---

Example

Assume the issued-check file contains the following:

The bank file contains:

The reconciliation would produce:

• Check 4101: Matched
• Check 4102: Amount mismatch
• Check 4103: Issued but not cleared
• Check 4104: Cleared but not found in the issued-check register

This classification gives the reviewer a clear list of transactions requiring action.

---

Frequently asked questions

How frequently should checks be reconciled?

Monthly reconciliation is common, although businesses with high check activity or sensitive accounts may reconcile more frequently.

Can a check clear several months after it was issued?

Yes. The reconciliation should allow checks from earlier periods to match against later bank activity.

What is an outstanding check?

An outstanding check is a check recorded as issued but not yet found among the bank-cleared transactions.

Can one reconciliation cover multiple bank accounts?

Yes, provided the bank account is available in both sources or the files are processed separately by account.

Is a missing check always evidence of fraud?

No. Missing records can result from timing, incomplete exports, voided checks, data-entry errors, or differences in the reporting period. Exceptions should be investigated before conclusions are drawn.

---

Create a repeatable check-reconciliation process

Issued checks and cleared checks should not be treated as isolated datasets.

They are connected records that show whether a payment created internally was ultimately processed by the bank as expected.

A repeatable reconciliation process gives the business visibility into outstanding payments, discrepancies, duplicate records, and unrecorded bank transactions.

Cointab helps standardize this comparison and apply the same reconciliation logic across historical and future periods.