TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







VIEW STOCK LEDGER REPORTS
VIEW STOCK ITEM LISTING
  
The Stock Item Listing will only include the sales documents (Invoices and Credit Notes) and the purchase documents (Purchase or Goods Received Notes and Stock or Goods Returned documents entered in the Input - Documents menu option and which posted or updated to the ledger. If you are using the Point-of Sales facility, only the Point-of Sales Invoices for Shifts, which have been closed, will be included in this report. Any Stock Adjustments processed in the Input - Adjust Stock menu option will also be displayed.

This report is generated on the Stock List Options screen on which the following options criteria for the details to be included in this report is selected:
  1. Sequence - To list the details for the selected stock items included in this report according to the Stock Item Code, Description or Stock Groups 1 or 2 if you have created Stock Groups.

  2. Stock Code - select a specific stock item code or a range of codes on the Stock Item search or lookup facility.

     

  3. Select to include information such as the Stock Count, Quantity on Hand, Average Cost, Cost Prices and Selling Prices.
This report lists the accumulative quantities and stock values as well as any latest and average cost prices and the selling prices for the Invoices, Credit Notes, Purchases and Stock or Goods Returned documents, which is updated to the ledger. You may also select to list the selling prices of a selected or a range of stock items (price list). An example of the Stock Item Listing, is as follows:

Name of the business. System date and time. Name of the report. Stock Item code. Description or name for the Stock Item. Unit in which the Stock Item is traded. Quantity on Hand as updated in the Input - Stock Adjustments and when Documents are updated to the ledger. One of the 3 selected Selling Prices (VAT - Excluded) as entered in the Edit - Stock Items or adjusted in the Input - Adjust Stock Items (Selling Prices) menu options. The total value of the Stock at cost price. Page number. Latest Cost Price as updated in the Input - Adjust Stock (Take-on and/or Adjusted) and/or in the Input - Documents menu option. Average Cost Price as updated in the Input - Adjust Stock (Take-on and/or Adjusted) and/or in the Input - Documents menu option. Stock Count column is blank for stock taking purposes. Quantities may be entered as on the shelves. Discrepancies in quantities on hand need to be adjusted in the Input - Adjust Stock menu option. This is the quantities on hand x the Cost Price (Latest or Average Cost - depending on the Use Cost Price method selected).

The number of columns in which the information will be displayed, depends on the selected information to include. This report displays the information for if all the information to include is selected and one selling price in the following 9 columns.
  1. Stock Code - The selected Stock Item code will be displayed.

  2. Description - The name or description of the selected Stock Item code.

  3. Unit - This is the selected unit (each, litres, boxes, etc. in which stock items are traded as defined in the Setup - System Parameters - Stock Information menu option and as selected for each Stock item in the Edit - Stock Items menu option.

  4. Qty On Hand - This is updated when opening stock quantities and cost prices were taken on in the Input - Adjust Stock (Take-on tab) menu option and when documents are updated to the ledger. Purchases and Credit Notes as well as any adjustments, which increases the Stock quantities (stock in), will update the quantity on hand as a positive quantity. Invoices and Goods Returned documents as well as any adjustments, will decrease the Stock quantities (stock out).

  5. Latest Cost Price - This is the latest cost price (excluding VAT) for each unit of a Stock Item as entered on the last Purchase or Goods Received Documents, which is updated to the ledger.

  6. Average Cost Price - This is the average cost price (excluding VAT) for each unit of a Stock Item of the Stock items purchased. This may differ from the latest cost price if you have purchased a stock item for which a higher or lower price was entered on Purchase or Goods Received Documents, which is updated to the ledger.

  7. Sell Price - If you have selected to view No selling prices, this column will not be displayed. You may select to view any of one the available 3 selling prices, with any combination of the information included in this report. Should you select to view all 3 selling prices, you may only select to include the Quantities on Hand. The selling prices (up to 3 selling prices) which may be displayed on this report are entered in the Edit - Stock Items menu option or as adjusted on the Input - Adjust Stock (Selling Prices tab) menu option.

  8. Stock Count - This column is blank. This enables you to enter (write) the physical stock count when you do stock taking on the printed item listing. Once this is done, you need to adjust the stock quantities in the Quantity and Average Cost or Quantity and Latest Cost options of the Input - Adjust Stock menu option, if the Stock Count Quantities are not the same as that of the System Quantities on Hand.

  9. Stock Value - This is updated when opening stock quantities and cost prices were taken on in the Input - Adjust Stock (Take-on tab) and when documents are updated to the ledger. Purchases and Credit Notes as well as any adjustments will increase the stock value with the cost prices. Invoices and Goods Returned documents as well as any adjustments will decrease the stock value with the cost prices.
An example of the Stock Item Listing reflecting the Selling Prices, is as follows:

Name of the business. System date and time. Name of the report. Stock Item code. Description or name for the Stock Item. Unit in which the Stock Item is traded. Quantity on Hand as updated in the Input - Stock Adjustments and when Documents are updated to the ledger. Up to 3 Selling Prices (VAT - Excluded) as entered in the Edit - Stock Items or adjusted in the Input - Adjust Stock Items (Selling Prices) menu options. The total value of the Stock at cost price. Stock Count column is blank for stock taking purposes. Quantities may be entered as on the shelves. Discrepancies in quantities on hand need to be adjusted in the Input - Adjust Stock menu option. This is the quantities on hand x the Cost Price (Latest or Average Cost - depending on the Use Cost Price method selected). Page number.


No quantities on the Stock Item Listing should reflect a negative quantity. If a quantity is displayed as a negative quantity, it could indicate that the Opening Quantities and Cost were not taken on in the Input - Adjust Stock (Take-on tab) menu option that Purchase or Goods Received Notes and Credit Notes are not yet updated to the ledger.