payment worksheet

[Lcarter]

I am trying to set up a worksheet to keep track of parent's weekly payments.
I also want to show their balance due after each payment that is made. How
do I set this up?

 

[Pete_UK]

Homework?

Think of the things you might want to record in addition to the payment.
Probably the date on which it was made, and maybe a description of what the
payment was for (groceries, or electricity etc), and possibly also the type
of payment (by cheque, credit card, cash etc). You might think of other
things that are worth recording.

Once you have decided these things, you can allocate a column for each, and
at the end you will need a column for the payment and a column for the
remaining balance, so that you enter new data going down the sheet.

You can put labels at the top of the columns so that you know what each
column is for, and you will need a blank row in which you can put the
opening balance. As you make a payment you need to subtract this from the
balance on the previous row to give you the current balance.

Hope this helps.

Pete

 

[Tim879]

set up a spreadsheet as follows:

Cell Reference | Value
A1 | Date
B1 | Parent Name
C1 | Balance (represents the opening balance or any additional charges
incurred)
D1 | Payment amount (entered as a negative)
E1 | Ending Balance (shows balance after pmt)

In A2.....Axxx enter the pmt date
In B2.... Bxxx enter the parent's name. This will serve as the index,
therefore it must be unique and entered exactly the same way each time
you enter a transaction for the parent.

In C2 enter the first parent's name and balance owed.
In C3....Cxxxx. If you are entering a new parent's info, enter the
name and balance owed.

Otherwise, enter the following formula (this assumes that you are
entering the first payment in row 3. If you're entering this formula
in another row, just change the "3" in the formula below to correspond
to the first row with a payment.)
=SUMIF($B$1:$B2,$B3,$C$1:$C2)+SUMIF($B$1:$B2,$B3,$D$1:$D2)

In D2.... Dxxxx enter the payment amount as a negative.

In E2...Exxx enter the following formula: =+C2+D2