Managing your stock
Description

NOTE:

Stock is only available on Sage Accounting Plus. To upgrade, read how to upgrade your Sage subscription.

If you buy and sell products, hold enough stock to meet demand without tying up too much cash.

Accounting helps you manage stock and keep the right amount available for your customers. After you create your stock list, we update stock levels and record the value each time you buy or sell products.

Cause
Resolution

Enter opening stock balances

Before you use stock inventory in Accounting, make sure the value of any stock you already hold appears in Accounting.

  1. Enter a stock adjustment for the number of items you currently hold for each stock item. This keeps stock levels correct.
  2. Enter a journal for the total value of all your stocks between your stock account and suspense account. This keeps your stock value correct.
Stock (Balance sheet) Debit  
Suspense account (Profit and Loss)   Credit

Ask your accountant where to move this value at year-end.

Stock item records

Each record holds information about your stock item.

Access it by selecting an item from your stock list and then selecting Edit to make changes.



Stock movements

When you add stock items to invoices and credit notes, the stock record automatically updates stock levels and values.

Accounting records stock movements when you buy and sell stock.

The movement type shows whether you added or removed stock.

What are stock adjustments?

You use stock adjustments to change the number of items you have in stock. You typically use this to write off damaged stock or adjust quantities after a stock take.

Stock adjustments don't update the nominal ledger accounts.

When you first start using stock items, use adjustments to record how many items you currently have. The system then updates stock levels each time you add the item to a sales or purchase invoice.

Stock value

As well as tracking stock quantities, you need to record the value. Your stock value usually appears as a business asset on your Balance Sheet.

When you sell stock, it becomes a cost. It should appear on your Profit and Loss as a cost of sales. This ensures your Balance Sheet only shows the value of stock you still hold.

To record this, we recommend:

  1. Record stock purchases against an Asset ledger account. Set a default nominal ledger account on the stock record so each purchase posts correctly.
  2. When you sell stock, transfer the value of the sold stock from the Balance Sheet to the Profit and Loss using a journal. If you're unsure which nominal ledger account to use, contact your accountant for advice.

Alternatively, you can record stock purchases directly to your Profit and Loss. For details on how to do this, speak to your accountant or read our opening and closing stock guide.

Steps to duplicate
Related Solutions