This article serves as a general troubleshooting guide for QuickBooks Statement Writer. If you are experiencing a specific error, please refer to the QuickBooks Support Site or ProAdvisor Support Site for an article specific to the issue you encounter.
- Make sure QuickBooks Desktop is updated to the latest release.
- Get the latest release of Statement Writer.
- Open Statement Writer.
- Click the Help Center.
- 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 QSW data file (.qsm) is local, if you are having problems opening over a network.
- If you are using Windows 7 or Vista, you need to enable User Account Control (UAC).
- Make sure you have a supported version of Microsoft Excel. QSW 2014 and later are compatible with MS Excel 2007, 2010 (32-bit) and 2013.
How do I find the version and bit size of Excel?
To find the year, version (i.e. Office Professional, Standard, Trial, etc), and bit size (2010 only) of Microsoft Excel:
- From the File menu, select Account.
- The Excel version can be found on the right side under the Office Updates heading.
- From the File menu, click Help.
- 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..."
- Office 2013:
- (2010 and prior only) Verify the product and license numbers for QSW. Make sure it is not an expired trial version. Contact QuickBooks support or ProAdvisor support if you are unsure.
- Try to access QSW in another company on the same computer.
- Review the log file QSW creates: isw_YYYY.log (where "YYYY" is the year, such as isw_2015.log), this file shows certain user activity and errors that have occurred (look at the very bottom of the log file).
Note: You can browse to the location of the file (Windows 8, 7 or Vista: C:\ProgramData\Intuit\Statement Writer) or you will need to turn on hidden files and folders:
- If you are using Windows 7, make sure you are not running either QuickBooks or Excel as an Administrator
- Right click 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 issue persists, this support article may also help.