logo

customer balances

How to Export Customer Balances from Quickbooks into SMARTSystem

Normally, payments are manually posted against customer invoices and afterwards the customer balances are exported from Quick Books and Imported to SMARTSystem.

The sequence of events for daily exporting Quick Books Customer Balances that will be imported into the SMARTSystem is:

1.  After payments are posted to your customer accounts.

2.  Keep Quick Books open and minimized.

3.  Double click on the Quick Books Import icon:

4.  The following screen will be displayed:

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

         

6.  When completed close the QB Import Tool.

7.  Open SMARTSystem, File, Import and Import Customer Balances.

8.  The following screen will be displayed:

9.  Click “Browse” to select the folder for Import:

C:\WFSData\ImportFiles

          Click on “customerbalances.txt” to select.

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

11.  When completed close this “Import Customer Balances” screen.