Payment terms for cash flow

[TL]

Hi,

does anyone have any good ideas how to take into account payment terms in
cash flow projection in Project? Percentage of completion will give me
accounting based cost distribution but I'd also like to have cash based
distribution.

Thanks in advance.


Tarmo

 

[John]

Hi,

does anyone have any good ideas how to take into account payment terms in
cash flow projection in Project? Percentage of completion will give me
accounting based cost distribution but I'd also like to have cash based
distribution.

Thanks in advance.


Tarmo

TL,
You have to remember that Project is not designed to be a financial
application. Some rudimentary pieces of financial data can be generated
given appropriate formulas or through a VBA macro, but otherwise, I
suggest you use a spreadsheet or actual financial application.

John
Project MVP

 

[Steve House]

Echoing John, Project is not an accounting application. It's only concerned
with estimating the costs of tasks and when during the project you acquire
the obligation to pay for them - that's what it's talking about with it's
cash flow report. It does not deal at all with either revenues or
expenditures. It will tell you that you'll owe Joe $200 for painting the
walls and that obligation will be accrued during such and such reporting
period but doesn't know or care when or if you actually pay him or get paid
yourself for the work by the customer of the project.