How to Reconcile Deluxe Checks With Bank Statements

Businesses that use Deluxe checks typically maintain one record of checks written and another record of checks cleared through the bank.

The Deluxe check register shows what the business intended to pay. The bank statement shows what was actually presented and cleared.

These two records should agree, but differences can arise because of outstanding checks, voided checks, duplicate check numbers, incorrect amounts, delayed deposits, or incomplete historical records.

Reconciling Deluxe check data against bank transactions helps a business understand which checks cleared correctly and which ones require further review.

---

What is Deluxe check reconciliation?

Deluxe check reconciliation is the process of comparing checks written or printed through Deluxe with check transactions recorded by the bank.

The two sides of the reconciliation are generally:

Deluxe check data

This may include:

• Check number
• Check issue date
• Payee
• Check amount
• Bank account
• Check status
• Memo or payment reference

Bank check data

This may include:

• Check number
• Cleared date
• Cleared amount
• Bank account
• Transaction description
• Bank reference number

The objective is to determine whether every relevant check appears correctly in both sources.

---

Why the Deluxe register and bank statement may differ

A difference between the two files does not always indicate an error.

For example, a check may have been issued in one month but deposited several weeks later. It would appear in the Deluxe register immediately but would not appear in the bank statement until it clears.

Other differences may require investigation.

Common reasons include:

• The check has not yet been deposited
• The check was voided after it was created
• A replacement check was issued
• The check cleared for a different amount
• The same check number appears more than once
• The bank file covers a different period
• A check transaction is missing from one of the exports
• Historical data was entered inconsistently

A structured reconciliation separates expected timing differences from genuine exceptions.

---

What should be matched?

The check number is usually the primary identifier.

However, matching only by check number may not be sufficient. The reconciliation should also compare the amount and, where relevant, the bank account.

A typical matching rule may be:

Deluxe check number equals bank check number, and Deluxe amount equals bank-cleared amount.

The issue date and cleared date will normally differ and should therefore not be required to match exactly.

Dates are generally more useful for reporting how long a check remained outstanding.

---

Possible reconciliation results

A Deluxe-to-bank reconciliation can classify records into several categories.

1. Matched checks

The check number and amount agree across both files.

These transactions usually require no further action.

2. Outstanding checks

The check exists in the Deluxe register but has not been found in the bank data.

Possible reasons include:

• The payee has not deposited the check
• The check is stale
• The check was lost
• The check was voided but not updated in the source data
• The bank export does not cover the required period

3. Checks found only in the bank

The bank shows a cleared check, but the corresponding record cannot be found in the Deluxe data.

This may indicate:

• Incomplete Deluxe data
• A check written outside the normal process
• An incorrect or unreadable check number
• A duplicate clearing entry
• A transaction belonging to another bank account

4. Amount mismatches

The same check number appears in both files, but the amounts are different.

Amount differences should normally be reviewed carefully because the amount printed on a check should correspond with the amount cleared by the bank.

5. Duplicate check numbers

The same check number may appear multiple times in one or both files.

This can happen because of:

• Reissued checks
• Data-entry duplication
• Multiple bank accounts using overlapping check sequences
• Duplicate bank records
• Incorrect historical exports

Duplicates should be reviewed before finalizing the reconciliation.

---

How to prepare the files

The reconciliation is easier when both sources are available in Excel or CSV format.

Before beginning, check that:

• Each row represents one check
• Check numbers are stored consistently
• Amounts are stored as numeric values
• Bank accounts can be distinguished
• Headers are present
• Blank rows and totals are removed
• The files cover the intended period

Check numbers sometimes appear as text in one file and numbers in another. Leading zeroes may also be removed by spreadsheet software.

These formatting differences should be standardized before matching.

---

Step-by-step Deluxe check reconciliation

Step 1: Export the Deluxe check register

Obtain the available history of checks written or printed through Deluxe.

Include the check number, amount, date, payee, and status wherever possible.

Step 2: Export cleared-check data from the bank

Request or download the check transaction history in Excel or CSV format.

Where possible, include both the check number and cleared amount.

Step 3: Confirm the reconciliation period

Decide whether the exercise covers:

• A single month
• A financial year
• Several historical years
• All available check history

The bank file may need to extend beyond the issue period because checks written near the end of the period may clear later.

Step 4: Standardize the columns

Prepare the check number and amount fields so that they can be compared consistently.

Examples include:

• Removing unnecessary spaces
• Converting numeric check numbers to text
• Standardizing negative and positive amounts
• Separating transactions by bank account
• Removing currency symbols from amounts

Step 5: Apply the matching rules

Match the two files using check number, amount, and bank account where applicable.

Step 6: Review the exceptions

Investigate outstanding checks, amount differences, unmatched bank transactions, and duplicate check numbers.

Step 7: Save the reconciliation setup

If the process will be performed every month, save the file mappings and matching rules so that the reconciliation does not need to be rebuilt for every period.

---

Can QuickBooks perform this reconciliation?

QuickBooks includes bank-reconciliation functionality, but the available result depends on how the checks were entered, how the bank transactions were imported, and whether the historical data is complete.

A separate data reconciliation may still be required when:

• The check register exists outside QuickBooks
• Historical transactions were not entered consistently
• The bank feed does not cover the full period
• The business needs a row-by-row exception report
• Multiple exports must be compared independently
• The original reconciliation was never completed

In these situations, reconciling the source files directly can provide a clearer view of matched and unmatched checks.

---

Using Cointab for Deluxe check reconciliation

Cointab can be used to compare a Deluxe check export against check transactions received from the bank.

The reconciliation can be configured to identify:

• Checks matched by check number and amount
• Checks written but not cleared
• Cleared checks missing from the Deluxe file
• Amount differences
• Duplicate check numbers
• Other exceptions based on the available data

Once the configuration is validated, the same process can be reused for subsequent monthly files.

This allows the business to complete the historical reconciliation first and continue using the same logic for ongoing check reconciliation.

---

Frequently asked questions

How far back can Deluxe checks be reconciled?

Historical checks can be reconciled for any period for which the Deluxe and bank data are available in a usable format.

Can multiple years be reconciled together?

Yes. However, it is often useful to retain the issue date and cleared date so that results can be reviewed by year, month, or ageing period.

What if the bank provides PDF statements?

Excel or CSV data is preferable because each transaction is already available in a structured row. Businesses should ask the bank whether historical check transactions can be provided as a spreadsheet export.

Should outstanding checks be treated as errors?

Not automatically. A recently issued check may simply not have cleared yet. Older outstanding checks may require investigation.

Can the reconciliation be repeated monthly?

Yes. Once the columns and matching logic are configured, new Deluxe and bank files can be processed using the same reconciliation setup.

---

Complete historical and monthly check reconciliation

A Deluxe check register and a bank statement represent two different stages of the same payment process.

Reconciling them provides a clear answer to three important questions:

• Which checks cleared correctly?
• Which checks remain outstanding?
• Which transactions require investigation?

Cointab helps businesses compare check data from separate systems, review exceptions, and reuse the same reconciliation process for future periods.