QuickBooks Export Utility Setup Guide

You can export your data to QuickBooks by running our Java application now. It’s for Windows only. Intuit hasn’t provided Mac QBFC yet.

Preliminary Requirements

1. You must install QBFC. You only need to do this once when running the app for the first time on your machine. Click here to download and install QBFC. After QBFC installation is complete, you may be shown a “Getting Started with QuickBooks FC” window, in addition to other related windows. Please disregard and close all these additional windows.
2. If you have a JAVA 64 bit JRE version installed, please uninstall it. QBFC requires 32 bit JRE version 7 update 51 or later. Click here to download the JRE installer.

Running Exporting Program

1. Setup QuickBooks company file
   1. Although you can export your data to an existing company file, we strongly recommend that you export the data to a newly created one. If you really want to do it with the existing one, back it up first.Open QB, and create a new company file with the Express Start option. Ensure NOT to close the company file during the export process.
2. Running program
   1. In your windows computer, click on Start button.
   2. Search for Configure Java and open it. You will see a Dialog Box.
   3. Goto Security (tab) -> Click on Edit Site List -> Add Button -> Add the following URL.
      1. https://trexglobal-assets-live.s3.amazonaws.com
   4. 
   5. Disable Algorithms
      1. Open Notepad as Administrator
      2. Click on File -> Open. Navigate to C: Drive -> Program Files (x86) > Java > jrex.x.x_xxx > lib > security
      3. From the Dropdown in the bottom right corner above Open button. Select All Files
      4. Select file java.security
      5. In the opened file. Search for jdk.jar.disabledAlgorithms (You will find 2 occurrences, the second one is )
      6. Add # at the beginning of the line if it does not exist. Also any subsequent line which after a \ at the end. Example
         1. # jdk.jar.disabledAlgorithms=MD2, MD5, RSA keySize < 1024, \
            #        DSA keySize < 1024, SHA1 denyAfter 2019-01-01 \
            #        SHA1….
      7. Save and Close the file.
   6. Download and Run the application.
   7. Download the SimplifyEm QuickBook Sync Application from here
   8. Go to where the file is downloaded and Extract the zip file by Right Clicking and Selecting Extract All.
   9. Goto the Folder and Double Click on DataSync.jnlp. Keep all of these files on your machine so you don’t have to download them again next time when launching the application.
   10. You will get a security warning dialog on Windows Vista and Windows 7. Select the check box at the bottom and click “Run” to continue.
3. Exporting Data
   1. Enter your SimplifyEm account email and password. Follow the steps in the main UI to have your data exported to the company file:
   2. Click Browse to select the QB company file where data will be exported (the newly created one is highly recommended).
   3. Select the way to record income.
   4. At the very least, set the earliest date for which to export data to QuickBooks. It’s optional. You can leave it empty, which means you want to export all of your data to the company file. It may take many minutes.
   5. Click Export, then click OK in the confirmation popup to start the data transfer. Or click Cancel in the confirmation popup to cancel.
      Then you will get the QB application certificate dialog. You may check either the 3rd or 4th radio button to grant the application access to the company file.
   6. Click Continue and you will get the access confirmation dialog. Click Done to start the data exporting process.
   7. You will get the Finishing Exporting dialog when data exporting finishes:

 

Now you’re done with the data exporting process. Congratulations!