Inventory Recording Methods

Businesses use inventory recording methods to track the value of inventory and determine the cost of goods sold (COGS). The two primary methods are the periodic inventory system and the perpetual inventory system. Each method differs in how and when inventory movements are recorded, and each has distinct benefits and drawbacks.

Periodic Inventory System

Under the periodic inventory system, inventory transactions are not recorded continuously. Purchases of inventory are recorded in a temporary account (such as Purchases), and the inventory balance is only updated at the end of an accounting period after a physical stock count.

COGS is calculated using the formula:

Opening Inventory + Purchases − Closing Inventory = Cost of Goods Sold

Benefits of the Periodic System

  • Simplicity: Easier to understand and maintain, particularly for smaller businesses.
  • Lower system and administrative costs: Does not require advanced software or real‑time tracking.
  • Suitable for low‑volume or low‑value inventory where real‑time accuracy is less critical.

Drawbacks of the Periodic System

  • Lack of real‑time inventory information: Stock levels and COGS are unknown until period end.
  • Greater risk of undetected losses: Theft, damage or errors may only be discovered during the physical count.
  • Less useful for management decision‑making due to delayed information.

Perpetual Inventory System

The perpetual inventory system records inventory movements continuously. Each purchase, sale, return or adjustment updates inventory and COGS in real time. This method is commonly integrated with Point of Sale (PoS) and accounting systems.

Benefits of the Perpetual System

  • Real‑time visibility of inventory quantities and values.
  • Improved accuracy in financial reporting and stock control.
  • Better loss prevention, as discrepancies can be detected quickly.
  • Supports automated reordering and operational efficiency.

Drawbacks of the Perpetual System

  • Higher setup and maintenance costs due to software and system requirements.
  • Greater reliance on system accuracy: errors in data entry or scanning can affect records.
  • More complex implementation, especially for small or non‑technical businesses.

Hybrid and Accrual‑Focused Processing in QuickEasy BOS

QuickEasy BOS lets businesses choose between periodic and perpetual inventory processing, depending on their operational and reporting needs. In addition, it supports a hybrid inventory model that combines elements of both approaches.

In this hybrid configuration:

  • Inventory‑related transactions (such as purchases) are posted to an accrual or interim inventory control account rather than being fully finalised immediately.
  • These postings are transferred to final inventory and COGS accounts based on transaction summaries.
  • Direct costs (such as outwork) and non-inventory items can be posted directly to COGS without affecting the other reports.
  • This approach provides operational flexibility, allowing real‑time transaction capture while still supporting period‑end review, reconciliation and adjustments.

Advantages of the Hybrid Approach

  • Balances control and flexibility by combining real‑time transaction capture with structured financial oversight.
  • Improves accuracy through additional review before final posting.
  • Aligns with accrual accounting principles, ensuring expenses and revenues are recognised in the correct period.
  • Scales well for growing businesses that need stronger controls without full system rigidity.
  • Reduces the number of inventory transactions that are posted to the ledger.

Inventory Valuation With the Weighted Average

Info

See Item Prices Explained for how the Stock Price and the weighted average are worked out.

QuickEasy BOS values the stock of each item and location at its Stock Price. The Stock Price can be entered manually, or kept up to date as a moving weighted average with the General Setting Inventory > Auto Update Stock Price (Weighted Average).

  • With the weighted average, each Goods Received or positive adjustment with a price updates the average: New Average = (Qty in stock x Average + Qty received x Cost) / (Qty in stock + Qty received).
  • Issues and write-offs are valued at the average, so the Inventory Report (Item Summary, stock reports) carries the actual stock value and the cost of the issues, as in a perpetual system.
  • Transaction Types with Pricing = Stock Price (for example, Goods Issued, Transfer Issue and Stock Adjustments) price their entries at the Stock Price, so issues to production or customers are posted at the stock value.
  • A backdated, cancelled or deleted transaction recalculates the average from its date and revalues the later issues. Saved transaction entries and accounting are not changed, except the issue entries of Transaction Types with Pricing = Stock Price.

Summary Comparison

Method Key Feature Best Suited For
PeriodicUpdates at period endSmall or low‑complexity businesses
PerpetualContinuous real‑time updatesHigh‑volume or data‑driven operations
Hybrid (QuickEasy BOS)Accrual posting with further processingBusinesses needing flexibility and control

How to Manage Inventory in QuickEasy BOS

Question Process
Q1: Do you physically control stock on hand?

Yes:

Go to Question 2.

No:

  1. Post Supplier Invoices directly to COGS (e.g. Dr COGS, Cr Supplier).
  2. If you have stock on hand at the end of a financial year (even if you do not physically control it), you must manually count that stock. You must then assign a value to it for tax purposes, depending on your country’s regulations. Accounting principle: COGS = Opening Stock + Purchases – Closing Stock.
Q2: Are all your purchases stock items?

Yes:

  1. Post Supplier Invoices to an accrual account (e.g. Dr Purchases Accrual, Cr Supplier).
  2. Set up Copy Rules to automatically create Goods Received transactions from the Supplier Invoices.
  3. Create Goods Issued transactions for goods transferred to production (Work Orders) or customers. You can use Copy Rules to create these transactions automatically.
  4. Create a periodic journal at the end of the month and transfer the balance of the accrual account to COGS and Inventory (e.g. Goods Issued = COGS. Goods Received less Goods Issued = Change in Stock on Hand).

No:

  1. Post the non-stock items (e.g. work outsourced) directly to COGS. Do not create inventory movement transactions for these items.
  2. Follow the steps under Yes above for the stock items.

Tip: To make it easier to know when to create inventory transactions, you can create separate purchase order and supplier invoice Transaction Types. The separate transactions let you automate creating the applicable inventory transactions.

Report an issue with this page

For more useful feedback, select the text on the page you are reporting on, then click Feedback again — or continue without selecting anything.