Daily Closure
Close business day, review reports, and send Slack report.
Open Discrepancies
Escalations
Damaged Boxes
Missing Boxes - Driver Breakdown
Detailed breakdown of missing boxes by driver for DSP reporting.
Frequently Asked Questions
Answers to common questions about Daily Closure operations.
Closes the business day by finalizing all box assignments and returns for that date. This locks the daily reports and prevents further edits to that day's data. You'll typically run this at the end of each business day.
Click "Copy Slack Report" button. This generates a formatted summary of the day's activity (discrepancies, escalations, damaged boxes) that you can paste into Slack. The report is automatically copied to your clipboard.
Open Discrepancies are missing boxes or items that haven't been resolved. These represent inventory gaps between what was assigned and what was returned. Track these to ensure timely resolution with drivers.
Escalations are discrepancies that have been flagged as requiring special attention or management approval. They typically indicate repeated issues with a specific driver or anomalous patterns that need investigation.
A box is marked damaged when its condition issue is scanned at the return station. This helps track maintenance needs and may indicate problems in the supply chain or delivery process.
No, once a day is closed, it's locked for audit purposes. If you need to correct data, contact your administrator to reset the data or create a corrective entry.
Close the day after all deliveries are complete and you've verified all returns have been scanned in. This is typically at the end of the business day, around 8-10 PM.
📦 Backpick Management
Upload Backpick data, filter, and export Reinvoicing data (20-day retention).
Upload New Backpick CSV
Upload your Backpick data (CSV). Old data (>20 days) will be automatically deleted.
Quick Sheet Date Range
Select the date range for your Backpick data export.
Backpick Data (Last 20 Days)
Reinvoicing Export
Frequently Asked Questions
Answers to common questions about Backpick Management.
Backpick data is a CSV file containing missing items from customer orders that must be fulfilled from warehouse stock. You upload it so the system can track which items need to be picked and their values for reinvoicing purposes.
Upload a new Backpick CSV each time you receive updated missing item data from your fulfillment system. This is typically daily or as new orders are processed.
Data older than 20 days is automatically deleted from the system. This keeps your database lean and focuses attention on recent, actionable items. Download a backup before the 20-day window closes if you need long-term archives.
Use the "Filter by Date" dropdown in the Backpick Data section. Select a specific date to view only the items uploaded on that date, or select "All Data" to see everything within the 20-day window.
Reinvoicing Export compiles the list of missing items and their values across a selected date range. This data is used to create invoices to customers for items you couldn't fulfill, or for internal cost tracking.
Black boxes are special cases (high-value or critical items). Checking this option excludes the end date from the reinvoicing range for black boxes, preventing partial-day charges and ensuring accurate cost allocation.
You can do both. "Export Boxes + Backpick" combines box loss and missing item data in one report. "Export Black Boxes" creates a separate report for high-value items only, for specialized handling.
📊 Live Operations Dashboard
Real-time metrics, performance trends, and operational health at a glance.
Status Distribution
Assignment status breakdown
Top Companies
Volume by company
Top Drivers
Performance by driver
Frequently Asked Questions
Answers to common questions about Analytics and KPI metrics.
Return Rate is the percentage of assigned boxes that are successfully returned (Returned ÷ Assigned × 100%). Aim for 98-99%+. Lower rates indicate boxes are lost in transit, which creates financial exposure.
Missing Rate shows the percentage of assigned boxes not yet returned (Missing ÷ Assigned × 100%). High rates early in the day are normal; they should decrease as deliveries complete. Persistent high rates flag problem drivers or operational issues.
Charge Exposure estimates financial risk from missing boxes, calculated as (Missing Boxes × €40). This assumes each unreturned box incurs a €40 penalty. It helps prioritize recovery efforts on high-value losses.
Repeat Driver Rate shows the percentage of drivers who have multiple discrepancies/missing boxes. High rates indicate systemic training or process issues. Focus quality checks on high-rate drivers.
Overdue counts boxes missing for more than 24 hours since assignment. This is the immediate charge risk you face NOW. Boxes overdue >24h typically trigger automatic penalties, making this the most urgent metric.
Reissued metrics track boxes that were reassigned to new drivers after the original assignment was incomplete. "Reissued Boxes" = total reissues. "Active Reissued" = boxes still in transit after reassignment.
Start with Return Rate and Overdue (>24h). Return Rate shows overall health; Overdue shows immediate financial risk. Then track Repeat Driver Rate to identify training opportunities, and Charge Exposure for total liability.
Admin Functions
Protected admin operations.
Create Assignment
SQLite Import
Delete Assignments
Deletes all assignments and restarts sync from now.
Delete Anomalies
Deletes all detected anomalies (reassignments without return). Helps remove old data after a reset.
Frequently Asked Questions
Answers to common questions about Admin functions.
Go to the Admin tab, fill in the assignment form with Vehicle code (e.g., F-424), Company code (e.g., FSFK), and Driver Name. Click "Save". The system will begin tracking this assignment immediately.
Vehicle identifies the delivery vehicle (van, truck, etc.). Company identifies which customer/company the boxes belong to. One vehicle may serve multiple companies on a single route.
SQLite Import allows you to bulk-load historical data or backup data from a JSON export. Paste a JSON file (exported from another instance or backup) and click "Start Import". Use this for migrations or data recovery.
The JSON must follow the database schema: {"assignments":[...], "scans":[...], ...}. Export format from a working instance is the safe template. Invalid JSON will be rejected with an error message.
This permanently deletes all assignments and restarts the sync from that moment forward. All historical assignment data is lost. This is useful for fresh-start testing but use with extreme caution in production.
Anomalies are patterns detected by the system: reassignments to a new driver without return of the original box, repeated missing items from the same driver, etc. Deleting anomalies clears the system's memory of these patterns—useful after a data reset.
No. Both "Delete All Assignments" and "Delete Anomalies" are permanent and cannot be undone. Always backup your database before using these dangerous operations. Contact your administrator if you delete data by mistake.