Fix problems with Statement Writer
Note: If you are experiencing a specific error, you should search the QuickBooks Support Site or ProAdvisor Support Site for an article specific to the issue you are encountering, as this article does not address any specific issue.
Important: Excel 2010 64bit is not currently supported for ISW, however Excel 2010 32bit is. Please see Microsoft Office 2010 FAQ for details on QuickBooks and Microsoft Office 2010.
- Be sure you have the latest release of Statement Writer and the latest release of QuickBooks.
- Check Regional Settings in Windows.
- Run the Quickbooks Statement Writer Diagnostics.
- From the Statement Writer Welcome Page, click Preferences & Formats.
- Click Run Diagnostics Now.
- Follow the wizard to diagnose any problems listed.
- Be sure that the ISW data file (.qsm) is local, if you are having problems opening over a network.
- If you are using Windows 7 or Vista, User Account Control (UAC) must be enabled.
- Be sure that Microsoft Excel 2003 (2003 Professional is the only version of 2003 Office that is supported with ISW) or later is installed (ISW is fully compatible with Microsoft Office and Excel 2007 and Office 2010 32bit).
To find the year, version (i.e. Office Professional, Standard, Trial, etc), and bit size (2010 only) of Microsoft Excel:
- Click the green File button.
- Select Help under the File menu.
- Look on the right of the Help window .
NOTE: The Help button on the right of the Excel window will NOT show the version information.
- Click the Round office circle button at the left side of your task-bar.
- Click the Excel Options button in the bottom right corner of the drop down.
- Select Resources.
- Click About next to About Microsoft Office Excel 2007.
- The second line of text should say "Part of Microsoft Office..."
- Select Help.
- Select About Microsoft Excel.
- Office 2010:
- (2010 and prior only) Verify the product and license numbers for ISW, ensuring that this is not an expired trial version of ISW (contact QuickBooks support or ProAdvisor support if you are unsure).
- Attempt to access ISW in another company on the same computer.
- Review the log file ISW creates: isw_YYYY.log (where "YYYY" is the year, such as isw_2009.log), this file shows certain user activity and errors that have occurred (look at the very bottom of the log file).
You can browse to the location of the file (you will need to turn on hidden files and folders):
- Windows 8, 7 or Vista: C:\ProgramData\Intuit\Statement Writer
- If you are using Windows 7, ensure that you are not running either QuickBooks or Excel as an Administrator
- Right click on the version of Quickbooks and/or Excel you are using from the programs menu and go to Properties.
- Go to the Compatibility tab and make sure no boxes are checked.
- If the error still persists, SLN43527 may also resolve the issue.