Controllers Toolbox – The Valuation Reports

Inventory Values are determined as quantity multiplied by cost. Our valuation reports show this level of detail on all of our reports.

The Inventory Valuation shows the detail you need to tie out and audit the balances in each asset account.

The valuation by location group not only has the granular information to support inventory by location group (warehouse), but by individual location.

The costing layer valuation report has many uses as it not only shows the current active costing layers, but can be used to monitor historical trends.  This report is a must for users of standard cost to evaluate current standards vs historical trends.  It also is a great tool to spot bad costing layers perhaps a manufacturing order that was fulfilled without all of the items, being picked or a UOM error in purchasing.

As the value of inventory is defined as cost multiplied by Quantity.  All our valuation reports display quantity and cost.

Unit Costs and Total Value will vary dependent upon the costing method being used.  For Fishbowl Desktop, the choices are Average, LIFO, FIFO and Standard.

Coming soon in Fishbowl Online the choices will be Average, LIFO, FIFO and Actual.

Costing Layers with Transaction Source

Export Work Order Details

Costing Layers with Transaction Source

Export Work Order Details

Costing Layers with Transaction Source Options

The Columns Displayed

  • Part
  • Description
  • Date Created (this is a system date)
  • Transaction Type
  • Transaction # (This is a hyperlink transaction that created the layer)
  • Vendor (if applicable)
  • Adjustment Info (if applicable)
  • Asset Account
  • Qty
  • Layer Cost
  • Standard Cost
  • Difference between Standard and Layer Cost
  • Total Asset Value of that Layer

 

Date Filters

  • Layer Creation Date

 

This report can be filtered by

  • Transaction Type
  • Active Costing Layers
  • Fullfilled Costing Layers
  • Voided Costing Layers
  • Historical Data

 

Format Options

  • Paginated
  • Formatted for exporting

 

The costing layer valuation report has many uses as it not only shows the current active costing layers, but can be used to monitor historical trends.  This report is a must for users of standard cost to evaluate current standards vs historical trends.  It also is a great tool to spot bad costing layers perhaps a manufacturing order that was fulfilled without all of the items, being picked or a UOM error in purchasing.

A Must have for anyone using Standard Cost

 

  • Review the costing layers that make up LIFO and Average Costs
  • Compare Actual costs to standard
  • Research costs of individual  parts

$150.00

Inventory By Account

Export Work Order Details

Inventory Valuation by Account Report

Export Work Order Details

Inventory Valuation by Account Report Options

The Columns Displayed

  • Part Number
  • Part Description
  • Quantity on Hand
  • LIFO/FIFO unit cost
  • LIFO/FIFO Extended Cost
  • Standard Unit Cost
  • Standard Extended Cost
  • Average Unit Cost
  • Average Cost Extended

 

The Sort

 

  • Sorted by General Ledger Account
  • Then by Part Number

 

Filter Option

  • Show parts with zero quantity
  • Select Part
  • Select Asset Account

 

Display Options

  • Formatted for Printing
  • Formatted for Exporting
  • The Inventory Valuation by Account is THE report to compare to your QuickBooks Balance Sheet when reconciling between Fishbowl and QuickBooks.
  • This report should be scheduled to run nightly and saved to .csv. I usually save the report as Dvalue and Fishbowl appends the date and time to the file name.

    $150.00

    Valuation by Location

    Export Work Order Details

    Valuation by Location Group Report

    Export Work Order Details

    Valuation by Location Group Report Options

    The Columns Displayed

    • Location Group
    • Location
    • Part Number
    • Part Description
    • Qty
    • UOM
    • Value

     

    The Filters

    • Location Group
    • Location
    • Part Number

     

    The Display

    • Format for Exporting
    • Show Location Detail (Y/N)
    • Sow Part Details (Y/N)

      $150.00

      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