Outstanding checks list and check register templates
Two free CSV templates for tracking checks that have been written but not yet cleared the bank. They open in Excel, Google Sheets or Numbers. No sign-up needed.
Outstanding checks list
Check number, date issued, payee, amount, date cleared, days outstanding, status and follow-up action.
Download CSVCheck register
Date, check number, payee, payment, deposit, running balance and cleared (C) or reconciled (R) status.
Download CSVHow to use the outstanding checks list
- At month-end, list every check written that has not appeared on the bank statement.
- When a check clears, fill in the date cleared and set the status to Cleared.
- Calculate days outstanding (statement date minus date issued) and follow up on anything older than 90 days.
- Checks outstanding for around six months are usually stale-dated. Agree with your accountant whether to void and reissue, and check your state or provincial unclaimed-property rules.
Doing this in QuickBooks Online
QuickBooks Online keeps the same information in the account register and the reconciliation report. Our guides cover clearing outstanding checks and fixing checks that will not show as cleared.
Skip the spreadsheet
Kyriq reads every check on your bank statement, matches it to QuickBooks Online and clears the ones you approve, so the outstanding list is whatever is left. Start a free trial.