Compare periodic and perpetual inventory by asking when transactions enter the records, when accounting is updated and how a physical count is reconciled. Keep those questions separate. A continuously updated stock record still needs supporting transactions and count evidence, while an interval-based accounting process needs a clear owner for the updates between reporting points.
What does the distinction mean in the software being assessed?
ERPNext’s perpetual-inventory guide describes an accounting entry for each stock transaction. The same guide contrasts that with accounting updates at larger intervals. The ERPNext perpetual-inventory guide provides a specific application example of the accounting distinction.
Ask the finance and stock owners to describe the actual process in use. Which events are entered when goods move? Which entries affect the accounts? Who checks the result and when? Record those answers before selecting a software setting or importing opening records.
Do not infer the whole operating process from a single label. A team may be discussing transaction entry, financial posting or the timing of physical counts when it says “periodic”. Make the intended meaning explicit so the comparison addresses the decision the business actually needs to make.
Keep the reporting requirements with the appropriate owner. This article explains a software assessment and reconciliation exercise; the intervals mentioned in the publisher’s example are not a decision about the organisation’s accounting duties.
Which records should reconcile with one another?
The ERPNext Stock Ledger Report tracks stock movements. The report includes quantities and values of stock issued, received or transferred. Stock-ledger entries include the item and warehouse details. Use the ERPNext stock-ledger guide to identify the transaction history being examined.
Choose one item and one location for a controlled example. Identify the opening record, receipts, issues, transfers and the closing position you intend to inspect. Ask which of those transactions should also affect the relevant accounts under the chosen configuration.
For a hypothetical store, use a synthetic item called Test Carton. Define an opening quantity, a receipt and an issue as the proposed exercise. Keep the expected arithmetic separate from the result observed in the application. The purpose is to trace a sequence, not to infer that all real stock is correct from one sample.
A ledger voucher reference can open the transaction that created the entry. Follow that link when investigating a difference. Record whether the source document, the selected item, the location or the posting interpretation explains the result. A total without its contributing transactions is a weak basis for a correction.
How should warehouse and account mapping be checked?
In ERPNext’s described setup, a warehouse is linked to an account head. ERPNext’s documented inventory account lookup can fall back from warehouse to parent warehouse and then company default. In the proposed ERPNext assessment, ask the evaluator to show the actual mapping for the selected warehouse and the configuration it depends on.
Prepare a mapping note that identifies the warehouse, intended account relationship and responsible reviewer. Where a fallback is being used, make it visible rather than assuming that an empty field means the transaction has no account relationship.
Use a synthetic location to examine the proposed configuration before changing live mappings. Ask the finance owner what result is expected from the sample receipt and issue, then compare that expectation with the records created by the controlled exercise.
Keep the effect of a configuration change separate from an ordinary stock transaction. If the organisation is considering moving between accounting approaches, the migration decision needs a defined starting point, opening records and reconciliation plan. It should not be treated as a casual switch made during a product demonstration.
What does a physical count add?
A proposed physical-count exercise should identify the item, location, count boundary and person recording it. Ask how movements during the count are handled in the agreed process, so the reviewer knows which transactions belong to the comparison.
The ledger guide lists stock reconciliation among its transaction sources. When a count leads to a correction, keep the physical evidence and the reason for the entry together. An adjustment that makes two totals equal does not explain why they differed.
Separate a missing movement from an observed physical difference. For Test Carton, the reviewer might discover that a synthetic issue was omitted from the example sequence, or that a location filter was wrong. Those cases need a different response from a count that remains unexplained after the recorded movements have been checked.
Which comparison worksheet makes the decision clearer?
Use this original record-to-count comparison for the configured approach under consideration. Complete the same questions for each candidate process rather than assuming one label answers them all.
| Question | Evidence to inspect | Owner of the unresolved decision |
|---|---|---|
| When is a movement entered? | Source document and recorded event | Stock-process owner |
| When does accounting change? | Configured posting relationship and sample entry | Finance owner |
| Which location is represented? | Warehouse record and report filters | Inventory administrator |
| How is the period boundary set? | Agreed transaction inclusion rule | Finance and stock owners |
| What supports the count? | Recorded count scope and observations | Count reviewer |
| How is a difference corrected? | Investigation and authorised reconciliation entry | Appropriate approval owner |
| What happens between updates? | Outstanding transaction list and review procedure | Named operational owner |
The worksheet focuses on responsibility and evidence. It does not prescribe one inventory method for every business, and it avoids treating software automation as a substitute for an agreed accounting process.
The guide says disabling perpetual inventory requires manual entries to update the stock account balance. Include the manual responsibility in any assessment of that ERPNext option. Ask who prepares the required update, who reviews it and how an omitted update would become visible.
What should the handover contain?
Include an example of a transaction entered after the proposed reporting boundary. Ask the reviewer which comparison it belongs to and how that decision is explained. This gives the handover a concrete way to investigate timing differences without silently changing the original period definition.
Keep the agreed terminology, mapping note, sample transaction sequence and count evidence together. Record the configuration and period boundary used for the exercise, along with any unresolved differences and the person responsible for each.
Ask another reviewer to explain the result from those records. They should be able to identify the source transaction, the relevant stock movement and the accounting interpretation without relying on the person who performed the demonstration.
Use the broader inventory-control guide for the general movement process. See web development, or discuss your requirements with Spout using the completed comparison worksheet and the finance owner’s requirements.
By Spout Team. AI-assisted drafting by Codex using the linked primary documentation.