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 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.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

## 3 Suitable Ways to Calculate a Debit Credit Running Balance in Excel

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 the Excel formulas** named **SUM function**, **OFFSET function**, **INDEX function**, and **SUMIF function**. Hereâ€™s an overview of the dataset for our 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.

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

Last but not the least, we will calculate the debit credit running balance by using the formula named **the 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])`

- Where inside the sum function first INDEX function indexing the credit balance and second
**INDEX**function indexing 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.

## Related Articles

**How to Calculate Running Total in One Cell in Excel (5 Ways)****Calculate Running Total by Group Using Excel Power Query****How to Use Pivot Table to Calculate Running Total by Date in Excel****Quick Analysis Tool: Calculation of Running Total in Excel (4 Ways)****How to Calculate Horizontal Running Total in Excel (3 Ways)****Cumulative Sum in Excel If Condition Applied (6 Methods)****How to Calculate Running Total in Excel (9 Ways)**

Very helpful. Thank you!!