![Excel Formulas For Check Register Excel Formulas For Check Register](/uploads/1/2/5/5/125504908/289358462.jpg)
Creating the Excel Checkbook Register This demo will be using MS Excel 2010 but this will also work with MS Excel 2007 or 2013 though the provided screen shots may be different.
Note: A running balance differs from a running total (also called a running count), in which you watch the number of items in a worksheet add up as you enter new items. For more information, see.
Set up a worksheet like the following example. Example 1 2 3 A B C Deposits Withdrawals Balance 1000 625 =SUM(A2,-B2) 1245 740 =SUM(C2,A3,-B3). Click anywhere outside cell C3 to see the calculated total. To maintain the running balance, add a row for each new entry by doing the following:. Type the amounts of your deposits and withdrawals into the empty rows directly below the existing data. For instance, if you were using the example above, you would type the deposits into A4, A5, and so on, and the withdrawals into B4, B5, and so on. Extend the running balance formula into the new rows by selecting the last cell in the balance column and then double-clicking the fill handle.
For instance, if you were using the example above, you would select cell C3 and then double-click its fill handle to extend the formula into all new rows that contain deposit and withdrawal values. Need more help? You can always ask an expert in the, get support in the, or suggest a new feature or improvement on.
![Excel Formulas For Check Register Excel Formulas For Check Register](/uploads/1/2/5/5/125504908/570073401.jpg)
A seven-column spreadsheet will work for a simple checkbook register. Open Excel, click the Save button and save the register to a convenient location in your system. In the first row of the spreadsheet, starting in column A, add these labels in all capital letters: code, date, payee, description, payment, deposit and balance. Resize the payee and description columns so they can include more text. To do this, place your cursor in the header section between columns C and D.
When the cursor’s appearance changes to two arrows, left-click and drag until the column-width tool tip displays 30.00. Repeat this for the header section between columns D and E. Format the Register. Correct formatting is vital to make sure the information you enter displays correctly. To format the date column, click the column B header to select the entire column and then right-click anywhere in column B and select “format cells” to open the formatting window. Open the number tab, select the date option and choose how you want to display dates. To format columns E through G to display dollar amounts, left-click in the header for column E and drag through to column G.
Click the drop-down box in the number section of the home tab and select the accounting option. Enter your opening balance in cell G2 and then move to cell G3. In this cell, enter this formula: =IF(ISBLANK(B3),',SUM(G2+E3-F3). This formula tells Excel to either add or subtract a dollar amount from the opening balance after you enter a transaction date. Use Excel’s autofill feature to carry the formula down the entire column. To complete this task, click in cell G3 and position the pointer in the lower-right corner of the cell.
When the cursor changes to a simple cross shape, left-click and drag as far down as you want to go.