Performing a monthly bank reconciliation is critical to managing personal finances. When your records and the bank's don't match, you'll need to investigate.

USING VLOOKUP TO DO BANK RECONCILIATIONS I enjoyed the article “Double-Teaming in Excel” ( JofA , Nov.05, page 83 ). VLOOKUP is so versatile; I have used it to reconcile outstanding checks each month.