QuickBooks Lot & Expiration Tracker

Upload Inventory List.xlsx. This version reads QBDATA, Lot and Expirations, and Purchase by item detail.

Cloud: starting…
Upload the Inventory List workbook in Setup to begin.
ItemDescriptionLot NumberExpiration DateLot QtyTotal Item QtyU/MMonths to ExpStatus
Upload a file to begin.
ItemDescriptionQuickBooks Qty On HandU/MQty on SOTotal AvailableNotes
Upload a file to begin.
ItemDescriptionNoteLast UpdatedActions
No item notes yet. Add notes from Item Totals.
% discount
Order Number
Salesman
Order Date
QBs ID
DBA
Total Items
Total Amount
Light green: available, not orderedLight red: ordered, out of stockYellow: item in production
ItemDescriptionQty On HandQty OrderedQty SoldLotes with expiration dates available
Upload Inventory List.xlsx first, then upload a Sales Order or start a Manual Order.

Saved Orders

Order NumberSalesmanOrder DateTotal ItemsTotal AmountActions
No saved orders yet.

Inventory Info Upload

Upload Inventory List.xlsx with QBDATA, Lot and Expirations, and Purchase by item detail.

For Email in Saved Orders: run Start Outlook Email Bridge.bat once and keep that window open. Outlook will open ready to send with the PDF attached.

Filled automatically from your Outlook profile. Override here only if needed.

Waiting for file...0%

Web and PC do not share browser storage. Upload once from the PC that has your data, then use Download on the web.

Salesmen & Price Levels

Add each salesman and their discount percentage. When a Sales Order is loaded, the matching salesman applies the Price Level automatically in SO Picking List.

Route NoSalesmanDBAQBs IDLaceUp IDPrice LevelPhoneEmailActions
No salesmen configured yet.

Ship Via

Add shipping methods here. They appear as a dropdown in SO Picking List.

Ship ViaActions
No Ship Via options configured yet.

Loading workbook...

Large files can take 1–2 minutes. Please wait.

Manual Sales Order

Select a salesman. The order number is generated automatically.

Order number will appear here.