Every company must have goods or services that are products to be sold to the market. Especially if the company is engaged in manufacturing and producing goods . Activities such as the entry and exit of goods according to need is a common thing. Fulfillment of this item occurs because of high demand or just the fulfillment of stock of goods. To manage the activity of entry and exit of goods, you must make a list of reports of goods in and out to provide convenience in the management process and monitor the availability of goods in the company.
Many companies ignore inventory management and report preparation. In fact, if the inventory is not suitable at the time of sale, the company can suffer losses. Therefore, you need to make a good and correct report. If you still find it difficult, you can make a report in and out of goods first. Although simple, it will help you manage merchandise inventory.
How to Make a Goods In and Out Report?
Making reports in and out of goods is now very easy. Especially with the presence of computer technology assistance, any process can be done quickly and automatically.
Things to consider when making a report:
· Prepare Data
Have someone specifically take responsibility for recording. This person must do it as accurately as possible. From here, you can find out data from the previous period and finally determine marketing targets and sales forecasts for the current period.
· Create F orecast
This estimate is made to record the amount of inventory needed in this period. You must specify it per item.
· Make a Check Before the Item Stored
Check before the goods are put on the shelf. Give a code on the item to find out whether or not the item is recorded. In this step, you can find out which items are defective, misplaced and other errors.
· Give Code to each item
If the customer, for example, asks about the stock of goods with an AA code, then you immediately know what items the customer intended. This code is also useful to help arrange items.
· Separate Old Stock with New Stock
This is done to make it easier for you to calculate the amount of old stock sold and not yet sold. You can also classify old and new items.
There are two ways to make reports in and out of goods, namely by using Excel or software. Both of these methods certainly have steps that can be applied easily to anyone or who do not really understand Excel or even software . The following steps are explained in making a report using tools:
1. Create Reports with E Xcel
- Create a new excelor sheet work paper and name it. Then you create a table with columns that are given the code title, item name, initial stock, entry, exit and final stock.
- Make headerby way of block all the columns that you have created, click the table on the menu i Nsert.
- Put a checklist(v) on the ” My tables has header ” option .
- Fill in the data in accordance with the data items in the company.
- Create a new worksheet (sheet)and name it “incoming goods”.
- Make 4 columns with name: date, code, item name, amount.
- Create a new worksheet (sheet)and name it “outgoing item”.
- Make the same column with step number 6 (date, code, item name, amount).
- Open or activate the “inbox” sheet. In the item name column give the excel formula “Vlookup”, this function is to bring up the item name if you type the item code.
- Do step number 9 on the sheet“goods out”.
- Open the “data item” sheet. In the “Enter” column enter the formula
- = Sumif (table6 [code], table8 [#thisrow], [code], table6 [number])
Information:
- Table6 [code] à select the code in the “incoming goods” sheet
- Table8 [this row] à select the code in the “item data” sheet
- Table6 [amount] à select the amount column in the “incoming goods” sheet
- In the final stock column, type the formula “initial stock” plus “in” and minus “out”.
Examples of Goods Data Tables
Examples of Incoming Goods or Outgoing Goods Tables
b. Create Reports with S oftware
Apart from Excel, you can also use software. Many accounting software that can be used to make reports in and out of goods. To be able to maximize every report you make, choose software with features that can provide convenience and accurate results.
However, the amount of software that can facilitate your work is not guaranteed quality and accuracy. Therefore, you can choose the Journal as an accounting software in making reports of goods in and out. The journal integrates the purchasing, sales and inventory sections automatically. You can check and get certainty and value of inventory accurately and realtime because the Journal will directly send notifications and inventory calculations directly if there is a change.
