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 (for CA and UK support site links see below).
- MS Excel 2010 64-bit is not currently supported for QSW. However Excel 2010 32-bit is.
- If you are using two monitors and you're unable to adjust the fonts or column widths in QuickBooks Statement Writer, drag the Excel window to the primary monitor and this should fix the issue. This normally occurs if the QSW is opened on a secondary monitor.
- Make sure QuickBooks Desktop is updated to the latest release.
- Get the latest release of Statement Writer.
- Open Statement Writer.
- Click the Help Center.
- Change 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). For details, refer to Use User Account Control in Windows
- 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..."
- (2010 and prior only) Verify the product and license numbers for QSW. Make sure it is not an expired trial version. Contact QuickBooks support (US, Canada or UK) or ProAdvisor support (US, Canada or UK) if you are unsure.
- Try to access QSW in another company file 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). You can browse to the location of the file (Windows 8, 7 or Vista: C:\ProgramData\Intuit\Statement Writer) or you need to turn on hidden files and folders. For detailed steps, refer to Display hidden files and folders or search for files using Windows.
- 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.