forecast cash flow, P&L and balance sheet

(0) Share

Report

Posted on by marcod59

125

is it possible to produce a forecast cash flow, P&L and balance sheet in NAV 13? I know (or I'm pretty certain ) you can produce budgets and drive a cash flow from a budget but is it possible to get a balance sheet that reflects the budget /cash flow

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

keoma 32,729 on at

Like (0)

Report

hi,

for cash flow forecasting watch these tutorial videos:

www.youtube.com/watch

www.youtube.com/watch

www.youtube.com/watch

Was this reply helpful? Yes No
Suggested answer

Saurabh Shah 4,560 on at

Like (0)

Report

Hi,

Go with below link, you will have some of finance related topics available there.

dynamicsnavfinancials.com/.../financial-statement

Regards,

Saurabh Shah

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello Marcod,

You can create numerous reports from Chart of Accounts

'Accounts Schedules' can be used for meeting your requirements.

Refer: http://msdn.microsoft.com/en-us/library/hh930256(v=nav.70).aspx

--JO

All my posts are provided "AS IS" with no warranties and confer no rights

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

A cash flow statement is just a re-arranged balance sheet, so you should be able to do so.

Though in the real world you'd be better off doing something like that in Excel. You will probably have to download the statements at the account level as the very basic NAV Chart of Accounts is full of cheater sub-totals. You have to pull out individual accounts, probably in an order that doesn't match how they get sub-totalled. Once you do that, it's pretty easy. Bringing it into Excel allows to you use varying logic on the different accounts: based on last year; based on a constant; based on ytd results; different constants per quarter; etc... and lets you force line totals based on all the other totals.

The biggest problem I've found in NAV reports is that they are usually good for one period at a time. If you want to see 13 periods, side by side, in your forecast, and have actual results fill in the schedule period by period and be used to update the remaining future periods, you're way ahead of the game by doing this in Excel. Again, NAV reporting is pretty rudimentary.

Was this reply helpful? Yes No
marcod59 125 on at

Like (0)

Report

Thank you - I've got excel models that flow through from p&L to cash flow and Bsheet but but wanted to make sure there wasn't a model set set up in NAV its a pity because if you're working with third parties, investors etc they want to see the P&L and Cashflow linked to a balance sheet to prove they are working properly

Was this reply helpful? Yes No
marcod59 125 on at

Like (0)

Report

Thanks - I don't have a problem with cash flows its the linked forecast P&L, Cash flow and Balance sheet report that would be the answer to my prayers. I have it all set up in excel but its a chore.

Was this reply helpful? Yes No