Prospective Adagio client is a CPA firm with a couple hundred clients. They want to produce a set of financial reports for each client from the Ledger financial reporter and then publish them to a secure web portal. Each client will have their own page on the portal that will store their current reports. That's the general requirement.

They want to automate this as much as possible. Printing each report to Excel or PDF for each client individually will take some time. And copying each of these files to the web site will take even more time. They'd like a way to do a complete set of reports for each client and copy the set to the server and folder for that client automatically.

Are they asking too much?

TIA.

And, for the same prospect, is there a good way to convert QuickBooks G/L accounts and historical journal entries to Adagio? I know Adagio can import but don't know how to export from QB. Anyoen done this?

TIA.

Conversion from QuickBooks to Adagio can be done by Dakota Software - one of Softrak's partners. See http://www.dakotasoftware.com for details.

Statement groups can be created to export all financial statements for a single company to a single Excel workbook, which can then be distributed. If you are looking to do this for all companies and not just one at a time, you would need to look for a Windows macro to accomplish this - Adagio doesn't have this setup.

Thanks. I'll contact Dakota and see if the workbook solution suffices.

Matthew:

I assume the goal would be to update the reports on the web site whenever they were updated in the CPA office.

This might be easy if a folder structure for the reports was created on a local server that exactly matched that on the web server.

Then, if a statement group was created for each client containing the needed reports, it would be printed to a pdf file with PDF Creator or similar program before the accountant or bookkeeper exits. These files would be saved in the folders on the local server with pre-defined file names.

At day end, the entire folder structure would be copied to the web server via FTP, updating all the client reports.

Hi Matthew

There are two separate questions:

1) Automating the downloading of Adagio reports:

I have had success using Automation Anywhere (www.automationanywhere.com). The version you would want to look is called Premier and costs about $700 but you can download a copy for free for 30 days and by then you will know if it will work for you.

2) Quickbooks to Adagio GL conversion:

There are two possibilities. If you want to continue using Quickbooks and just use Adagio to print financials and view details, then you want Adagio FX. If you want to transfer the Quickbooks data to Adagio GL and stop using Quickbooks, then you want to look at Dakota Software to do the conversion.


Steve

Yes, when the CPA is finished working on the client's account, he wants to 'delivery' the set of financial reports to the client's web site. Ideally, an email would go out to the client notifying him that there is a new set of reports.

I'm agnostic about PDF vs. Excel. What matters is which is fastest and easiest to make the set of reports.

I like your idea about the local folder structure mirroring the web site server folder structure.

The prospect uses FX already which is why they are favorably disposed towards Adagio. They don't want to stay on QB. They have outgrown it.

-Matt.

Hi Matt,

In terms of delivering the statements securely through the web, this is exactly what Websafe is designed to do.

A lot of the printing functionality you are looking for could be handles by PrintBos, including individual directories, unique PDF files names, and email notification. Uploading to the web needs a little further investigation.