all your stock items, select the name of the vendor or supplier who you buy the item from (you might purchase from more than one vendor) and other important information. So, Install Java 8u45 or latter and install MySql to Operate Storekeeper. Sign Up No, Thank you. If you manufacture the stock item, you can leave the vendor columns blank. "No installation, no macros - just a simple spreadsheet" -. You can reveal and edit this list - to add more options to select from - by pointing your mouse to the tabs along the bottom, right clicking, and selecting " Unhide", then choose " ListSelections". Item #1, Item #2 etc. Once reported, our staff will be notified and the comment will be reviewed. Did you use stock in a promotion (like at a Fair)? . The, stock Details is for entering in the name and other important information for each stock item. Login To Rate This Project, user Ratings.0 out of 5 stars ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of. Get latest updates about Open Source Projects, Conferences and News. The spreadsheet includes a column for location, so items can be organized based on rooms in your home. It will be re-updated at the end of June and then reversed 1 July using the same steps as explained in all the info above, and doing this every single month. Download Excel Template, personal Inventory Template, like the home inventory template above, this template allows you to record personal belongings so that youre prepared in the event of a natural disaster or other emergency. Every time you make a purchase of stock You will enter the cost of the purchase into your Cost of Goods Sold account (which you can call Purchases with one of the following methods:- A purchase invoice (bill entering the. This sheet is linked to every Stock Item tab in this Excel workbook. This stock inventory control template can help you identify when its time to reorder stock, reduce excess inventory, access supplier information, and easily locate items in storage. . Continue reading after the download block for more information. First of all, if you live in a country where you report on, and pay sales tax, to your government, exclude the sales tax amounts from this spreadsheet. Category screenshots, user Reviews, current Version.0 out of 1 votes 5 star 0 4 star 0 3 star 0 2 star 0 1 star 1, all Versions.0 out. Zip Popularity Total Downloads 8,156 Downloads Last Week 5 Pricing License Model Purchase Limitations Not available Price 145 Report a problem Latest Stories. Light weight, project Samples, license, gNU General Public License version.0 (GPLv2). The employee training evaluation Drop Down List Transaction Types If you select a cell in the Transaction Type column, a field arrow will appear in the right-hand side of the cell. You need to set up three new accounts : - a " Stock on Hand" account on your Chart of Accounts under Assets (Current Asset) a " Closing Stock" account on your Chart of Accounts under Cost of Goods. Use " Stock Adjustment". Stay informed by checking out our reviews and get access to the latest news and exclusive offers. Journal entries for inventory To update the Balance Sheet and Income Statement If you are using bookkeeping software, you will enter two journals to bring the balances in to your accounts - you can learn about journals here or about debits and credits here. Leverage the barcode scanning feature to count items, confirm retrieval, and check price information, all from a mobile device.