Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinancePersonal FinanceCheck Register

SpreadsheetPersonal FinanceFree

Check Register

A checkbook register with running and cleared balances, low-balance alerts and a quick reconciliation to your bank statement.

Shown with sample data

Colour

Check Register

A checkbook register with running and cleared balances, low-balance alerts and a quick reconciliation to your bank statement.

Balance
$2,629
Including uncleared items
Cleared balance
$3,551
Should match the bank
Outstanding payments
$921.46
Deposits in transit
$0
Difference to statement
$0
Zero when reconciled
Running balance
Nov 1, 2026Nov 20, 2026

Latest: $2,629.06

Payments by category
  • Housing$2,090
  • Transfer$300
  • Utilities$260.30
  • Insurance$187.33
  • Groceries$126.85
  • Other$100
  • Healthcare$85
  • Shopping$78.46

How to use it

  1. 1On Settings, enter the opening balance, the lowest balance you are comfortable with and your latest statement ending balance.
  2. 2Record every transaction on the day it happens: date, check number or type (DEBIT, ATM, ACH, DEP), payee and amount.
  3. 3When the transaction appears on your statement, set Cleared to Yes.
  4. 4Difference to statement should be zero once every cleared item is marked.
  5. 5Investigate any Low balance or Overdrawn alert before the next payment goes out.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A check register shows what you really have, not what the bank app shows before checks and pending payments clear. Record each check, debit, transfer and deposit; the register keeps a running balance, a separate cleared balance that should match the bank, warns when the balance falls below your safety level and reconciles to the statement in one figure.

Who it’s for

  • Anyone who still writes checks or has scheduled payments
  • Avoiding overdraft fees
  • Managing an account on behalf of someone else

What’s included

  • Register sheet: Every check, debit, transfer and deposit in date order.
  • By category sheet: Payments and Deposits and the number of entries for each category.
  • Settings sheet: Opening balance, alert level and statement balance.

How to use it

  1. 1On Settings, enter the opening balance, the lowest balance you are comfortable with and your latest statement ending balance.
  2. 2Record every transaction on the day it happens: date, check number or type (DEBIT, ATM, ACH, DEP), payee and amount.
  3. 3When the transaction appears on your statement, set Cleared to Yes.
  4. 4Difference to statement should be zero once every cleared item is marked.
  5. 5Investigate any Low balance or Overdrawn alert before the next payment goes out.

Tips

  • Record checks when you write them, not when they clear. Uncashed checks are the main reason bank balances mislead.
  • Note automatic payments a few days ahead so the running balance shows them coming.
  • If Difference to statement is not zero, look for an amount entered twice, a transposed number (an error divisible by 9) or a missing bank fee.

Questions

How do I balance a checkbook?

Mark every transaction that appears on your statement as cleared, then compare the cleared balance with the statement ending balance. If they match, the account is reconciled; uncleared items explain the difference to your running balance.

What is the difference between the running and cleared balance?

The running balance includes everything you have recorded. The cleared balance includes only transactions the bank has processed, so it should match your statement.

Do I still need a check register with online banking?

Online banking does not show checks you have written that have not cleared, or scheduled payments. A register gives you the true available balance.

Related searchescheck registercheckbook registercheck register templateprintable check registerchecking account registerbalance checkbook

Details

Format
Spreadsheet
Category
Personal Finance
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPersonal FinanceFree

Check Register

A checkbook register with running and cleared balances, low-balance alerts and a quick reconciliation to your bank statement.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Personal Finance
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More personal finance templates

View all
Savings Goals Tracker2 sheets

Total saved

$29,175

Overall progress

40%

Needed each month

$2,342

Progress by goal
88%
67%
67%
35%
33%
Christmas giftsEmergency fundNew laptopSummer holidayHouse deposit
SpreadsheetPersonal Finance

Savings Goals Tracker

Track several goals with a deposit log, monthly amount needed, projected finish date and on-track status.

10 min setupPreview
Bill Payment Tracker2 sheets

Bills per month

$2,510

Bills per year

$30,117

Due in the next 7 days

$216

ABCD
1BillCategoryFrequencyDue day
2RentHousingMonthly1
3ElectricityUtilitiesMonthly12
4WaterUtilitiesQuarterly18
5Home insuranceInsuranceYearly20
Bills
SpreadsheetPersonal Finance

Bill Payment Tracker

Every recurring bill with its next due date, days left, autopay and what bills really cost you each month.

10 min setupPreview
Emergency Fund Planner2 sheets

Essential costs per month

$2,970

Fund target

$11,880

Months covered today

1.1

ABC
1Essential costCategoryMonthly amount
2Rent or mortgageHousing$1,350
3Energy, water, internetUtilities$230.00
4GroceriesFood$480.00
5Fuel and transportTransport$190.00
Essentials
SpreadsheetSavings Goals

Emergency Fund Planner

Work out your essential monthly costs, the fund you need for three to six months and how long it will take to build.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