Statement Converter Statement Converter Support Knowledgebase
Using the Converter
Suggested knowledgebase articles:

Knowledgebase Using the Converter

Articles in this category

Config or lookup file is not seen by the program

If Statement Converter does not see your conversion settings config file or your lookup file, here's what to do: 1. The conversion settings config files (SC_config_xyz.txt) must be in the same folder...

Menu is grayed-out/disabled/dimmed

If the program menu is dimmed (grayed-out) or disabled, there are two possibilities: A.  If you are using Excel 2013, macros are not enabled.  To enable macros, select "Convert to QB" and c...

Runtime error '13' (when converting)

If you receive a "Runtime error 13 - Type mismatch" when converting a statement, there are a couple of possible reasons. The easiest solution is to send me your statement (.csv) file and your config f...

Runtime error '13' (when editing a config file)

If you receive a "Runtime error 13 - Type mismatch" when editing a config file from within the program, it is probably because the file is set to "read only" in your operating system. Solution: Brows...

Run-time error '1004' Cannot run macro

If you receive the message, "Cannot run the macro "!Convert_XXXX_to_QB'. The macro may not be available in this workbook or all macros may be disabled," it is due to the security settings on your comp...

Run-time error '1004' in SetLookupTable

Error message:  "Error #1004 in SetLookupTable.  Excel cannot access 'Quickbooks Statement Converter'.  The document may be read-only or encrypted." Issue:  Excel cannot open the Lookup table. Reason...

Do you want to save changes?

If you close your statement after running the converter, Excel may ask you, "Do you want to save changes you made to [your statement file]?" You may select, "No". No changes were made to your state...

Error in "SaveQBFile"

When converting, if you receive "Error in SaveQBFile", 1. please exit Excel and add this setting to your config file: Save_as_format = TAB_NOLOCAL then restart Excel and try again. 2. If that does...

Error #70 in SaveTextToFile - Permission denied

If you receive "Error #70 in SaveTextToFile" after clicking "Save changes" you have made to a config file, it means that the file is open in another application (such as Word).  The solution is s...

Error #53 or Error #75 when editing/saving a config file

If you receive "Error #53, GetTextFromFile, File Not Found" or "Error #75, SaveTextToFile, Path/File access error" when editing a configuration file, it's because your config files are not in the prop...