Print This Post

Intuit Statement Writer Update April, 2011

April 13, 2011 | By | 3 Replies More

Here are a few tips and updates about Intuit Statement Writer (ISW) version 3.0.2.0.

  1. ISW needs MS Office installed. Version 2003, 2007, or 2010 works, but 64-bit MS Office is NOT supported yet.
  2. We are still seeing some instability with ISW on Win 7 64-bit running Office 2010 32-bit. The symptom is that it crashes Excel on exit (seems to be a harmless crash), and Intuit is working on it.
  3. We’ve noticed an occasional issue with PDF creation: If you have Acrobat Pro version 9 with Office 2010, the Print to PDF does not generate. This is not rampant but has been observed  on customers’ machines that have the Acrobat reader as well. The work around is to use Acrobat to combine the documents that reside in the ISW report folder.
  4. The bug I identified in my blog article from February 7, 2011 (the issue with the “Net Income” line on the Balance Sheet) has been fixed.
  5. If you see an error message from Excel that says “Office document customization is not available,” it is caused by locating ISW files on the network without the proper configuration/security settings on the network.

ISW Error

The work around is to copy the QSM file to the local machine and open it there in Excel. However, you can fix it so that ISW allows the files to remain centralized on the server so that all client machines in the office can remotely access ISW files.

Locating ISW files (.qsm files) on a server is tricky and depending on your security settings. If you save files to a network folder, you should do the following:

  • Set the ISW preferences so that they use the network path (e.g. the UNC path such as \\myserver\Intuit\Statement Writer, or to a Mapped Network Drive like X:\Intuit\Statement Writer)

Intuit Statement Writer preferences

  • After setting the preferences in Statement Writer, apply one of the two “ISW Network Fix Utilities,” located on Intuit’s support site for automating the “permissions” on your network so that ISW can work properly. The article on that web page discusses two scenarios. The first is where you have “redirected” the My Documents folder on network client machines to point to a server location. The more common scenario is when you simply want to open files located on a the network somewhere, but not via your My Documents (redirected) folder. So pick the second link on that page to apply the network fix if you don’t redirect your My Documents folder.

If you continue to have trouble with locating ISW files on a server, please report them to us so we can get the feedback to Intuit.

Tags:

Category: Technical QuickBooks, Working with QuickBooks

About the Author ()

Doug Sleeter is a passionate leader of innovation and change in the small business accounting technology world. As a CPA firm veteran and former Apple Computer Evangelist, Doug has melded his two great passions (accounting and technology) to guide developers in the innovation of new products and to educate and lead accounting professionals who serve small businesses. Doug is best known for his expertise in QuickBooks as well as driving the adoption of online accounting and small business process solutions. In the early 1990s, Doug was a pioneer in developing the first QuickBooks seminars in the country and has since built the largest group of accounting software consultants in the small business accounting profession. Doug serves on several advisory boards for technology companies and has consulted with numerous industry leaders, including Intuit, Sage, Apple, and Adobe Systems. CPA Practice Advisor has recognized Doug as one of the "Top 25 Thought Leaders" in the accounting profession for the past several years and he has been named to Accounting Today's "Top 100 Most Influential People in Accounting" each year since 2008. Highly sought for his ability to engage and educate accounting professionals, Doug presents at various accounting events throughout the year, including those held by the AICPA and numerous state CPA societies. Doug also hosts the annual Accounting Solutions Conference, attended by hundreds of accounting professionals, industry leaders, and technology developers.

Comments (3)

Trackback URL | Comments RSS Feed

  1. William "Bill" Murphy says:

    It really depends on what ‘exact’ version of Excel you are using for any year, if it works or not. Initially ISW worked with all versions of Excel 2003, then after a couple of revisions it no longer worked with some versions; same with Excel 2007 (it doesn’t work with Home and Student version) or at least it hasn’t in some ISW incarnations.

    This is one of the frustrating things about ISW, some versions and releases work with some Excel versions and some other releases do not work with the exact same Excel version. At times it seems like a ‘crap shoot’….so it’s a gamble if the extra $$$ you pay for the ISW product are going to work with the Excel you already have (or if you are going to have to upgrade your Excel to make it work) or send ISW packin back to the Intuitities.

    William “Bill” Murphy – Oklahoma City

  2. Doug Sleeter says:

    Bill, Thanks for the note. I agree that it’s somewhat frustrating to deal with all the different versions of Excel. But ISW has done the best they can to deal with all of the possibilities out there. Not perfect yet, but most things are now working…

Leave a Reply