I'm wondering how I should handle tallying a $ amount.

I have record for each month out of the year and it's broken down by office. In this record I have 2 fields that add to $ amount and 2 fields that subtract from $ amount. After the adding and subtracting, I need the final $ amount to carry over to the next record based on month and year.

Should I break those add and subtract fields into their own records or should I try and figure out a calculation that will pull the amount from one record to the next?

Any thoughts?

Thanks

Wouldn't a summary field (running total) do?