Managing your stock
Description

 NOTE: Note: This topic describes a premium feature. If you don't have it, see Growing your business with Sage to learn more about upgrading your subscription to turn on premium features. 

If you buy and sell products, you need to hold enough stock to meet demand, but not so much that it becomes costly and impacts cash flow. Accounting is a great tool for stock management, it can help you keep just the right amount available for your customers.

Once you've created your stock list, every time you buy and sell products, we'll automatically adjust stock levels and record the value for you.

Cause
Resolution

Enter opening stock balances

Before using stock inventory in Accounting you'll need to ensure the value of any stock that you already hold is represented in Accounting.

  • To make sure stock levels are correct, you need to enter a stock adjustment for the number of items you currently hold for each stock item.
  • To make sure your stock value is correct, enter a journal for the total value of all your stock between your stock account and your suspense account:
Stock (Balance sheet)Debit
Suspense account (Profit and Loss)
Credit

Ask your accountant for advice on where this value should be moved to at the end of the year.

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 stock items are added to invoices and credit notes, you'll see the stock levels and values update automatically within the stock record.

Accounting records stock movements when stock is bought and sold.

Each stock movement has a type which records whether stock was added or removed.

What are stock adjustments?

These are where you can manually adjust your stock levels to change the number of items you have in stock. You would generally use this to write off damaged stock, or to adjust quantities after a stock take.

This does not update the nominal ledger accounts.

When you first start using stock items, you can use adjustments to record the number of items you currently have. Your stock levels are then updated each time you add the item to a sales or purchase invoice.

Stock value

As well as keeping track of the number of items you have in stock, it’s also important to record their value. The value of your stock is usually shown as a business asset on your Balance Sheet.

When stock is sold it becomes a cost and should be represented on your Profit and Loss as a cost of sale. This is to make sure your Balance Sheet only reflects the value of Stock you still hold.

To record this, we recommend:

  1. The purchase of stock items are recorded against an Asset ledger account. You can set a default nominal ledger account on the stock record to make sure the purchase of items is recorded correctly.
  2. When stock is sold, you transfer the value of sold stock from the Balance Sheet to the Profit and Loss using a journal. If you’re not sure which nominal ledger accounts you should be using, we recommend you contact your Accountant for advice.

Alternatively, if you want to you can record the purchase of stock to your Profit & Loss. For more information about how to do this, please speak to your accountant or refer to our opening and closing stock guide.

[BCB:299:UKI - Personal content block - Dane:ECB]


[BCB:306:UKI - Search override - Accounting UK / IE:ECB]


[BCB:276:UKI - hide back button:ECB]
Steps to duplicate
Related Solutions