Fishbowl QuickBooks Integration

Fishbowl QuickBooks Integration

Most of you must be familiar with QuickBooks as a means of handling accounting information. By integrating QuickBooks with Fishbowl, you can more easily manage both your inventory and your accounting, allowing for more productivity in your business. This can be the best add-on for your accounting software because it fulfills the QuickBooks services that are lacking. QuickBooks is unable to meet most company’s inventory management needs such as part tracking, barcoding, and multiple locations. Fishbowl integrated seamlessly with every desktop version of QB and QBO as well. Let's go over some of the important information that you need to know for a proper Fishbowl QuickBooks integration in this particular article.  

What is Fishbowl?

Fishbowl is an inventory management software that is the ideal software for SMBs, especially those clients who are using QuickBooks. it is a powerful assets tracking tool that helps to manage assets, products, and stocks easily and more efficiently. The entire integration between Fishbowl and QuickBooks means that they will share the same database and get permission from you to get a better and clearer picture of your company's health.

Fishbowl is a robust tool that permits you to complete your company tasks more easily and more effectively. It starts where QuickBooks leaves and provides you with a fuller range of functions that help to track items, monitor stock levels, and manage common actions like creating job orders, bills of materials, or item movement.

What is QuickBooks

QuickBooks is the most popular software for accounting and managing expenses or keeping track of daily health. In this, you can prepare invoices for customers, and pay bills, reports, and taxes. Multiple solutions are available to support a variety of business requirements, including in QuickBooks Product List: QuickBooks Online, QuickBooks Desktop, QuickBooks Payroll, QuickBooks Time, or QuickBooks Checking.

How do you prepare for Fishbowl QuickBooks Integration?

There are certain requirements that you should aware are the following:

  • .NET 4.0 or higher must be installed on your system 
  • You must have accurate information in your QuickBooks before start integrating 
  • Make sure that you review all the details and it should be correct 
  • Be sure to check inventory, customer, and vendor information 
  • Ensure values match in Fishbowl and QuickBooks that means you make sure that the values in Fishbowl and QB will match after integration 
  • Change all your inventory values in Fishbowl to zero. Then, when you import your QuickBooks inventory information, Fishbowl will update its values to match.
  • It is important to close all purchases and open sales orders in QuickBooks. You have two options for how you can transition this information to Fishbowl:
    • One option is to manually input the orders from QuickBooks into Fishbowl, and then delete the information off of QuickBooks.
    • The other option is to fulfill all the orders in QuickBooks first, and then integrate it with Fishbowl.

Steps by steps instructions to integrate QuickBooks and Fishbowl via QB Integration Wizard

Step 1: Installation of both QuickBooks and Fishbowl 

  • In this step, you have to install QB on your server PC and Fishbowl on both the server and the client PC as well to have a successful integration 
  • After done with that, you have to log onto the Fishbowl Client as an Administrator on your server PC 
  • Then log onto the QuickBooks in a single-user mode
  • Now, select the “Configure” tab >>> click the “QuickBooks Connection” button within the accounting integration module.
Step 2: Map your accounts 
  • In the next move, you’ll be recommended to map your accounts and you can see a list of all the accounts that 
    you need to map
  • Here, you have to review and decide on the accounts in QB which you want to prefer 
  • Create any new accounts that you wish in QuickBooks before you move to the next step.
Step 3: Create Users
  • In this step, you are prompted to create a user in QuickBooks and you’ll be using this while exporting Fishbowl to QuickBooks
  • Go to the Company menu and select the “Users” to create a new user 
  • After that, click “Set Up Users and Roles”
  • Make sure that the new users that you want to create have names so that you can identify which are related to Fishbowl
  • Once you decided on the first user name then you need to assign “Full Access” to that particular user
  • You can give it a password to make it more secure.
Step 4: Connect to the right database
  • Open your QuickBooks and connect it to the correct database
  • Next, you can see an option to use the file currently open in QB with the Accounting Integration Wizard for the QuickBooks File step
  • You can also use a specified file name for the QB file step
  • You have to click the “File currently opened in QuickBooks” option
Step 5: Select the Access options 
  • In this step, you can see the Fishbowl start the process of connecting to QuickBooks
  • Allow Fishbowl to access the company file if you’re prompted to allow access
  • You can choose to always allow access, or only allow access when the QuickBooks company file is open
  • Or you’ll be prompted every time to decide if you want to allow access. 
  • For more ease of use in the future, choose the option to always allow access
  • This way, you won’t need to have QuickBooks open on the same computer to export to QuickBooks.

Step 6: Set up the Default Accounts to Use

  • Go back to the Fishbowl and then select the QuickBooks file 
  • Next, choose the option to use the file currently open and then proceed further 
  • Now, you’ll be asked whether you want to use the default accounts on Fishbowl or your existing accounts on QuickBooks

Step 7: Finish the Integration process 

  • Finally, select the items from QuickBooks that you want to import into Fishbowl
  • After the import is finished, click Finish to end the integration process 
  • Fishbowl will handle inventory and purchase orders going forward, therefore you should disable those features in QuickBooks.

Features of Fishbowl integrating with QuickBooks

Some of the solutions that it offers after integration:

  • Inventory management: It has extensive inventory management tools that help you manage numerous warehouses, track parts based on several criteria, set up auto-reorder points, and produce bar codes.
  • Part tracking: On a per-location basis, Fishbowl keeps track of the number and status of each part. You can check the Fishbowl database at any time to see how many raw materials and completed commodities you have on hand.
  • Multiple locations: It can keep track of inventory in multiple locations. You can always view up-to-date inventory levels by location if you have many warehouses, stores, and/or offices.
  • Order management: You can create all of your purchase orders, sales orders, pick tickets, and other important papers. It uses auto-reorder points, in-depth reports, and improved warehouse management and picking processes to make order administration considerably easier.
  • Shipping: Whether it's acquiring inventory, transferring commodities between warehouses, or sending finished goods to clients, shipping is a vital function of any organization. Fishbowl integrates with many shipping options to ensure that your orders arrive at the correct locations and at the appropriate times.
  • Reporting: You can create reports to graph sales and inventory data and anticipate future inventory requirements.
  • Multi-Currency: This enables you to make and receive sales and purchase orders in any currency, then convert them back to your native currency for correct accounting and tax records, and more. 

What Happens After I Integrate Fishbowl and QuickBooks?

After completing the integration of QuickBooks with Fishbowl, then Fishbowl will start managing all of the inventory.

that means you should turn off all purchase orders and inventory in QuickBooks after completing your integration. Because the Fishbowl will create all your sales orders and purchase orders. Also, Fishbowl will send invoices and bills to QuickBooks when orders are fulfilled and exports are completed.

Bill payment will still control QuickBooks. when Fishbowl accepts payment through merchant services, it will send a sales receipt to QuickBooks.

Fishbowl will also adjust the cycle count account, the sales order account, and the purchase order account, among others.

Winding Up!

With the Fishbowl QuickBooks Integration, you can save many hours of work and ensure your records are accurate- which is an excellent benefit of integration. Moreover, Fishbowl has access to all important data that allows it to keep up with every new QuickBooks version.

Call Now+1-800-961-4963