Fix problems with Statement Writer
by Intuit• Updated 5 months ago
Here are steps and recommended solutions that'll help you fix performance issues when using QuickBooks Statement Writer (QSW).
In this article, you'll learn how to:
- Update QuickBooks Desktop
- Download the latest version of QSW
- Change the Windows settings
- Make sure Excel is compatible
- Change the way you access the .QSM file
- Refresh QSW's access permission
- Run the QuickBooks Statement Writer Diagnostics
- Review the .log file
- Edit the QBDSK.INI file
- Manage specific issues
Solution 1: Update QuickBooks Desktop
Update QuickBooks Desktop to the latest release.
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, select the Preferences.
- Select Integrated Applications on the left pane, then go to Company Preferences tab.
- Select 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, select Open with then select Notepad.
- Add the following:
[Log]
Level=verbose
UnlimitedSize=Y
[Parser]
DumpRequestData=Y
SdkAccelerator=N
- 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.
Manage 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 the solutions above.
- If the report opens, your existing file is damaged. You can just recreate the report.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Fix PDF and Print problems with QuickBooks Desktopby QuickBooks•3•Updated July 02, 2024
- Use and navigate QuickBooks Statement Writer (QSW)by QuickBooks•Updated July 02, 2024
- Create and open portable company files in QuickBooks Desktopby QuickBooks•5•Updated July 03, 2024
- Mixing currencies in journal entries in QuickBooks Onlineby QuickBooks•19•Updated June 21, 2024