Here are steps and recommended solutions that'll help you fix performance issues when using QuickBooks Statement Writer (QSW).
Solution 1: Update QuickBooks Desktop
Solution 2: Download the latest version of QSW
- Open QuickBooks Statement Writer.
- Select Help Centre, then Update.
Important: If a Download/Install update prompt appears every time you open QSW or shows up after updating, select Cancel to open QSW.
Solution 3: Change the Windows settings
- Change the regional settings in Windows.
- Change user settings (for Windows 7 only):
- Enable User Account Control (UAC).
- Make sure you are not running QuickBooks or Excel as an Administrator.
- Right-click the version of QuickBooks and/or Excel you are using from the Programs menu, then select Properties.
- Go to the Compatibility tab and make sure no boxes are checked.
Solution 4: Make sure Excel is compatible
QuickBooks Statement Writer 2014 and later versions are compatible with Microsoft Excel 2007, 2010 (32-bit). Check this Microsoft article to know which version you have.
Solution 5: Change the way you access the .QSM file
- If you cannot open your QSW data file (.QSM) over a network, save the file locally.
- If you are unsure whether the problem is with your QSW file or not, on the same computer, access the QSW file while using a different company file (.QBW). If the file opens, try some basic data damage troubleshooting on your company file.
Solution 6: Refresh QSW's access permission
- From the Edit menu, choose Preferences.
- Select Integrated Applications on the left pane, then go to Company Preferences tab.
- Choose QuickBooks Statement Writer, then select Remove.
- Close then relaunch your QuickBooks Desktop.
- Open the Statement Writer.
Solution 7: Run the QuickBooks Statement Writer Diagnostics
- From the Statement Writer Welcome Page, select Preferences & Formats.
- Select Run Diagnostics Now.
- Follow the wizard to diagnose and fix any problems listed.
Solution 8: Review the .log file
- Go to the location of the file: C:\ProgramData\Intuit\Statement Writer.
Note: You may need to display hidden files and folders if the folder is not appearing.
- Open the isw_YYYY.log (where "YYYY" is the year, such as isw_2018.log). This file shows user activity and errors that have occurred.
- Look at the very bottom of the .log file to determine what is causing the error, then refer to our Learn and Support site to get detailed steps on how to resolve it.
Solution 9: Edit the QBDSK.INI file
This solution also resolves QuickBooks SDK invalid result error when creating a new report in QuickBooks Statement Writer.
- Go to the location of the file C:\ProgramData\Intuit\QuickBooks\QBDSK.INI.
- Right-click the QBDSK.INI file, choose Open with then select Notepad.
- Add the following:
- Save the changes by going to File, then Save in Notepad.
- Restart QuickBooks.
Note: This step turns on logging and may affect performance the longer it is enabled.
For specific issues...
- Display issues If you are having problems with adjusting fonts and column widths when using two monitors, drag the Excel window to the primary monitor. Adjustment issues normally occur if the QSW is opened on a secondary monitor.
- StatementModel.DLL or FsdCommon.DLL could not be found This is caused by a problem with the QSW installation. Follow solutions 1-7 to fix this error.
- C:\Program files (x86)\Intuit\Statement Writer 20XX\microsoft.office.interop.word.dll did not succeed To determine if the problem is with QSW installation or with the QSW file itself, create a new report in QSW.
- If the report does not open, follow solutions above.
- If the report opens, your existing file is damaged. You can just recreate the report.