How to Set up Inventory Opening Balances in MYOB Premier

Want create site? Find Free WordPress Themes and plugins.

How to Setup Opening Inventory Quantities and Values

Now that you learn how to set up items and create links, you have to setup opening inventory quantities and the related value amounts in MYOB Premier to get all things started and to get in place recording for purchases and sales transactions. To start setup opening inventory quantities and values, you have to follow these steps:

1)     Count your inventory quantities and values and be sure that these figures are correct and reconciled for setup purposes as at the start of conversion date because you have to setup inventory values by using Count Inventory window.  Using Inventory Count Sheet  is also very helpful to make this task easy since you have to manually input your beginning inventory quantities.  To print Inventory Count Sheet, go to Reports menu below the Main Command Centre, the choose Inventory.

PIC1The Inventory Reports window appears with many ranges of reports to choose from.  Choose Inventory Count Sheet and print the countsheet.  Once you have printed, you can now indicate manually the inventory quantity balances and values in the printed reports.

PIC2

 

Now go to Inventory Command Centre and click on Count Inventory.  See screen below:

PIC3

Window for Count Inventory appears.  Now, key in the inventory quantities per inventory count sheet on the Counted portion on a per unit basis and not per Selling or Buying Units.  Take note that once you have entered the quantity in the Counted field, Difference show change in quantity corresponding to the quantity you key in.

Now, to illustrate this procedure, we take for example ABC Stationery Supplies with the following inventory count as at conversion date May 1, 2014:

Item No.

Item Name

Quantity

Unit Cost

Total Cost

Selling Price

OS0001 Office Supplies    500 S$12.00 S$ 6,000.00 S$25.00
OS0002 Office Supplies – Assorted 1,000     7.00      7,000.00     14.00
PP0001 Paper Products    155    12.00     1,860.00     25.00
PP0002 Paper Products – Assorted     461      1.00        461.00      2.50
Totals S$15,321.00

After key in of inventory quantities, the screen now show the entered inventory quantities as Difference so you have to click on Adjust Inventory to make adjustment for the variance vs. the On Hand quantity.  Screen after entering quantity of inventory items appear below:

PIC4

When clicking on Adjust Inventory, MYOB Premier prompts Adjustment Information and ask if you want to set a Default Adjustment Account for Inventory Adjustment.  Since this pertains to an opening inventory adjustment, you can proceed without indicating default adjustment account and click on Continue

PIC5

When you click on Continue, the following screen appears:

PIC6

Click on Opening Balances.  The inventory adjustment window appears with default inventory adjusting entry.  Please note that the Journal is an inventory journal with default adjusting entry to inventory account since this adjustment for Opening Balances.

Take note that the Unit Cost is indicated on this adjusting entry.  When the adjustment is correct, click Record to save the entry.

PIC7

Please note that discussion on entering inventory adjustments due to damage, shrinkage, loss or theft is taken up in the topic– How to Create  Inventory Adjustments in MYOB Premier.

 

 

 

 

 

 

Did you find apk for android? You can find new Free Android Games and apps.

You may also like