Is it possible to download/import my bank transactions and get them into Excel checkbook spreadsheet?
Yes. Nearly all banks will allow you to download your checking or savings account transactions to a CSV file which Excel will open. The trick is to then reformat that spreadsheet from the bank so that it has a similar layout of columns as the Excel Checkbook Register. In other words, you’ll need to add/remove columns from the bank file so that you have columns for: Date, Trx Type, Check#, Payee/Description, Withdrawal and Deposit. I frequently download my bank transactions, and after a quick reformat, I then copy/paste those columns (being careful to NOT include the balance values) over to my checkbook. Please see this list of articles for popular banks with step-by-step instructions.