Jeanne’s Quick Guide for your QuickBooks & Fishbowl Inventory Integration

February 24, 2017 by in category Fishbowl Inventory, Inventory Management, QuickBooks with
Home > 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, 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)

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

New Call-to-action