# Calculate Debit Credit Running Balance Using Excel Formula (3 Examples)

Get FREE Advanced Excel Exercises with Solutions!

Keeping a debit credit running balance of your checking and credit accounts is one of the most critical chores in personal finance, and spreadsheets are a popular tool for doing so. When recording a debit credit running balance or a running balance, the ancients may have committed certain math mistakes. As we allow Excel formulas to do the math for us, we may believe our current spreadsheets are vastly superior, yet we can run across other forms of errors instead. Today, in this article, Iâ€™ll show you four suitable and effective ways in which Excel can calculate the debit credit running balance formula with appropriate illustrations.

## How to Perform Debit Credit Running Balance Formula in Excel: 3 Suitable Ways

Consider the following scenario, you have an account in a bank. You deposit the balance and withdraw the balance corresponding to your account from that bank which has been given in column C and column D. Weâ€™ll calculate the running balance by using Excel formulas such as SUM, OFFSET, and INDEX,Â functions. Hereâ€™s an overview of the dataset for todayâ€™s task.

### 1. Apply the SUM Function to Calculate Debit Credit Running Balance in Excel

From our dataset, we can calculate the debit credit running balance by using the SUM function. Excel debit credit running balance formula named the SUM function is the easiest and the most time-saving way. Please follow the instructions below to learn!

Step 1:

• First of all, select cell E6 to calculate the debit credit running balance by using the SUM function.

• After selecting cell E6, type the SUM function in the Formula Bar. The formula in the Formula Bar is,
`=SUM(E5+C6-D6)`

• Hence, press Enter on your keyboard and youâ€™ll get \$109,958.00 as the return of the SUM function in cell E6.

Step 2:

• After learning the above process, place your cursor on the bottom rightÂ of cell E6, and instantly an AutoFill Sign will appear in front of you, and drag the AutoFill Sign downward.

• Finally, after dragging the AutoFill Sign downward, you will be able to calculate the debit credit running balance by using the SUM function from our dataset which has been given below screenshot.

### 2. Use of the OFFSET Function to Calculate Debit Credit Running Balance in Excel

The OFFSET function lets you generate a reference by giving the number of rows and columns that should be offset from a given reference. Here, weâ€™ll apply the OFFSET function to calculate the running balance from our dataset. Letâ€™s follow the steps.

Steps:

• To apply the OFFSET function to calculate the debit running balance, select cell E6 first.

• Now, type the SUM and OFFSET functions in the Formula Bar. You should type the OFFSET function inside the SUM function. The function is in the Formula Bar,
`=SUM(C6,-D6,OFFSET(E6,-1,0))`
• Here, to refer to the past balance, we can use the current balance (E6) as a reference and offset rows and columns with -1 and 0.

• After typing the functions in the Formula Bar, simply press Enter on your keyboard. After that, you will get \$109,958.00 as the output of the functions in cell E6.

• Now, AutoFill Sign the OFFSET function to the rest of the cells in column E, and you will get your desired output in column E which has been given below screenshot.

Read More: How to Keep a Running Balance in Excel

### 3. Merge the SUM and INDEX Functions to Calculate Debit Credit Running Balance in Excel

Last but not least, we will calculate the debit credit running balance by using the formula namedÂ SUM and INDEX functions. This is the easiest way to calculate the running balance by using Excel formulas. Please follow the steps to calculate the debit credit running balance!

Step 1:

• For calculating the debit credit running balance by using Excel formulas, first select the cell array B4 to D14.

• Now, from your Insert Tab, go to,

Insert â†’ Tables â†’ Table

• By clicking on Table Menu, a window pops up titled Create Table.
• Hence, press the OK button from the Create Table window, and you will be able to create a table with the header.

Step 2:

• After creating the table, select cell E5.

• Now, type the SUM and INDEX functions in cell E5. The functions are,
`=SUM(INDEX([Credit],1):[@Credit]-INDEX([Debit],1):[@Debit])`
• Inside the sum function first INDEX function indexes the credit balance and the second INDEX function indexes the debit balance.

• After typing the functions in cell E5, just press Enter on your keyboard and you will be able to calculate the debit credit running balance to the entire column which has been given below screenshot.

## Things to Remember

ðŸ‘‰ While applying the INDEX function, first create a table from the Insert Tab.

ðŸ‘‰ You can also create a Table by pressing the Ctrl + T simultaneously on your keyboard.

## Conclusion

I hope all of the suitable methods mentioned above to calculate the debit credit running balance will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

1 Comment