Coin Collection by outlet v2
πͺ Purpose
Use Coin Collection by Outlet v2 to view coin collection records by operator, outlet, and date.
You can view each outlet separately or combine multiple outlets into one report.
π Step 1: Select Operator
Select the operator you want to check.
- Specific Operator β View one operator.
- All Operator β Include all operators.
πͺ Step 2: Select Outlet
Select the outlet you want to check.
- Specific Outlet β View one outlet.
- All Outlet β Include all outlets.
π Step 3: Select Date Type
Choose how you want the report to be displayed.
π Daily
View the collection by individual day.
Example: 1β30 September 2026
ποΈ Monthly
View the collection by month.
Example: JanuaryβSeptember 2026
π‘ Tip: After changing the Date Type, click Submit to refresh the report.
ποΈ Step 4: Select Date Range
Select the required date range based on the selected Date Type.
Daily: Select the required start and end date.
Monthly: Select the required months.
π Step 5: Select View Type
Choose how you want the report to be displayed.
πͺ By Outlet
View each selected outlet separately.
Outlet A β Report A
Outlet B β Report B
Outlet C β Report C
π Combined View
Combine the selected outlets into one report.
Outlet A + Outlet B + Outlet C
β
π One Combined Report
π€ Which One Should I Use?
Need to check each outlet separately?
β‘οΈ Choose By Outlet
Want to review multiple outlets together?
β‘οΈ Choose Combined View
π Step 6: Generate the Report
After selecting all filters, click Submit.
The report will be generated based on your selected:
Operator + Outlet + Date Type + Date Range + View Type
π Understanding the Report
π Total Variance
Shows the variance information for the collection record.
βοΈ Difference
Shows the difference between the relevant collection values.
βΉοΈ Variance Information
Use the information icon to understand what positive and negative variance represents.
π§ Customize the Report
π§ Column Filter
Click Column Filter to select which columns you want to display.
This allows you to keep only the information you need.
β Add Favourite
Click Add Favourite to save your preferred report settings for easier access later.
Favourite settings can also be synced with the Collection report.
π₯ Download Excel
Click Download Excel to download the report.
The Excel file includes:
π All
β Combined data from the selected outlets.
πͺ Individual Outlet Sheets
β Separate data for each outlet.
Example
π Excel Report
βββ π All
βββ πͺ Outlet A
βββ πͺ Outlet B
βββ πͺ Outlet C
π Example
Check September Collection for Multiple Outlets
π€ Operator: All Operator
πͺ Outlet: Outlet A + Outlet B
π
Date Type: Daily
ποΈ Date Range: 1β30 September 2026
π View Type: Combined View
Process
Select Filters β π Submit β π Review Report β π Check Variance β π₯ Download Excel
π‘ Quick Tips
- Use Daily when you need a day-by-day collection view.
- Use Monthly when you need a month-by-month view.
- Use By Outlet to review outlets separately.
- Use Combined View to review multiple outlets together.
- Click Submit after changing the Date Type.
- Use Column Filter to simplify the report.
- Use Add Favourite for frequently used report settings.
- Use Download Excel when you need the data for further analysis.




