How to Balance a Checkbook

Make a row at the top with these columns: Deposits, Deposit Description, Debit Description, Debits, Status, and Date. Use a paper register if you have one, or open a fresh sheet in Excel, Google Sheets, or LibreOffice Calc.

Add two more rows at the bottom for Total deposits, Total debits, and Remaining (deposits minus debits). That total cell is what you're going to watch.

On the next row down, enter your current bank balance as the first deposit. Label it 'Starting balance' so future-you knows where the math began.

Then add a row for your most recent paycheck. Use the after-tax (net) amount, not the gross. If you make $7.25 an hour for 20 hours, that's about $145 gross, roughly $113 after tax depending on your state. The number that hits your bank is the number that goes here.

For each recurring bill, add a row in the debit columns: Description, amount, and due date. Cable, internet, car insurance, phone, streaming subscriptions - everything that comes out automatically.

Don't try to remember them off the top of your head. Pull up your last bank statement and copy the recurring charges over. Anything you don't recognize is a clue worth chasing down.

When a bill actually clears your account (not just the due date - the actual clear date), update the Status column to 'Paid' and record the date.

The total at the bottom updates automatically. Watch the Remaining cell. If it goes red, you've overspent and need to either move money in or hold off on discretionary spending until the next paycheck.

Once a week, open your bank app and compare the actual balance to the Remaining number on your register. They should match within a few dollars (pending transactions account for the gap).

If they're off by more than that, scan the register for missed transactions, transposed digits, or charges you didn't recognize. Catching a fraudulent charge in week one is much easier than catching it in month three.