This Checkbook register template provides a very simple way to record your transactions for both checking and credit card accounts
The formula in the Balance column uses the OFFSET function to make it easy to insert and delete rows. Use the Cleared Balance value to compare to your statements when balancing your check book.
For a tracking expenses and managing a budget, you can also try the Money Management Template, which uses a more advanced transactions register for recording transactions in multiple accounts.
... more info