Home

Accounting Interface - QuickBooks


QuickBooks supports importing both Accounts Receivable transactions and Accounts Payable transactions, so the "Destinations" on the System Parameters Accounting tab of the eCotton Gin System can be set as you wish. However, a single producer ID cannot exist as a customer and a vendor in QuickBooks at the same time. For this reason, if you want to send both gin statement and producer settlement invoice entries to accounting from the eCotton Gin System, we recommend that they both be set to send to the AP module, and that your producers be set up as vendors.
Since QuickBooks does not use Customer IDs or Vendor IDs, the "Customer Names" and/or "Vendor Names" in QuickBooks must match the Producer IDs and Buyer IDs in the Gin System, or the Shipper IDs in the Warehouse System.
Since QuickBooks does not support the "token" concept for general ledger accounts, the "Account Name" in QuickBooks must match the "Token Description" (not the Line Description) for a given token in the Gin and/or Warehouse Systems. The "Token Description" is accessible from the lookup window (question mark key) when entering a token.
The Accounting Interface generates ".IIF" files for QuickBooks. These can be imported into QuickBooks by going (in QuickBooks) to File | Utilities | Import | Import IIF Files.
The file layout is part of the data file, so there is no need to set up an import layout in QuickBooks.
QuickBooks requires that the "A/R Trade" account token (and the "A/P Trade" account token in Gin) be entered in System Parameters.


 

© 2021 EWR, Inc. All rights reserved.