Hello,

I am looking for some guidance on where/how I can find information on cash flows and how to build them out of the financial reporter?

Any help would be greatly appreciated here as I am not sure even where to start.

Are you talking about the "Statement of Cashflows" financial statement, or a report that predicts where/when cash will be needed based on Receivables and Payables requirements?

Have you looked at the Statement of Cashflows in the sample data or on http://www.GreatStatements.com ?

Thank you for the link that is great. I am looking for both actually.. Does Adagio have the ability to predict cash requirements?

Thanks again for your help!

In Adagio BankRec there is a report that allows you to predict a cash position based on your current bank balance, aged receivables and aged payables. You can also manually enter any external payments or receipts (such as payroll) before running the report.

Predicting cash inflows is much easier that predicting cash outflows. Most cash inflows are the result of your collecting your A/R, making cash inflows somewhat predictable using only your A/R. I recently did cash projections for a client and we had to set up several schedules in Excel for outflows that never hit A/P. Examples are rent, payroll, loan payments, all pre-authorized automatic withdrawls, such as car lease payments, etc. You know in advance when all these outlays will occur, but most of them never sit in your A/P in advance.

Hi Brian,

That's why we allow the user to enter these before the report is printed. Of course, in some companies it's only payroll that doesn't hit AP.

I have another question about this? Should be FX reporter have templates like those found at Greatstatements.com? I am struggling to try and build a cash flow statement from the ground up so I am just looking for suggestions on making the process smoother?!

Adagio FX (indeed all the Adagio Modules), install sample data in the directory \softrak\xxWIN\SAMDATA with example forms and reports. Adagio FX installs all of the statements you will see on GreatStatements.com in this directory. Find one that you would like to use as a starting point and use File | Import Workbook to move the one you want to your data directory and extension.

Alternatvely, if you already have a Cashflow statement in Excel that you'd like to use as your example, then open the spreadsheet in Excel with the financial reporter open and use File | Import from Excel direct to import the spreadsheet into the financial reporter with all the formatting preserved and columns set up read for the formulas and SmartSheet commands.

Does this help?

That is excellent thank you so much Andrew!