Israel Lopez Consulting
News

Fishbowl 2026.7: QuickBooks/Xero connections that stay connected, no more duplicate invoices, and job costing in QBO

Israel LopezJuly 14, 2026

Fishbowl shipped version 2026.7 (26.7), and for once the accounting integration is the main event. Two of these changes fix problems we see constantly in reconciliation work: connections that silently drop, and invoices that post twice. QuickBooks Online also finally gets customer and job on journal entries. There are a few upgrade notes to keep in mind too. Let’s start with the accounting.

The accounting changes that matter

  • QuickBooks Online and Xero connections now stay active on their own. The connection used to drop every few weeks with no setting change, and the only fix was to manually reconnect and re-authorize. That was never a fluke. The underlying OAuth token has a short life and rotates when it refreshes, so a connection that isn’t renewed on schedule just dies. 26.7 refreshes the QBO and Xero tokens automatically before they expire, with a system option for how many days ahead (default 10). If you’ve been re-authorizing your accounting connection on a recurring calendar reminder, you can probably delete that reminder now.
  • No more duplicate invoices when an account is missing. This is the important one. Before 26.7, if an order referenced an account that was inactive or missing in QuickBooks Online, the export reported an error but posted the invoice and journal entries anyway. Then, once you fixed the account, it posted a second copy. That behavior is a direct source of the exact discrepancy we get called in to untangle: two invoices in QBO for one Fishbowl order, revenue overstated, and an inventory or COGS number that won’t tie. 26.7 stops the export for that order the moment it hits a missing or inactive account, so nothing posts until it’s clean. The same protection now covers Xero. If you’ve been on an earlier version, this bug may have already left duplicates in your books, so it’s worth checking before you close another period.
  • Customer/job on QBO journal entries (job costing). Journal entries Fishbowl posts to QuickBooks Online now carry the customer or job when one is set in Fishbowl, matching what the QuickBooks Desktop integration has always done. This ties the cost side of a transaction to the customer or job, so QBO job-costing reports finally reflect the whole picture. Jobs map to QBO sub-customers, and it applies across sales orders, purchase orders and receiving, inventory adjustments (cycle count, scrap, initial add), and work orders.
  • Two smaller Xero and cash fixes worth knowing. Due dates on 30 Days EOM terms synced to Xero could be wrong, because Fishbowl wasn’t sending a calculated due date and Xero derived one from the transaction date instead (ugly in short months). That’s fixed. And when cash rounding was on, the rounding line wasn’t exported if payment came in after fulfillment, so Fishbowl and your accounting system disagreed by a few cents. Also fixed.

Everything else new

  • Auto PO now counts inventory in transit. The Auto PO wizard used to ignore stock already covered by open transfer orders and recommend buying more. It now counts in-transit transfer inventory, so it stops padding your purchasing.
  • Fishbowl Payments refreshes its own credentials. Go 30 or more days without taking a card payment and your payment credentials could expire and lock you out until you regenerated them by hand. Now they refresh automatically before expiry (default 10 days).
  • Read-Only Location Groups reach Work Orders. The read-only location-group feature now covers the Work Orders module. You can view work orders in a group without being able to create or edit them, with a lock icon in the search list. A related fix also blocks view-only Purchase Order users from changing a line’s vendor cost through the right-click menu or a keyboard shortcut.
  • Part CSV gains “Pick in part UOM only.” This part option can finally be set and reviewed through CSV import and export (both Part and PPVP), so bulk maintainers stop editing it one part at a time. Existing CSV files without the new column import unchanged.
  • REST API additions. Transfer orders can now be created, un-issued (back to Entered), and deleted. Work orders get full memo support (list, get, create, update, delete). And there are next-number endpoints for sales orders, work orders, and purchase orders. One thing to watch on the next-number calls: requesting a number consumes it, so the counter advances whether or not you create the order.

Fixes we’d flag

  • Sales Production Demand report miscalculated its summary totals when the part and product used different units of measure, mixing units so the Short total was wrong. It now converts consistently. If you plan production off this report and run mixed UOMs, your old totals were suspect.
  • Non-admin Part Cost CSV import failed with an “only the admin can import this information” error even for users granted the permission. That’s fixed.
  • Import/Export dialog ran the wrong import or export for users with limited CSV permissions. It now honors what you actually selected.
  • BOM CSV imports: note lines set as variable quantity, and finished goods marked one-time-use with a sales order quantity greater than one, both produced broken or wrong-quantity manufacture orders. Both fixed.
  • Dates now format consistently across all modules, and several Sales Order report alignment and created-date quirks are resolved.

The usual upgrade caveats carry over: Fishbowl Anywhere users and anyone on custom Plugins should stay on 2025.9 (custom integrations on the REST or Legacy API are unaffected), upgrades from 2025.9 or older need the server updated before clients, and MySQL 5.7 is no longer supported, with MySQL 8.0 now past end of life but fine on 26.7 through the September release. Nothing new there, but worth a glance if any of it applies to you.

The connection-stability and duplicate-invoice fixes are genuinely good news, but they raise a question worth asking: if you were on an earlier version, what did those bugs already leave in your books? Duplicate invoices and journal entries don’t clean themselves up on upgrade. If your Fishbowl and QuickBooks numbers don’t tie and you’re not sure whether a since-fixed export bug is the reason, get in touch. That’s exactly the kind of thing we chase down.