Guides & Resources
Historical Check Reconciliation for Law Firms
Historical Check Reconciliation for Law Firms
A law firm may continue issuing checks for years without completing a full comparison between its check register and the checks cleared through the bank.
The underlying records may still exist, but they may be distributed across accounting software, check-printing systems, spreadsheets, archived bank statements, and monthly exports.
As the backlog grows, the reconciliation becomes harder to complete.
A historical check reconciliation gives the firm a structured way to determine which checks cleared, which remain unresolved, and which records require further review.
What is a historical check reconciliation?
A historical check reconciliation compares checks issued during an earlier period with the corresponding check transactions recorded by the bank.
The review may cover:
- Several previous months
- One or more calendar years
- The entire available history of a bank account
- A period that was never formally reconciled
- Records from a previous bookkeeper or accounting system
- Checks issued before a software or banking change
Unlike a normal monthly reconciliation, the process may need to review several years of data together.
This is important because a check issued in one period may clear in a later period.
Why law firm reconciliation backlogs develop
A law firm may postpone historical check reconciliation because:
- Current client work takes priority
- The firm does not have a dedicated finance team
- The bookkeeper does not have complete source data
- Bank statements are available only in PDF
- The check register is stored in another system
- Earlier attempts did not produce a clear result
- The accounting software does not contain the full history
- Check numbers or amounts are formatted inconsistently
- The person familiar with the process is no longer available
The row count may not be very large.
The real challenge is often organizing the records and deciding how to classify each difference.
Define the purpose before starting
The firm should first decide what the historical reconciliation is expected to achieve.
Possible objectives include:
- Confirming that issued checks cleared for the correct amounts
- Identifying checks that were never deposited
- Preparing a complete outstanding-check list
- Finding checks present in the bank but missing internally
- Reviewing duplicate or reused check numbers
- Completing a long-pending bookkeeping project
- Supporting an accountant's review
- Establishing a monthly process for the future
A defined objective keeps the exercise focused and prevents unrelated accounting issues from delaying completion.
Identify all relevant accounts
The firm should determine which bank accounts are included.
Examples may include:
- Operating accounts
- Payroll accounts
- Expense accounts
- Settlement-related accounts
- Other accounts from which checks were issued
Where multiple accounts use overlapping check-number sequences, the bank account must form part of the matching logic.
A check number alone may not uniquely identify a payment across multiple accounts.
Collect the issued-check history
The issued-check data may come from:
- Accounting software
- Check-printing software
- Practice-management software
- A Deluxe or other check-provider export
- Internal Excel registers
- Archived reports
- Previous bookkeeping files
The historical export should retain as much detail as possible, including:
- Check number
- Issue date
- Amount
- Payee
- Bank account
- Status
- Memo
- Matter or case reference
- Source file
- Internal transaction number
Additional fields may not be required for initial matching, but they are useful when reviewing exceptions.
Obtain historical bank data
The bank data should ideally be available in Excel or CSV format.
Useful fields include:
- Check number
- Cleared amount
- Cleared date
- Account
- Transaction description
- Bank reference
- Statement period
If historical transactions are not available through online banking, the firm may need to request an export directly from the bank.
The requested bank period may need to continue beyond the final check-issue date so that late-clearing checks are included.
Combine monthly and annual files carefully
Historical bank and check data may be split across many files.
When combining them:
- Retain the original file name
- Preserve the statement month
- Preserve the bank account
- Remove repeated headers
- Remove subtotal and total rows
- Avoid importing the same period twice
- Confirm that each transaction appears only once
- Keep a record of the files included
This makes it easier to trace a reconciliation result back to the original data.
Standardize historical check numbers
Check numbers may appear differently across systems.
Examples include:
000784versus784- Numeric values versus text values
- Spaces before or after the number
- Prefixes such as
CHK - Check numbers included within a description
- Blank or unreadable check-number fields
The standardized value can be used for matching, while the original value should be retained for reference.
Create a structured matching sequence
A historical law firm reconciliation may use the following sequence.
Exact check number and amount match
These transactions can be classified as matched.
Same check number with a different amount
These should be shown separately as amount exceptions.
Issued check without a bank transaction
These may represent:
- An outstanding check
- A voided check
- A lost check
- A replacement check
- Missing bank history
- Incorrect data
Bank-cleared check without an issued record
These may result from:
- Incomplete internal records
- A check issued outside the usual process
- Missing historical exports
- Incorrect check numbers
- A different bank account
- A transaction requiring investigation
Duplicate check numbers
Duplicates should be reviewed together with the amount, account, payee, date, and status.
Do not reconcile only within the same month
A common historical reconciliation error is to compare each month's issued checks only with the bank transactions from that same month.
A check written at the end of one month may clear during the following month.
Under a same-month comparison, it may appear unmatched twice.
The reconciliation should allow an issued check to match a later cleared transaction.
The issue date and cleared date can then be used to calculate how long the check remained outstanding.
Age the unresolved checks
After matching the available records, outstanding checks can be grouped by age.
For example:
- Up to 30 days
- 31 to 60 days
- 61 to 90 days
- 91 to 180 days
- More than 180 days
- More than one year
The appropriate review process may differ depending on how long the check has remained unresolved.
The reviewer may need to determine whether the check was:
- Deposited under another reference
- Lost
- Voided
- Replaced
- Never delivered
- Recorded incorrectly
- Still expected to clear
Preserve the original data
Historical records should not be changed merely to force a match.
The reconciliation file should retain:
- Original check number
- Standardized check number
- Original amount
- Standardized amount
- Original status
- Reconciliation status
- Review notes
- Resolution
- Supporting reference
This provides a clearer record of how each transaction was handled.
Convert the backlog into a monthly process
After the historical reconciliation is completed, the same logic can be used for future periods.
A repeatable process may include:
- Exporting new checks issued during the month
- Exporting cleared checks from the bank
- Uploading both files
- Applying the saved matching rules
- Reviewing new exceptions
- Carrying forward unresolved checks
- Saving the final result
This prevents the historical backlog from developing again.
Complete historical law firm reconciliation with Cointab
Cointab can compare several years of law firm check data with bank-cleared transactions.
The system can separate:
- Matched checks
- Outstanding checks
- Bank-only checks
- Amount differences
- Duplicate records
- Other user-defined exceptions
The reconciliation can first be tested using a sample period.
Once the file formats and matching rules are validated, the same configuration can be applied to the complete history and reused for subsequent monthly reconciliations.
Frequently asked questions
How many years of law firm checks can be reconciled?
The practical period depends on whether the issued-check and bank records are available in a structured and usable format.
Can incomplete years still be reconciled?
Yes, but missing periods should be documented because they may explain unmatched transactions.
Should earlier issued checks be included?
Earlier checks may need to be included if they cleared during the period under review.
Can multiple Excel files be processed?
Yes. Monthly and yearly files can be combined or processed as part of the same reconciliation exercise.
What if the earlier QuickBooks reconciliation was unsuccessful?
The underlying check and bank exports can still be compared directly, independently of the previous reconciliation attempt.
Can the firm start with a sample?
Yes. A limited period can be used to validate the data structure and matching logic before the complete historical records are processed.
Finish the historical project
A historical check reconciliation may remain unfinished for years even when the number of transactions is manageable.
The difficulty usually comes from fragmented files, inconsistent formats, delayed clearing, and unresolved exceptions.
A structured reconciliation helps the firm turn those records into:
- Confirmed matches
- Outstanding checks
- Amount discrepancies
- Unrecorded bank checks
- Reviewable exceptions
Cointab helps law firms complete the historical comparison and continue with a repeatable process for future months.
