Free Check Register Template: Excel, Sheets and Printable PDF
A check register is your own chronological record of deposits, checks, fees and other account activity. This free digital download pairs a blank register with a worked example and separates your register balance from activity that has cleared the bank.
What you download
- Instructions
- Signs, row limits, source references and import guidance.
- Register
- 200 blank transaction rows; enter opening book and cleared balances, positive deposits/payments and a cleared status.
- Example Register
- Fictional October activity with two distinct $100 payments, pending items and a $5 fee.
- Reconcile
- Statement balance plus pending deposits minus pending payments compared with the blank register.
- Example Reconcile
- $1,295 + $200 - $50 = $1,445, matching the completed register.
Scope: Educational register, not a bank-issued statement, available-funds guarantee or automatic bank connection. All examples are fictional. Validation can be bypassed by pasted data; inspect row warnings and reconcile independently.
Follow the numbers
Fictional educational example. Not customer records or professional accounting advice.
| Source / activity | Deposit | Payment | Status | Register | Cleared |
|---|---|---|---|---|---|
| DEP-01 / receipt | 500.00 | Cleared | 1,500.00 | 1,500.00 | |
| CHK-101 / first payment | 100.00 | Cleared | 1,400.00 | 1,400.00 | |
| CHK-102 / separate payment | 100.00 | Cleared | 1,300.00 | 1,300.00 | |
| DEP-02 / deposit in transit | 200.00 | Pending | 1,500.00 | 1,300.00 | |
| CHK-103 / outstanding check | 50.00 | Pending | 1,450.00 | 1,300.00 | |
| BANK-10 / service fee | 5.00 | Cleared | 1,445.00 | 1,295.00 |
Use it with your records
Open or import the workbook
Keep an untouched download. Open the XLSX in your spreadsheet app, or in Google Sheets choose File, Import, Upload and Create new spreadsheet. Import the whole workbook, not one CSV tab. Check formulas, dates, dropdowns and print settings against the completed example before entering live records. No hosted Sheets copy or actual Excel/Sheets compatibility test is claimed.
Set the opening balances and period
Use one account and currency. Enter opening book balance in B2 and opening cleared balance in E2. Carry prior outstanding items into the register and adjust the opening book amount so those items are not counted twice. Enter the statement cutoff in H2.
Record each real transaction
Use rows 6 through 205. Enter a date, a distinct source reference, the original description and a positive amount in either Deposit or Payment. Keep separate legitimate payments even when their amounts match.
Mark only statement-matched items cleared
Select Cleared only after matching the source reference, amount and date to the statement. Everything else remains Pending. The running book balance includes both; the cleared balance includes only Cleared activity.
Reconcile, then retain the evidence
Enter the statement closing balance on Reconcile. Investigate the difference rather than adding a balancing plug. Record verified bank fees once. Retain receipts, check references and the statement with the period copy.
What is included in each format?
The workbook contains formula-driven balances, input validation, frozen headers and separate blank and example sheets. The standard printable PDF has a blank table and a worked example. The large-print version uses 16-point body text and larger writing spaces across more pages, rather than simply enlarging the same crowded table. PDFs are printable worksheets, not interactive calculators or physical checkbooks.
Why $1,445 in the register differs from $1,295 at the bank
Before the fee is recorded, the register has $1,450. Recording the cleared $5 service fee makes it $1,445. The bank has not yet included a $200 deposit or a $50 check, so its $1,295 statement balance becomes $1,445 after adding the deposit in transit and subtracting the outstanding check. Both pending items clear after October 31 in this fictional example.
A cleared balance is not necessarily the bank's available balance. Holds, timing, prior outstanding items and omitted bank activity can still create differences. Match the actual statement before relying on the result.
Do not erase equal-looking payments
CHK-101 and CHK-102 are two separate $100 payments with different supporting references. Both remain in the example. Equal amount and similar description alone do not prove duplication. Review the source record before correcting any entry.
Questions about this resource
Is this check register free and printable?
Yes. Download the XLSX or either PDF without a hosted spreadsheet account. The PDFs include blank writing space and a completed example. Print at actual size; the large-print PDF uses larger text and fewer entries per page.
Can I use this check register in Google Sheets?
You can import the XLSX using Google Sheets File, Import. A live Sheets copy and actual Sheets or desktop Excel testing are not claimed. Compare the imported example with $1,445 register balance and $1,295 cleared balance, then check dropdowns and print layout.
Is a check register a bank statement?
No. A check register is your record, including pending checks and deposits. A statement is issued by the bank. Keep and compare both.
How many transactions fit?
The workbook formulas cover 200 rows, rows 6 through 205. Do not paste below row 205 and assume totals expand. Use a new period copy or deliberately extend every formula, validation and print range.
Sources and documentation
- IRS Publication 583: recordkeeping, journals, ledgers and reconciliation(opens in a new tab)
- Google Docs Editors Help: import Excel data into Sheets(opens in a new tab)
Examples are educational. Check your records and accounting policy before posting entries or relying on a forecast.
Statement rows still trapped in a PDF?
Fulla turns bank-statement PDFs into rows you review against the source before exporting CSV, Excel, OFX or JSON. These free workbooks are separate manual tools, not automatic accounting or financial advice.