Help! DETAILED Cash Flow!!

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Hi, I appreciate any help/advice!
My supervisor wants me to create a detailed cash flow
including all of our vendors and the projected payment,
followed by a column with the actual payment for each
week. He also wants any incomplete payments to roll into
the next weeks column. I have a fairly good understanding
of Excel, but my brain just can't put this one together.
Any help?? :)
Thanks!
 
Thank you for your response.
So far, I have a very simplistic spreadsheet set up with
the weeks across the top and the vendors down the lefthand
side. I have input the bills as they come in in the
correct columns, but now my supervisor wants me to split
each week into 2 columns, with a column for the projected
payment (what's owed) and what we actually pay out to our
vendors. Then, as each week goes by, he wants remaining
amount owed on each bill to automatically roll into the
next weeks projected payments. He also wants it so that
he can easily add any new payments to the total for that
specific vendor. Does that make sense? Then at the
bottom, he wants totals projected and totals actual. I am
kind of at a standstill and don't even know if
the "rolling into the next week" AND being able to simply
add more on top of that is possible.
If anyone has any advice, it'd be appreciated!
Thank you!!!
 
Are you doing this with worksheets formulas (no VBA)? If so, you could use a
"helper" cell to tally each vendors' unpaid balance:
=OneVendorBalance+SUMIF(Vendors,OneVendorName,Charges)-SUMIF(Vendors,OneVend
orName,Payments)

On next weeks' sheet, the beginning balance for that vendor will be the
value returned by the formula above.

It is too bad there are so many virus attachments inundating the web, else
you could post what you have on the web
 
Back
Top