Using formula to calculate figures based on dates, it gives circular reference

[questforexcel]

Ledger No:	ID#	Src	Account Name	Date	Memo	Beginning Yr Balance	Debit	Credit	Cl Daily Bal	Cl Mon Bal
4-1100	GJ000327	GJ	Sales	30-Sep-16	PayPal US Transactions	0		$77,477.73	($122,046.23)	($122,046.23)
4-1100	CR000382	CR	Sales	07-Oct-16		0		$53.79	$0.00	$0.00
4-1100	CR000383	CR	Sales	07-Oct-16		0		$53.79	($122,153.81)	$0.00

<colgroup><col><col><col><col><col><col><col><col span="2"><col span="2"></colgroup><tbody>
</tbody>

Hi, This is the current formula that I am using.

=IF(ISNUMBER(SEARCH("Beginning Balance",C4931)),D4931+I4932-J4932,K4931+I4932-J4932)

This is taking into account cumulative figures Month over Month. Hence I need to remove the last end of month figures.

Below is the formula that I had typed out on this:

=IF(ISNUMBER(SEARCH("Beginning Balance",C4929)),D4929+I4930-J4930,IF(AND(MONTH(F4929)=MONTH(F4930)),K4929+I4930-J4930,K4929-K4930))

When I use the formula IF(AND(MONTH(F4929)=MONTH(F4930)),K4929+I4930-J4930,K4929-K4930))

It gives in the correct result but when I combine it with this, it tells me circular reference warning. IF(ISNUMBER(SEARCH("Beginning Balance",C4929)),D4929+I4930-J4930


Could you please help how else could i remove cumulative figures for my data with daily and monthly figures.

Thank you