A platform dedicated to share experience of cost effective IT solutions. Featured free web based POS.

POS Report Gallery

[ POS Utility Gallery ]

NOTE: Reports in this gallery can only be started from within Bossmiles POS 1.3 or above by clicking the report name on the first column.

Report Name

 
Description

 
Comment

 
Sales Reports

Top Selling Items (POS.SO.03)

This reports top selling products within a specified period.

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period
  • # of Top Sellers - Number of top selling product items to be reported.

Bottom Selling Items (POS.SO.04)

This reports worst selling products within a specified period.

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period
  • # of Bottom Sellers - Number of bottom selling product items to be reported.

Hourly Sales Report (POS.SO.09)

This reports sales by hour and by employee

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Daily Sales Report (POS.SO.10)

This reports sales by date and by employee

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Monthly Sales Report (POS.SO.11)

This reports sales by month and by employee

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Export Orders for Quickbook (POS.SO.??)

This utility exports completed orders. The exported file can then be imported into Quickbook.

Report Type: JR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Sales Detail by Customer (POS.SO.05.J)

This reports all sales transaction details performed for each customer. The details include Date/Time, Product and Purchase Amount.

Report Type: JR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Received Payment Summary (POS.SO.12)

This reports a summary of payment received within the specified period of time.

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Pending Sales Report (POS.SO.06)

This reports all pending / saved transactions.

Report Type: XR

Parameters: N/A

Tax Remittance (POS.SO.09)

This reports tax collected from customers within a specified period.

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Profit and Loss Report (POS.SO.91) [Under Construction]

This reports profit and loss of a specific period based on gross sales, discount, price included tax average per unit cost, commision and labor cost.

Report Type: XR

Parameters:

  • Site# - Always 1 for single store scenario.
  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period
  • Commission % - Percentage of commission to be applied.

Customer Reports

Customer eMail and Phone List (POS.SO.08)

This report lists customer eMail and phone number.

Report Type: XR

Parameters: N/A

Customer eMail and Phone List (POS.SO.08.J)

This report lists customer eMail and phone number. The output can be exported to other programs for purposes such as eMail campaigns.

Report Type: JR

Parameters: N/A

Store Credit Balance (POS.SO.18)

This report shows the store credit balance along with store credit transaction history. The output can be printed on receipt printer and pass to the customer as a statement.

Report Type: XR

Parameters: Customer name with optional percentage sign (%) as wildcard

Gift Card Balance (POS.SO.19)

This report shows the gift card balance along with gift card transaction history. The output can be printed on receipt printer and pass to the customer as a statement.

Report Type: XR

Parameters: Gift Card Number with optional percentage sign (%) as wildcard

Product and Inventory Reports

Inventory On Hand (POS.IN.01)

This reports inventory on hand along with average purchasing cost per item.

Report Type: XR

Parameters: N/A

Low Inventory Alert (POS.IN.02)

This reports product item at low inventory level. Store manager should check this report periodically to ensure enough inventory to satisfy the customer need.

Report Type: XR

Parameters:

  • Site ID - Default to 1 that should the primary store. For multi-store scenario, other site id should be specified.
  • Low Inventory Alert Level - report any product item that has inventory lower than this value.

Inventory Count Form (POS.IN.03)

This reports inventory on hand along with an empty column for you to record the corresponding inventory count. Barcodes of product SKUs are also printed for each data entry, when the form is completed by the warehouse staff.

Report Type: XR

Parameters: N/A

Ideally, you can run Bossmiles POS on your laptop or nettop and bring the machine to your warehouse, so that you can record the inventory counts directly in the receipt area (left side) of the POS program and press the physical inventory button to record the physical inventory count.

However, the second best solution is to print this report and record the inventory count on this report. Then, the inventory count recorded on this report can be entered into Bossmiles POS.

For each inventory count, you can enter the inventory count, press * button on your numeric pad, scan the barcode and press the + button on your numeric pad. After all inventory counts are entered, press the physical inventory button to reset the inventory level.

HR Reports

Payroll Report (POS.HR.01.J)

Report wage for the specified period. It also reports special customer note within the reporting period. This report can be executed at the end of each pay period to summarize the staffs' work hours and to calculate the wage to pay.

Report Type: JR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Sales Commission Report (POS.HR.02)

Report sales commission to be distributed for the specified period. This report can be executed at the end of each pay period to summarize the sales person's commission.

Report Type: XR

Parameters:

  • Period Start Date - Start date of the reporting period
  • Period End Date - End date of the reporting period

Job / Work Order Reports

Work Order Report (POS.WO.07)

This reports outstanding jobs / work orders, if you treat each transaction as a job / work order before billing your customer.

Work items can be entered as regular sales items. Work item owner can be changed by right mouse click on the work item. Alternatively, you can double click the work item and update the ownership with the dialog window. The entered job / work order can then be saved with the store order button. When the job / work order is completed, you can restore the order and bill the customer as if it is a regular sales order.

Additional information can be entered into the work order by adding a dummy service item, changing the description with the additional information and reducing the item price to zero.

Report Type: XR

Parameters: N/A