If opening & closing stock value not showing/mismatched in P&L a/c and balance sheet, then how to resolve it?

Opening & closing stock value not showing/mismatched in P&L a/c and balance sheet

If opening & closing stock value not showing/mismatched in P&L a/c and balance sheet, then how to resolve it?


In SwilERP software, if the opening & closing stock is not available in profit & loss a/c and balance sheet, then users can edit the stock amount according to actual stock. This option is available in both P&L and Balance sheet forms. There, users can edit the stock amount according to the selected date range.

For example, if the closing stock as of 31st march is mismatched, then you can edit the closing stock amount with this option.

Start with login in SwilERP dashboard to initiate the process

  1. Go to the Reports Menu> Account Reports> Profit & loss Account.
  2. After that, a new window of Profit and Loss account will appear.
Reference image:
SwilERP Dashboard Window
  1. Select the Date Range from which you want to view the closing stock.
  2. Click on the View option.
  3. After that, all data under the Selected Date Range will display on screen.
  4. Now, if you want to see stock details, then click on the Closing Stock option.
Reference image:
Profit & Loss Account Window

How to Update Stock Details

  1. A new window of Product Wise Current Stock Details will appear in the next slide.
  2. The total stock details are shown in the Closing Stock column.
  3. Here users can update the stock details according to the actual stock. (For example, display stock amount is 5000 & the actual stock is 4500, then user can enter the actual stock amount here)

  4. Click on the Update Stock option to update it.

  5. And the entered stock amount will be updated in the Profit & Loss account.

Reference image:

Update Stock Window
Note: Once you update the stock details in the profit & Loss account, it will be automatically updated in the Balance sheet.
  1. Go to the Reports Menu> Account Reports> Balance Sheet.
  2. After that, select As on Date.
  3. Click on the View option and all data will displayed in the screen.
  4. Here you will see updated Closing Stock.
  5. Suppose you want to update stock directly from the balance sheet window. Then Closing stock option is also available here. Follow the same process as you followed in the P&L account.
Reference image:
Balance sheet Window



      • Related Articles

      • Balance Sheet

        How to View Balance Sheet in SwilERP (RetailGraph) Software What is Balance Sheet? A balance sheet is a pivotal financial statement delineating a company's assets and liabilities at a specific juncture. It underpins investor returns computation and ...
      • View Balance Sheet

        How to view Balance Sheet in SwilERP  What is Balance Sheet in SwilERP? A balance sheet tells you a business's worth at a given time, so you can better understand its financial position. Balance sheet states a business's assets and  liabilities at a ...
      • Why does closing stock not appear in Trial Balance?

        In SwilERP (RetailGraph) Software, Why does closing stock not appear in Trial Balance? While viewing the trial balance in SwilERP software, the closing stock does not appear in this. The question that occurs in the mind is why? Here is the answer ...
      • Trial Balance in SwilERP

        How to View Trial Balance in SwilERP Software The trial balance is a crucial accounting report that displays the closing balances of various general ledger accounts at a specific moment. It serves as the initial step in finalizing the books at the ...
      • Opening Stock Entry

        How to Add Opening Stock in SwilERP (RetailGraph) Software Opening Stock is the amount and value of materials a company has available for sale or use at the beginning of an accounting period. In SwilERP, you can add opening stock in your product. ...