Jim,
start by keeping all paycjecks and their breakdowns in a single table.
Use column A:A for paycheck date, use column B:B for paycheck amount
and then use the next columns for your formulas.
Assuming your data start from row 2, A2 would be the date, B2 would be
the amount, and then C2:H2 (imaginary) would contain the various
formulas for producing the sub-amounts from B2. These formulas can be
copied down for each new entry.

Running totals can then be dealt with, with formulas like:
=SUM($F$2:F2). Such a formula, copied down to row, say, 13, woulc
produce the sum of all cells F2:F13, to produce a running total of the
amounts allocated to the specific impound account.

Write back for more, if this helps.

Kostis Vezerides