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.

Detailed instructions

  • MS Excel 2010 64-bit is not currently supported for QSW. However Excel 2010 32-bit is.  Please see Microsoft Office 2010 FAQ for details on QuickBooks and Microsoft Office 2010.
  • 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.
  1. Make sure QuickBooks Desktop is updated to the latest release.
  2. Get the latest release of Statement Writer.
    1. Open Statement Writer.
    2. Click the Help Center.
  3. Check Regional Settings in Windows.
  4. Run the Quickbooks Statement Writer Diagnostics.
    1. From the Statement Writer Welcome Page, click Preferences & Formats.
    2. Click Run Diagnostics Now.
    3. Follow the wizard to diagnose any problems listed.
  5. Be sure that the QSW data file (.qsm) is local, if you are having problems opening over a network.
  6. If you are using Windows 7 or Vista, you need to enable User Account Control (UAC).
  7. 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.  
  8. (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.
  9. Try to access QSW in another company on the same computer.
  10. 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:
  11. If you are using Windows 7, make sure you are not running either QuickBooks or Excel as an Administrator
    1. Right click the version of Quickbooks and/or Excel you are using from the programs menu and go to Properties.
    2. Go to the Compatibility tab and make sure no boxes are checked.
  12. If the issue persists, this support article may also help.