| No | Type | Part Number | Description | Total Qty | Balance | Used Qty |
|---|
Add Transaction (auto-updates Master Inventory)
📥 Bulk Import Transactions (Excel)
Same format as your existing transaction sheet: No. / Date / Type / Part Number / Description / Total Qty / Requester / From.
Total Qty positive = In/New, negative (e.g. -1) = Used/Deduction. Each row automatically updates Master Inventory's Total Qty / Balance / Used Qty, and the whole batch is added to the Transaction Log.
| No | Date | Type | Part Number | Description | Qty | Requester | From |
|---|
Import Existing Excel (initialize / add data)
Upload a Master Inventory Excel (columns: Type, Part Number, Description, Total Qty, Balance, Used Qty), or a Transaction Log Excel (columns: Date, Type, Part Number, Description, Total Qty, Requester, From). The system auto-detects sheet names containing "master"/"inventory" or "log"/"transaction" keywords, otherwise it uses the 1st/2nd sheet.
Data Management
Data is auto-saved to cloud storage. After each update, it's recommended to click Export Excel (top right) to keep a backup record.