Perpetual Inventory Control Use this template to record the inventory status of a given part or item. Because there are relatively few formulas, this template can be used on paper as well as electronically. Enter the sheet number. The amount that should be carried forward to the next sheet and the next sheet number are at the bottom of the template. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next. Perpetual Inventory Control ITEM ITEM NUMBER SHEET NUMBER ORDERED RECEIVED SOLD DATE ORDER NO VENDOR QTY DATE QTY BACKORDER DUE DATE DATE ORDER NO QTY BALANCE COMMENTS BALANCE FORWARD CARRIED TO NEXT SHEET