Outstanding checks register

Create an outstanding checks register for a single bank statement. Add each recorded check and its amount, then mark the ones included in that statement as cleared. The remaining rows make up the outstanding total. Enter the statement balance to see the effect of subtracting those checks. This result covers the check adjustment only; deposits in transit and book adjustments still belong in the full reconciliation.

Worked example: IRS outstanding checks

Amounts from the recordkeeping illustration in IRS Publication 583. Subtract the total on the bank side.

How it works

Method source: IRS Publication 583. Amounts are calculated in whole cents. The tool reports the arithmetic of your inputs and does not update your records.

Build the list from check records

Compare each check in your records with the checks included on the statement. IRS Publication 583 tells users to compare both the check number and the dollar amount and to mark the check number as cleared. Enter a reference and amount for each item you want to review in this register. Mark the cleared box only when the item belongs to the statement period you are reconciling.

The unchecked items contribute to the outstanding total. You can leave cleared items in the register to document the comparison, or remove a row that was entered by mistake. Removing a row changes the total immediately. Make sure each recorded check appears only once, and keep any explanation of a corrected item with the original check record rather than relying on the register alone.

Use the statement cutoff consistently

A check that appears on a later statement can still belong in the outstanding list for the earlier statement. Compare against the statement ending date used for this worksheet. Do not mark an item cleared merely because you have now seen it in a current online balance. For the earlier reconciliation, use the statement and supporting records for that earlier period.

Enter the bank statement balance to see the balance after subtracting the outstanding checks. This intermediate figure does not include deposits in transit or other bank corrections. Copy the unchecked amounts into the bank side of the full worksheet when you are ready to reconcile both sides. Do not deduct the same checks again from the book side if they are already included in the ledger balance.

Review an unresolved item

Use the check reference to find the original entry and compare the amount with the source document. If your records and statement show different amounts, review which record needs a correction. A cleared checkbox only changes whether this calculator includes the item in the outstanding total. It does not cancel, void, reissue or change a check, and it does not update an accounting ledger.

The IRS example shows the outstanding checks individually. You can enter those official amounts to reproduce the illustrated deduction, then use the homepage worksheet for the complete bank and book comparison. Avoid writing an unsupported adjustment solely to eliminate a difference. Keep the item visible until you have a document that explains the appropriate treatment.

Export a supporting schedule

The CSV includes every row, its amount and its cleared status, followed by the outstanding total and the adjusted bank figure. Print the register when you need a paper schedule. Browser saving keeps the current entries on this device, so clearing a shared browser after keeping your own copy can help avoid restoring the wrong period next time.

Questions about this tool

Official sources

• IRS Publication 583: checking account reconciliation and recordkeeping illustration

Data as of 2026-10-05. Published illustrations are static teaching cases, not live account data.