How to Calculate and Record COGS Under a Periodic Inventory System
Calculating cost of goods sold at period-end using the periodic method: opening inventory plus purchases minus closing inventory.
| Account Name | Type | Debit ($) | Credit ($) |
|---|---|---|---|
| Cost of Goods Sold | Expense (+) | 45,000.00 | - |
| Merchandise Inventory (Closing Balance) | Asset (-) | - | 45,000.00 |
💡 Accountant's Note
Under the periodic system, COGS = Opening Inventory + Purchases - Closing Inventory. The closing inventory figure comes from the physical count. COGS is calculated and recorded as one entry at period-end.
Practitioner & Systems Framework
💻 ERP Architecture
The periodic system is simpler but provides less real-time inventory control than perpetual. It requires a physical count at each period-end to determine closing inventory. COGS is calculated as a residual (opening + purchases − closing) rather than tracked per transaction. Most modern retail ERP systems use perpetual — periodic is more common in smaller operations without barcode/POS integration.
⚠️ Audit Flags
The closing inventory count is the foundation of the COGS calculation in the periodic system — any error in the count directly flows to COGS. Auditors will observe or independently verify the physical count. The COGS figure cannot be independently validated at the transaction level (unlike perpetual), making the count even more critical.
📄 Required Documentation
Opening inventory balance, all purchase invoices for the period, physical closing count sheets (signed and dated), COGS calculation (opening + purchases − closing = COGS), and auditor count observation record.
Automate this entry with the JEH Accounting Suite
Stop doing manual entry. Our VBA-powered ERP automatically generates your ledgers, Trial Balance, and Financial Statements.
No Subscriptions. Own your data.
Expert Analysis by Qusai Ahmad
General Accountant Supervisor & IFRS Specialist
Specialized in SAP GUI automation and Middle Eastern tax compliance. Building digital tools for the next generation of finance leaders.