--- title: Jeanne’s Quick Guide for your QuickBooks & Fishbowl Inventory Integration description: With both programs in place you get a robust inventory management system and a proven accounting system. But as I’ve mentioned before, for this environment to be a happy one, you’re likely to need to change some of your habits and ideas about the “right” way to do things in QuickBooks alone. image: https://blog.tarabyte.com/hubfs/thumbnail_large-26.webp --- [![TaraByte 239 x 120 ](https://blog.tarabyte.com/hs-fs/hubfs/TaraByte%20239%20x%20120%20.png?width=239&name=TaraByte%20239%20x%20120%20.png)](https://www.tarabyte.com/) - About ⌄ - [Our Story](https://www.tarabyte.com/about-us/) - [Services](https://www.tarabyte.com/our-services/) - Fishbowl ⌄ - [About Fishbowl Inventory](https://www.tarabyte.com/fishbowl-inventory/) - [Fishbowl Accounting Basics For QuickBooks](https://info.tarabyte.com/fishbowl-accounting-basics-for-quickbooks-desktop-quickbooks-online) - [Advance Fishbowl Chart of Accounts Guide](https://info.tarabyte.com/advance-fishbowl-chart-of-accounts-guide) - [Custom Fishbowl Reports](https://www.tarabyte.com/fishbowl-inventory/custom-fishbowl-reports/) - [Controller's Toolbox](https://tarabyte.com/fishbowl-inventory/fishbowl-accounting-controllers-toolbox/) - [Custom Programming](https://www.tarabyte.com/fishbowl-inventory/custom-fishbowl-programming/) - [3PL Integration](https://www.tarabyte.com/fishbowl-inventory/3pl-integration/) - [CRM Integration](https://tarabyte.com/fishbowl-inventory/fishbowl-crm-integrations/) - [E-commerce Integration](https://www.tarabyte.com/fishbowl-inventory/ecommerce-integrations/) - [POS Integration](https://www.tarabyte.com/fishbowl-inventory/pos-integration/) - [QuoteWerks Integration](https://www.tarabyte.com/fishbowl-inventory/quotewerks-integrations/) - [QuickBooks ⌄](https://tarabyte.com/about-quickbooks-software/) - [Data File Services](https://www.tarabyte.com/quickbooks-data-services/) - Community ⌄ - [FAQ](https://www.tarabyte.com/faq/) - [Events & News](https://www.tarabyte.com/events/) - [Blog ⌄](https://blog.tarabyte.com/blog) - [Fishbowl Inventory](https://blog.tarabyte.com/blog/tag/fishbowl-inventory) - [QuickBooks](https://blog.tarabyte.com/blog/tag/quickbooks) - [Video Tutorials](https://tarabyte.com/tarabyte-videos/) - [Shop ⌄](https://www.tarabyte.com/shop/) - [Fishbowl Inventory ⌄](https://www.tarabyte.com/product-category/fishbowl/) - [Controller's Toolbox](https://tarabyte.com/product/controllers-toolbox/) - [The Sales and Margins Report](https://tarabyte.com/product/the-sales-and-margins-report/) - [QuickBooks Ship-To Export Utility](https://tarabyte.com/product/quickbooks-ship-to-export-utility/) - [QuickBooks Software](https://www.tarabyte.com/product-category/quickbooks/) - [Contact Us ⌄](https://www.tarabyte.com/contact/) - [Upload Files](https://www.tarabyte.com/upload-files/) [Home](https://www.tarabyte.com) > Blog - About ⌄ - [Our Story](https://www.tarabyte.com/about-us/) - [Services](https://www.tarabyte.com/our-services/) - Fishbowl ⌄ - [About Fishbowl Inventory](https://www.tarabyte.com/fishbowl-inventory/) - [Fishbowl Accounting Basics For QuickBooks](https://info.tarabyte.com/fishbowl-accounting-basics-for-quickbooks-desktop-quickbooks-online) - [Advance Fishbowl Chart of Accounts Guide](https://info.tarabyte.com/advance-fishbowl-chart-of-accounts-guide) - [Custom Fishbowl Reports](https://www.tarabyte.com/fishbowl-inventory/custom-fishbowl-reports/) - [Controller's Toolbox](https://tarabyte.com/fishbowl-inventory/fishbowl-accounting-controllers-toolbox/) - [Custom Programming](https://www.tarabyte.com/fishbowl-inventory/custom-fishbowl-programming/) - [3PL Integration](https://www.tarabyte.com/fishbowl-inventory/3pl-integration/) - [CRM Integration](https://tarabyte.com/fishbowl-inventory/fishbowl-crm-integrations/) - [E-commerce Integration](https://www.tarabyte.com/fishbowl-inventory/ecommerce-integrations/) - [POS Integration](https://www.tarabyte.com/fishbowl-inventory/pos-integration/) - [QuoteWerks Integration](https://www.tarabyte.com/fishbowl-inventory/quotewerks-integrations/) - [QuickBooks ⌄](https://tarabyte.com/about-quickbooks-software/) - [Data File Services](https://www.tarabyte.com/quickbooks-data-services/) - Community ⌄ - [FAQ](https://www.tarabyte.com/faq/) - [Events & News](https://www.tarabyte.com/events/) - [Blog ⌄](https://blog.tarabyte.com/blog) - [Fishbowl Inventory](https://blog.tarabyte.com/blog/tag/fishbowl-inventory) - [QuickBooks](https://blog.tarabyte.com/blog/tag/quickbooks) - [Video Tutorials](https://tarabyte.com/tarabyte-videos/) - [Shop ⌄](https://www.tarabyte.com/shop/) - [Fishbowl Inventory ⌄](https://www.tarabyte.com/product-category/fishbowl/) - [Controller's Toolbox](https://tarabyte.com/product/controllers-toolbox/) - [The Sales and Margins Report](https://tarabyte.com/product/the-sales-and-margins-report/) - [QuickBooks Ship-To Export Utility](https://tarabyte.com/product/quickbooks-ship-to-export-utility/) - [QuickBooks Software](https://www.tarabyte.com/product-category/quickbooks/) - [Contact Us ⌄](https://www.tarabyte.com/contact/) - [Upload Files](https://www.tarabyte.com/upload-files/) # Jeanne’s Quick Guide for your QuickBooks & Fishbowl Inventory Integration [February 24, 2017](https://blog.tarabyte.com/blog/archive/2026/) by [Jeanne](https://blog.tarabyte.com/blog/author/jeanne) in category [Fishbowl Inventory](https://blog.tarabyte.com/blog/tag/fishbowl-inventory), [Inventory Management](https://blog.tarabyte.com/blog/tag/inventory-management), [QuickBooks](https://blog.tarabyte.com/blog/tag/quickbooks) with [Home](https://www.tarabyte.com) > [Blog](https://blog.tarabyte.com/blog) > Jeanne’s Quick Guide for your QuickBooks & Fishbowl Inventory Integration A Fishbowl/QuickBooks environment can be a match made in heaven. With both programs in place you get a robust inventory management system and a proven accounting system. But as I’ve mentioned before, for this environment to be a happy one, you’re likely to need to change some of your habits and ideas about the “right” way to do things. *Because the right way to do things with Fishbowl is different than the right way to do things in QuickBooks alone.* A great example of this is dating…meaning, of course, how you date your transactions. #### **Some Important Tips** - **Everything starts with Fishbowl** Always keep in mind that Fishbowl controls everything except the chart of accounts, and that Fishbowl pushes information through to QuickBooks. If something is done in QuickBooks that should have been done in Fishbowl, your books will not be accurate. - **Never backdate a transaction in Fishbowl** If you do so, due to the nature of the Fishbowl database, you will lose your ability to get an accurate Inventory Valuation report. - **Never change dates in QuickBooks** If you change dates in QuickBooks, these changes will not flow back to Fishbowl. As a result, your QuickBooks and Fishbowl will not balance. For example, shipping products from a Fishbowl Sales Order drives two transactions to QuickBooks: an Invoice to record the sale, and a Journal Entry to record the cost of goods sold. These entries are independent of each other. So if you change the date on an Invoice after it is posted to QuickBooks, the Journal Entry for the cost of goods sold will retain the original shipping date, while the Invoice will have the new date. As a result, you can get revenue showing in one time period and its associated cost of goods sold showing in different time period. - **Always use the inventory received date as the vendor bill date** As I explained in a previous [article](https://blog.tarabyte.com/blog/vendor-bills-and-the-dancing-dollars), if you don’t do this you can end up with what I call the “dancing dollars” problem. - **Be sure to “chaperone” your non-accounting personnel** A situation that came up with one of my clients is a great illustration of the “never change dates in QuickBooks” principle. This client’s Fishbowl and QuickBooks accounts were not reconciling. It turns out that the management and sales people were messing with the Invoice dates so that it would appear as though they had met their sales goals. It never occurred to these employees that changing the Invoice dates would create a serious accounting problem. As mentioned above, in the Fishbowl/QuickBooks world, the Invoice only drives the sales transaction. The cost of goods sold transaction is a separate Journal Entry. By changing the Invoice date, things no longer matched up – and my client was left with books that were wrong.   ![Untitled design (1)](https://blog.tarabyte.com/hubfs/Untitled%20design%20(1).png "Untitled design (1)") ### **Jeanne Tarazevits** **CPA, QuickBooks Maven, Fishbowl Guru** As a Top 100 QuickBooks ProAdvisor and Fishbowl Inventory Super Hero, Jeanne helps businesses change the way they do business by getting their inventory management, accounting and manufacturing systems all working together seamlessly. In providing these services Jeanne draws upon her knowledge as a CPA, her previous experience as an Auditor with Ernst & Young and long-time CFO of a publicly-traded medical device manufacturer, and the expertise gained in the 10+ years she has been working with Fishbowl Inventory. #### Related Posts ### Recent Posts ### Posts by Tag - [Fishbowl Inventory (32)](https://blog.tarabyte.com/blog/tag/fishbowl-inventory) - [QuickBooks (29)](https://blog.tarabyte.com/blog/tag/quickbooks) - [Inventory Management (14)](https://blog.tarabyte.com/blog/tag/inventory-management) - [Accounting (11)](https://blog.tarabyte.com/blog/tag/accounting) - [Our Partners (4)](https://blog.tarabyte.com/blog/tag/our-partners) - [QuickBooks Online (2)](https://blog.tarabyte.com/blog/tag/quickbooks-online) - [netstock (2)](https://blog.tarabyte.com/blog/tag/netstock) - [Food Manufacturing (1)](https://blog.tarabyte.com/blog/tag/food-manufacturing) - [Payable (1)](https://blog.tarabyte.com/blog/tag/payable) - [Payables (1)](https://blog.tarabyte.com/blog/tag/payables) - [Purchase Orders (1)](https://blog.tarabyte.com/blog/tag/purchase-orders) - [Uncategorized (1)](https://blog.tarabyte.com/blog/tag/uncategorized) See all [![New Call-to-action](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/5606425/15e03d41-fea1-404a-b70e-3b0b87f5bdce.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/5606425/15e03d41-fea1-404a-b70e-3b0b87f5bdce) ![TaraByte-Logo-Wht](https://blog.tarabyte.com/hs-fs/hubfs/TaraByte-Logo-Wht.png?width=250&height=43&name=TaraByte-Logo-Wht.png) TaraByte Solutions has been providing expert QuickBooks consulting and accounting services to small and mid-market firms since 2001. Our focus is the selection, sale and implementation of inventory solutions. Join the many retail, wholesale, manufacturing and e-commerce businesses that count on us for scalable best-of-breed applications. #### Contact Us **Toll Free North America:** (888) 745-1533 **Worldwide:** (949) 645-1019 --- **Email **: [info@tarabyte.com](mailto:info@tarabyte.com) --- ****Monday - Friday: 9:00 am - 5:00 pm**** --- **Saturday - Sunday: Closed**