Sales / Stock Reports
Options uses Crystal Reporting for all output. This allows you to output to any device on the network and export to multiple formats including PDF's, spreadsheets and graphs. There is a wide variety of pre-defined reports including customer and stock best to worst sellers, sales persons commission statements, stock ageing report and many more. It includes sales reporting of customer orders, invoices or invoiced + POS sales. Sales reporting which analyses percentage of sales by stock type (group) compared to percentage of stock held by stock type. The facility to view print-preview versions of each report is standard and each report can export to screen, PDF, Excel, Word etc |
| .. |
| Master File Lists |
| • |
Customers – detailed customer list by account code, area, name, postcode and business nature or business nature and postcode with options to include various types of customer information. |
| • |
Areas – master file list of sales areas / sales people. |
| • |
Product Groups – master file list of stock product categories. |
| • |
Contract Prices – Qty Breaks – master file list of special stock sell price contracts for date range periods or bulk buy pricing. |
| • |
Operators – master file list of system operators |
| • |
Trial Balance – detailed or compressed aged debtors trial balance with various options to include certain ages or perform aging using different methods. Also includes an option to exclude deposits so users can see outstanding transactions only that should be settled. |
 |
|
|
| . |
| Stock Reports |
| • |
Price List – price list master file by supplier, stock code, product group, catalogue page or stock description with multiple options to include one or all price levels and various other stock information. Also allows full price list production including our unique stock options setup. |
| • |
Sales and Cost MTD – summary report by product group or code listing sales, cost and gross profits for a selected date range. |
| • |
Movements – audit trail of stock movements in the system. |
| • |
Inventory – list of stock currently on hand by product group, code or supplier. Various options including different types of stock and stock information. |
| • |
Supplier Deliveries without Invoices – audit trail of goods received on delivery docket that have not had a matching invoice entered into the system. |
| • |
Stock Returns waiting Credits – audit trail of stock sent back to suppliers on stock returns that a corresponding credit note has not been received for. |
| • |
Stock Take Input List – list used for manual stock take counting. Can be run by supplier, product group or product code and has various options for including different types of stock. Also has the option to print barcodes on the report to allow easy entry of count data into the stock take entry program. |
| • |
Stock to be Invoiced or Allocated – list of customer orders that need to be invoiced or allocated. |
| • |
Stock Best to Worst – stock item sales report that compares quantity or dollar value sales per month and year to date total per stock code. This can be ordered by best to worst or worst to best and grouped by sales area, product group, product code, supplier, catalogue page number or postcode. Performance can be rated by sales value, qty or gp. This report can perform this analysis on invoiced sales or written sales and has various other options for including certain types of items or presetting groups of items to be analysed only. |
| • |
Purchasing – produces a purchasing report or available stock analysis by product code, product group or supplier. This can be run for ranges of items, preset groups of items or items with current inventory levels below an entered number of months using the average sale level. |
| • |
Stock Age List – list of oldest to youngest or youngest to oldest stock items available for serialized stock items. |
| • |
Production Schedule – list of stock items and time required to assemble un-assembled items on hand based on an entered average assembly time. Used for scheduling labour to assemble flat pack items etc in a warehouse situation. |
| • |
Qty Sales – This Year and Last – monthly summary sales comparison per stock item for this year and the previous year. |
| • |
Weekly Sales Comparison – weekly stock sales comparison summarised by stock code. |
|
|
| |
| |
. |
| Sales Order Reports |
| This report is an essential report to controlling customer order status and has a lot of options for selecting different types of orders and including different information. This report has various formats depending on the options selected. The main uses are: |
| • |
All - lists details of all orders and their current purchased, allocated or invoiced quantity status, required by date, purchased status and other order information. |
| • |
Outstanding – details unsupplied orders and their current purchased, allocated or invoiced quantity. |
| • |
status, required by date, purchased status and other order information. |
| • |
Available to Invoice – details orders that have allocated stock and are can be invoiced to customers. |
|
|
| |
| |
. |
| Purchase Order Reports |
| This report is an essential report to controlling supplier purchase order status and has a lot of options for selecting different types of orders and including different information. This report has various formats depending on the options selected. The main uses are: |
| • |
All – lists all orders and their current order and outstanding quantities, etas and product information. |
| • |
Outstanding – lists outstanding orders only and their outstanding quantities, etas and product information. |
| • |
Due in a selected date range – lists order details for orders that are due in a specified date range. This allows the user to chase suppliers prior to the promised date and pro-actively keep customers up to date with current eta information. |
|
|
| |
| |
. |
| Sales Reports |
| • |
Sales by Date + Group – summary report by product group, sales area, customer or supplier of sales, cost and gp for a selected date range. Secondary format which analyses stock holding patterns by the above groupings and compares the percentage of sales for a group to the percentage of stock held. This allows managers to check if their stock on hand mix is close to their sales mix. This report is available by invoiced or written sales. A bar graph comparison per group is also available for graphical analysis of the sales. |
| • |
Sales Product – Customer – Supplier – summary or detailed sales report by product and customer, customer and product, product and supplier, product and group or invoice reference. This allows selection of 2 date ranges for comparison and includes sales, cost and gp. This report can be run by invoiced or written sales. This report is available by invoiced or written sales. |
| • |
Sales by Day – Week – Month – sales report including sales, cost and gp figures for an entered date range. The sales san be summarised and compared by days, weeks or monthly groupings. Group, Supplier or Sales Area breakup per group is also available and a bar graph is available for graphical analysis. This report is available by invoiced or written sales. |
| • |
Sales by Sales Person – detailed or summary sales analysis by sales person for a selected date range. Includes sales, cost, gp and optionally commission figures. This report is available by invoiced or written sales. |
| • |
Sales + Cost Area Report – sales person summary sales report. |
| • |
Customer Best to Worst – best to worst or worst to best sales report per customer or customers grouped by sales person. Analyses customer sales per month and year to date. |
| • |
Commissions – sales person commissions report. This report has a number of formulae built into it, and can be tailored to suit your commission structure if required. It currently supports commissions on sales or paid invoices only with various costing options. |
| • |
Commissions by Customer Budget – sales person commission report when commissions are based on sales per customer compared to budgets. |
|
|
| |
| |
. |
| Transaction Lists |
| • |
Transaction Audit Trails – audit trail of any debtor's transactions. This report can be used as an audit trail to aid in reconciling the daily takings and has options to include only selected transaction types, date ranges and customers. |
| • |
Bank Deposit Slip – daily till reconciliation and bank deposit slip. This report is used to balance the daily takings in the system to the cash drawer(s) / eftpos machine(s). It can also produce a bank deposit slip, which can be used to bank the takings without having to re-produce a bank deposit slip. |
|
|
| |
| |
. |
Statements – customer statement printing for businesses that work on credit and send customers statements for settlement.
.
Quotes – reports showing an audit trail of quotes with options to list accepted quotes, rejected quotes, pending quotes or all. It allows reports by sales person or customer range. There are many options including a summary report or detailed report as well as a quote success forcast
.
Business Analysis – report with key financial information from the system including stock on hand value, creditors and debtors total balances, new orders and quotes for a period compared to orders and quotes done for existing clients etc.
.
GST Remittance Report – comprehensive gst remittance report that consolidates all system gst information into one report with subtotals per BAS category that can be transferred directly to the BAS. This is normally the only gst report run in the system at the end of your gst reporting period as it details all systems and provides the BAS totals. Note – the system correctly handles all issues of GST including prior period adjustments and discounts taken and given.
.
Supplier – Customer Performance – lists percentages of supplier orders arriving before, on or after the provided eta to check on supplier delivery performance. Also has a format, which lists percentages of customer orders, delivered before, on, or after the requested date to check on users delivery performance.
.
Sales Order Deliveries – handles order delivery scheduling. Reports on orders booked to deliver, available to invoice that have been contacted but not booked, available to invoice but not contacted or orders not allocated that there is available inventory on hand to fill. This report lists the order and product details and quantities and any outstanding deposit on the order. |
| |
|
| |
|
