Hi Richard:

I'm not a QuickBooks user but I can answer the Adagio-related questions.

1) Yes, you must enter Excel-like formulas to calculate derived fields. If you edit the statement in collapsed mode, this is very quick.

2) Do you only have 2007 data in FX right now? Then go to the Company Profile button and edit the dates on the 2 tabs "Current Fiscal year" and "Prior Fiscal Year" to indicate 2007 and 2006 respectively.

The Period Selector will change both the data and the titles. If you choose Period 1, all figures in your statement should be as of the 1st Period.

3) You are dragging an Account group onto the spreadsheet grid and selecting "Expand"? That should be sufficient. Does the resulting statement should have ".Smartsheet" in cell A1. In column A you should see ".Range" in a number of cells. In the rows with ".Range" you should see a range of Accounts in column B. For instance, you should see something that looks like "1000:2999" in cell B. Then if you click on the "Expand" icon on the button bar, the rows with .Range should expand.

It may be a good investment to get a local Adagio consultant to advise you. Or you could attend an Adagio webinar. The cost is only $75. See the https://www1.gotomeeting.com/register/630799103 link.

For examples of what the Financial Reporter can do, look at the following link: http://www.greatstatements.com/examples.htm. You can click on the images to drill-down for more detailed examples.