Periodic Accounting Entry
When Perpetual Inventory is disabled for a Company, ERPNext does not automatically create General Ledger (GL) entries for stock transactions. Instead, businesses must periodically reconcile inventory values and manually post accounting entries to keep stock asset accounts aligned with actual inventory.
To simplify this process, ERPNext Version 16 introduces the Periodic Accounting Entry Journal Entry type. It automatically calculates the adjustment amount by comparing inventory values, eliminating the need for manual calculations.
Periodic Accounting Entry is intended for companies that use the Periodic Inventory method. If Perpetual Inventory is enabled, ERPNext automatically creates inventory accounting entries for every stock transaction, making this Journal Entry type unnecessary.
1. Why Use Periodic Accounting Entry?
Under the Periodic Inventory method, businesses typically create inventory adjustment entries at the end of an accounting period such as a month, quarter, or financial year.
Traditionally, this requires manually comparing:
- The closing inventory value from the Stock Balance Report.
- The balance of Stock Asset accounts in the Trial Balance.
Any difference between these values must then be posted using a Journal Entry.
- Stock Balance Report shows inventory worth $250,000.
- Trial Balance shows the Stock Asset Account balance as $245,000.
- The difference of $5,000 must be posted as an inventory adjustment.
With the Periodic Accounting Entry, ERPNext calculates this difference automatically.
2. Creating a Periodic Accounting Entry
- Create a new Journal Entry.
- Select Periodic Accounting Entry as the Journal Entry Type.
- Select the Company and Posting Date.
- Click Get Balance.
- Review the automatically generated adjustment entries.
- Save and Submit the Journal Entry.
3. Automatic Balance Calculation
When you click Get Balance, ERPNext automatically:
- Retrieves the inventory value from the Stock Ledger.
- Compares it with the Stock Asset Account balance.
- Calculates the difference between the two values.
- Creates the required Journal Entry lines for adjustment.
Always review the generated Journal Entry before submitting it to ensure the adjustment aligns with your organization’s accounting policies.
4. Benefits
- Eliminates manual inventory reconciliation calculations.
- Automatically identifies differences between inventory and accounting balances.
- Reduces the risk of calculation errors.
- Saves time during month-end and year-end closing.
- Simplifies inventory accounting for companies using the Periodic Inventory method.
Summary
The Periodic Accounting Entry feature in ERPNext Version 16 simplifies inventory reconciliation for companies that use the Periodic Inventory method. Instead of manually comparing reports and calculating adjustment amounts, users can create a Journal Entry, click Get Balance, and let ERPNext automatically generate the required inventory adjustment entries.
