Thread
:
tracking money owed and paid
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bill Ridgeway
external usenet poster
Posts: 268
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
Reply With Quote
Bill Ridgeway
View Public Profile
Find all posts by Bill Ridgeway