Shannon,
This gives a little more to go on. Don't know if I can
help you or not but maybe.......
-----Original Message-----
I don't understand why this seems to be so difficult but,
prehaps I can attempt explain what I am looking for
another way.
What would the formula be for the following list
1. Monthly Assmt
2. Parking
3. Total Due
I would assume the "Total Due" for this months services
would be the Monthly Assmt + Parking. I would also assume
that Monthly Assmt and Parking would be entered either
manually or by a date activated macro and entered as
Currency. I think to make things easier to understand you
might want to think of this as a Sub-total and possibly
rename it to "Monthly Fees"
4. Previous Bal ( Do I add the total balance from Monthly
Assmt and Parking to get the "Previous Balance"
I would take "Previous Bal" to mean the amount of your
clients last billing. In this case last months total
amount due.
5. Prepaid Amt (and do I take the "previous balance " and
add the prepaid amount to get a total
"Prepaid Amt" normally is a credit balance in itself and
normally would be applied to the billing at the time of
Invoice.
I'm seeing two redundant terms here.....Balance and Total
Due....I may be reading those terms differently than you
do. Unless you have an agreement where as only a certain
amount of the "Balance" will be billed as "Total Due" and
some sort of baloon payment will be paid at a later date.
7. Paid (and do I add the total of prepaid previous
balance and subtract what was paid to get a balance
"Paid" is simply that.....the amount that you credit your
clients account with in the form of payments and/or
prepaid amt's.
"Late Fee" should be listed on the Invoice as such and
becomes a part of the total due. This would then carry
over into the "Previous Balance" column for the next
billing period.
Again, "Other Charges" should be defined somewhat and
listed on the Invoice as such and, as above, becomes a
part of the total due. Also this would then carry over
into the "Previous Balance" column for the next billing
period.
"Credit Balance" would come into effect if your client had
overpaid his account balance or possibly if there were to
be an adjustment on his billing without cash compensation.
Again, according to your business's rules, this figure
would reflect all balances that were left unpaid for a
defined time period. Normally these would have some
penalty attached to them.
So, this is what I am trying to understand is how to setup
my spreadsheet formulas.
Thanks,
Shannon
there are a couple of areas in my response that you should
address before we devote more time on this, but if you're
willing to do that, I'm sure there are those on here that
will attempt to help.....we'll then have what we need to
help you.
It's frustrating getting started with this but hang in
there, the dawn will come,
HTH,
Don
