Stock Inventory Template for Trading-Retail-StoreStock inventory template for Excel is a simple inventory spreadsheet to record and track flow of goods in your warehouse. Why is it called simple? Because it just count the number of outgoing and incoming goods and reveal its stock balance over particular period of time. It uses simple logic where you might already implement using Microsoft Excel by yourself. The difference maybe on its counting method and its function selection to count it.

In this spreadsheet, you will find four working worksheets. It should be applicable for one warehouse. To start using it, you need to define your stock names and their initial quantities. There are Minimum Order Quantity (MOQ) numbers that you may put to show particular color markers in Summary worksheet if their quantities fall below that number.

After you defined all of your stocks, you can see those names shown in Summary worksheet. You will see their balance categorized into several categories. Those are In, Out, Balance, Booked, Final Balance 1, On Delivery, Final Balance 2 and MOQ. They are explained as follows : [click to continue…]

{ 0 comments }

Inventory Manager for Rental BusinessInventory system for equipment rental business is a spreadsheet to organize your rental inventory. Different from managing inventory for trading business or store outlet, managing inventory for this type of business requires formulas to calculate returning equipment. And there are many rental business that might need this type of spreadsheet to manage their equipment. General example is a library. Librarian should fill two cards when one book is borrowed or returned. One card is a book card to record particular book balance. The other one is customer card to record books that are borrowed/returned by the customer. There are many cards that Librarian should maintain before computer system are available. Computer has helped to ease their recording jobs now.

Nowadays, there are many businesses that have similar business process with Library. People who works in those business needs to maintain their inventories carefully. It won’t be a problem if they manage only a few quantity and they are not having too much variation. Business that falls to this type of manageable rental business are wedding hall or sport court rentals. But, rental business like costume or cooking rental business can’t rely on manual recording. Especially when customers may book them in advance where you have to make sure the item is available for pickup on particular booked date. [click to continue…]

{ 0 comments }

Monthly Bill Payment Planner Template

Bill payment planner templates is an Excel spreadsheet to organize payment of your bills monthly. Different from budget spreadsheet, this template will allow you to assign date or day for your payment plan. Formulas in weekly worksheet will place them in respective dates or days. It should help you on organize your personal cash flow […]

Read the full article →

Cash Flow Planner Spreadsheet

Cash flow planner spreadsheet is a useful excel spreadsheet to organize your personal and company income and expenses in calendar visualization. This visualization will help you to see a clear picture of your money management within particular time period. Different from general budget spreadsheet, this spreadsheet will distribute your income and expenses based on dates […]

Read the full article →

Income Statement Template

Income Statement is a report to measure the company’s financial performance during particular accounting period. This report reflects the company’s operating activities. According to Van Horne and Wachowicz (2005: 193), the income statement is a summary of the company’s revenues and expenses over a certain period, concluded by net profit or loss for that period. […]

Read the full article →

Balance Sheet Template

Balance sheet is one important financial for every company. Accounting people creates this report at the end of accounting period. They create this report together with other important financial reports, income statement, equity report and cash flow statement. Balance sheet will present all the assets as well as the liabilities owned by the company. This […]

Read the full article →

Petty Cash Template

Petty Cash is a small amount of money reserved by a company for the payment of small expenses. Petty Cash is used for urgent/unexpected expenditures. However, the amount of expenditures that can be paid using Petty Cash is limited to each bookkeeping period. In a way, Petty Cash is an unexpected financing. General expenses that […]

Read the full article →

Savings Calculator

Savings calculator is a tool in Microsoft Excel to help you calculate the future value of your savings. It uses excel built-in financial functions. You can easily learn all formulas if you want to understand how it works. You must be able to manage your money in good way or you will lose lots of […]

Read the full article →