Reports

Prev Next

10. Reports

10.1 Customer Transaction Reports

  1. Click Reports -> Customer Transaction Reports to enter the page below. By clicking each link, you can go to the corresponding sub-page for details. You can add the target date range by the calendar selector and the shortcut buttons at the top.

10.1.1 All Transaction Summary

In All Transaction Summary report, the data of Cash Register, Cash Register Transactions, Online, and Online Transactions come from KioSoft POS, and the data of Vending and Vending Transactions come from Universal Server.

You can select the time range or location(s) to customize the date you’d to view from the report, or directly resort to the shortcut filters to define the time range. These filters are applicable to all individual reports.

Note: The “Other” column records the transaction data from the third-party terminal payment.

10.1.2 All Transaction Detail

In All Transaction Detail report, the data of this report comes from KioSoft POS and Universal Server.

It’s worth noting that there are two additional functions for All Transaction Detail report.

  1. Click the arrow “” in front of the transaction and it displays the associated payment details for the transaction.

Notes:

*The “Other” column records the transaction data from the third-party terminal payment.

*“Create Time” simplifies the time when the order was created.

*“Payment Time” indicates the time when the order was paid.

  1. Click a specific value in the Sales Order Number column to open the Sales Order Detail page. On this page, you can view details for the selected order, including Sales Order Info, Payment Info, Product Info, Customer Info, and Work Order Info.

Note: There is an optional route to access the Sales Order Detail page: go to Transactions > Transaction > Transaction List and click View Details.

Thus, you may refer to 8.2 Sales Order Details for a detailed instruction on the Sales Order Detail page.

10.1.3 Closeout Report

The Closeout Report displays the number of transactions on each day and daily transaction amounts. Click the date in each line to jump to the corresponding page of All Transactions Summary.

10.1.4 Summary Report (Hourly)

The Summary Report (Hourly) displays the hourly transactions of different transaction ways (Cash Register, Online, Vending). The data in this report comes from KioSoft POS and Universal Server.

10.1.5 Summary Report (by Machine)

The Summary Report (by Machine) displays the transactions of different payment methods of Vending; the data comes from Universal Server.

10.1.6 Summary Report (by Cash Register)

The Summary Report (by Cash Register) will display the transactions of different payment methods on Cash Register. The data in this report comes from KioSoft POS.

10.1.7 Cloud Card Top Up

The Cloud Card Top Up will be displayed as below. The data in this report comes from KioSoft POS and Universal Server.

10.1.8 Prize Redemption Report

The Prize Redemption Report (exclusive to the Amusement Market) will be displayed as follows:

You can refine the report using a fuzzy filter by searching for Create Time, Location, Employee, or Customer. Alternatively, you can apply an exact filter by searching for specific Product Names, SKUs, UPCs, and Redemption Order IDs.

  1. eTickets: This indicates the number of eTickets spent.

  2. Banked eTickets: If the value of a trade-in prize exceeds that of the redeemed prize, the remaining eTickets will be credited to the customer's account. The remaining eTickets are shown here; a value of “0” indicates no eTickets were banked.

 

Note: With regards to Prize Redemption Report, please follow the steps below for full use of it. 

To view all the details of a specific record, click the “>” icon to expand it. When the icon changes to a “v” shape, you will see all the fields of that record displayed below. You can review the SKU, Product Name, Method, eTickets, Quantity, and the total amount for the product.

Note: The “Method” field is a new addition, indicating the way a prize product was redeemed. The options include:

a. Trade-In: Using one prize to redeem another prize.

b. Bank eTickets: Banking extra eTickets if the value of the trade-in prize exceeds that of the redeemed prize.

c. Redemption: Using eTickets directly to redeem a prize.

 

  • Click on the underlined Customer ID to open the customer profile window.

  • Click on the underlined SKU to open the product detail pop-up dialog.

 

  • If you want to export your selected report records, click the “Export” button at first. 

 

  • Select the file type from “CSV,” “XLSX,” and “PDF,” and then click the “Export” button. 

 

10.1.9 Financial Overview Report

Financial Overview report is composed of Financial Summary Report and Financial Overview Report.

You can refer to the hierarchy illustration of the field Financial Category in the Financial Summary Report.

Note: Fields should be noted in Financial Summary Report

Financial

Category

Product Sales

1) Net Sales:

the total product sold amount (after discount is deducted) for the current location and matches the net sales amount shown in the Financial Overview Report.

2) Sales Tax:

the total product tax amount for the current location.

3) Refund:

the total refund amount (not including the top up refund) for the current location.

4) Grand Sales = Net Sales + Net Tax-Refund

Top Up

1) Value:

