ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   tracking money owed and paid (https://www.excelbanter.com/excel-discussion-misc-queries/152086-tracking-money-owed-paid.html)

know just enough to be dangerous

tracking money owed and paid
 
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.

Bill Ridgeway

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




All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com