View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Ridgeway Bill Ridgeway is offline
external usenet poster
 
Posts: 268
Default tracking money owed and paid

"know just enough to be dangerous" <know just enough to be
wrote in message
...
i need help in tracking past due child support payments. what chan i use
to
do this. i don't have office, but have excel and word.


You say you don't have Office but you have Excel and Word. These are
important components of Office so you do (or did) have Office.

In its simplest form the answer to your question is to have four columns in
Excel
A- Date
The date each CS payment is due or received
B- CS due
The amount of CS due
C- CS received
The amount of CS received
D- Over / under paid
A running balance of over / underpayment. This can be done with the formula
=SUM($B$2:B2)-SUM($C2:C2)
copied down to each row

Regards.

Bill Ridgeway
Computer Solutions