logo

customer balance

Exporting Data from SMARTSystem to QuickBooks and back to SMARTSystem using the IMPORT TOOL

SMARTSystem- Exporting Data to QuickBooks or your Accounting System

How to Export Data to QuickBooks from SMARTSystem

  1. Check if the days Sales Orders have been Invoiced. Go to End of Day> Invoice Print Verification

  1. If the popup says “All of the orders for delivery on (your date) have been invoiced.” You can continue with export to QuickBooks. If you receive a list of Invoices, those need to be processed before continuing:
    1. By clicking each sales order listed one at a time to display the sales order
    2. Invoice the sales order or change the delivery date

  1. Pick the Date Range Start >End Date. Then click the “Export Daily Activities to Quick Books” Button.

Note: leave the Start Date set to capture any back dated transactions. Usually, the End Date will be the last full day of operations.

  1. Items will save to your file and become available for import into Quick Books or your Accounting System:

  2. The Report: Invoice Register by Delivery Date will list all invoices and credits transferred for import to Quick Books or your Accounting System.

    ** Create a Backup of your QuickBooks company file at this time.

  3. Using the Quick Books Import Tool:
    1. You must have Quick Books open
    2. Switch to Single User Mode to prevent an import error by having another user access QB data until the Import process completes.

  4. Click Quick Books Import Tool icon

  5. Go to QuickBooks Import Tool:

  6. You need to Define Accounts first before first use to start Export process. Your Accounts will likely look different from the below example:

    Alternate Settings in Import 7.0:

    How to setup inventory in Quick Books as Non-Inventory Parts:

    Click “Define Accounts” then check “Create New Inventory Items as Non-Inventory Parts” Click Save.

  7. Click the Browse button to Navigate to the file you want to import. Choose the most recent file in C:\WFSData\ExportFiles (Be sure that the file you are importing says “COMPLETE” and there is more than 1KB of data):

    Click Open.

  8. Your source file will appear in the Browse box.

    Click the Import Data to QuickBooks button.

  9. If the import was successful, you will receive a popup with the number of records successfully uploaded:

  10. Process Complete
  11. Export Customer Balances

  12. When the process is complete you will see this pop-up:

  1. Print Import Log

  1. The Today’s Invoice Register report is automatically created. It is strongly suggested that you print it as a record of what will be exported to QuickBooks after the QuickBooks Import Utility is run. Files are created at this location on your computer: , as shown below. When you run this again, the old files will move to the Backups folder and the new ones will display in place of the old ones.

  2. If you need to check what was in the “QB COMPLETE” file you can go to the file in C:\WFSData\ExportFiles and right click file and choose OPEN with>Notepad. You can File >Save As >Documents file if needed.

Do not delete the Backup files this may be your only source of past information from the EOD. They cannot be replaced. Although there are additional backup measures in place deleting files is not recommended. If you have a question, please call support 727-483-5306.

Import Back into SMARTSystem

If you have not done so from the earlier steps above:

Click on the “Export Customer Balances” and the export from Quick Books will begin:

         

When completed close the QB Import Tool.

Open SMARTSystem, File menu >Import Customer Balances.

 

The following screen will be displayed:

Click “Browse” to select the folder for Import:

C:\WFSData\ImportFiles

          Click on “customerbalances.txt” to select.

 

Click on “Import Customer Balances” and your customer balances will be updated in the SMARTSystem:

When completed close the “Import Customer Balances” screen.

This completes the entire End-of-Day cycle from beginning to end.