Checking Account Register Excel: Columns for Deposits, Withdrawals, and Cleared Status

People searching checking account register excel usually want a sheet that behaves like the bank: money in, money out, balance after each row. They do not want a credit-card APR dashboard or a 50-category budget. Hub: Excel Checking Account Register Template: Deposits, Withdrawals, Running Balance.

Key takeaway: A checking register works when Deposit and Withdrawal are unambiguous, the running balance formula never relies on hidden “true balance” cells, and Cleared tracks what the bank has already posted.

Hub: excel checking account register template

Recommended column layout

[TABLE: Checking register columns]

Column	Rule
Date	Prefer post date when bank and receipt disagree
Description	Match statement wording when possible
Deposit	Positive money in only
Withdrawal	Positive money out only (do not mix signs)
Check / Ref	Optional; blank for debit and ACH
Cleared	Blank until matched to statement
Balance	`=prior+Deposit−Withdrawal`
Memo	Pending, NSF, split notes

Keep category optional. Category helps later pivots; it is not required for a valid register.

Build or download — same rules

Set up a checking register

Create headers for Date, Description, Deposit, Withdrawal, Check/Ref, Cleared, Balance, Memo.
Enter opening balance on row 1 in Balance (or as a Deposit labeled Opening Balance).
Format Deposit, Withdrawal, and Balance as Accounting.
Convert the range to an Excel Table so formulas auto-fill.
Enter withdrawals as positive amounts in the Withdrawal column — not negative deposits.
Once a week, filter uncleared rows against mobile bank activity.

Warning: Sorting a register without structured references can scramble balances. Use an Excel Table or carefully absolute prior-balance references.

BuyExcelTemplates-style guides emphasize entering outflows as negatives in a single Amount column. That works if you document the convention. Split Deposit/Withdrawal columns reduce sign mistakes for household users.

What SERP competitors optimize for

AI overviews and video results still say “checkbook register” even when the query says checking account. Free template sites and excel-checkbook.com sell multi-account Quicken replacements. Tiller’s account register assumes feed-powered reconciliation first. Your job here is narrower: one checking account, readable columns, bank-ready cleared flags.

For statement math beyond the register grid, open excel bank reconciliation template. For the close ritual, open how to reconcile checking account in excel.

A structured file such as PlanoNest’s checking register keeps Register and Help separate so you are not reinventing intake rules each month. One-time purchase, instant download; live pricing on the product page.

[PRO_CON]

Single Amount column (±)

Pros: fewer columns; easy CSV paste
Cons: sign errors; harder for shared household sheets

Deposit + Withdrawal columns

Pros: hard to put money in the wrong direction
Cons: one extra field when importing CSV

Product highlight: Registers fail most often on bank fees and interest — tiny rows people skip until the PDF ending balance differs by a few dollars.

FAQ

What belongs in a checking account register Excel sheet?

Deposits, withdrawals, optional check numbers, running balance, and a cleared flag — plus memos for exceptions.

Should I categorize every transaction?

Optional. Categories help spending review; they are not required to prove the bank balance.

Can I track savings in the same workbook?

Yes — separate register sheet (or Account field) per cash account. Do not mix savings and checking rows without an account label.

Practical scenarios that stress-test the register

Scenario A — payday and bills in the same week. Deposit the paycheck on the post date, then enter each bill-pay withdrawal as it leaves the account. If two autopays hit on Friday and you also send a rent transfer, you should see three withdrawal rows — not one combined “bills” lump. Combined lumps make bank matching harder and hide which vendor actually posted.

Scenario B — pending debit that changes amount. A gas-station authorization holds $120 and later posts at $87.43. Edit the original register row to $87.43 and note the change in Memo. Creating a second row for the “difference” double-counts the merchant and breaks reconciliation.

Scenario C — bank fee you forgot. The statement shows a $12 maintenance fee you never typed. Add a withdrawal dated to the bank’s post date, clear it, and move on. Chasing “perfect history” for a twelve-dollar fee wastes more time than documenting it.

Scenario D — transfer to savings. On the checking register, log a withdrawal labeled clearly as a transfer. On the savings register (if you keep one), log the matching deposit. If you only track checking, still label the withdrawal as a transfer so next month’s you does not think cash vanished.

These scenarios are ordinary. The register that survives them is the one with boring columns, a protected running balance, and a Cleared habit you actually use.

Free vs paid vs DIY — decision cues

Use a blank DIY sheet when you are learning Deposit vs Withdrawal and the balance formula. Move to a structured workbook when someone else will type into the file, when you need Start Here / Help, or when you are tired of repairing broken formulas after a sort. Subscription feed tools help when typing volume is the bottleneck; they still need human judgment on Cleared and exceptions.

For a checking-focused structured option, see the PlanoNest Excel Checking Account Register product page for current one-time purchase pricing and instant download details. Compatible with Excel, Google Sheets, and WPS.

Month-end archive habit

After the adjusted balances match:

Export or save a PDF of the bank statement for the period.
Save a dated copy of the Register sheet (or the whole workbook) with the period in the filename.
Leave a one-line note in Settings: “Reconciled through YYYY-MM-DD.”
Carry only intentional uncleared items into the next period — not a mysterious pile.

That archive is what auditors, partners, and future-you trust. A beautiful dashboard without dated proof is decoration.

Keep the checking job narrow on purpose. If you need category budgets, keep them on a separate sheet that reads summaries from the register — do not force every grocery subcategory into the cash log. If you need credit-card statement control, use a liability register elsewhere and only record the payment that left checking. Narrow tools stay honest longer.

Before you email the workbook to a partner or bookkeeper, run this short checklist: Balance column protected or locked; Deposit and Withdrawal formats set to Accounting; opening balance documented in Settings with a date; Cleared values only mean matched to bank — not wishful thinking; Memo used for NSF, disputes, and amount changes; no credit-card purchase rows mixed into checking; no Vertex42 or other competitor download links pasted into Help as instructions.

If anything on that list fails, fix it before sharing. Shared messy registers create duplicate rows and silent formula edits faster than any template feature can save you.

When you return from vacation, skim uncleared rows first. Uncleared older than one statement cycle deserve a decision: still outstanding, voided, or missing from the bank side. Decisions beat piles.

Keep reconciliation boring on purpose: same columns, same cleared meaning, same archive habit every month.

Disclosure

PlanoNest sells this template. Links to PlanoNest products and collections point to our own digital template shop.