# Debit and Credit Running Balance

This is a discussion on Debit and Credit Running Balance within the Excel Questions forums, part of the Question Forums category; Hello, Could anyone recommend a slick way of producing a debit and credit running balance for a double-entry bookkeeping account? ...

1. ## Debit and Credit Running Balance

Hello,
Could anyone recommend a slick way of producing a debit and credit running balance for a double-entry bookkeeping account?

I envision four columns: debit, credit, debit balance, and credit balance.

The challenge seems to lie in cases where a debit is made that exceeds the former credit balance (or a credit is made that exceeds the former debit balance). In other words, a credit balance becomes a debit balance, or vice versa.

Thanks for the help

2. ## Re: Debit and Credit Running Balance

maybe something like this:

******** ******************** src="http://www.interq.or.jp/sun/puremis/...<CENTER><TABLE cellSpacing=0 cellPadding=0 align=center>
 Microsoft Excel - Book2 ___Running: xl2002 XP : OS =
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 C2D2C3D3C4D4C5D5 =

A
B
C
D
1
DRCRDR BALCR BAL
2
100 1000
3
2005000200
4
500 3000
5
30000
 Sheet2

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

3. ## Re: Debit and Credit Running Balance

formula I had in cell D2 was (which didn't show in my previous post):

Code:
```
=IF(SUM(\$A\$2:\$A2)-SUM(\$B\$2:\$B2)>=0,0,SUM(\$A\$2:\$A2)-SUM(\$B\$2:\$B2))*-1```

4. ## Re: Debit and Credit Running Balance

Brilliant! Thanks for your help, Crimson!

5. ## Re: Debit and Credit Running Balance

I am having the same problem.......from above formula i am still confused....i have debit value and credit value it should get updated from opening value......if there is any credit then it should add and if there is any debit then it should deduct from respective opening value.

6. ## Re: Debit and Credit Running Balance

can you post the setup of your data and perhaps I can better assist you.

Originally Posted by ashishbarot
I am having the same problem.......from above formula i am still confused....i have debit value and credit value it should get updated from opening value......if there is any credit then it should add and if there is any debit then it should deduct from respective opening value.

7. ## Re: Debit and Credit Running Balance

Brilliant! It helps me alot.
Kindly solve an another problem of mine, In the next cell of 'Balance' which have no value in 'Debit' & 'Credit' Columns, should not show the value in 'Balance'. Plz Help Me for this. Only Show value in 'Balance' when I have data in 'Debit' & 'Credit'. No need of drag the Formula just enter the value and get the result.
Like; If my Data is:
 Debit Credit Balance 100 100 80 20 200 220 300 520 20 500 50 550 100 650 30 620 500 1120 1120 1120 1120 1120 1120 1120 1120

8. ## Re: Debit and Credit Running Balance

Originally Posted by soomaiya
kindly solve an another problem of mine, in the next cell of 'balance' which have no value in 'debit' & 'credit' columns, should not show the value in 'balance'. Plz help me for this. Only show value in 'balance' when i have data in 'debit' & 'credit'. No need of drag the formula just enter the value and get the result.
Like; if my data is:
 debit credit balance 100 100 80 20 200 220 300 520 20 500 50 550 100 650 30 620 500 1120 1120 1120 1120 1120 1120 1120 1120