Perpetual Inventory

As per the perpetual inventory system, accounting entry is done for every stock transaction. Otherwise, it's done in larger intervals for example monthly or quarterly. Each warehouse is linked with a corresponding account head.

On receipt of items in a particular warehouse, the balance in the Warehouse Account will increase. Similarly, when items are delivered from the Warehouse, an expense will be booked, and the balance in the Warehouse Account will reduce.

1. How to activate perpetual inventory

  1. Activate Perpetual Inventory:
  2. Home > Accounting > Company > Enable Perpetual Inventory
  3. Perpetual Inventory Note that if you disable perpetual inventory, users will have to manage the account entries manually.
  4. Set up the following default accounts for each Company if not set. These accounts are created automatically in the new TechoERP accounts.
  5. Default Inventory Account (Asset)
  6. Stock Received But Not Billed (Liability)
  7. Stock Adjustment Account (Expense)
  8. Expenses Included In Valuation (Expense)
  9. Cost Center
  10. If the user wants to set an individual account for each warehouse, create account head for each account. Go to:
  11. Accounts > Chart of Accounts > Company > Application of Funds (Assets) > Current Asset > Stock Assets > Create a new account with same name as Warehouse
  12. Now, go to a warehouse and link this account to the warehouse. This helps in filtering and viewing statements warehouse-wise.
  13. For stock transactions, general ledger entries made against the Account Head set on the warehouse, if the user had not set the account for the warehouse then the system gets the account head from the parent warehouse. If Account was not set for parent warehouse then the system gets the account(Default Inventory Account) from the company master.

2. Example

Consider the following Chart of Accounts and Warehouse setup for your company:

Chart of Accounts:

  1. Assets (Dr)
  2. Current Assets
  3. Accounts Receivable
  4. Debtors
  5. Stock Assets
  6. Stores
  7. Finished Goods
  8. Work In Progress
  9. Tax Assets
  10. VAT
  11. Liabilities (Cr)
  12. Current Liabilities
  13. Accounts Payable
  14. Creditors
  15. Stock Liabilities
  16. Stock Received But Not Billed
  17. Tax Liabilities
  18. Service Tax
  19. Income (Cr)
  20. Direct Income
  21. Sales Account
  22. Expenses (Dr)
  23. Direct Expenses
  24. Stock Expenses
  25. Cost of Goods Sold
  26. Expenses Included In Valuation
  27. Stock Adjustment
  28. Indirect Expenses
  29. Shipping Charges
  30. Customs Duty

2.1 Warehouse - Account Configuration

  1. Stores
  2. Work In Progress
  3. Finished Goods

2.2 Purchase Receipt

Suppose you have purchased 10 nos of item "RM0001" at $200 from supplier "Arcu Vel Quam Fabricators". Following are the details of Purchase Receipt:

Supplier: Arcu Vel Quam Fabricators

Items:

ItemWarehouseQtyRateAmountValuation Amount

RM0001

Stores

10

200

2000

2250

Taxes:

AccountAmountCategory

Shipping Charges

100

Total and Valuation

VAT (10%)

200

Total

Customs Duty

150

Valuation

Stock Ledger

Perpetual Inventory

General Ledger

Perpetual Inventory

As stock balance increases through Purchase Receipt, "Store" accounts are debited and a temporary account "Stock Receipt But Not Billed" account is credited, to maintain double-entry accounting system. At the same time, the negative expense is booked in account head having category as "Valuation" or "Total and Valuation" in taxes and charges table for the amount added for valuation purpose, to avoid double expense booking.

2.3 Purchase Invoice

On receiving Bill from supplier, for the above Purchase Receipt, you will make Purchase Invoice for the same. The general ledger entries are as follows:

General Ledger

Perpetual Inventory

Here "Stock Received But Not Billed" account is debited and nullified the effect of Purchase Receipt.

2.4 Delivery Note

Let's say, you have an order from "Utah Automation Services" to deliver 5 nos of item "RM0001" at $300. Following are the details of Delivery Note:

Customer: Utah Automation Services

Items:

ItemWarehouseQtyRateAmount

RM0001

Stores

5

300

1500

Taxes:

AccountAmount

Service Tax

150

VAT

100

Stock Ledger

Perpetual Inventory

General Ledger

Perpetual Inventory

As an item is delivered from "Stores" warehouse, "Stores" account is credited and an equal amount is debited to the expense account "Cost of Goods Sold". The debit/credit amount is equal to the total valuation amount (buying cost) of the selling items. And the valuation amount is calculated based on your preferred valuation method (FIFO / Moving Average) or actual cost of serialized items.

In this example, we have considered the valuation method as FIFO.

Valuation Rate  = Purchase Rate + Charges Included in Valuation

               = 200 + (250 / 10)

               = 225

Total Valuation Amount  = 220 * 5

                       = 1125

2.5 Sales Invoice with Update Stock

Let's say, you did not make Delivery Note against the above order and instead, you have made Sales Invoice directly, with "Update Stock" options. The details of the Sales Invoice are same as the above Delivery Note.

Stock Ledger

Perpetual Inventory

General Ledger

Perpetual Inventory

Here, apart from normal account entries for an invoice, "Stores" and "Cost of Goods Sold" accounts are also affected based on the valuation amount.

2.6 Stock Entry (Material Receipt)

Items:

ItemTarget WarehouseQtyRateAmount

RM0001

Stores

50

220

11000

Stock Ledger

Perpetual Inventory

General Ledger

Perpetual Inventory

2.7 Stock Entry (Material Issue)

Items:

ItemSource WarehouseQtyRateAmount

RM0001

Stores

10

220

2200

Stock Ledger

Perpetual Inventory

General Ledger

Perpetual Inventory

2.8 Stock Entry (Material Transfer)

Items:

ItemSource WarehouseTarget WarehouseQtyRateAmount

RM0001

Stores

Work In Progress

10

220

2200

Stock Ledger

Perpetual Inventory

General Ledger

Perpetual Inventory

  1. Accounting Of Inventory Stock
  2. Migrate to Perpetual Inventory