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 PURCHASE ANALYSIS REPORTS
VIEW PURCHASES BY PRODUCT REPORT
  
The Purchases by Product report will only include the 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.

This report is generated on the Purchases by Product 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 Items - any available stock item or a range of stock items on the Stock Item search or lookup facility.

     

  3. Dates - enter or select the date or dates (using the Date picker) for the detail you wish to include in this report.

  4. Select whether to include detail or only a summary of the transactions.
This report summarises or lists all the Purchase and Stock or Goods Returned documents for each Stock Item within a selected period or range of dates. You will be able to analyse the purchase and returns totals for each selected stock item. An example of the Purchases by Product report reflecting the details, is as follows:

Name of the business. Name of report. Selected date or dates for which transactions are included in this report. System date and time. Page number. Stock Item code and description or name. The Purchase and Goods Returned document number. Document or transaction date. Cost Price (Exclusive of VAT). Total for the Stock Item. Grand total of the Purchases for the selected Stock Items included in this report. The Purchase and Goods Returned document number. Stock Item code and description or name. Document or transaction date. Cost Price (Exclusive of VAT). Cost Price (Exclusive of VAT). Cost Price (Exclusive of VAT). Total for the Stock Item. The Purchase and Goods Returned document number. Quantity of Stock Items purchased or returned. Quantity of Stock Items purchased or returned.

This report consists of 8 columns reflecting the following information for each selected Stock Items:
  1. Stock Item Code - The selected stock item code or numbers will be displayed. This report will be listed according to the selected Stock Item Codes.

  2. Purchase Number - The Purchase and Stock or Goods Returned document number as generated by TurboCASH. The Description or name of the Stock Items will be displayed as headings.

  3. Purchase Date - The date when the Purchase and Stock or Goods Returned documents were generated.

  4. Quantity - The quantity of Stock Items as entered on a Purchase and Stock or Goods Returned document.

  5. Purchase Amount - This is the total amount of the Cost or Purchase price for all the selected stock items on the Purchase and Stock or Goods Returned documents.

  6. Net Cost Amount - This is the total amount of the Cost or Purchase price for all the selected stock items on the Purchase and Stock or Goods Returned documents.

  7. Gross Profit - Not applicable to the Purchase and Stock or Goods Returned documents.

  8. Gross Profit % - Not applicable to the Purchase and Stock or Goods Returned documents.
These amounts or totals are exclusive of VAT. Totals will be displayed for each of the selected stock items and a grand total for all the stock items included in this report.

The Quantities, Net Sales Amount and Net Cost Amount for Purchase documents are displayed in <> indicating a credit or negative figure. You may change this negative amount indicator to a minus sign (-) to prefix your amounts or set it to display a D (for Debit) or a C (for Credit) in the Setup - Preferences - Data Parameters menu option.