In a perfect world, Fishbowl would be the only user to ever create or modify an inventory transaction. You should never delete a bill or any other transaction affecting inventory that originated in Fishbowl. There should also never be a bill correction or credit memo to the QuickBooks inventory account.
There should never be a manual entry to the QuickBooks inventory account. Next, understand that if the mappings are correct the problem is on the QuickBooks side. I had a client who was mapping his cycle count adjustments back to inventory, which led to the following situation: Inventory was no longer in Fishbowl but the dollars, instead of crediting inventory and debiting expense, were being debited and credited to inventory, creating a zero adjustment and leaving the QuickBooks asset account too high. Troubleshootingįirst, check your mappings in Fishbowl to QuickBooks. If there is a difference, it’s time to troubleshoot. Run a QuickBooks balance sheet for all dates (you can have transactions dated after today’s date) – Match the total of the appropriate valuation report to the QuickBooks inventory account(s).Run the appropriate valuation report – Note the total dollars.Post all transactions to QuickBooks through the Fishbowl Accounting Export.
First, unless you’ve made a copy of your database at month end, QuickBooks and Fishbowl can only be reconciled as of now. I would like to save you a lot of time by sharing what I’ve learned as I’ve worked closely with Fishbowl Inventory and QuickBooks.