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
Costing Layers with Transaction Source
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
Inventory Valuation by Account Report
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
Valuation by Location Group Report
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.
$1,095.00