From Fishbowl Inventory

[edit] General Information about QuickBooks and Fishbowl Integration

Before Integrating QuickBooks and Fishbowl many customers have general questions or concerns about the process. Below is an overview of what is expected so you may successfully link the two softwares together.

Start with an Accurate QuickBooks

• Before you begin the QB integration take some time to check the accuracy of your information. Errors in QuickBooks will transfer over to Fishbowl Inventory unless they are corrected first. Check customer information, vendor information and inventory, and mark as Inactive anything you do not want to transfer into Fishbowl. This also may be a good time to count your inventory, thus providing the most accurate information as possible as you begin using this new program.
  

Fishbowl manages the Inventory

• One of the first things to understand is that Fishbowl will now be the manager of your inventory. Therefore, when you are ready to integrate the two softwares together you will want to turn off your Inventory and Purchase Orders in QuickBooks.

Purchase Orders and Sales Orders are now created in Fishbowl

• Fishbowl is now where Purchase Orders and Sales Orders will be created. When these are fulfilled in Fishbowl and an export is completed, Fishbowl will send over an Invoice and/or Bill to QuickBooks. Paying your bills is still handled in QuickBooks unless you are using Merchant Services in Fishbowl. If you are making payments in full in Fishbowl via Merchant Services then a paid invoice is what will be sent over to QuickBooks.

When Exporting to QuickBooks, Certain Accounts will be Adjusted

• When exporting to QuickBooks for the reasons below the following accounts will be adjusted in QuickBooks:
  

Cycle Count: Inventory Asset, Inventory Adjustment (this adjusment account will depend on where your accounts were mapped to during the Accounting Configuration Wizard).

Purchase Order: Inventory Asset Account, Payables

Sales Order: Inventory Asset, COGS, Income, Receivables

Keep your QuickBooks and Fishbowl Inventory Value matching

• Before integrating you will also want your Inventory Asset Account to match Fishbowl's Inventory Valuation Summary. If your QuickBooks inventory is correct, you will want to import your inventory information from QuickBooks into Fishbowl. In order to do this and have your inventory values matching in both QuickBooks and Fishbowl, your Fishbowl inventory values will need to be zero (which will then be updated by the import from QuickBooks). If your QuickBooks inventory is not correct and you would like to start fresh in Fishbowl with your inventory value, then you will want to make sure you do not import over the inventory from QuickBooks during your initial Accounting Configuration integration. This way QuickBooks inventory will not interfere with Fishbowl. In this circumstance you would need to realize that your Fishbowl inventory value is correct, but it will not match your QuickBooks value because the two softwares did not hold the same values to begin with. 
  

Close Open Sales Orders or Purchase Orders in QuickBooks

• Due to the fact that Fishbowl is now in charge of Sales Orders and Purchase Orders, you will want to either wait to integrate with Fishbowl until all of your open orders are fulfilled in QuickBooks, or you will want to delete the orders in QuickBooks and manually create the orders in Fishbowl. If you create the orders in Fishbowl but do not close them out of QuickBooks, those invoices will export to QuickBooks as a duplicate. At this time Fishbowl does not import any orders from QuickBooks during the Accounting Configuration Wizard. If you have a large amount of orders that would need to be created in Fishbowl, you may import them in using the Sales Order or Purchase Order Imports.

Return to Support