WinTill :: Knowledge Base

The Margin Value report details the total margin values for the specified date range at branch level. There are a series of sub reports which can be drilled down to by double clicking on the hyperlinked fields on the reports. The sub reports include:

• Margin Values at Style Level
• Margin Values at Product Level
• Margin Values at Sale Level

The Last Run Time depends on the criteria selected. It is calculated by using the time that was taken upon loading the report previously in accordance to the criteria selected. The time lapsed gives the user a timer when the report is loading.

Each time the user drills down to a sub report, the main report form will be displayed giving an indication of the estimated time the report is going to take to calculate and display. There is also a time lapsed figure to show the user how long the report has been running for during calculation.

The amount of time the reports will take to load is dependent upon the date range selected and how many sales etc have taken place during this period.

Margin Value at Branch Level

This is the top report that is loaded first. This report lists the branches along with the following information at branch level:

• Items Sold –  Total number of items sold
• Returned Items – Total number of items returned
• Refunds – Total number of transactions which contained a refund payment, including credit notes
• Refund Value – Total value of refunds including credit notes
• Gross Takings – VAT inclusive value of sales minus the value of any refunds
• Net Takings – Same as Gross Takings but exclusive of VAT
• Cost of Sales – Cost value ex VAT of net sale items (i.e. after returns have been taken into account)
• Gross Profit – This is calculated as Net Takings minus Cost of Sales
• Average Price inc VAT – Average VAT inclusive sale item price
• Average Cost ex VAT – Average sale item cost based on average cost at time of sale
• Margin – This is calculated as Average Price ex VAT minus Average Cost ex VAT

Double clicking on a branch name will load the Margin Value at Style Level report for the selected branch at the originally specified date range.

Margin Value at Style Level

This report will load when the user drills down from the previous report i.e. the Margin Value at Branch level report. This report groups the data for the selected branch at style level along with the following information per style:

• Style code – Default style code
• Description – Style description
• Qty Sold – Total quantity sold
• Average Price inc VAT – Average price item sold at inclusive of VAT after any discounts and price changes
• Average Price ex VAT – As above except exclusive of VAT
• Average Cost ex VAT – Average item cost exclusive of VAT base on average cost at time of sale.
• Margin – This is calculated as Average Price ex VAT minus Average Cost ex VAT
• Total Sales Value ex VAT – This is calculated as Qty Sold times Average Price ex VAT
• Gross Profit – This is calculated as Total Sales Value ex VAT minus (Average Cost ex Vat times Qty sold)
• %age – Margin expressed as a percentage of Average Price ex VAT ((Margin / Average Sell Price Ex VAT)*100)

Double clicking on a style code or style description will load the Margin Value at Product Level report for the selected style at the originally specified branch and date range.

Margin Value at Product Level

This report will load when the user drills down from the previous report i.e. the Margin Value at Style Level report. This report groups the data for the selected branch, style and date range by product along with the following information per product:

• Code – Product code
• Description – Product description
• Qty Sold – Total quantity sold
• Average Price Sold At inc VAT – Average actual sell price for item inclusive of VAT after any discounts or price changes have been applied
• Average Base Price inc VAT – Average sell price for item inclusive of VAT before any discounts or price changes, based on item sell price at time of sale
• Average Cost ex VAT – Average unit cost of item exclusive of VAT based on average item cost at time of sale
• Margin – This is calculated as Average Price Sold At exclusive of VAT minus Average Cost ex VAT
• %age – The Margin expressed as a percentage of Average Price Sold At exclusive of VAT ((Margin / Average Sell Price Ex VAT)*100)

Double clicking on a product code or product description will load the Margin Value at Sale Level report for the selected Product at the originally specified branch and date range.

Margin Value at Sale Level

This report will load when the user drills down from the previous report i.e. the Margin Value at Product Level report. This report displays the transaction details of all transactions containing the previously selected product at the originally specified branch and date range. The details on this report include all transaction details, not just details of the selected product, including:

• Transaction no – Transaction reference
• Code – Product code
• Description – Product description
• DateTime – Date and time transaction took place
• Qty – Total quantity sold
• Base Price Inc Vat – Individual item sell price before any discounts or price changes inclusive of VAT
• Sold At Inc Vat – Individual item sell price after any discounts or price changes have been applied inclusive of VAT
• Average Unit Cost – Average cost price of individual item at the time of sale exclusive of VAT
• Margin – Calculated as Sold At price ex VAT minus Average Unit Cost ex VAT