tracking money owed and paid

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
"know just enough to be dangerous" <know just enough to be
(e-mail address removed)> 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.
Click to expand...

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
 
Back
Top