In the 'Expiration Date' column, the cells will turn red in the rows that contain items that have expired. At the top of this column, today's date will display. The template also has a column where you can track the expiration date of your items. The template has a place for you to record these amounts, in columns D and E. Columns for 'On Order', Max Quantity', and 'Expiration Date'īeyond knowing how many of each item you have in stock, you may also want to track how many of each item that you have on order, and the maximum quantity for each item. If you would like you can also enter the 'Item ID' for your items. In columns A, B, and C, you can enter the names of your inventory items, as well as the quantities that you have for each item. Enter basic information into columns A, B, and C The other columns can be ignored or hidden if they do not apply to your needs. Remember that only the first three columns in the template are essential. Below are instructions on where to enter different types of information into the template. There is a wide range of information that you can track in the Google Sheets inventory template. Entering items and other information into the inventory template