website logo
How to Install Statement Converter

In summary:

  1. Download the program file to your computer
  2. Add the program to Excel

This one-time procedure may be repeated if you ever need to re-install the program.

What You’ll Receive

When your order is received, I’ll prepare your converter and email the files to you. You’ll receive:

  • The program: StatementConverter.xla
  • Matching rules: Vendor_list_sample.xls

You’ll also receive the following files, but you may ignore them; they are provided only for consistency with the installation video:

SC_config_System.txt SC_config_XYZBank_sample.txt

Step 1: Save the .XLA file to your computer

Download StatementConverter.xla from your email and save it in Excel’s Add-in folder:

  • Excel 365: C:\Program Files (x86)\Microsoft Office\Root\Office16\XLSTART
  • Excel 2016: C:\Program Files (x86)\Microsoft Office\Root\Office16\Library
  • Excel 2013: C:\Program Files\Microsoft Office\Office15\Library
  • Excel 2010: C:\Program Files\Microsoft Office\Office14\Library
  • Excel 2007: C:\Program Files\Microsoft Office\Office12\Library
  • Earlier versions of Excel: any folder (suggestion: create a folder named Statement Converter)

Using Excel for Mac? Excel macros cannot handle long folder names. When naming folders for Statement Converter, use 25 characters or less. For example, use "Statement Converter" instead of "QuickBooks Statement Converter Program".

Installing on a network server?

Your network folders might need to be "Trusted Locations."

In Excel Options > Trust Center checkmark Allow Trusted Locations, as shown:

Allow trusted locations
(Screenshot from Excel 2007)

Step 2: Add the Converter to Excel
  1. Start Microsoft Excel
  2. If Excel started with an open workbook, go to the next step.
    If not, open a new, blank workbook: FILE > NEW... > Blank workbook. This workbook is not used except to enable the next step.

3. Continue with...

  1. Click the FILE tab

  2. Select OPTIONS at the bottom

  3. Click Add-ins. In the "Manage" box, select Excel Add-ins then Go...

  4. Browse... to the folder where you saved the StatementConverter.xla program.

    Excel Add-ins menu

  5. Click StatementConverter.xla to select it, then OK

    Navigate to the .XLA file

  6. Select the ADD-INS tab. You should see Convert to QB in the menu:

    Convert to QB

  7. The program is installed. Go to What to do next
  1. Click the FILE tab

  2. Select OPTIONS at the bottom

  3. Click Add-ins. In the "Manage" box, select Excel Add-ins then Go...

  4. Browse... to the folder where you saved the StatementConverter.xla program.

    Excel Add-ins menu

  5. Click StatementConverter.xla to select it, then OK

    Navigate to the .XLA file

  6. Select the ADD-INS tab. You should Convert to QB in the menu:

    Convert to QB

  7. The program is installed. Go to What to do next
  1. Click the Microsoft Office button (logo)

    Office button

  2. Click Excel Options

    Office menu

  3. Click Add-Ins. In the "Manage" box, click Excel Add-ins then Go...

    Excel options

  4. Browse... to the folder where you saved the StatementConverter.xla program.

    Excel Add-ins menu

  5. Click StatementConverter.xla to select it, then OK

    Navigate to the .XLA file

  6. Select Add-ins from the Excel menu

    Add-Ins menu

    and you should see Convert to QB in the menu:

    Convert to QB

  7. The program is installed. Go to What to do next
  1. On the Tools menu, click Add-Ins

    Excel Tools menu

  2. Click Select... and browse to the folder where you saved the StatementConverter.xla program.

    Excel Add-ins menu

    Note: No other add-ins are needed in order to use Statement Converter. Any other add-ins that might appear in your list above are unrelated to Statement Converter.

  3. Click StatementConverter.xla to select it, then Open

    Navigate to the .XLA file

  4. "Statement Converter" should show in the list of Add-ins. Click OK

    Add-in installed

    Note: No other add-ins are needed to use Statement Converter. Other add-ins that might show in your list above are unrelated to Statement Converter.

  5. You should see Convert to QB in the menu:

    XL2011 Convert to QB

  6. The program is installed. Go to What to do next
  1. Click File in the top menu bar, then Options in the left panel.

    File Options

  2. Click Add-Ins. In the "Manage" box, click Excel Add-ins then Go...

    Add-ins Menu

  3. Browse... to the folder where you saved the StatementConverter.xla program.

    Excel Add-ins menu

  4. Click StatementConverter.xla to select it, then OK

    Navigate to the .XLA file

  5. Select Add-ins from the Excel menu.

    Add-Ins menu

    You should see Convert to QB in the menu:

    Convert to QB

  6. The program is installed. Go to What to do next
  1. Click the Microsoft Office button (logo)

    XL2007 Office button

  2. Click Excel Options

    XL2007 Office menu

  3. Click Add-Ins. In the "Manage" box, select Excel Add-ins then Go...

    XL2007 Excel options

  4. Browse... to the folder where you saved the StatementConverter.xla program.

    Excel Add-ins menu

    Note: No other add-ins are needed to use Statement Converter. Other add-ins which might show in your list above are unrelated to Statement Converter.

  5. Click StatementConverter.xla to select it, then OK

    Navigate to the .XLA file

  6. Select Add-ins from the Excel menu

    Add-Ins menu

    You should see Convert to QB in the menu:

    Convert to QB

  7. The program is installed. Go to What to do next
  1. On the Tools menu, click Add-Ins

  2. Browse... to the folder where you saved the StatementConverter.xla program.

    Excel Add-ins menu

    Note: No other add-ins are needed in order to use Statement Converter. Other add-ins shown in the list above are unrelated to Statement Converter.

  3. Click StatementConverter.xla to select it, then OK

    Navigate to the .XLA file

  4. "Statement Converter" should be displayed in the list of Add-ins. Click OK

    Add-in installed

    Note: No other add-ins are needed in order to use Statement Converter. Other add-ins shown in the list above are unrelated to Statement Converter.

  5. You should see Convert to QB in the menu:

    XL2003 Convert to QB

  6. The program is installed. Go to What to do next

What to do next

You’re done with installation. Next, enter a few settings about your QuickBooks: