If your bank’s app or website isn’t showing a deposit or ATM cash you just put in, grab your Check Register—a simple two-column table where you jot down the date, amount, and running balance after every check, deposit, or ATM withdrawal.
Quick Fix Summary
Open a plain text file, Google Sheet, Excel workbook, or the free Google Sheets template from your bank. In the first column enter the date, second column the check number or “ATM” or “Deposit,” third column the amount received (+), fourth column the amount paid (-), and fifth column the new running balance. If you use a paper register, keep it in the same folder as your cancelled checks.
What’s happening with my transactions?
Whether you’re balancing a checkbook, running a side hustle, or just trying to dodge overdraft fees, the Check Register is where every dollar that enters or leaves your checking account gets tracked. Banks usually post most transactions within one business day, but pending holds can delay ATM cash or mobile deposits for up to 24–72 hours. A manually kept register helps you spot timing gaps before they turn into $35 NSF charges.
How do I set up a check register?
- Pick your tool
- No budget? Open Google Sheets → Template Gallery → “Personal Finance Tracker.”
- Excel fans: File → New → search “check register” in the template search bar.
- Paper purists: order a free register from your bank’s website or grab an $8 register at any office store.
- Set the columns (names may vary slightly by template)
Column Label Example Entry 1 Date 2026-06-14 2 Description ATM Withdrawal 3 Check # or Category 1247 4 Deposit (+) $450.00 5 Withdrawal (-) $60.00 6 Running Balance $2,310.00 - Enter every transaction
- For checks: drop the check number and amount under “Withdrawal (-).”
- For deposits: list the source (employer, Venmo, cash) and amount under “Deposit (+).”
- For ATM withdrawals: type “ATM” in the Description column and the dollar amount under “Withdrawal (-).”
- Update the running balance
- Google Sheets/Excel formula:
=SUM(D2:E2)in the balance column, then drag it down. - Paper register? Add deposits, subtract checks and ATM. Keep a $100 cushion so pending transactions don’t bite you.
- Google Sheets/Excel formula:
- Reconcile with the bank
- Every 7–10 days, open your bank’s app → Accounts → select the account → Transactions → Download → QFX or OFX.
- Import the file or compare each row by hand. Circle any mismatches and investigate within 48 hours.
What if a transaction still won’t show up?
Still missing something?
- Pending transactions: Check the app’s “Pending” tab; those amounts aren’t available yet but will hit within 1–3 days.
- Mobile deposit hold: call the number on the back of your debit card and ask for an exception—some banks release the first $200 of mobile deposits immediately.
- Bank error: screenshot the missing entry, note the transaction ID, and file a claim through your bank’s website under “Dispute a Transaction.” You’ve got up to 60 days to report most errors.
How can I keep my register accurate?
Once your register is up and running, keep it accurate with these habits:
- Enter transactions the same hour you write the check, swipe the card, or hit “Deposit.”
- Use the same font or ink color to avoid “phantom” entries that’ll confuse you later.
- Store a backup in two places: cloud drive (Google Drive/Dropbox) and a password-protected USB stick in a fireproof safe.
- Every quarter, print a one-page summary and tape it inside your checkbook so your spouse, roommate, or accountant can spot gaps.
- Set calendar reminders on the 1st and 15th to reconcile—this catches fraud before the thief spends more than $50.
Keeping a register isn’t about being perfect; it’s about catching the $5 latte before it becomes a $35 overdraft fee. Once you hit a 90% match rate for three months straight, you can switch to quarterly reconciliations.
