Operational Dashboard & Financial Reports
Real-time tracking of sales, purified liters, loaned containers and receivable balances.
Fleet Performance & Vehicles
| Vehicle | Plate | Capacity | Driver | Status |
|---|---|---|---|---|
Recent Tax Invoices Transmitted
Financial Reports Center & Multisede Reconciliation
Daily sales journals, blind cash audits, bottle rotation kardex, and P&L statements.Accounting Kardex & Movement Flow
| Date / Time | Movement Type | Product / Supply | Quantity | Reason / Ref | Responsible |
|---|---|---|---|---|---|
Daily Consumption Forecast (Heuristic AI Engine)
Preventive Stock & Supply Alerts
~420 caps remaining in stock. Based on projected demand, stock will run out in 2 days.
Geofencing clustering is saving ~14% in fuel across the north quadrant.
Predictive Smart Reorder — Customers Out of Water Soon
Daily consumption frequency heuristic algorithm| Customer | Phone / WhatsApp | Usual Frequency | Days Since Order | Days to Depletion | Urgency | Commercial Action |
|---|---|---|---|---|---|---|
| Analyzing real-time consumption history... | ||||||
Wholesale Water Bottling Supplies & Equipment Directory
Access factory-direct pricing on caps, water jugs, reverse osmosis membranes and food-grade chemicals with BotellónGo exclusive agreements.
PlastiTapas Industrial Co.
Manufacturing 55mm crown caps with spill-proof inner liners and custom branded heat shrink safety bands.
MegaBotellones Polycarbonate LATAM
Virgin 100% FDA food grade 20L and 10L containers with reinforced handles engineered to endure 2-meter drop impacts.
AquaFilter Pro & UV Technology
12-55 GPM germicidal UV lamps, coconut shell activated carbon block cartridges, softener resin and Filmtec membranes.
BioSanit Pure Food Chemicals
Stabilized chlorine dioxide, peracetic acid and neutral alkaline detergents formulated for automatic jug washing and disinfection.
SmartAqua Dispensers & Tech
Automatic USB rechargeable water pumps, freestanding and countertop hot/cold water dispensers for corporate client loyalty.
Massive Master Data Importer
Migrate your water purification plant in seconds by uploading Excel (.xlsx, .xls) files, CSV sheets, or pasting direct lists.
Drag and drop your Customers file here
Supports Excel spreadsheets (.xlsx, .xls), .csv sheets, or raw text
| Order / Customer | Delivery Address | Total | Payment Method | Status |
|---|---|---|---|---|
Customer Directory & B2B Credit ManagementCredit & Bottle Loans
Manage credit limits, loaned containers, payment abonos and generate official PDF account statements.
| Customer / Company Name | Contact | Balance / Credit Line | Deposits | Loyalty | Actions |
|---|---|---|---|---|---|
Product Catalog
Select products and create your order. Choose NUEVO (jug delivery) or REFILL (container exchange).
| Product | Type | Price | Add |
|---|---|---|---|
Water Purification Plant Profile
Customer Business Hours
Define when this branch accepts and dispatches orders. Customers will see this schedule in the catalog; outside business hours the app blocks immediate checkout.
Useful for unexpected events (out of water, vehicle breakdown, etc.) without touching the weekly schedule.
Tax Vault .p12 & Fiscal Parameters
Configure your PKCS#12 digital certificate and authorized sequential counters for automatic XML signing and real-time electronic invoice transmission.
Electronic Invoices & SRI Batch Transmission
Two-Factor Authentication (2FA / MFA)
Protect your cash settlements, inventories, and billing by enabling Google Authenticator, Authy, or 1Password.
Your Business Subscription
Free plan active.
- 100% Ad-Free
- Up to 150 Jugs/month
- 1 Vehicle & 1 Branch
- Real-Time GPS Tracking
- Digital WhatsApp Delivery Receipts
Enabled Payment Methods
Automated billing with instant activation for monthly and annual plans.
Pichincha, Bancolombia, Nequi, SPEI and Yape with 5-minute activation.
Submit Receipt on WhatsAppPlant Reputation & Customer Satisfaction
Real-time telemetry on customer satisfaction regarding water purity, heat-shrink seal integrity, and route driver friendliness.
Sanitary Water Quality Log & Process Control
| Date / Time | Stage / Point | pH | TDS (ppm) | Free Chlorine | Turbidity | Pressure / RO | Compliance | Notes |
|---|---|---|---|---|---|---|---|---|
| Loading water quality logs... | ||||||||
Recent Household Reviews & Product Ratings
| Date | Customer / Area | Water & Jug | Courier Service | Highlights | Customer Feedback |
|---|---|---|---|---|---|
| Today, 13:42 | Elena Gómez North District | 5.0 | 5.0 | Crystal Pure Water Intact Seal | "Great water taste, very fresh and the bottle arrived pristine with seal intact. Courier was very punctual." |
| Today, 12:15 | Carlos R. Mendoza Downtown | 5.0 | 4.0 | Spotless Jug Fast Delivery | "Arrived in under 20 minutes. Excellent delivery speed." |
| Yesterday, 16:50 | San Jose Dental Clinic South District | 5.0 | 5.0 | Great Service Agile Swap | "Ordered 4 jugs for the clinic and electronic invoice was issued automatically. Highly recommended." |
Security Center, Audit Trail & RBAC Permissions
Monitor active connected devices in real time, remotely revoke unauthorized sessions, and audit critical inventory, billing, and credit operations.
Connected Devices & Sessions
Security Audit Trail
Live AuditRBAC Access Control Matrix (Role-Based Access Control)
Privileges and restrictions configured per company user profile.
| Module / Operation | Administrator | Driver / Dispatcher | POS Cashier | B2C/B2B Customer |
|---|---|---|---|---|
| Tax Electronic Invoicing & Signature (.p12) | Allowed | Restricted | POS Invoices | Restricted |
| Modify Credit Limits & Bottle Deposits | Allowed | Restricted | Restricted | Restricted |
| Manual Stock Adjustments & Shrinkage Kardex | Allowed | Restricted | Restricted | Restricted |
| Route Dispatch, GPS Tracking & Mobile Collections | Allowed | Allowed | Restricted | Restricted |
| Place Orders & View Personal History | Allowed | Allowed | Allowed | Allowed |
PayPal Subscription Plan Management
Create, reprice, and activate/deactivate the subscription plans billed via PayPal to BotellónGo's purification-plant customers. See ACTA_MESA_REDONDA_GESTION_PLANES_PAYPAL.md.
| Plan Type | Name | Price | Frequency | Status | Plan ID (PayPal) | Actions |
|---|---|---|---|---|---|---|
