How to capture Inventory value into P&L and Balance Sheet (New Vers.)

How To Capture Inventory Value Into P&L and Balance Sheet (New Vers.)

When it comes to a year end, we will normally do a cut-off on stock take and calculate the inventory value to be brought forward to the next financial year. This method is known as Periodic Inventory.

Let's illustrate the following scenario in your P&L:

Manual Journals

In order to achieve the chart above, there are 2 sets of journals have to be passed.

Closing Inventory

At the end of your financial year, pass a journal entry to capture your closing inventory. In the example above, your closing inventory is RM2,000.

1. Click on Accounting and select 'Journals'

(If you are not sure how to pass a journal please refer to, Inserting journals)

2. The double entry will be debiting the Inventory of a Balance Sheet account, and credit the Closing Inventory of a P&L account. Note that the date should be the last day of your financial year, i.e. 31/12/2017.

Dr Opening Inventory 2000 

Cr Inventory 2000

Opening Inventory

3. Now, after you have closed the inventory for previous year, you should also set an opening for the next financial year to bring forward the inventory value. The double entry will be debiting the Opening Inventory of a P&L account and credit the Inventory of a Balance Sheet account from the previous journal. Note that the date should be the first day of your new financial year, i.e. 1/1/2018.

Outcome

4. Click on accounting and select 'View Report'

5. Select 'Profit & Loss' report

6. When you review your P&L on year 2017, you should see the figure reflected on COGS as below:

7. This should be how it look like on year 2018 as opening.