- #Home inventory spreadsheet google docs how to
- #Home inventory spreadsheet google docs update
- #Home inventory spreadsheet google docs download
If a maximum quantity is entered, and if there are more items in inventory than the maximum quantity, this indication will say "Overstocked" and the cell will be blue. If there are 0 of a certain item, this indication will say "Out of Stock" and the cell will be red. If there are 1 or more of a certain item, this indication will say "In Stock" and the cell will be green. Stock Status: This column shows whether each item is in stock or not, based on the enter quantities Quantity + Order: This total shows you the current quantity of items that you have, added to the quantity of items that are on order Order Needs: This column will show you how many items should be ordered to reach the maximum quantity for an item (Considering the current amount in stock) View detailed totals and stock statusĪfter you have entered the item information / amounts, you can view the totals and status indications in columns G through K. 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. Get home insurance quotes by filling out our online form, messaging us on LiveChat, or calling us.Entering items and other information into the inventory template
#Home inventory spreadsheet google docs update
It’s also important to remember to update your inventory regularly to make sure you’re including all of your treasures in it. Update your inventory in Google Drive regularly. You can drop pictures into your Inventory folder super easily. Google Drive automatically saves your work as you go along, so you don’t have to worry about losing anything. Then you’ll have to type in all the belongings in that room to keep track of everything. Add the belongings that are in that room to your list. Then title your new document or spreadsheet with the name of the room that you’re inventorying. Click “New” again and choose either New Doc (which is like Word) or New Sheet (which is like Excel.)Ĭhoose whether you’d rather use a blank document (Doc) to make your inventory or a spreadsheet (Sheet). Double click on the new folder you’ve created. Title it something that makes sense for an inventory, like “Unicorns.” (That was a joke.) 3. This will create a brand-new folder in your Google Drive account. When you click the “New” button, select Folder.
Then you can just launch it from your phone and wander around your house easily.
#Home inventory spreadsheet google docs download
To make yourself more mobile, you can download the Google apps (Google Drive, Google Sheets, and Google Docs) on your phone for the free. If you don’t have a Google account or a Gmail…well, get one.
#Home inventory spreadsheet google docs how to
How to take a home inventory with Google Drive.
We’ll explain how to use Google Drive to take your home inventory. But what if we told you that you could employ a readily accessible technology to make the pain-in-the-butt task easier? It’s this magical thing called Google Drive. Okay, okay, we get it – taking a home inventory is probably not something you’re psyched up to do, even if you know that a home inventory is important for your home insurance.
0 kommentar(er)
