| Tracking Number | Date | Shipper Name | Shipper Number | Consignee Name | Consignee Number | Origin | Destination | Mode | Number of Cargo Boxes | Status / Location | Amount | Payment | Actions |
|---|
| Description | Amount | Action |
|---|---|---|
| Total: | 0.00 |
| CustomerID | Name | Phone | Address | Tags | Last Used | Actions |
|---|
Loading…
Branch (from CSV) is from your upload. Destination Branch (linked) is the Zoning branch you assign—used in Pricing and Cargo. Filter, select rows, pick a branch, then Apply. Data is saved to Supabase so branch assignments persist across sessions.
| Route Code | Province | City | Branch (from CSV) | Destination Branch (linked) | Sector |
|---|
| Tracking Number | Barcode | Size | Status | Time in Branch | Shipper | Consignee |
|---|
Live data from Cargo Collections, Day Book, LPO sales, HQ expenses, and transfers. Use filters to set scope and date range.
Scope: All sectors · All branches
| Sector | Income | Boxes | P&L |
|---|
| Branch | Boxes | New | Repeat |
|---|
| Date | Category | Branch | Description | Amount (AED) |
|---|
| Date | Type | Transfer ID | Branch | Boxes | Cost (AED) |
|---|
| Branch | Income | Empty box | Cargo | P&L |
|---|
| Location | Shipments | Boxes |
|---|
| Username | Full Name | Role | Branch/Sector | Modules | Actions |
|---|
| Barcode | Prefix | Number | Suffix | Assigned Driver | Assigned Branch | Status | Actions |
|---|
Configure drivers and vehicles for each branch. When a branch is selected in Transfer, Final Mile, or Scheduling modules, only the predefined drivers and vehicles for that branch will be available.
| Driver Name | Phone | License # | Status | Actions |
|---|
| Plate Number | Type | Make/Model | Status | Actions |
|---|
This will permanently delete ALL cargo orders, internal transfers, external transfers, and related data. This action cannot be undone. Only use this for testing purposes.
Clears all data per database mapping.
Clears only operational data. Preserves all configuration.
Select a sector first, then define box sizes and rates for that sector. The same config is applied to all branches in the sector. Odd is always included. These settings drive Pricing and all box size dropdowns (Cargo Collection, Pick Up Schedule, Empty Box LPO, etc.).
Add or remove standard box size names. "Odd" is fixed and always available for all branches.
Select a sector above. Tick which box sizes each branch uses, and enter empty box sale rate (₱) and internal purchase cost (₱) per size. Odd is always included. These apply to all branches in the selected sector.
| Branch |
|---|
Set the sale price per box size when selling empty boxes at this branch. Used in Cargo Collection (Box Sales / LPO) and in the Empty Boxes module.
Rates for:
Rules apply to the branch selected above. Add lines: box size, mode, condition (city/route/branch), value, amount. Copy rules from another branch to save time.
| Box Size | Mode | Condition | Value | Rate Type | Amount (₱) |
|---|
Box sizes and branch assignment are configured in Settings → Box Sizes. Odd is always available for all branches. The rates below apply to the sizes you assign there.
Note: Branches are configured in the Zoning module. Select a branch from Zoning to assign pricing.
Ledger shows all inward and sales (from this module, Cargo Collection, and Driver Pick Up). Record new entries below.
| Date | Type | Branch | Box Size | Qty | Remaining | Customer / Notes | Rate | Total |
|---|
No entries for the selected filters. Record an inward or a sale below.
Empty boxes received at a branch.
Sell empty boxes to a customer.
| Date | Type | Details | Amount |
|---|
| Date | Category | Amount | Notes |
|---|
| Date | Tag | Type | Invoice No. | Customer | Branch | Payment Mode | Payment Receipt | Amount |
|---|---|---|---|---|---|---|---|---|
| Select a branch and date to view collections | ||||||||
| Date | Branch | Type | Amount | Cheque Count | Bank Account | Notes | Action |
|---|---|---|---|---|---|---|---|
| No banking entries yet | |||||||
| Date | Mode | Category | Payee | Bank Account | Link | Amount | Notes | Receipt | Actions |
|---|---|---|---|---|---|---|---|---|---|
| No expenses recorded yet | |||||||||
| Date | Branch | Revenue Stream | Description | Amount | Reconciliation |
|---|---|---|---|---|---|
| Select a sector to view income ledger | |||||
| Date | Branch | Category | Mode | Description | Amount | Link | Receipt | Actions |
|---|---|---|---|---|---|---|---|---|
| Select a sector to view expenses ledger | ||||||||
Step 1: Create a payee here and assign which branch(es) can use it. Leave branches unassigned to show in all branches. Then add invoices below (Step 2).
Step 2: Add an invoice for a payee you already created above. Select payee from the dropdown.
| Date | Type | Invoice # | Description | Debit (₱) | Credit (₱) | Balance (₱) | Status | Due Date | Invoice | Reconciliation | Actions |
|---|
All invoices for this payee with individual attachment links.
| Invoice # | Date | Description | Amount (₱) | Status | Attachment |
|---|---|---|---|---|---|
| No invoices | |||||
| Date | Branch | Payee | Category | Description | Amount | Status | Payment Method | Reconciliation | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Select a sector and month to view payment schedule | |||||||||
| Transaction ID | Date | Branch | Transaction Detail | Payee | Bank Account | Amount | Receipt | Source | Actions |
|---|---|---|---|---|---|---|---|---|---|
| No bank transactions yet | |||||||||
| Bank Account | Month | Upload Date | File | Actions |
|---|---|---|---|---|
| No bank statements uploaded yet | ||||
| Date | Branch | Type | Detail | Amount | Source | Actions |
|---|---|---|---|---|---|---|
| Select a sector to view wallet ledger | ||||||
Log asset transfers between any branches
| Date | From | To | Asset Category | Amount | Description |
|---|---|---|---|---|---|
| No inter-group transactions recorded yet | |||||
Define expense categories that will be applied to all Accounts Gates (Day Book and Headquarters Accounts) for the selected sector.
| Category Code | Category Name | Magnetic Linkage | Description | Actions |
|---|---|---|---|---|
| No expense categories defined yet | ||||
| Tracking Number(s) | Branch | Date |
|---|
View all cargo currently in the final mile warehouse, organized by routes for easier planning.
Loading final mile cargo...
| Date | Tag | Type | Invoice No. | Customer | Branch | Amount | ||
|---|---|---|---|---|---|---|---|---|
| Select a branch and date to view collections | ||||||||
| Date | Mode | Category | Payee | Bank Account | Link | Amount | Notes | Receipt | Actions |
|---|---|---|---|---|---|---|---|---|---|
| No expenses recorded yet | |||||||||
| Date | Branch | Revenue Stream | Description | Amount |
|---|---|---|---|---|
| Select a sector to view income ledger | ||||
| Date | Category | Link | Description | Amount | Status |
|---|---|---|---|---|---|
| Select a sector to view expenses ledger | |||||
Add payee details and assign branches. Then add invoices or credit notes below.
| Date | Payee | Description | Amount | Status |
|---|---|---|---|---|
| Select a sector to view payment schedule | ||||
Upload and manage bank statements for reconciliation.
Manage company assets and inter-branch transfers.
Define expense categories for all accounts gates.
| From | To | Rate | Effective Date | Actions |
|---|---|---|---|---|
| No FX rates configured yet | ||||
| Date | Transfer ID | From Sector | To Sector | Value (Origin) | Value (PHP) | Status |
|---|---|---|---|---|---|---|
| No international transfers recorded | ||||||
| Date | From | To | Amount | Description |
|---|---|---|---|---|
| No money movements recorded | ||||
| Sector | Revenue | Expenses | Net P/L | Margin |
|---|---|---|---|---|
| No P&L data available | ||||
| Date | Sector | Type | Description | Debit | Credit | Balance |
|---|---|---|---|---|---|---|
| No historic data available | ||||||