ANSWER Answer ID:9172Image Removed Periodical inventory is a system of accounting for inventory whereby where the goods on hand are determined only determined by a physical count, and the cost of goods sold equals opening inventory plus net purchases, less closing inventory. This support note explains how you can implement periodical inventory in your company file. Before implementing this method it is advisable to check with your accountant as to its suitability for your business. Do not use this system if you want your software to track inventory for you using a perpetual inventory system. [Australia only]Note: To get the most out of your software for managing inventory, learn from an expert in our Inventory Management training course! How can I account for inventory under a periodical inventory system?There are two methods you can choose from and these are described below. Method 1: Show the Purchases account only in the Profit and Loss statementCreate . Unlike perpetual inventory systems, where inventory updates are made on a continuous basis, periodical inventory might be useful if you maintain minimal amounts of inventory and a physical inventory count is easy to complete. Before implementing periodical inventory, you should discuss its suitability with your accounting advisor. Using the periodical inventory system, when stock is purchased it's immediately expensed to a cost of sales account. When stock is sold, there is no entry to cost of sales. In order to be able to report the value of stock you have on hand, end of period journals must be recorded. Here are two methods you can use based on how much detail you want to show in the cost of sales section of your Profit & Loss Statement. UI Expand |
---|
title | To show the purchases account only in the Profit & Loss Statement |
---|
| - Create two accounts:
- a Stock On Hand (Asset) account
| and - a Purchases (Cost of Sales) account.
| Both accounts should be Detail Accounts.Create the inventory items and The linked - for the Expense Account for Tracking Costs
| must be the - select the Purchases (Cost of Sales) account.
Select a relevant Income
| account tracking sales. Image Removed Note: If at the This means that when stock is purchased, it is immediately expensed to the cost of sales account. When stock is sold, there is no entry to cost of sales. In order to be able to report the value of stock you have on hand, end of period journals must be recorded. This is discussed below. - At the beginning of the financial year
| there is - , if there's a balance in the Stock On Hand account you need to prepare a
| General Journal to - :
- debit the Purchases (Cost of Sales) account
| and - credit the Stock On Hand (Asset) account
| . The - the amount entered needs to be the value of the Stock on Hand as at the end of the previous financial year
| .[Australia only]Image Removed [New Zealand only]Image Removed - Here's our example: Image Added The effect of the general journal entry will leave the account with a zero balance.
- At the end of the financial reporting period,
| in other words Month, Quarter or Year, you need to make - make an adjustment to the Purchases (Cost of Sales) account to reflect the value of stock still on hand.
| First, perform a stock-take - Perform a stocktake and accurately value the stock on hand at the end of the financial reporting period.
| Then, prepare a General Journal stock-take. Debit - stocktake:
- debit the Stock on Hand (Asset) account
| and - credit the Purchases (Cost of Sales) account
| for - the amount entered should be the value determined in the
| stock-take. [Australia only]Image Removed [New Zealand only]Image Removed - stocktake. Here's our example: Image Added
- Print the Profit & Loss Statement and Balance Sheet reports.
- On the first day of the next financial period, prepare a
| General Journal Entry Closing Stock - closing stock adjustment.
| Debit - debit the Purchases (Cost of Sales) account
| and - credit the Stock on Hand (Asset) account
| for - the amount entered should be for the same value entered in Step 4.
|
[Australia only]Image Removed [New Zealand only]Image Removed - Image Added
After the journal entry has been performed, the Stock on Hand (Asset) account should be returned to a $0 balance. At the end of future financial reporting periods, repeat Steps 4 and 5 to accurately reflect the true Cost of Sales figure in your Profit & Loss Statement and show the value of stock on hand in the Balance Sheet. |
Method 2: Show the opening and closing stock accounts in the Profit and Loss StatementNew AccountRight (v2011 and later) only: The Year-End Adjustments functionality replaced the need to use 13 accounting periods. Simply complete the steps below to UI Expand |
---|
title | To show the opening and closing stock accounts in the Profit |
---|
| and .Classic AccountRight (v19 and earlier) and AccountEdge only: To use this method, the company file must be set up as having 13 accounting periods per year. To check if you have 13 accounting periods you need to go to the Setup menu and choose Company Information. If your company file is set to 12 Accounting periods, you will not be able to use this method until you Start a New Year and change the number of periods to 13. account- Closing Stock (Cost of Sales)
| account-
- Purchases (Cost of Sales)
| account- Stock on Hand (Asset) account
| Note: All accounts should be Detail Accounts.Create the inventory items and . The linked - for the Expense Account for Tracking Costs
| must be the - select the Purchases (Cost of Sales) account
| . Select account for tracking sales.- Account for Tracking Sales
- At the beginning of the
| fiscal General Journal - journal entry to show the Opening Stock balance in the Profit and Loss statement
| . Debit - :
- debit the Opening Stock (Cost of Sales) account
| for the amount that was shown as in the 30th of June Balance Sheet and credit the Stock on Hand (Asset) account. [Australia only]Image Removed [New Zealand only]Image Removed - (Asset) account
- the amount entered should be the value shown as Stock on Hand in the Balance Sheet. Here's our example: Image Added
- During the month, record your purchases and sales as per usual. Make sure that the allocation account used for Service purchases is the Purchases (Cost of Sales) account.
- On the last day of the month, perform a
| stock-take the level of stock . Enter a General Journal the level of stock on hand at the end of the month. Debit the - this:
- debit the Stock on Hand (Asset) account
| for the amount determined in the stock-take and - credit the Closing Stock (Cost of Sales) account
- the amount entered should be the value determined in your stocktake.
|
[Australia only]Image Removed [New Zealand only]Image Removed - Here's our example: Image Added
- On the first day of the next month, create a
| General Journal . Debit - :
- debit the Opening Stock (Cost of Sales) account
| for the same amounts entered as the previous month's closing stock and - credit the Stock on Hand (Asset) account
- the amount entered should be the previous month's closing stock value.
|
[Australia only]Image Removed [New Zealand only]Image Removed New AccountRight (v2011 and later): Prepare a Year-End Adjustment - Here's our example: Image Added
- Enter a year-end adjustment to reverse the impact on the opening stock and closing stock expense accounts.
| If this is not done, the opening and closing stock will increase every time an end of month journal entry is entered. To correct this, you need to - debit the Closing Stock (Cost of Sales) account
| for the same amount as entered in steps 5 and 6 and - credit the Opening Stock (Cost of Sales) account
| .[Australia only]Image Removed [New Zealand only]Image Removed AccountRight v19 and AccountEdge only: Prepare a '13th period adjustment' to reverse the impact on the opening stock and closing stock expense accounts. If the 13th period adjustment is not done, the opening and closing stock will increase every time an end of month journal entry is entered. To correct this, you need to debit the Closing Stock (Cost of Sales) account for the and credit the Opening Stock (Cost of Sales) account. [Australia only]Image Removed [New Zealand only]Image Removed Notes: - The journal entry must be a Year-End Adjustment (new AccountRight only), or a '13th period adjustment' (with an asterisk (*) entered before the date) and the date should be the first day of the next period (such as the first day of the next month as used in our example above).
- By entering this adjustment as a Year-End Adjustment or a 13th period transaction, the adjustment will be isolated from normal trading transactions and can be included or excluded from your Profit and Loss report.
- The 'Cost of Sales' figures are now correct and you will now be able to produce accurate monthly Profit and Loss and balance sheet reports. In order to reflect the true 'Year to Date' figures for your Profit and Loss reports you must filter the report to include Year-End Adjustments/13th period adjustments.
How 13th period transactions are reported (not applicable for the new AccountRight)13th period transactions can be reported by themselves, or they can be included with the conventionally dated transactions on a YTD basis. When filtering reports and transaction listing, you will need to be mindful that the 13th period transactions won't be included if an asterisk isn't used in the report Date field. 13th period transactions can be reported by themselves, or they can be included with the conventionally dated transactions. However when viewing 13th period transactions along with conventional dated ones they will only be shown as part of a YTD value. Reporting transactions in both the conventional twelve periods AND the 13th period will reflect 13th period entries in the YTD balance regardless of the To date selected. It will not reflect partial months/partial years of 13th period entries. The 13th period cannot be reported as part of normal daily, weekly or monthly P&L and can only be reported on its own or as part of a YTD value. To report transactions in both the conventional twelve periods AND the 13th period:Enter an asterisk in the To Date field ONLY. To report transactions within the conventional twelve periods:DO NOT enter an asterisk in either of the Date fields. To report transactions within the 13th period ONLY:Enter an asterisk in BOTH the From and To Date fields. How Year-End Adjustments are reported (new AccountRight only)Year-End Adjustments can be reported by themselves, or they can be included with other transactions. As shown in the example below, when filtering reports you have the option to: - display all transactions
- exclude Year-End Adjustments
- Display only Year-End Adjustments
Image Removed 'I Buy', 'I Sell', 'I Inventory' and Linked Accounts Entering transactions in the 13th period and Year-End Adjustments |