The QuickBooks Link allows for the seamless exchange of data between Catalyst Manufacturing® and QuickBooks®. The interface allows for enhanced synchronization of your manufacturing and financial data through the import of customers, vendors, items, sales orders, chart of accounts, payment terms, and other list data and the export of customers, vendors, customer invoices, credit memos, PO receipts and vendor bills to QuickBooks. The records can either be updated automatically when changes are saved in Catalyst or in batch mode by exporting records at the end of a day or shift.
The interface supports the export of inventory items from Catalyst to QuickBooks as a mass update or one at a time. If an item does not already exist in QuickBooks when a customer invoice or vendor bill is exported, the item is added to QuickBooks at that time. Catalyst serves as the inventory system of record between the two systems for raw material, intermediate-level/WIP, sub-assemblies, and finished product inventory; however, the inventory balances and values can be exported to QuickBooks with the click of a button. This allows QuickBooks to reflect the current quantity and value of the different inventory asset accounts at any given time making it easier to report and review financials at the end of a period or any time in between.
QuickBooks Link //
FUNCTIONALITY
After the initial import of chart of accounts, sales tax codes, payment terms, customers, vendors, and items from QuickBooks, the standard order fulfillment process occurs as follows:
-
Create a customer order in Catalyst or import sales orders from QuickBooks. During the order creation process, a shop order may be linked to order lines for make-to-order items.
-
Review material and capacity availability, order raw materials, schedule production of sub-assemblies and perform other activities to support production as required.
-
Release shop order to production to build finished product. After reporting completion of final product, the end item is placed in inventory for shipping.
-
Prepare shipping documents and enter shipment confirmation to relieve inventory. If QuickBooks is open, the customer invoice is created in QuickBooks during shipment confirmation. Otherwise, invoices are exported to QuickBooks in batch mode at the end of the day or shift.
-
QuickBooks is used to receive payments against the invoice and generate financial and accounting journal entries and reports of the business activity.
-
For raw materials, receipts are entered in Catalyst and exported to QuickBooks to update liabilities and inventory. When the vendor invoice is received, it’s posted in Catalyst and exported to QuickBooks as a vendor bill. Alternatively, the bill can be entered directly in QuickBooks. In either case, any item receipts are applied when entering the vendor invoice. The vendor bill is then used as the basis for processing vendor payments and updating the relevant expense and liability accounts.
