6Physical Inventory
Option 7Physical Inventory Variance Report
This report calculates quantity and amount variances between the on hand inventory quantities and the physical count entered from count sheets or tags. You can use this report to review discrepancies before the actual adjustments are posted.
Here is a sample Physical Inventory Variance Report:
Expert Distributing, Inc.
05/24/91 11:48 am KAY Page: 1
Physical Inventory Variance Report
On Hand Physical Variance Variance
Product Wh Unit At Physical Count Quantity Amount
=================================================================================================================================
Product Class 10 Standard
40 #58 10" Yellow Cylinder 20 Each 182.00 300.00 118.00 0.00
----------- ----------- -------- -----------
-- Product Class Subtotals --> 182.00 300.00 118.00 0.00
=========== =========== ======== ===========
Product Class 20 Special Order
10 #10 3-1/2" White Round 20 Each 722.00 300.00 422.00- 0.00
30 #56 10" Red Cylinder 20 Each 592.00 250.00 342.00- 0.00
----------- ----------- -------- -----------
-- Product Class Subtotals --> 1314.00 550.00 764.00 0.00
=========== =========== ======== ===========
Product Class 30 Custom
20 #4 12" Gold Plated Black Round 30 Each 730.00 250.00 480.00- 0.00
30 #56 10" Red Cylinder 30 Each 1030.00 240.00 790.00- 0.00
----------- ----------- -------- -----------
-- Product Class Subtotals --> 1760.00 490.00 1270.00 0.00
=========== =========== ======== ===========
----------- ----------- -------- -----------
-- Grand Totals --> 3256.00 1340.00 1916.00 0.00
=========== =========== ======== ===========