Spreadsheets

Is there a spreadsheet that I could create that would show me several
different vendos and what they owe to our company on a day to day bases. Then
I need it to show me total for the month after the daily collections have
come in.

Patty,
I'm certain that such workbooks exist, or at least something you could adapt
to your needs.

If you're actually looking to create one on your own, there is no doubt that
this is easily within the realm of Excel's abilities.

Depending on how many vendors you deal with, you probably would want to put
each vendor's information on a separate sheet and do the math for each
account on that sheet. If you need help on getting started, try searching
for checkbook balance type workbooks - they'll do much the same thing.
Consider the payments that the vendors make to you as 'deposits' in a
checkbook, while amounts they owe to you are kind of like checks/debits in a
checkbook keeping setup.

The general layout could be something like this:
Column A Column B Column C Column D
date amt owed amt paid Balance

You would do manual entry of the date, amt owed and amt paid. The Balance
would be a calculated value. Assuming your entries begin on row 2 (with row
1 having the headings for the columns) then the formula in D2 would be
= C2 - B2
that allows you to enter both amounts in regular amounts (without having to
use a negative sign in front of one)
For the next formula beginning in D3 and extending down the sheet you would
use
= D2 + C3 - B3
That would take the previous balance, add any payments to it and subtract
any outstanding debit incurred on that day from those numbers.

Hope this helps get you started.

You might also start looking at this page for free downloads of workbooks
that may already do all that you need done:
http://office.microsoft.com/en-us/te...s/default.aspx


"patty" wrote:

> Is there a spreadsheet that I could create that would show me several
> different vendos and what they owe to our company on a day to day bases. Then
> I need it to show me total for the month after the daily collections have
> come in.