All the Essential Fishbowl Accounting Reports You’ve Been Looking for in One Convenient Controller’s Toolbox

Get the transparency you need for every debit and credit sent to QuickBooks from Fishbowl Inventory.

What’s Included in Your Controller’s Toolbox:

  • Export reports designed to track every debit and credit from Fishbowl to its QuickBooks account.
  • Useful costing review reports, including a sales tax charged report and a detailed listing of individual receiving transactions.
  • A FIFO/LIFO valuation report by location group, which is not available in standard Fishbowl reports.

You Also Get:

  • Complete account mapping
  • Total Debits and Credits by account, summary and detail
  • Transaction date and posting date
  • The ability to export our Table Reports to Excel without merged cells and headers, ready for data analysis. Sort, pivot and search to your heart’s content!
 
 

The Core Four Export Reports:

  • The core reports, which trace the accounting transactions from Fishbowl to QuickBooks and which allow you to do roll forwards and roll backs, are the four export reports: purchases, sales, work orders and inventory adjustments.

The Valuation Reports:

  • There are three valuation reports which provide on hand quantity, unit cost and extended cost.
  • Note the Inventory Valuation by Location Group is only provided for those on FIFO-LIFO costing as there exists a standard Fishbowl report which can be run for Average and Standard Costing.
  • The valuation report with sorting options is extremely useful when reviewing the makeup of inventory.
  • Note: no valuation report can be run for any date other than now. Therefore we recommend that you schedule the valuation report of your choice to be run after close of business each day and saved to .csv.

Trouble Shooting Reports:

  • The Receiving Detail Report allows you to view each receipt against a purchase order. It also shows you the received date and the bill date. Best practice is for the bill date to equal the received date to avoid “dancing dollars” in QuickBooks. This report allows you to identify the bill transactions that do not follow best practice.
  • The Sales Tax detail Report allows you to see the detail of sales taxes charged as tool to prepare the sale tax return.
  • The Costing Review Report allows you to select parts based on certain criteria. This is useful when diagnosing costs that seem out of line.
  • The Costing Layers with Transaction Source is extremely useful for determining-troubleshooting the costs being used with hyperlinks to the transaction that created the costing layer.

Transaction Detail Reports

 

Payment Transactions

Receiving Transaction Detail

Unbilled Receipts

The Core Four

 

Export Purchase Transactions

Export Sales Transactions

Export Inventory Adjustments

Export Work Order Transactions

Valuation Reports

 

Posting Layer Valuation

Valuation by Asset Account

Valuation by Location

See What’s Included in Your Controller’s Toolbox:

Report

One Report All Costing Methods

Avg Cost Only

FIFO/LIFO Cost Only

Std. Cost Only

Core Four

 

 

 

 

    Export Purchase Transactions

 

Yes

Yes

Yes

    Export Sales Transactions

Yes

 

 

 

    Export Inventory Adjustments

Yes

 

 

 

    Export Work Order Transactions

 

Yes

Yes

Yes

Transaction Detail Reports

 

 

 

 

      Payment Transactions

Yes

 

 

 

      Receiving Transaction Detail

Yes

 

 

 

      Unreconciled Receipts

Yes

 

 

 

Valuation Reports

 

 

 

 

      Costing Layer Valuation with Transaction Source

Yes

 

 

 

      Inventory By Location Group

 

Yes

Yes

Yes

      Inventory Valuation by Asset Account

Yes

 

 

 

 

 

Get all of these reports  by purchasing the entire Controller's Toolbox collection of reports.

$795.00

Shopping cart0
There are no products in the cart!
Continue shopping