If you use QuickBooks inventory, FinJinni can provide advanced reporting that you can't otherwise create without excessive manual work. We report on Inventory available, Inventory on order, Inventory needed, and so on. All of this is combined in snapshots so you can see everything you need in one place.

We recently created two reports for a company that makes sheds. A shed has four walls, a floor, and a roof. Each of these is a QuickBooks Inventory Assembly. Each consists of lumber, nails, etc. The first report shows, for each order, how much material went into each assembly and the second, is a "pick list" report that shows how much material went into the whole shed.

The first report looks like this:

Sales Order #1
1 Shed
Floor System
Gable Wall x 2
Eave Wall x 2
Door Standard 6'
Paint Gal. x 3

1 Floor System
2X4X11 x 6
4X4X16 x 4
PLYWOOD 4X8 x 3
TRUSS PLATES
NAILS x 1

2 Gable Wall
2X4X12 x 8
2X4X7 x 20
CEDAR PANELS x 6
NAILS, BOX x 2
TRIM
FLASHING
VENT
etc.

The second looks like this:

Sales Order #1
2X4X11 x 6
2X4X12 x 8
4X4X16 x 4
PLYWOOD 4X8 x 3
TRUSS PLATES
NAILS x 3
etc.

Click here to see samples of Inventory Status and Predictions.