To enhance the capacity of reconciliation for all locations managed by a vendor, auto-reconciliation has been introduced, allowing vendors to directly acquire the reconciliation report with no manual efforts involved. To acquire this functionality, the criteria and preconditions for auto-reconciliation should be configured in Settings, based on which the reconciliation will be initiated and run on an automatic basis.
1. Customize Location(s) and Recurring Date under Settings
Log in to the KioCentral Pro platform. Go to “Settings” → “Reconciliation and Statements”. Under the “Reconciliation” tab, you will see the “Auto-Reconcile” section, in which you can put the relevant parameters for the auto-reconciliation functionality.
Auto-Reconcile: “Disabled” by default. “Enable” it to initiate the auto-reconcile function.
Locations: “All” locations will be selected by default. Use the search bar by entering the keywords of the location’s name or location ID to select multiple locations. The number of locations has no upper limit. Click on “+” to add more locations.
Recurring: it can be configured to set the periodical basis on which the auto-reconciliation will perform. “Monthly” is set by default.
Recurring | Trigger Date |
Monthly (default) | Drop-down options starting from the 5th to the Last Day of the calendar month. Select the exact date from the calendar picker when the system generates the reconciliation report for the past calendar month. |
Bi-weekly | Select the exact date of the weekday. Three options are provided: Friday, Saturday, and Sunday. |
Weekly | Select the exact date of the weekday (Friday, Saturday, or Sunday). You are allowed to change the weekday. Example: If the calendar date has been selected as May 2nd 2025, then the weekday would be filled in as “Friday” automatically. And if the weekday should be changed to “Sunday,” then the first report will be generated on May 4th 2025. The indicated “Start From” date won’t be changed if the weekday is re-selected. |
Daily | Select the daily as the recurring period, and the system will generate a daily report of the last 5 days. And there will be a prompt “Transaction data synchronization takes 5 days. Reports are available for data up to 5 days ago.” |
You can click on the plus “+” button to add new location settings for auto-reconciliation.
The quantities of the addition of the new locations have no upper limit.
If the newly added location shares the same settings as an existing one, there will be a prompt stating that the ### location setting is the same as the ### location. Please make sure you still want to proceed. If the two locations share the same settings, only one reconciliation report will be generated.
Click on the icon
to delete a location setting.
“Email Address” is an optional field. The Monthly/Bi-weekly/Weekly/Daily auto-reconciliation report will be sent to your email automatically. The field limit should be within 500 characters.
2. Check Auto-Reconciliation in Reconciliation History
Check the auto-reconciliation reports in Finance → Reconciliation History.
Two tabs simplify the methods of the reconciliation process: Manual Reconcile and Auto Reconcile.
Click on the “Auto Reconcile” tab to check the reconciliation history along with the reports. You can refer to the screenshot and the headers’ descriptions as follows:
Header | Descriptions |
|---|---|
Checkbox | Manually select the box(es) to export the reconciliation list. |
Period | The period based on which the reconciliation of the selected location will be generated. |
Recurring | daily, weekly, bi-weekly, and monthly. |
Create Date | The generation date of the reconciliation report. |
Location | The locations selected in Settings are reconciled. |
App | The total amount for the App reconciled against the Source 1. |
CR@Kiosk | The total amount for the credit card reconciled against Source 1. The variance will be indicated by the colored icon - red, yellow, or green. |
CR@Machine | The total amount for CRCard@Machine reconciled against Source 1. The variance will be indicated by the colored icon - red, yellow, or green. |
Action | Two actions are provided as the extended functionalities to make the report more interactive.
|
3. View Auto Reconciliation Report
You can click or select a reconciliation report to check the details of the reconciliation of the selected locations.
Information Card: provides the background of the reconciliation report, including the elements such as the reconciliation period, the recurring period, the applicable locations, and the trigger date.
Underneath the information card, you can find the bar graphs of the reconciled transactions. On the left of the bar graph, it displays the variances of Source 1 and Source 2. And on the right side lie the bar graphs of the transaction data of Source 1 for the past 12 months. Both bar graphs follow the same logic of the “Manual Reconcile.”
Underneath the bar graphs, you can find three lists (App Variances, Credit Card@Kiosks Variances, and Credit Card@Machine Variances).
Search Bar: used to search for locations by directly selecting from the drop-down list. The list will display the variances of the selected location(s) only.
Location Name: all the locations selected for reconciliation, which are sorted by the variance data.
You can click on the download button to export the data into a CSV. file in which the variances title, location name(s) will be included and sorted based on the variances results (Normal, Moderate, or Severe).
If a location doesn’t support the current payment method and has no data recorded, such location(s) will stand at the bottom of the list and be shown with two en dashes “- -”.
If you entered an email address when you configured the auto-reconciliation, you will receive the reconciliation report via that email address. The email format will follow the format below:
In the attached Excel file, there are four sheets to describe the variances reconciled for the selected locations:
Overall: Reconciliation Period, Location, Location ID. App Variances, CR@Kiosk Variances, CR@Machine Variances.
Location List-App Variances: Level, Location Name, Data Sources' data, Variance
Location List-CR@Kiosk Variances: Level, Location Name, Data Sources' data, Variance
Location List-CR@Machine Variances: Level, Location Name, Data Sources' data, Variance