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

[questforexcel]

[TABLE="width: 1097"]
<colgroup><col><col><col><col><col><col><col><col span="2"><col span="2"></colgroup><tbody>[TR]
[TD="align: center"]Ledger No:[/TD]
[TD="align: center"]ID#[/TD]
[TD="align: center"]Src[/TD]
[TD="align: center"]Account Name [/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Memo[/TD]
[TD="align: center"]Beginning Yr Balance[/TD]
[TD="align: center"]Debit[/TD]
[TD="align: center"]Credit[/TD]
[TD="align: center"]Cl Daily Bal[/TD]
[TD="align: center"]Cl Mon Bal[/TD]
[/TR]
[TR]
[TD="align: center"]4-1100[/TD]
[TD="align: center"]GJ000327[/TD]
[TD="align: center"]GJ[/TD]
[TD="align: center"]Sales[/TD]
[TD="align: center"]30-Sep-16[/TD]
[TD="align: center"]PayPal US Transactions[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]$77,477.73[/TD]
[TD="align: center"]($122,046.23)[/TD]
[TD="align: center"]($122,046.23)[/TD]
[/TR]
[TR]
[TD="align: center"]4-1100[/TD]
[TD="align: center"]CR000382[/TD]
[TD="align: center"]CR[/TD]
[TD="align: center"]Sales[/TD]
[TD="align: center"]07-Oct-16[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]$53.79[/TD]
[TD="align: center"]$0.00[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]4-1100[/TD]
[TD="align: center"]CR000383[/TD]
[TD="align: center"]CR[/TD]
[TD="align: center"]Sales[/TD]
[TD="align: center"]07-Oct-16[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]0[/TD]
[TD="align: center"] [/TD]
[TD="align: center"]$53.79[/TD]
[TD="align: center"]($122,153.81)[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
</tbody>[/TABLE]


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