Data preloaded from AAC FY 2082-2083.xlsx | Includes billing/dispatch, purchase order, gate pass, store stock and reorder planning
Landing Page
Raw Materials Tracked
0
Finished Goods Tracked
0
Billing/Dispatch Entries
0
Purchase Orders Created
0
Raw Material Reorder Summary
Status
Material
Current Stock
Avg Daily Use
Days Left
Suggested Action
Reorder Date
Finished Goods Quick Check
Note: Receive Material sheet has many entries where the date column appears as “DATEâ€/blank in the source file, so some receipts are treated as undated. Negative stock usually means opening stock or purchase receipt dates/quantities need reconciliation.
Raw Material Current Stock & Reorder Status
Status
Material
Received
Consumed
Current Stock
Avg Daily Consumption
Days Left
Suggested Action
Reorder Date
Action
Finished Goods Current Stock
Product
Produced
Billed/Dispatched
Current Stock
Order Section
Create customer orders with multiple products. The system compares ordered quantities with bills issued and shows discrepancies.
Create Order
Product
Qty
Action
Order vs Billing Discrepancy
Red means billed less than ordered. Yellow means billed more than ordered. Green means matched.
Status
Order No
Customer
Product
Ordered
Billed
Difference
Saved Orders
Date
Order No
Customer
Items
Product / Raw Material Entry
Use dropdowns from the master list so item names remain consistent across stock, production, billing and dispatch.
Raw Material Receipt
Raw Material Consumption
Production Output
Billing / Dispatch Entry
Password Protected Settings
Default password: admin123. You can change it inside settings after unlocking.
Enter admin password to add, rename, or remove raw materials, finished goods, suppliers, customers, and store items.
Message Settings
Numbers should be entered with country code, for example 97798XXXXXXXX.
User & Role Settings
Name
User ID
Role
Action
WhatsApp Standard Message Formats
Change Settings Password
Raw Material / Output Settings
Use these settings to control dropdown names across Product / Raw Entry, Purchase Order, Gate Pass, Billing and Store modules.
Raw Material Master
Raw Material
Action
Finished Goods Master
Product
Action
Supplier Master
Supplier
Action
Customer Master
Customer
Action
Store Item Master
Store Item
Action
Create Purchase Order
Purchase Orders
Date
Supplier
Material
Qty
Rate
Total
Delivery
Create Gate Pass for Goods Sent
Add multiple products under the same gate pass / bill number before saving.
Gate Pass Items
Item
Qty
Action
Gate Pass Records
Date
GP No
Bill No
Vehicle
Party
Items
Purpose
Store Item Maintained
Type a new store item and click Add Item to save it in this field list.
Store Item Field List
Item Name
Action
Store Item Balance
Item
Category
Received
Issued
Balance
Billing & Dispatch Details
Date
Bill No
Party
Item
Qty
Bill Amount
VAT
Upload File to Update Stock Database
Upload an updated Excel file in the same format as AAC FY 2082-2083.xlsx, or upload CSV files with columns matching the templates below.The dashboard will read the file in your browser and update the stock database saved on this device.
Accepted Excel Sheet Names Receive Material, Old Plant, New Plant, Output Autoclave, BILL
Accepted CSV Types Raw Receipt, Raw Consumption, Production, Billing Dispatch