What we do
Tools
Industries
Department
How we workLet's talk →
Home/Fishbowl/Fishbowl QuickBooks Integration Mismatches
Fishbowl + QuickBooks

What the Fishbowl QuickBooks Integration Posts, and Why the Totals Drift

Fishbowl's inventory valuation says one number and the Inventory Asset account in QuickBooks says another. Or an invoice shows up twice, or the export quietly stopped a week ago. Fishbowl doesn't copy every record into QuickBooks. It posts the accounting result of events that happen in Fishbowl: a shipment, a receipt, a count, a finished work order. Knowing which events post is most of the fix.

What reaches QuickBooks

Posts: a shipped sales order becomes the customer invoice, adjusting income, cost of goods sold and inventory asset. A received, reconciled purchase order becomes a bill. Customer payments taken in Fishbowl, new customers and vendors, cycle counts, scrap, returns and completed work orders post too.

Doesn't cross over: the sales orders and purchase orders themselves. Close any that are open in QuickBooks, or re-enter them in Fishbowl, before connecting.

When: Fishbowl exports on a schedule you set, as often as you like. QuickBooks Online makes you re-authorize the connection every 90 days.

Setup in Fishbowl Advanced: connect, sign in to QuickBooks, then map Accounts Receivable, Accounts Payable and the accounts for each part type.

Accounting Integration Configure Connect to QuickBooks Online

Editions: QuickBooks Online Plus or Advanced, or QuickBooks Desktop Pro, Premier or Enterprise.

One month where Fishbowl and QuickBooks disagree on inventory

Example figures. Run your own comparison with Fishbowl's Inventory Valuation Summary and the QuickBooks Inventory Asset balance on the same date.
Fishbowl Inventory Valuation Summary $84,300
Freight bill coded straight to Inventory Asset in QuickBooks (Fishbowl never saw it, so it never reached a part's cost.) +$1,200
Damaged stock written off in QuickBooks, not Fishbowl (Fishbowl still counts those units.) −$450
Receipt billed twice: old QuickBooks PO left open at cutover (Once from the QuickBooks PO, once from Fishbowl's receipt.) +$2,100
QuickBooks Inventory Asset balance $87,150

Every line here is inventory work done on the QuickBooks side, where Fishbowl can't see it. Reverse the duplicate in QuickBooks, record any real adjustment in Fishbowl so it posts, and the two balances meet again.

Five reasons a Fishbowl sync stops matching the books

Inventory still worked in QuickBooks

How you'll know: Someone receives stock, writes off damage or creates an inventory item in QuickBooks, and the Inventory Asset balance moves while Fishbowl's valuation doesn't.

Fix: Retire purchase orders and inventory entries on the QuickBooks side after go-live. Every count, receipt and write-off goes through Fishbowl, which posts it for you.

Orders left open at cutover

How you'll know: An invoice or bill appears twice, once from the old QuickBooks order and once from Fishbowl's shipment or receipt.

Fix: Close open QuickBooks sales and purchase orders before connecting, and re-create the ones that still matter in Fishbowl.

A QuickBooks Online plan that can't take the postings

How you'll know: You're on Simple Start or Essentials, and Fishbowl's integration isn't an option.

Fix: Fishbowl's Online integration needs Plus or Advanced. Move up a plan before go-live rather than after a month of hand entries.

The 90-day re-authorization slipped past

How you'll know: Shipments from the last few days in Fishbowl have no invoices in QuickBooks.

Fix: Intuit's security rules make you reconnect QuickBooks Online every 90 days. Put the date on someone's calendar, and confirm the next export posted after each reconnect.

Account mapping set once and never revisited

How you'll know: A new part type posts to the wrong income or cost account, so margins by product line look off.

Fix: Each part type maps to its own accounts. Review the mapping whenever you add a part type or your accountant changes the chart of accounts.

A distributor whose split shipments needed splitting in QuickBooks too

Multi-location distributor · Fishbowl and QuickBooks Desktop

Before

Large orders often shipped from two Fishbowl locations on two different days.

In that setup, the standard sync handled an order that shipped once, in full. Split shipments left accounting correcting QuickBooks invoices by hand.

Whoever did the correcting had to remember which Fishbowl location matched which QuickBooks class.

After

n-frames built a layer that spots partial shipments in Fishbowl and creates the matching split invoices in QuickBooks, with each location's class already applied.

Orders that ship in one go still run through the standard Fishbowl sync, which does most of the work.

Accounting stopped splitting and re-classing invoices after every partial shipment.

Fishbowl and QuickBooks sync questions

Does Fishbowl integrate with QuickBooks Online or just Desktop?

Both. Fishbowl Advanced connects to QuickBooks Online Plus or Advanced, and to QuickBooks Desktop Pro, Premier or Enterprise. The Online connection runs through an Intuit sign-in that you renew every 90 days, while Desktop connects to your company file.

Is the Fishbowl-QuickBooks sync real-time?

Not unless you set it close to that. Fishbowl exports to QuickBooks on a schedule, and you choose how often, so a shipment made a minute ago may not have its invoice yet. If your team needs QuickBooks current through the day, shorten the export interval instead of posting anything by hand.

What data actually syncs between Fishbowl and QuickBooks?

Customers and vendors added in Fishbowl, invoices from shipped sales orders, bills from received purchase orders, customer payments, inventory adjustments such as cycle counts, scrap and returns, and completed work orders posted to the general ledger. The sales and purchase orders themselves stay in Fishbowl.

Does Fishbowl replace QuickBooks accounting?

No. Fishbowl posts to your chart of accounts and never changes it. QuickBooks still pays bills, handles banking and produces the financial reports, while Fishbowl owns stock, warehouse work and production.

Why did a sales order sync incorrectly to QuickBooks?

Usually one of three things: the customer or part type maps to the wrong account, an old QuickBooks order for the same sale was still open, or the order shipped in pieces and the invoices didn't split the way your accountant expected. Check the mapping first, then look for a duplicate in QuickBooks.

Why does Fishbowl keep asking me to reconnect QuickBooks Online?

Intuit's security rules expire the connection, so you sign in again every 90 days. Go back to Accounting Integration, open Configure, choose Connect to QuickBooks Online, sign in, and then make sure the next export goes through.

Can someone handle partial shipments and class mapping in our Fishbowl QuickBooks sync?

Yes. n-frames builds the piece beside Fishbowl's own integration for cases it doesn't post the way your books need, such as partial shipments split by location and class, and leaves everything else to Fishbowl's export.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.