Manufacturing Software and Integration to QuickBooks-isn’t it time you operate your business like a professional?

Are you struggling with trying to see your true costs for your job or project?  Are you guessing at the sales price to your customer?  Why not begin operating your business like a true professional and put some software in place to get you visibility of your company costs.

QuickBooks is not always ideal for manufacturing. It doesn’t have a means of automatically allocating expenses to multiple departments, allocating overheads, etc. It doesn’t have a means of easily recording costs of materials purchases when freight and other costs are billed separately.

Understanding how a good ERP Software would integrate with QuickBooks is essential to you understanding how the data flows and what decisions you will need to make when looking at a software solution.





The integration is really simple. There are three areas that usually integrate into QuickBooks from your manufacturing software.

  1. The customers you have in QuickBooks will need to be setup or imported into your ERP system. They need to be the same on both sides in order for you to post cash received. A good ERP system will do your quote, sales order, invoice, and shipment and then send the invoice data to QuickBooks. The cash posting takes place on the QuickBooks side.
  2. Your suppliers needed in the ERP system will also need to be the same as your QuickBooks suppliers. The good ERP system should create a requirement for procurement whether it be the item in inventory which is below the threshold, the description only or non stock items, or even the requirement for an outside processes. Once the receipt of the item is posted in the ERP system, it should send the receiver and bill over to QuickBooks after the bill is matched and entered. The checks are still done in QuickBooks
  3. The inventory you carry in QuickBooks will also be carried in the ERP system. Most ERP systems will allow you to select whether you want inventory to post from the ERP System to QuickBooks and be carried on both sides, or you can select to just keep inventory on the ERP side. Keep in mind timing at the end of your month. Things need to be done in order if you are automating the inventory into QuickBooks.
  4. Other requirements may also be considered. Fiscal periods will need to be the same. Your units of measure, classes of products, etc

It is important you have a consultant to guide you through the process of implementation. Setting up an ERP system correctly is costly, but bad implementations can cost you more. Think about moving to a professional level in your business as it will save you money and allow you to grow your business to a whole new level.

Visual Jobshop

Business Logic Solutions endorses VISUAL Jobshop software by Infor. For a free demo contact us today.

About Susan Faulkner

Expertise in ERP Manufacturing and Quality Software. Provides business software consulting for VISUAL Jobshop, Unipoint Quality Software and QuickBooks. Implementation, training, and process improvements for manufacturing environment.. Includes bar code setup and integration. Crystal report writing and distribution partner with Infosol Re port Scheduler. Many years of experience in IT, accounting, and manufacturing, makes me the perfect fit to see the total picture. Organized data is extremely important to your bottom line. Without the right visibility of your business you are flying blind. Let me show you how to automate your processes and save you money. Specialties: Quickbook ProAdvisor, VISUAL Jobshop, Crystal Reports and distribution/bursting. Specialties in process improvements for manufacturing processes.

Leave a comment

Your email address will not be published. Required fields are marked *