Use Serial or Lot Numbers and Expiration Date
by Intuit• Updated 8 months ago
Learn how to use serial or lot numbers and expiration dates to track inventory in QuickBooks Desktop Enterprise.
Important: Only QuickBooks Desktop 2023 offers expiration dates to manage your inventory.
QuickBooks Desktop Enterprise lets you track inventory with serial numbers, lot numbers, with expiration dates when you turn on Advanced Inventory.
- Decide which to track
- Turn on serial or lot numbers
- Turn on expiration date
- Assign numbers to inventory
- Assign expiration date
- Status Report
- Frequently asked questions
Decide how you want to track your inventory
Before you start, decide if you want to track serial or lot numbers.You can only choose one.
Use serial numbers if you:
- Buy and sell inventory items with unique serial numbers.
- Keep track of which customers bought specific serial numbers.
- Want to know which serial numbers are in inventory.
- Need a report with invoices for a specific serial number. (This helps you track down a serial number's history for a warranty).
Use lot numbers if you:
- Buy items in lots.
- Keep track of which customers bought items from a specific lot.
- Need a recall report in case you have to track all the items from a specific lot. (Like which items are in inventory and who purchased them).
Note: Make sure you enter the serial or lot number to complete the transaction to avoid any errors.
Turn on serial or lot numbers to track your inventory items
- Select the Edit ▼ dropdown, then select Preferences.
- Select Items & Inventory, then select Company Preferences.
- Select Advanced Inventory Settings, then select Serial/Lot Number & Expiration Dates (if available).
- Select Activate Lot or Serial Numbers, then select Serial Numbers or Lot Numbers.
- Go to Show serial or lot number in and select the transaction types you want to show serial or lot numbers. QuickBooks adds a serial or lot number field to most purchase and sales forms including:
- Item receipts
- Bills
- Credit card transactions
- Checks
- Invoices
- Credit memos
- Sales orders and pending invoices
Make it mandatory to enter serial or lot numbers on invoices, sales receipts, item receipts, inventory transfers, and adjust quantity on hand. Go to For the selected transactions and select Make serial or lot number mandatory.
- Select OK.
If you already have a lot of inventory with serial numbers, you don't have to enter them into QuickBooks right away. Enter newly purchased items with serial numbers as you get them. Then, your company file will have all your serial numbers.
Turn on expiration date
You can pick specific serial or lot numbers based on expiration and sell the stock that’s soon to expire . As you get items, you can stop stock from going bad. Make it mandatory to fill in serial/lot numbers along with an expiration date.
After you turn on serial or lot numbers, turn on the expiration date to track your inventory items.
- Select Activate Expiration date.
- From Show expiration date in, choose what type of transactions you want to display the expiration date. QuickBooks adds an expiration date field to most purchase and sales forms including:
- Item receipts
- Bills
- Invoices
- Credit memos
- Sales orders and pending invoices
- Optional: Make it mandatory to enter serial or lot numbers on invoices, sales receipts, item receipts, inventory transfers, and adjust quantity on hand. Go to For the selected transactions and select Make serial or lot number mandatory.
If the expiration date is left out, it’ll result in an error message. - Select OK.
Assign serial/lot numbers to existing inventory
Make sure you have all the info about the serial or lot numbers with your current inventory on hand. You'll use Adjust Quantity/Value on Hand to assign serial or lot numbers to existing inventory.
Serial numbers
- Go to Inventory then select Adjust Quantity/Value on Hand.
- Select the Adjustment Type ▼ dropdown, then select Serial Number.
- Select the Adjustment Date.
- In the Item field, enter the item name, or select the small arrow ▼ and select it from the item list.
- In the Serial number column, select Quick view for Serial Numbers.
- Enter the serial numbers.
- Repeat steps 3 - 6 for each item.
- When finished, select Save & Close.
- To check your entries for mistakes., run the Serial/Lot Numbers in Inventory report.
You can paste serial numbers from Excel or a comma-separated values (CSV).
Excel/CSV files
- Copy the serial numbers from your Excel file.
- In the Item field, enter the item name, or select the small arrow▼ and select it from the list.
- Select the Add Serial Numbers column.
- Select the small arrow▼ and then select Quick View for Serial Numbers.
- From Excel: Right-click and select Paste, then OK.
From CSV: Paste the serial numbers directly into the Serial Numbers field. - Repeat as needed, then select Save & Close.
Lot numbers
- Go to Inventory then select Adjust Quantity/Value on Hand.
- Select the Adjustment Type ▼ dropdown, then select Lot Number.
- Select the Adjustment Date.
- In the Item field, enter the item name, or select the small arrow ▼ and select it from the item list.
- Enter the lot number in the Lot Number field.
- In the New Count column, enter the number of items in that lot.
Pro Tip: Repeat steps 4 and 5 to assign a different lot number to more of the same item, or to assign a different lot number to a different item. - When finished, select Save & Close.
- To confirm the accuracy of your entries, run the Serial/Lot Numbers in Inventory report.
Assign expiration date to existing serial or lot numbers
Use Adjust Quantity/Value on Hand to assign expiration date to serial or lot numbers.
Serial numbers
- Go to Inventory then select Adjust Quantity/Value on Hand.
- Select Adjustment Type ▼, then select Serial Number.
- Select your Adjustment Date.
- Enter the item name in the item field, or select the small arrow ▼ icon and select it from the item list.
- In the Serial number column, select Add multiple serial numbers.
- Select the serial numbers, enter expiration dates, and then select Yes, update .
- Repeat steps 4, 5 and 6 for each item.
- To confirm the accuracy of your entries, run the Serial Numbers in Stock report.
Lot numbers
- Go to Inventory then select Adjust Quantity/Value on Hand.
- Select Adjustment Type ▼, then select Lot Number.
- Select your Adjustment Date.
- Enter the item name in the item field, or select the small arrow ▼ icon and select it from the item list.
- Select the lot number from the Lot Number field.
- In the Expiration date column, enter the expiration date and then select Yes, update.
Pro Tip: To assign expiration date to a different lot number of the same item, or to assign a different lot number to a different item, repeat steps 4 and 5 as needed. - To confirm the accuracy of your entries, run the Lot Numbers in Stock report.
Use the Inventory Expiration Status Report
Inventory Expiration Status helps you track and monitor expired and expiring lots/serials in one place.
- Select Reports,and then Inventory
- Select Inventory Expiration Status
Note: To view inventory reports, turn on the Inventory and purchase orders are active checkbox in Items and Inventory Company Preferences.
This report includes your inventory lot/serial numbers along with the expiration date and days left to expire.
You’ll also be able to filter for:
- All items
- Already expired items
- Yet-to-expire items
- Custom date range
Frequently asked questions
What do Serial Numbers and Expiration date or Lot Numbers and Expiration date do in the New/Edit Item window?
Select this option to make any adjustments to the global warnings you set in preferences.
How do serial numbers and lot numbers appear on printed forms?
You can edit templates to add or remove serial and lot numbers on printed forms. Serial and lot numbers always appear on the display. On printed forms, multiple serial numbers appear in the description separated by commas. The lot number appears in its own column.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Use the Inventory Stock Status by Lot Number report in QuickBooks Enterprise 24.0by QuickBooks•1•Updated January 12, 2024
- Turn off Advanced Inventory in QuickBooks Desktopby QuickBooks•5•Updated June 25, 2024
- What’s new in QuickBooks Desktop 2023by QuickBooks•80•Updated May 13, 2024
- Import your accountant's changes into your company file in QuickBooks Desktopby QuickBooks•21•Updated July 03, 2024