Checking Account Spreadsheets
- 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."
- 2). Create a column for your headings. Use a heading for "Beginning Balance," "Checks and Debits," "Deposits and Credits," and "Current Balance."
- 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.
- 4). Enter the balance from your checkbook into the "Starting Balance" column. Make sure the balance is entered correctly.
- 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.
- 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.
Source...