Overview

If the company has a QuickBooks integration active, the user will have the option to synchronize Vendor invoices with QuickBooks.

Instructions:

To be able to synchronize vendor invoices with the external accounting system follow the instructions below:

1. The vendor must confirm and ship the purchase order, and upload their invoice to Komet following the instructions provided in Upload invoices to Komet.

2. The Accounting and Procurement users must approve the invoice by following the Workflow to Approve Vendor Invoices instructions.

3. Once approved, go to Accounts Payable (A/P) > PO Reconciliation > click on the Actions button and select the option "Send to External System". At this point, the Vendor Invoice Status will be changed to "Sent to External System". This process takes a second unless the invoice is unable to be synchronized.

   

4. Following this, the system will synchronize the data from Komet with the external system, and once done the Vendor Invoice Status column will change to "S" (Synchronized). 

   
   

   
   

5. Finally, the invoice will be synchronized with the External System and the user will be able to process payments for that invoice within the external system.

Companies using QuickBooks:

The following items must be taken into account when using the QuickBooks Integration with Komet:

• The vendor account within Komet should have the same QB Accounting name as the one assigned in QuickBooks. 
• The Purchase Order in Komet will be transferred as a "Bill" in QB.
• The Bills Reference Number in QB will be composed by the purchase order number and the vendor invoice number assigned in Komet. 
• The Bills Date in QB will be the same as the Ship Date in Komet.
• By the default, the product description in QB will always be "Fresh Cut Flowers", but there is also the option to use the product description already created within QB.
  
• The Bills totals in QB will be the same as the Komet PO total. 
• The PO must be associated to a vendor with an Accounting Name.
• The PO must have an invoice number which is the one the vendor uploads from the Grower Portal.
  

QuickBooks Setup:

Generating the komet_sales.qwc File:

In order to setup QuickBooks, follow the steps below:

1. Contact Komet Sales to activate this option.
2. Once the option has been activated, Komet will notify you, so you can proceed with the integration.

3. Next go to "Setup" > "Settings" > "Integrations" > "QuickBooks"

4. A pop-up window called "QuickBooks" will appear. 

   

    

5. Click on the "Download" link to download a file called komet_sales.qwc. This file is for users to configure the integration between Komet Sales and QuickBooks. The user should then add the file in QuickBooks. 

Adding the komet_sales.qwc File into QuickBooks:

Log on to your QuickBooks account to continue with the integration and follow the instructions below:

1. Click on File> Update web services.
   
   
   
   
2. A new window will pop-up, click on the "Add an application" button.
   
   
   
   
3. A window to select the file needed will pop up. Look for the "komet_sales.qwc" file.
   
   
   
   
4. The Authorize New Web Service window will pop-up showing the file information. Click on the "Ok" button.
   
   
   
   
5. The system will prompt you to specify the permissions that should be given. Please choose the "Yes, whenever this QuickBooks company file is open" option and click on Continue. Another window called Access Confirmation will appear; you should click on Done.
   
   
   
   
   
   
   
6. Find the Komet Sales application within QuickBooks in order to add the password (token integration) provided by Komet Sales, this is mandatory.
   
   
   
   
7. To complete the activation, check the box on the left side of the Komet Sales option in the "Application" column, followed by clicking on "Update Selected" button.