Integrator Accounting

Inventory Integration

FORMULATOR INVENTORY can co-exist with purchasing and sales orders in most accounting systems with an ODBC data exchange capability, receiving and maintaining inventory while communicating depletions and costs back to the accounting system. There are two main points of integration, with reconciliation at period end to account for final inventory levels and sales costs.

Loading Purchases and Sales into FORMULATOR

Sales and purchasing information is loaded into FORMULATOR via the Sales and Purchases Import module:

Information is drawn from your accounting system’s purchase and sales detail records. Imported transactions reference the receiving or shipping record keys (i.e. invoice or PO number) to prevent duplicate entries. Unit of measure mapping and G/L account information is configured via the INTEGRATOR.INI file.

Cost of goods sold information may be written back to accounting in real-time, or may be reconciled at month end, depending on your particular accounting system.

Inventory activity in FORMULATOR must be posted back to the accounting system on a regular basis. INTEGRATOR draws posted transactions from FORMULATOR, and writes them back to your accounting system.

Posted inventory transactions in FORMULATOR will be "mirrored" in the accounting system. Once sent, transactions are flagged to prevent duplicate entries.

Accounting Reconciliation

At end-of-period, the accounting workflow must reconcile between FORMULATOR and accounting inventory. Any transactions posted via FORMULATOR outside the current period must be temporarily reversed. A FORMULATOR current valuation report should be printed, or optionally, a physical inventory snapshot created to explicitly hold FORMULATOR reconciliation data.

Sales transactions loaded from the accounting system must be summarized, with the total representing the cost of goods sold for the month. Depending on your accounting system, this information may be written back in real-time, or reconciled at period end.

Physical Inventory Adjustment

Physical inventory counts are performed in the FORMULATOR Inventory module. Adjustments to inventory valuation are posted via INTEGRATOR on a demand basis.

Dedicated Accounting Integration

Formulator™, Regulator™, & Integrator™ are registered trademarks of Formulator Software LLC. All other manufacturers’ trademarks acknowledged.
CAS® is a registered trademark of the American Chemical Society. Copyright © 2009 Formulator Software LLC. All rights reserved.