In this article we present a breakdown of our reports sections and what reports can be found in each section. The reports we have on the humble Till cover 4 topics, namely : Sales, Stock, Cash Up, Audit and Company Data.
We've listed the sections as well as a brief overview of the detail the report includes below:
Sales Reports:
Gross Profit
The Gross Profit report can be filtered by date, item or category. On the report you can view the item details, Gross Profit Amount and the Gross Profit percentage per item as per sales completed in the specified date range.
Gross Profit Sales Person
The Gross Profit Sales Person report will show you the number of sales per category as well as the GP amount and GP percentage per cashier. The report can be filtered by date and User, you can also set the report to show all users on one report as per sales completed in the specified date range.
Gross Profit Sales Person by Product
The Gross Profit Sales Person by Product report will give you a detailed breakdown of the quantity of products sold as well as the GP amount and GP percentage per product for each individual cashier. The report can be filtered by date and user, you can also set the report to show all users on one report or for a specific user for sales completed on products in the specified date range.
Sales Audit Trail
The Sales Audit Trail report will show you a list of all the sales processed on the humble Till for a specified date range. On the Sales Audit you can view the date and time of the sale, the items sold out with the item quantities, the cost and selling price of the items, the sales person who processed the sale, the tender type used in the sale and any change amount if applicable. This report can be filtered by site and date range.
Sales Daily Summary
The Sales Daily Summary report shows you an overview of the total number of sales for the day, the total cost amount, the total selling amount as well as GP amount and GP percentage for that day. This report can be filtered by site and date range.
Sales Per Customer
The Sales Per Customer report shows the total balance on a customer account for the specified date range as well as details of the customers purchases in that period. This report can be filtered by site and date range. You can set the report to show details of one customer or set it to show all.
Company Site Summary Sales
The Company Site Summary Sales report gives you a summary of the sales made for a particular store or all stores.
Per Site Detailed Sales
The Per Site Detailed Sales report gives you a detailed of the sales made per item, per category for a particular store or all stores.
Customer Statement
The Customer Statement report shows all customer purchases and any customer account payments received through the humble Till.
Payments
The Payments report will show the full details of transactions processed in the Payments tab from the Till screen. You can filter the report by date and transaction type (Petty Cash and Receive On Customer Account). You can also select a Site and Date range for this report. On the report you will be able to see the date and time of the transaction, the transaction type, the transaction reference, the tender type as well as the amount paid out or received.
Sales Per Supplier
The Sales Per Supplier report will show the total quantity of items sold for the specified date range, as well as the total line cost, total line VAT, total selling amount and the GP amount and GP percentage for the specified period. This report can be filtered by site and date range.
Top Selling
The Top Selling report shows top selling items by rank in each category. The report will show you the item description, total number sold, current on hand quantity as well as the GP amount and GP percentage. This report can be filtered by site and date range.
Top Customers
The Top Customers report will show your top spending customers in-store for cash paying customers who have been allocated to a sale as well as any account customers. The report can be filtered per site and a specific date range. The report includes an Order By filter which can be set to show your customers in descending order by their Total Spent, Total Sales or Average Amount. It also includes a filter to show your Top 10, Top 20, Top 50 or Top 100 customers within the specified date range.
Customer Purchase Summary
The Customer Purchase Summary report will give you a breakdown of individual sales per customer made in-store for cash paying customers who have been allocated to a sale as well as any account sales. The report will detail the customers name, the date and time of the sale including the reference of the sale, the amount for the sale as well as the tender of the sale. This report can be filtered by site and date range. You can set the report to show details of a particular customer or set it to all customers.
Customer Purchase Details
The Customer Purchase Details report will give you a breakdown of individual sales per customer made in-store for cash paying customers who have been allocated to a sale as well as any account sales. The report will detail the customers name, the date and time of the sale including the reference of the sale, as well as the products that were purchased. It also includes the total amount for the sale as well as the tender of the sale. This report can be filtered by site and date range as well as a filter for selecting a particular customer.
Stock Reports:
Adjustment Reprint
The Adjustment Reprint report will show the full details of any previously processed stock adjustments. The adjustments will be listed in date order and you can select the required transaction from the list to view it. The report can be filtered by site and the stock movement direction (in or out).
Transfer Reprints
The Transfer Reprint report will show the full details of any previously processed stock transfers. The branch transfers will be listed in date order and you can select the required transfer from the list to view it. The report can be filtered by site and the stock movement direction, “in” applies to branch invoices and “out” applies to branch returns.
In Stock
The In Stock report will show the current quantities of your stock items (positive or negative quantities). A filter can be applied to include inactive items in this report and items with zero quantities. You can run the report for a specific site and a specified date range. You can also run the filters to show all items, one specific item or to show the items by category.
Item Audit
The Item Audit report shows the movements of items on the till. This report documents all sales, returns, adjustments, supplier invoices, supplier returns and stock take adjustments. The report can be filtered by site and date range, as well as set to show just one movement type or all applicable movements. You are able to run the report a single product or all the products in a particular category.
Serial Age Analysis
The Serial Age Analysis report shows how long serial items have been in stock, specifying if an item was brought in less than 30 days ago, 60 days ago or 90 days ago. The report details the date and time when a serial item was booked in to stock, the item description as well as the serial numbers of the items.
Serial Audit
The Serial Audit report details the life cycle of an item on the till. This report will show any sales, returns, supplier invoices or supplier returns of the specified serial item. To run the report you need to set the product name and select the applicable serial number.
Serials In Stock
The Serials In Stock report shows the description, serial number and pricing details of serial items currently in stock. The report can be set to show one serial item or the details of all serial items on the till.
Stock Take
The Stock Take Report gives you a full list of all the items counted in a Stock Take. You can also include uncounted items by selecting the tick box for "Show Uncounted". In the report you are able to see the item description, the on hand figure from the till, the figure you entered in to the count as well as the adjustment figure.
Stock Take Adjustments
The Stock Take Adjustments report shows the details of any items that were adjusted by a processed stocktake. This report is the same as the Differences Report you get after processing a stocktake. This report can be filtered by site and you can select the required stocktake from the drop down list.
Supplier Summary
The Supplier Summary report shows a total overview of the total invoices and returns for a supplier. Once you have selected the supplier you would like to view you’ll be able to view how much was invoices in from or returned to the supplier for each month.
Supplier Transaction Reprint
The Supplier Transaction Reprint report can be filtered by site and stock movement direction. You can select the required movement from the drop down list, the movements are listed in date order.
Supplier Order Reprint
The Supplier Order Reprint report can be filtered by site and stock movement direction. You can select the required movement from the drop down list, the movements are listed in date order.
Item Ingredients
The Item Ingredients report will give you a breakdown of the ingredient products and their quantities linked to that particular product. This can be filtered to either All products or a specific product.
Cash Up Reports:
Cash Up Reprint
The Cash up Reprint report can be filtered by site and you can select the required Cash Up from the drop down list. On this report you also have the option to display all the transactions that are included in the Cash Up. This report will show you the details of previously processed Cash Ups including any notes you may have added to the Cash Up.
Cash Up Summary
The Cash Up Summary report can be filtered by site and date range. When the report is run, you will be able to see an overview of what was declared in your previously processed cash ups. The Cash Up Summary also shows the date and time when the cash up was processed.
Pay Outs
The Pay Outs report is filtered by site and date range. On the report you will be able to view the details of previously processed Petty Cash payments. You will be able to see the date and time that the pay out was processed, the cashier who processed the transaction, the person the money was issued to, the reason for the pay out and the amount paid out.
SnapScan
The SnapScan report shows details of completed SnapScan transactions. On the report you will be able to view the date and time of the sale, the authorization code generated when the sale is processed, the required amount, the total paid and the status of the transaction; this will either be completed, if the sale was successful, or error if the sale was not completed.
Audit Reports:
Staff Audit Log
The Staff Audit Log shows all actions done by staff members on the till. The actions logged on the Staff Audit are:
- Opening of cash drawer outside of a sale
- Changing an item quantity in a basket
- Any changes of item prices
- Any changes on the amount tendered
- Items deleted from baskets
- Deleted baskets
- Discounts applied to items
- Any changes to previously declared amounts in the Cash Up
- All deleted Cash Ups
- Shows if till goes offline and when it comes online
Company Data Reports:
Company Low Stock Report
The Company Low Stock Report will show you items that have had low stock enabled, along with a threshold added that are now below the threshold value.
Transaction Listings Totals Only
The Transaction Listings Only report will show a breakdown of all transactions completed via the Stock function within Humble, referencing the store and the totals for that specific transaction.
The below transactions completed within humble Till will be displayed:
- Supplier Order
- Supplier Invoice
- Supplier Return
- Transfer In
- Transfer Out
- Adjustment In
- Adjustment Out
- Stock Take
Detailed Transfers
This report shows a breakdown of each Transfer IN and OUT that has been processed within Humble Till. The report shows the quantity per product per line and the totals.
Summary Transfers
This report shows all the Transfers that was processed IN and OUT of Humble Till. The report will display Time and Date of the Transfer as well as the reference of each Transfer and the exclusive value, VAT/ Tax Amount as well as the inclusive value.
Detailed Suppliers
The report will also show the quantity per product per line, unit cost, exclusive value, VAT/ Tax Amount as well as the inclusive value of the Supplier Invoices and Returns that have been processed within Humble Till - Only the date and reference will be displayed and not the name of the supplier.
Summary Suppliers
The report will also show the date and time, supplier, reference, lines, exclusive value, VAT/ Tax Amount as well as the inclusive value of the Supplier Invoices and Returns that have been processed within Humble Till
If you have any questions or need help with anything, please don't hesitate to contact us on support@humbletill.com
0 Comments