Checking Account Spreadsheets

by Bonnie Conrad ; Updated July 27, 2017
Create a spreadsheet to balance your checkbook

Items you will need

  • Checkbook
  • Bank statement

Keeping track of your checking account is important, and sometimes a check register simply is not enough. Modern technology can make the process of balancing a checkbook and avoiding overdrafts a lot easier. By using a spreadsheet program and your online banking program, you can see your account balance at a glance and avoid any unpleasant surprises.

Step 1

Log on to your computer and open your spreadsheet program. Click on the "File" menu and choose "New" to start a new spreadsheet. Save the file with a distinctive name like "Checking Account Summary."

Step 2

Create a column for your headings. Use a heading for "Beginning Balance," "Checks and Debits," "Deposits and Credits," and "Current Balance."

Step 3

Create a column to hold the current balance from your checkbook. Create a column to list all checks and other debits from the account. Create another column in which to list all deposits and credits. Format these cells to display dollars and cents.

Step 4

Enter the balance from your checkbook into the "Starting Balance" column. Make sure the balance is entered correctly.

Step 5

Log on to your online banking service and print a list of your most recent transactions. Type those transactions into your spreadsheet. Use a minus sign before each check or debit entry, i.e. -8.53, -10.00. Use postiive numbers for any deposits and credits.

Step 6

Go to the bottom of the column where your beginning balance is stored. Create a label to the left called "Current Balance." Create a formula to add the prior balance, checks and deposits. For instance, if your data is located in cells B1 through D20, the formula would read "=SUM(B1:D20)." Using negative numbers for the checks and debits allows you to use the =SUM feature to simplify the calculations.

About the Author

Based in Pennsylvania, Bonnie Conrad has been working as a professional freelance writer since 2003. Her work can be seen on Credit Factor, Constant Content and a number of other websites. Conrad also works full-time as a computer technician and loves to write about a number of technician topics. She studied computer technology and business administration at Harrisburg Area Community College.

Photo Credits