Excel Exports

One sheet per day of the month: opening, received, issued, and closing balance for every item.

One sheet per non-daily category: item × day-of-month issue grid, with cost and stock value formulas.

One sheet per daily-category item: date-wise consumption vs. billet production, with run-rate formulas.

Item-wise monthly cost, with quantity and cost per ton of billet produced.

Material Inward Register

From Date

To Date

Vendor

Material

PO No.

Material-wise Material Inward

From Date

To Date

Material

Daily Store Consumption

Date

Store/Location

Material

Monthly Store Consumption

Month

Store/Location

Material

Material Consumption & Cost

From Date

To Date

Material

Store/Location is not stored by the current database schema, so location values cannot be used to filter historical records.

The "per ton of Billet" columns need daily production entered on the Production page for the same month, or they'll show 0.