If you need the profit figure on your profit and loss report to take into account any unsold stock, you can do this either with simple opening and closing stock journals, or by using the Opening and Closing stock wizard. Let's take a look at each option.
The first time you post opening and closing stock journals, you need to create the following nominal codes if you don't have them already:
| N/C | Name | Section | Category | Information |
|---|---|---|---|---|
| 5200 | Opening Stock | Profit and Loss | Purchases | Holds the opening stock value at the start of the year. |
| 5201 | Closing Stock | Profit and Loss | Purchases | Holds the monthly opening and closing stock figures. |
| 1001 | Stock | Balance Sheet | Current Assets | Holds your stock value for the balance sheet. |
| N/C | Enter the nominal code number you want to use, for example, 5200. |
|---|---|
| Name | Enter the name of the account, for example, Opening Stock. |
Now you've created your nominal codes, you're ready to post the journals either manually or using the wizard.
| Date | Enter a date within the required month. All four journals are posted on the same date. |
|---|---|
| Reference | Enter your reference. |
| Details | Enter a description, for example, Opening Stock. |
| Stock nominal code (Balance sheet) | From the drop-down list, choose the required nominal code. By default, this is 1001. |
| Closing stock nominal code (Profit & Loss) | From the drop-down list, choose the required nominal code. By default, this is 5201. |
| Closing stock value | Enter your closing stock value, or to automatically calculate this value, click Calculate. It calculates by multiplying the quantity in stock by the average cost price for every product and is not date specific. In Sage 50 Accounts Professional, you can check this by running the Product Valuation by Stock Category report. |
| Previous closing stock value | Enter the previous closing stock value, this is also your opening stock value for the period. |
That's it, the wizard posts the relevant journals automatically.
If you prefer to post your journals manually, let's go through the postings for the first month and then subsequent months.
NOTE: If you have no opening stock value on the balance sheet, you can skip the opening stock journal and go to the next section, End of month 1 - Closing stock journal.
First we journal your opening stock value from the balance sheet, 1001, to the profit and loss, 5200.
| Nominal code | Name | Details | T/C | Debit | Credit |
|---|---|---|---|---|---|
| 1001 | Stock | Opening Stock | T9 | Value | |
| 5200 | Opening Stock | Opening Stock | T9 | Value |
To check the value shows in your opening stock you can run the Profit & loss report from the Nominal codes window.
Next we journal the value of your closing stock from the profit and loss, 5201, to the balance sheet, 1001.
| Nominal code | Name | Details | T/C | Debit | Credit |
|---|---|---|---|---|---|
| 5201 | Closing Stock | Closing stock | T9 | Value | |
| 1001 | Stock | Closing stock | T9 | Value |
To check the values you can run the Profit & loss report from the Nominal codes window.
From month 2 onwards, at the start of each month we journal the opening stock value from the balance sheet, 1001, to the profit and loss, 5201. The opening stock value is the closing stock value from the previous month.
| Nominal code | Name | Details | T/C | Debit | Credit |
|---|---|---|---|---|---|
| 1001 | Stock | Opening Stock | T9 | Value | |
| 5201 | Closing Stock | Opening Stock | T9 | Value |
To check the values you can run the Profit & loss report from the Nominal codes window.
From month 2 onwards, at the end of the month we journal the closing stock value profit and loss, 5201, to the balance sheet, 1001.
| Nominal code | Name | Details | T/C | Debit | Credit |
|---|---|---|---|---|---|
| 5201 | Closing Stock | Closing stock | T9 | Value | |
| 1001 | Stock | Closing Stock | T9 | Value |
To check the values you can run the Profit & loss report from the Nominal codes window.
When the Year end option is run, the balance on the profit and loss Opening Stock and Closing Stock nominal codes are cleared down to the retained earnings nominal code. This leaves the closing stock as an asset for the year on the Balance sheet report.
More support and information is available
Get the most out of your software, stay ahead with trending topics and get answers from thousands of articles using the Sage Knowledgebase. Visit the Help Centre >
More support and information is available
Get the most out of your software, stay ahead with trending topics and get answers from thousands of articles using the Sage Knowledgebase. Visit the Help Centre >
Upgrade your licence
Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.
