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 ACTIVITY REPORT
  
The Stock Activity Report 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.

This report is generated on the Stock Activity 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 whether to print each stock item on a new page.
This report summarises or lists quantities and Sales amount and the Cost Price (average or latest cost), the Gross Profit Percentage for This Year for each accounting period or month in the financial year. The number of Accounting Periods in a Financial Year is usually 12, unless you have selected the number of Accounting Periods to be 12 or any number less than 12 in the Setup - System Parameters - Reporting Dates menu option. If you have processed documents in the previous financial year, the Stock movements will also be displayed for Last Year. An example of the Stock Activity report reflecting the details, is as follows:

Name of the business. System date and time. Page number. Name of the report. Quantities of Stock Items sold during This Year periods. Stock Item code and description or name. Accounting periods as set in the Setup Reporting Dates menu option. Quantities of Stock Items sold during This Year periods. Total Selling Price (excluding VAT) of Stock Items sold during an Accounting Period in This Year. The Quantities, Selling Prices and Cost Prices as well as the Gross Profit % of Stock Items sold during an Accounting Period in This Year. Total Cost Price (excluding VAT) of Stock Items sold during an Accounting Period in This Year. Gross profit (Selling Price less Cost Price) percentage of Stock Items sold during an Accounting Period in This Year. Quantities of Stock Items sold during Last Year periods. Total Selling Price (excluding VAT) of Stock Items sold during an Accounting Period in Last Year. Total Cost Price (excluding VAT) of Stock Items sold during an Accounting Period in Last Year. Gross profit (Selling Price less Cost Price) percentage of Stock Items sold during an Accounting Period in Last Year. Total Selling Price (excluding VAT) of Stock Items sold during an Accounting Period in This Year. The Quantities, Selling Prices and Cost Prices as well as the Gross Profit % of Stock Items sold during an Accounting Period in Last Year. Stock Item code and description or name. Accounting periods as set in the Setup Reporting Dates menu option. Quantities of Stock Items sold during This Year periods. Total Selling Price (excluding VAT) of Stock Items sold during an Accounting Period in This Year.

The detail for this report is displayed in 9 columns. The first column is the Accounting Periods and the next 4 columns display the Quantity, Amount, Cost Price and Gross Profit for the Items sold This Year. The last 4 columns displays the quantity, amount, cost price and gross Profit for the Items sold Last Year. The details in the columns is as follows:
  1. Stock Item and Periods - The Stock Item code and description will be displayed as headings. The periods as set up or entered in the Setup - System Parameters - Reporting Dates menu option will be listed.

    Sold this year

  2. Quantity - This is the total net quantity of the Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the current financial year (This Year).

  3. Amount - This is the total amount or value of the selling prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the current financial year (This Year).

  4. Cost - This is the total amount or value of the cost prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the current financial year (This Year). These cost prices may be based on the Average or Latest Cost depending on the parameters and settings for Cost of Sales.

  5. GP% - Gross Profit Percentage - This is the Amount (selling prices) less the Cost amount displayed as a percentage.

    Sold last year.

  6. Quantity - This is the total net quantity of the Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the previous financial year (Last Year).

  7. Amount - This is the total amount or value of the selling prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the previous financial year (Last Year).

  8. Cost - This is the total amount or value of the cost prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the previous financial year (Last Year). These cost prices may be based on the Average or Latest Cost depending on the parameters and settings for Cost of Sales.

  9. GP% - Gross Profit Percentage - This is the Amount (selling prices) less the Cost amount displayed as a percentage.
These amounts or totals are exclusive of VAT.

The last 4 columns - Sold last year will only display quantities, amounts and gross profit percentages, if you have closed a financial year in the Tools - Global Processes - Do Year-end menu option.