View source for QuickBooks

The information listed below is specific to QuickBooks. General accounting information is available in the {{Module|Accounting Integration}}. For a list of supported QuickBooks versions, see [[System_Requirements#Supported QuickBooks versions|Supported QuickBooks versions]].

==FAQs==

*'''What should I know before integrating QuickBooks and Fishbowl?'''
:'''Start with an Accurate QuickBooks File''' - Before you begin the QuickBooks integration, take some time to check the accuracy of your information. Errors in QuickBooks will transfer over to Fishbowl 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 possible as you begin using this new program.
:'''Keep Your Inventory Value in QuickBooks and Fishbowl 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 inventory values in Fishbowl 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 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 inventory value in Fishbowl is correct, but it will not match your QuickBooks value because the two applications 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 integration. If you have a large amount of orders that would need to be created in Fishbowl, you may import them using the Sales Order or Purchase Order Imports.
*'''When integrated with QuickBooks, is my inventory tracked in Fishbowl or QuickBooks?'''
: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 applications together, you will want to turn off your Inventory and Purchase Orders in QuickBooks.
*'''Does Fishbowl support the QuickBooks Enhanced Inventory Receiving (EIR) feature?'''
:No. For more information about QuickBooks Enhanced Inventory Receiving, click [https://fishbowlhelp.com/files/QuickBooks%20EIR.pdf here].
*'''Where do I create Purchase Orders and Sales Orders?'''
: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. If you are taking payments in full in Fishbowl via Merchant Services, then a sales receipt is what will be sent over to QuickBooks.
*'''What are some examples of accounts that Fishbowl will adjust?'''
:'''Cycle Count:''' Inventory Asset, Inventory Adjustment (this adjustment account will depend on where your accounts were mapped to during integration)
:'''Purchase Order''': Inventory Asset Account, Payables
:'''Sales Order''': Inventory Asset, COGS, Income, Receivables

==Required QuickBooks accounts==

Fishbowl exports data to several QuickBooks accounts. These accounts can be added manually in QuickBooks, or automatically when going through the [[#Integration|Integration]]. The '''Select Accounts''' step of the wizard offers the following two choices:
* '''Use Fishbowl created accounts''' will automatically create and map the accounts below.
* '''Choose from existing QuickBooks accounts''' will allow existing QuickBooks accounts to be mapped to Fishbowl as necessary.

{| class="prettytable"
|-
! width="200" | Fishbowl Account Name
! width="200" | QuickBooks Account Type
! Description
|-
| Accounts Receivable
| Accounts Receivable
| The record of money owed to a business, that is, invoices for which a business has not received payment.
|-
| Accounts Payable
| Accounts Payable
| The record of the outstanding bills of a business.
|-
| Undeposited Funds
| Other Current Asset
| Payments made in Fishbowl that are waiting to be deposited in the bank.
|-
| Capital Equipment
| Fixed Asset
| All items associated with Capital Equipment part types will be tracked in this account.
|-
| Internal Use
| Expense
| All items associated with internal-use part types will be tracked in this account.
|-
| Non-Inventory
| Expense
| All items associated with Non-Inventory part types will be tracked in this account.
|-
| Service
| Expense
| All items associated with Service part types will be tracked in this account.
|-
| Labor
| Expense
| Tracks labor costs.
|-
| Overhead
| Expense
| Tracks overhead costs.
|-
| Sales Retail
| Income
| Tracks the income from the resale of inventory items.
|-
| Discount Expense
| Expense
| Tracks the expenses associated with discounts applied to sale type items.
|-
| Discount Income
| Income
| Tracks the amounts associated with discounts charged to customers (e.g., for returns or restocking fees).
|-
| Miscellaneous
| Expense
| Expenses that come from a Misc. type part.
|-
| Shipping Income
| Income
| Keeps track of customer charges for shipping.
|-
| Shipping Expense
| Expense
| Keeps track of vendor charges for shipping to your company.
|-
| Shipping Accrual
| Other Current Liability
| The account used to track a sum of your shipping expenses owed instead of showing them in Accounts Payable. QuickBooks account should be a current liability type.
|-
| Inventory Asset
| Other Current Asset
| Tracks the current value of your inventory.
|-
| Cost of Goods Sold
| Cost of Goods Sold
| The cost of goods and materials held in inventory and then sold. On a profit and loss report, QuickBooks subtracts the total cost of goods sold from your total income to provide a gross profit before expenses.
|-
| Scrapped Inventory
| Expense
| This account is used when inventory is scrapped (e.g., adjustments go down due to damage, theft, spoilage, etc.).
|-
| Inventory Adjustment
| Cost of Goods Sold
| This account is used to track cycle-count adjustments to inventory.
|-
| Cost Variance
| Cost of Goods Sold
| This account is adjusted only when using the Standard costing method. It will give you the difference of what your actual cost was compared to the current standard cost. Even if you are not using Standard costing, an account still needs to be applied to this section of the mapping.
|}

==Integration==

The '''QuickBooks Integration Wizard''' integrates '''QuickBooks''' and '''Fishbowl''' together.
* To integrate Fishbowl with QuickBooks on a separate computer, see [[#QuickBooks_on_another_computer|QuickBooks on another computer]].
* For details about using Fishbowl on Linux and integrating with QuickBooks, see [[Fishbowl_for_Linux#Integrate_with_QuickBooks|Linux - Integrate with QuickBooks]].
* For details about using Fishbowl on a Mac and integrating with QuickBooks, see [[Fishbowl_for_Mac#Integrate_with_QuickBooks|Mac - Integrate with QuickBooks]].

The wizard guides you through selecting accounts and importing data from QuickBooks into Fishbowl. The following steps will help with a successful integration:

# You will need to have QuickBooks installed on the server computer, as well as a complete install of Fishbowl (server and client).
# Log into your Fishbowl Client on the server computer as admin (or as a user with sufficient rights). Log into QuickBooks in single-user mode as admin.
# In Fishbowl, open the {{Module|Accounting Integration}}. Click the '''Configure''' tab and then click the '''QuickBooks Connection''' button.<br>[[File:Accounting_Config_subtab.png]]
# The first screen of this wizard will show a set of instructions that will be helpful during the integration. Within these set of instructions is a list of the accounts that will need to be mapped for the integration, as well as some recommendations for mapping of the accounts. We encourage taking a moment here to view the accounts and review which QuickBooks accounts you wish to reference from QuickBooks. If you wish to create new accounts in QuickBooks, now would be the time to do so. Click '''Next.'''
# Step two of the integration requests for a user to be created in QuickBooks. Fishbowl utilizes this user when it exports to QuickBooks. To add a user in QuickBooks, go to the '''Company''' menu and select '''Users'''. Then select '''Set Up Users and Roles'''. Create a new user that is easily recognizable, like "Fishbowl." This user needs to have the role "Full Access" assigned to them. You can add a password if you would like. Once this has been completed, click '''Next.'''
# Step three requests for your QuickBooks company file to be opened. Assuming your QuickBooks is currently open and connected to the correct database, select the option to '''use the file currently opened in QuickBooks'''. If your QuickBooks file is not open, click the '''Browse''' option and find your company file. Click '''Next.'''<br>[[File:QuickBooks Integ 1.png]]
# Integrating with QuickBooks requires .NET 4.0 or later, which is included on most computers or can be installed by running Windows Update.
# Fishbowl will now attempt to connect to QuickBooks. If this is your first time connecting to QuickBooks, a dialog box will be displayed in QuickBooks, which asks when to allow Fishbowl access to the company file. We recommend choosing "Yes, always; allow access even if QuickBooks is not running" (this option allows you to export to QuickBooks without requiring QuickBooks to be open on the same computer). Then select the previously created user as the user to log in as. Once you click '''Continue''', a dialog will come up asking if you want to grant access to Fishbowl. Select '''Yes'''.<br>[[File:QuickBooks Approval With User.png]]
# Back in Fishbowl, you will now choose again your QuickBooks file. Select the option that states "use the file currently open in QuickBooks," or browse to find your company file. Click '''Next.'''
# The next step will ask you to specify if you will be using Fishbowl default accounts or if you would like to choose from existing QuickBooks accounts. Using the Fishbowl default accounts will create a default set of 21 accounts in QuickBooks (the default will be what is listed in the instruction sheet in step 4). If you choose from existing QuickBooks accounts, then you will be asked to select the default account for each type. We recommend the assistance of a certified accountant while mapping your QuickBooks accounts. Whether you choose Fishbowl default accounts or existing QuickBooks accounts, click '''Next''' when you are finished with your mapping. '''Note: Changes to the default accounts can be made at a later time. Also, each product and part can be mapped to [[Part#Accounts_tab|specific accounts]]. The accounts selected in this wizard will be used if the Default account is selected on the [[Part#Accounts_tab|part]] or [[Product#Details_tab|product]].'''<br>{{anchor|Accounts}}[[File:Select accounts accounting config wizard.png]]
# The last screen allows data to be imported from QuickBooks into Fishbowl. Select the items that should be imported, and then click '''Next''' to import in the data. After the import is complete, click '''Finish'''.<br>[[File:Accounting_integration_import_items.png]]
#* '''Currencies''' will only be displayed if currency conversion is enabled in the {{ModuleOptions|Currency}}. Currencies can also be imported using the '''Update''' button in the {{Module|Currency|Module buttons}}, or by creating a [[Schedule#Create_Scheduled_Task|scheduled task]].
# Now that Fishbowl will handle your Inventory and Purchase Orders, we recommend you turn off these features in QuickBooks. You may do this in QuickBooks by selecting '''Edit | Preferences''' and selecting '''Items &amp; Inventory''' on the left side of the dialog. Select the '''Company Preferences''' tab and make sure that '''Inventory and purchase orders are active''' is unchecked. Then press '''OK''' to have it accept your changes.

* '''Note:''' In order to change company preferences in QuickBooks, you have to log into the company file (with administrative rights) in Single-User mode. If you are unable to change Company Preferences, go to File | Switch to Single-User Mode. You can change it back to Multi-User Mode after you have modified the Company Preferences.

To disconnect from QuickBooks, click the {{Button|Delete|Disconnect}} on the module toolbar.

==Import==

Users may import data from QuickBooks when they initially complete the integration. If, however, you wish to import data at a later time, it may be done on the '''General''' tab. Simply check all of the data options you wish to import into Fishbowl from QuickBooks. A connection to QuickBooks must already be established before this feature will work. Use caution when importing from QuickBooks as duplicate entries could possibly appear if the data has already been imported.

[[File:Accounting_General_subtab.png|right]] The following information may be imported from QuickBooks into Fishbowl:
* [[Company]] Information - Includes [[Carrier|Shipping Methods]], [[Payment Terms]], and [[User|Sales Reps]].
* [[Vendor|Vendors]]
* [[Customer|Customers]]
** Include [[Customer#Create a new customer|Customer Jobs]]
* [[Class|Classes]]
* [[Part#Accounts_tab|Accounts]]
* [[Currency|Currencies]] - Only displayed when currency conversion is enabled in the {{ModuleOptions|Currency}}. Currencies can also be imported using the '''Update''' button in the {{Module|Currency|Module buttons}}, or by creating a [[Schedule#Create_Scheduled_Task|scheduled task]].
* [[Sales Order|Sales Orders]] - Import open sales orders that have been modified within the specified number of days. Imported orders will have an '''Estimate''' status in Fishbowl.
* [[Sales Order|Invoices]] - Import open unpaid invoices that have been modified within the specified number of days. Imported invoices will have an '''Estimate''' status in Fishbowl.
* [[Purchase Order|Purchase Orders]] - Import open purchase orders that have been modified within the specified number of days. Imported orders will have a '''Bid Request''' status in Fishbowl.
* [[Part|Items]] - Includes [[Tax Rate|Tax Rates]]. For more information, see [[Accounting_Journal_Entries#Item_List|Item List]]
** Include [[Bill of Materials]]
** [[Inventory]] Quantity

In Fishbowl, initial inventory may be added in a few different ways:

'''Integration Wizard'''

Inventory may be added through the [[#Integration|Integration wizard]] in the {{Module|Accounting Integration}}, or by clicking the {{Button|Import}} on the '''General''' tab.

Part of this configuration includes deactivating the cost tracking feature in QuickBooks and handing it over to Fishbowl. If you were to try to add a part using QuickBooks, you would receive a message saying that you've turned this feature off. When you add/modify future inventory, you will need to do this in Fishbowl.

'''Import Inventory via CSV file'''

[[Imports and Exports|Import Inventory via a CSV (comma separated values) file]] and Fishbowl's '''Import Wizard'''.

CSV files are the most common import and export format for spreadsheets and databases. CSV files allow you to import mass information into Fishbowl from spreadsheets. Barcode readers can also be programmed to export this type of file.

'''Add Inventory via the Inventory module'''

Use the [[Inventory#Add inventory|Add inventory]] or [[Inventory#Cycle count|Cycle count]] options to add initial inventory, adjust inventory quantities, or scrap inventory. The component toolbar also has buttons that can be used to adjust inventory.

==Export==

The [[#Integration|Integration]] must be completed prior to exporting data from Fishbowl into QuickBooks. The QuickBooks export can also be initiated by clicking the '''Export to QuickBooks''' link in the {{Module|Dashboard}}.

'''Follow the steps below to export data to QuickBooks'''.

# Open the {{Module|Accounting Integration}}, located in the Accounting group, and click the {{Button|Export}}, located in the module toolbar.
#* '''Standard Export''' - Exports anything that has been fulfilled or completed since the last successful export.
#* '''Repost''' - Re-exports all entries in the given date range. Use with caution as this will create duplicates in QuickBooks of the entries that have already been posted.
#* '''Mark as posted''' - All transactions that are ready to be exported will be marked as posted and will '''not''' be exported to QuickBooks.<br>[[File:Accounting_General_subtab.png]]
# A progress box will be displayed showing a list of items that are being exported to QuickBooks.
# Depending on the number of items being exported, and the speed of the computer, the export may take several minutes. Do not stop the export once it has been started.
# When the export is complete, the Status column will show all areas as '''Done'''. Click '''OK''' to close the '''Export''' dialog.<br>[[File:In-process export.png]]

===Data validation===

Before exporting transactions to QuickBooks, Fishbowl verifies that the essential items exist in QuickBooks. The first time that the data validation runs, some minor issues may need to be resolved. Below are a couple of common errors, as well as the steps to resolve them.

:'''Unable to create employee'''

:[[File:Unable to create employee.png]]

:* This error often occurs when a QuickBooks vendor exists with the same name as the employee.
:* To resolve this error, change the name of the vendor in QuickBooks so that it is not an exact match of the name of the employee.

:'''Class "None" does not exist'''

:* To resolve this error, create a class in QuickBooks with the name of '''None'''.
:* To add a class in QuickBooks, click the '''Lists''' menu and then select '''Class List'''. Press '''Ctrl''' + '''n''' to create a new class. If '''Class List''' is not listed in the menu, turn on class tracking by clicking the '''Edit''' menu and then selecting '''Preferences''' > '''Accounting''' > '''Company Preferences'''.

===Export Item Number, Description, and UOM to QuickBooks===

[[File:QB Invoice.png]]

Fishbowl exports items to QuickBooks using the FB_Item code. This allows Fishbowl to store more parts than some versions of QuickBooks. It also allows Fishbowl to use different costing methods (LIFO, FIFO, Standard, etc.) without interfering with the costs that may have been stored in QuickBooks.

* '''DEFAULT'''<br>By default, Fishbowl includes the '''Item Number''' and the '''Item Description''' in the QuickBooks '''Description''' field as shown below.<br>[[File:QB Default Item Details.png]]


* '''CUSTOM'''<br>By customizing a few options in Fishbowl and QuickBooks, the columns of the QuickBooks report can be displayed as shown below.<br>[[File:QB Custom Item Details.png]]<br>There are many different ways to customize the export and the report. Below are the settings used in the '''CUSTOM''' example above.
** {{ModuleOptionsTab|Accounting Integration|General}}<br>[[File:Custom General Tab.png]]
** {{ModuleOptionsTab|Accounting Integration|QuickBooks}}<br>[[File:Custom QuickBooks Tab.png]]
** Customized invoice in QuickBooks<br>[[File:Custom Invoice in QuickBooks.png]]

=== Export updated information ===
When changes are made in Fishbowl to a customer, vendor, or other item that was previously exported to QuickBooks, you can export those changes to QuickBooks by using the '''Standard Export''' option and clicking the '''Export''' button. The customer, vendor, etc. in your QuickBooks file will then be updated to contain the new contact, shipping, and other information. That way, it will match what is contained in Fishbowl.

==Mapping==

===Company Information===

The following table shows the Company Information that is imported into Fishbowl from QuickBooks by using the Accounting Configuration Wizard. At this time, multiple addresses will not IMPORT into Fishbowl; however, if multiple Company addresses have been entered into Fishbowl, they will EXPORT to QuickBooks.

{| class="prettytable"
|-
! QuickBooks
! <center>Imports To</center>
! Fishbowl
! Max Characters
|-
| Company Name
| {{Arrow|Right}}
| Name
| 60
|-
| Address
| {{Arrow|Right}}
| Default Address
| Line=90<br>Zip=10<br>City=30<br>State=30<br>State Abbr=10<br>Country Name=64<br>Country Abbr=10
|-
| Phone
| {{Arrow|Right}}
| Phone
| 64
|-
| Fax
| {{Arrow|Right}}
| Fax
| 64
|-
| E-mail
| {{Arrow|Right}}
| Email
| 64
|-
| Web Site
| {{Arrow|Right}}
| Web Site
| 64
|}

===Customer===

A new customer that is created in Fishbowl will be exported to QuickBooks when the first order for that customer is exported. Any changes made to the customer's '''Default''' contact information in Fishbowl will be exported to QuickBooks.

{| class="prettytable"
|-
! Fishbowl
! <center>Exports To</center>
! QuickBooks
! Max Characters
|-
| Name
| {{Arrow|Both}}
| Customer Name
| 60
|-
| Main
| {{Arrow|Both}}
| Phone
| 64
|-
| Fax
| {{Arrow|Both}}
| Fax
| 64
|-
| Email
| {{Arrow|Both}}
| E-mail
| 64
|-
| Other
| {{Arrow|Both}}
| Alt. Phone
| 64
|-
| Default Address
| {{Arrow|Both}}
| Main Address
| Line=90<br>Zip=10<br>City=30<br>State=30<br>State Abbr=10<br>Country Name=64<br>Country Abbr=10
|-
| Bill To
| {{Arrow|Both}}
| Bill To
| Line=90<br>Zip=10<br>City=30<br>State=30<br>State Abbr=10<br>Country Name=64<br>Country Abbr=10
|-
| Ship To
| {{Arrow|Left}}
| Ship To
| Line=90<br>Zip=10<br>City=30<br>State=30<br>State Abbr=10<br>Country Name=64<br>Country Abbr=10
|-
| Shipping Terms
| <center><div style="font-size: 20px;"></div></center>
|
|
|-
| Salesperson
| {{Arrow|Both}}
| Rep
| 15
|-
| Tax Rate
| {{Arrow|Both}}
| Tax Code
| 31
|-
| Resale Number
| {{Arrow|Both}}
| Tax Exempt Number
| 30
|-
| Credit Limit
| {{Arrow|Both}}
| Credit Limit
| 12
|}

===Vendor===

When a vendor is created in Fishbowl, it will be exported to QuickBooks for the first time only after an order has been fulfilled and exported to QuickBooks. Aside from the Vendor Name (which is required), all of the below information will be exported to QuickBooks only if it is applicable:

{| class="prettytable"
|-
! Fishbowl
! <center>Exports To</center>
! QuickBooks
! Max Characters
|-
| Name
| {{Arrow|Both}}
| Vendor Name
| 60
|-
| Main
| {{Arrow|Left}}
| Phone
| 64
|-
| Fax
| {{Arrow|Left}}
| Fax
| 64
|-
| Email
| {{Arrow|Left}}
| E-mail
| 64
|-
| Other
| {{Arrow|Left}}
| Alt. Phone
| 64
|-
| Default Address
| {{Arrow|Both}}
| Main Address
| Line=90<br>Zip=10<br>City=30<br>State=30<br>State Abbr=10<br>Country Name=64<br>Country Abbr=10
|}

===Item List===

The table below shows how Fishbowl [[QuickBooks#Import|imports]] from the QuickBooks item list.

{| class="prettytable"
|-
! QuickBooks
! <center>Imports To</center>
! Fishbowl
|-
| Service
| {{Arrow|Right}}
| [[Part#Part_types|Service type part]]
|-
| Inventory Part
| {{Arrow|Right}}
| For more details, see [[#Inventory Part|Inventory Part]]
|-
| Inventory Assembly
| {{Arrow|Right}}
| {{Module|Bill of Materials}}
|-
| Non-inventory Part
| {{Arrow|Right}}
| [[Part#Part_types|Non-Inventory type part]]
|-
| Other Charge
| {{Arrow|Right}}
| [[Part#Part_types|Service type part]]
|-
| Subtotal
| {{Arrow|Right}}
| Not imported
|-
| Group
| {{Arrow|Right}}
| [[Kitting|Kit type product]]
|-
| Discount
| {{Arrow|Right}}
| {{Module|Discount}}
|-
| Payment
| {{Arrow|Right}}
| Not imported
|-
| Sales Tax Item
| {{Arrow|Right}}
| {{Module|Tax Rate}}
|-
| Sales Tax Group
| {{Arrow|Right}}
| {{Module|Tax Rate}}
|}

===Inventory Part===

Inventory parts will be [[QuickBooks#Import|imported]] from QuickBooks when selecting the '''Items''' import. Instead of exporting parts to QuickBooks, Fishbowl uses FB_Item. For other item types, see [[#Item List|Item List]].

{| class="prettytable"
|-
! QuickBooks
! <center>Imports To</center>
! Fishbowl
|-
| Item Name/Number
| {{Arrow|Right}}
| [[Part#General_tab|Part Number]] and [[Product#General_tab|Product Number]]
|-
| Preferred Vendor and Manufacturer's Part Number
| {{Arrow|Right}}
| {{ModuleTab|Part|Vendors}}
|-
| Unit of Measure
| {{Arrow|Right}}
| {{ModuleTab|Part|General}}
|-
| Description on Purchase Transactions
| {{Arrow|Right}}
| [[Part#General_tab|Part Description]]
|-
| Description on Sales Transactions
| {{Arrow|Right}}
| [[Product#General_tab|Product Description]]
|-
| Sales Price
| {{Arrow|Right}}
| [[Product#General_tab|Product Price]]
|-
| On Hand and Average Cost
| {{Arrow|Right}}
| {{Module|Inventory}}
|-
| Income Account
| {{Arrow|Right}}
| {{ModuleTab|Product|Details}}
|-
| COGS and Asset Account
| {{Arrow|Right}}
| {{ModuleTab|Part|Accounts}}
|-
| Reorder Point
| {{Arrow|Right}}
| {{ModuleTab|Inventory|Part}}
|}

===Sales Order/Invoice/Credit Memo===

{| class="prettytable"
|-
! Fishbowl
! <center>Exports&nbsp;To</center>
! QuickBooks
|-
| Customer
| {{Arrow|Right}}
| Customer
|-
| Class
| {{Arrow|Right}}
| Class
|-
| Bill To
| {{Arrow|Right}}
| Bill To
|-
| Ship To
| {{Arrow|Right}}
| Ship To
|-
| Customer PO
| {{Arrow|Right}}
| P.O. Number
|-
| Payment Terms
| {{Arrow|Right}}
| Terms
|-
| Carrier
| {{Arrow|Right}}
| Via
|-
| FOB
| {{Arrow|Right}}
| F.O.B.
|-
| Qty
| {{Arrow|Right}}
| Quantity
|-
| Product Number &amp; Description
| {{Arrow|Right}}
| Description
|-
| Price
| {{Arrow|Right}}
| Price Each
|-
| Tax
| {{Arrow|Right}}
| Tax
|-
| Fishbowl Sales Order Number
| {{Arrow|Right}}
| Memo
|-
| '''Other Options via Tools-Module Options'''
| 
| 
|-
| Tracking Information
| {{Arrow|Right}}
| Description
|-
| Optional (Number, Description, UOM Full Name, or UOM Abbreviation)
| {{Arrow|Right}}
| Other 1 (customized in QuickBooks)
|-
| Optional (Number, Description, UOM Full Name, or UOM Abbreviation)
| {{Arrow|Right}}
| Other 2 (customized in QuickBooks)
|-
| SO Item Note
| {{Arrow|Right}}
| Description
|-
| Fishbowl Sales Order Number
| {{Arrow|Right}}
| QuickBooks Invoice Number
|}

===Purchase Order/Bill===

{| class="prettytable"
|-
! Fishbowl
! <center>Exports To</center>
! QuickBooks
|-
| Vendor
| {{Arrow|Right}}
| Vendor
|-
| Main Office
| {{Arrow|Right}}
| Address
|-
| Payment Terms
| {{Arrow|Right}}
| Terms
|-
| Fishbowl Purchase Order Number
| {{Arrow|Right}}
| Memo
|-
| Part Number and Description
| {{Arrow|Right}}
| Description
|-
| Qty
| {{Arrow|Right}}
| Qty
|-
| Class
| {{Arrow|Right}}
| Class
|}

===Journal Entries===

For journal-entry examples, see [[Accounting Journal Entries]].

{| class="prettytable"
|-
! Fishbowl
! <center>Exports To</center>
! QuickBooks
|-
| Part
| {{Arrow|Right}}
| Memo
|-
| Description
| {{Arrow|Right}}
| Memo
|-
| Customer/Job
| {{Arrow|Right}}
| Name
|-
| QuickBooks Class
| {{Arrow|Right}}
| Class
|-
| Date and Time
| {{Arrow|Right}}
| Date and Time
|-
| FB Debit Amount
| {{Arrow|Right}}
| Inventory Asset Account
|-
| FB Credit Amount
| {{Arrow|Right}}
| Inventory Adjustment Account
|}

==QuickBooks on another computer==

Typically, the Fishbowl Server is installed on the same computer as QuickBooks and the QuickBooks company file. Below are some steps that ''may'' allow the Fishbowl Server to connect to QuickBooks on a separate computer, but this configuration is NOT supported by Fishbowl.

# Copy '''Fishbowl Nexus.exe''' from the Fishbowl Server computer ('''C:\Program Files\Fishbowl\server\bin''') to a location on the QuickBooks computer. Fishbowl Nexus must be running for the export to work. Placing the program in the '''Startup''' folder will allow the program to start automatically when the computer reboots. 
# Run '''Fishbowl Nexus.exe''' on the QuickBooks computer. The '''Fishbowl Nexus''' icon will appear on the taskbar.
# Open the Fishbowl Server and the Fishbowl Client on the computer with the Fishbowl Server installed.
# Open the {{Module|Property}} in the Fishbowl Client and double-click '''FBNexusURL''' in the search pane.
# Change the '''Value''' of the property from '''localhost''' to the IP address of the QuickBooks computer (for example, '''192.168.2.100''') and then click '''Save'''.
# Open the {{Module|Accounting Integration}} and run the [[QuickBooks#Integration|QuickBooks Integration Wizard]].

==Fishbowl Server service==

The Fishbowl Server can be run as a service, but this is not recommended when connecting to the desktop version of QuickBooks. This configuration may work if '''Fishbowl Nexus''' is started manually before exporting to QuickBooks, but this is not a configuration that is officially supported by Fishbowl.

==Hosted environment==
*{{FBQBHosted}}

=TROUBLESHOOTING=

Below is some information that Fishbowl Support uses when troubleshooting issues with QuickBooks. These steps may be useful to review before contacting Fishbowl Support.

==Run as administrator==

If you get an error that says "You've opened a new QuickBooks window for a second company file," one of the applications probably isn't running with administrative rights. Complete these steps on the Fishbowl Server computer to run all of the applications as an administrator.

# Verify that you have a [[System_Requirements#Supported_QuickBooks_versions|supported QuickBooks version]] with the latest updates installed.
# Verify that you have a [[System_Requirements#Supported_operating_systems|supported operating system]] with the latest updates installed. Windows Home edition is not supported.
# Make sure you are logged into your Windows computer as a user with administrative rights.
# In Fishbowl, go to the {{Module|Property}} and delete the '''Acct Last Sync Time Accounts''' property.
# Log into QuickBooks as Admin in '''Single-user''' mode. Click Edit > Preferences > Integrated Applications > Company Preferences, and then delete '''Fishbowl Inventory'''.
# Open the task manager by pressing '''Ctrl''' + '''Shift''' + '''Esc''' and then end every task that is Fishbowl or QuickBooks related (Fishbowl Server, Fishbowl Nexus, Fishbowl Client, QuickBooks, QuickBooks auto-updater, etc.).
# Right-click the '''QuickBooks''' application and select '''Run as administrator'''.
# Log into QuickBooks as Admin and switch over to '''Single-user''' mode.
# Right-click the '''Fishbowl Server''' and select '''Run as administrator'''.
# Navigate to '''C:\Program Files\Fishbowl\server\bin'''. Right-click '''Fishbowl Nexus.exe''' and select '''Run as administrator'''.
# Right-click the '''Fishbowl Client''' application, select '''Run as administrator''', and then log in as '''admin'''.
# Open the {{Module|Accounting Integration}} and click the '''Configure''' tab.
# Click the green button in the '''QuickBooks Integration''' section and proceed through the Accounting Integration wizard.
# Select the option to use the QuickBooks file that is currently open. QuickBooks should then start blinking in the taskbar, and it will display the certificate message. Accept the certificate, and return to Fishbowl to complete the integration.

==Common errors==

* A connection to QuickBooks was not able to be established
* Connection refused
* Unable to find specified QuickBooks file
* Access denied
* Dividing date error
* [[Support#Invalid_Reference_to_QuickBooks_Sales_Rep|Invalid reference to QuickBooks sales rep]]
* [[Support#Invalid_Reference_to_QuickBooks_Customer_or_Vendor|Invalid reference to QuickBooks customer or vendor]]

==General troubleshooting steps==

* Click the {{Button|Delete|Disconnect}} at the top of the {{Module|Accounting Integration}} module before trying to connect to a new database.
* Make sure that the Fishbowl Server and [[Support#Restart_Fishbowl_Server_and_Fishbowl_Nexus|Nexus]] icon are visible in the system tray.
* Make sure that no one else is logged in with '''Single-user''' mode other than the server computer. QuickBooks error message: "Recent changes to your configuration require you (the QuickBooks Administrator) to go into the Integrated Applications preferences and re-authorize your integrated application to log in automatically."
* Make sure that there is not an Accountant copy that is out. If there is, this will prevent anything from connecting to the company file. The title bar in QuickBooks will say that there is an Accountant copy. If you see a dividing date error, it means that there is an Accountant copy out.
* Verify that the '''FBNexusPort''' (default is 28292) matches the port in the '''Program Files/Fishbowl/server/bin/Fishbowl Nexus.exe.config''' file.
* Check the '''FBNexusUrl''' to see if the IP address is the same as the server computer, or change it to '''localhost'''.
** Exit the Fishbowl Server completely.
** Open the '''Program Files/Fishbowl/server/bin/Fishbowl Nexus.exe.config''' file in '''Notepad''', and make sure that the port number matches what is in the {{Module|Property}}.
** Restart the Fishbowl Server and QuickBooks and try the integration again.
** If you start Nexus manually from the '''Program Files/Fishbowl/server/bin''' folder and it shuts down immediately, try changing the port to 28293.
** Restart the Fishbowl Server and QuickBooks, and try the integration again.
* In QuickBooks, open '''Edit > Preferences > General > My Preferences''' tab and uncheck the box for '''Keep QuickBooks running for quick startups'''. Then restart the computer. This option will sometimes cause QuickBooks to open a second window and won't allow Fishbowl to connect to the company file.
* Disable antivirus software and firewall.
* Run '''Windows Update''' or install the [https://www.microsoft.com/net/download/all Microsoft .NET Framework Runtime].
* Uninstall and reinstall QuickBooks.
* Uninstall Fishbowl, delete the '''Program Files/Fishbowl''' folder, and then reinstall Fishbowl.
* Try installing Fishbowl and QuickBooks on separate computers, and try to integrate again.

==Notes==

* Fishbowl needs to be installed ''after'' QuickBooks.
* If you've changed the Nexus port, you may need to change the port in the '''Fishbowl Nexus.exe.config''' file after every [[Update Fishbowl|Fishbowl update]]. This is necessary when the '''Fishbowl Nexus.exe.config''' file gets replaced during the update, essentially changing the port back to 28292. This is especially important if two Fishbowl Servers are running on the same computer. Check the '''FBNexusPort''' in the {{Module|Property}} to see what it should be set to. 
* If Nexus is being shut down immediately after being opened, change the '''FBNexusPort''' in the {{Module|Property}}.
* If Fishbowl is running as a service, ensure that it is [[#QuickBooks_on_another_computer|configured correctly]]. 
* Storing the QuickBooks company file on a shared drive has been known to cause issues.

=MODULE OPTIONS=

{{Intro|Accounting Integration}}

{{General tab}}

{{QuickBooks tab}}

{{Costing tab}}