Summary of transactions where customers in the current location chose to top up amounts by value code.

Payment Amount:

the total amount paid by customers for the top-up value.

Bonus Value:

In the top-up transactions within the search scope, this is the total bonus amount customers received through the value code.

2) Credit:

Summary of transactions where customers in this location chose to top up amounts in credit mode.

Payment Amount:

the total amount paid by customers for top-up credits.

Top Up Credit:

In the top up transactions within the search scope, this is the total amount of credits customers receive through credits mode.

Total Revenue Earning

1) Payment Type (Cash/Cloud Card/Debit Card/Credit Card/Other):

Categorize the total income generated from product sales, top-ups and virtual top-ups into different payment methods, then calculate the total amount paid in cash/Cloud Card/debit card/credit card/Other (third-party terminal payment), respectively.

2) Net Revenue = Payment Type (Cash) + Payment Type (Cloud Card) + Payment Type (Debit Card) + payment Type (credit card) = Grand Sales + Total Top Up Value + Credits Payments Amount

3) Total Refund:

the total refund amount for grand revenue (= Net Revenue + Total Tax – Total Refund) of the current location.

10.1.10 Revenue By Product Sold

Revenue By Product Sold report can be displayed as below. Apart from applying the time range and location filters, you can also resort to the Product Type or Category filters to obtain the required revenue report details.

10.1.11 Top Up Transactions

The Top Up Transactions report is presented as follows: You will find the number of transactions and the payment amount in both value and credit for each location. The total column summarizes the overall transactions and values for each location.

10.1.12 Inventory Counting

The Inventory Counting report can be found as below.

* Total of Category: It refers to the sum of the total quantity for each category within this location during the selected time range.

10.1.13 Adjustments Report

If the inventory of a product at the current location is insufficient, employees can navigate to “New Sales” -> “Check Other Locations” -> “Transfer” to move a specified quantity of the same product from another location to the current one. Once the inventory transfer is completed, the data will be recorded in the “Adjustments Report.” You can access this report by going to Reports -> Customer Transaction Reports -> Adjustments Report.

The Adjustments Report will include details such as the local time of the transfer, the names of both locations involved, product name, quantity transferred, and more. This information serves as a reference report and cannot be edited.

10.2 Employee Transaction Reports

  1. Click Reports → Employee Transaction Report.

  1. Two types of reports can be checked.

10.2.1 Work Order Report

  1. If you select the Work Order Report, the transaction info generated by employees working on the machine will be displayed like below. The data comes from KioSoft POS Cash Register.

10.2.2 Cash Drawer Report

  1. If you select Cash Drawer Report, the reports will be listed as below. You can filter the reports by Date, Location, Machine and Batch ID. The reports are allowed to be printed and exported to CSV file. If you move your mouse to the icon at the end of the list, you can select to view the details of the report or edit the report.

Notes:

  • The report is not generated daily, but after a batch has been completed, meaning that the cash drawer has been opened and then closed.

  • If the count is less than the cash transaction results, the difference will be displayed as red, otherwise it will be in black.

  • If the cash drawer report is pending to be audited, it will be displayed as "Pending Audit" in orange, while if it has been audited, it will be displayed as "Completed" in blue.

  1. The details of the report will be displayed as below. It can be printed and edited.

Note: “Other Payments” indicates the transaction amount from the third-party terminal payment.

  1. If the report has been completed, you can click "Mark as Complete" to set its status as completed. Once it is done, the "Mark as Complete" button will change to "Re-audit". Any change for this report will be recorded in the "Audit Log," including set status as complete/pending, leave comments and change the counts of denominations. Employees who operated the Cash Drawer will be displayed in time order in the Employee column.

10.3 KioCentral Reports

“KioCentral Reports” allows users to directly access the “Location Performance” report on KioCentral in which users from KioCentral Pro can view the transaction reports of the locations managed by the operator user in vendor portal, ensuring a seamless switch between the two systems.

10.4 Transfer Balance Log

  1. Click on Reports → Transfer Balance Log

图片 1, Picture


  1. The fields of this log are shown below: Create Time, Location, Time Zone, Machine, Balance Type, Transfer Amount, From, To and Employee.

图片 1, Picture


  1. You can filter the search by the following fields: Create Time, Location, Machine, Balance Type, and Employee. Also, you can use the shortcut buttons “Yesterday,” “Today,” “This Month” and “Last Month” to determine the date range. Remember to click the “Search” button after you decide on the date range.

图片 1, Picture


  1. If you want to export the selected transfer balance log, first, click on the “Export” button.

图片 1, Picture


  1. Select the file type from “CSV,” “XLSX” and “PDF,” and then click on the “Export” button.

图片 1, Picture