How an Overnight Billing System Saved a Logistics Firm from Losing 3000 Yuan Daily

Problem Overview

Logistics companies often face mismatched billing at month‑end: missing deductions, wrong discounts, manual Excel reconciliation, and disputes that eat profit.

Solution Overview

We built a “Label Recharge and Deduction Management System” that automates the entire flow from client recharge → label deduction → reconciliation.

Key Features

1. Client self‑recharge with real‑time balance

Clients log in, view balance, discount rate, and daily deduction stats. Recharge supports Alipay and WeChat; successful payment updates the balance automatically.

2. Label import

Admins upload an Excel file (label number, weight, amount) or paste text. The system validates and batches the records into a pending list with clear statuses (pending review, reviewed, pending deduction, deducted).

3. One‑click deduction with automatic discount calculation

Read client discount rate

Calculate discounted amount

Deduct from balance

Generate a deduction record containing operator, before/after balances

4. Reconciliation query

Deduction records can be filtered by client, label number, or amount range, and exported as a complete settlement sheet at month‑end.

5. Management backend

Multi‑tenant admin portal provides user management, payment configuration, advertisement management, and SMS notifications.

Technical Architecture (for engineers)

Frontend: Vue 3 + TypeScript + Element Plus

Backend: Spring Boot 3 + MyBatis Plus

Payment: Aggregated payment gateway

Database: MySQL 8

Front‑end and back‑end are separated, making deployment straightforward.

Post‑launch Impact

Label leakage rate reduced from ~3% to 0

Manual reconciliation time dropped from 4 hours per week to 0.5 hour per month

Client recharge became real‑time instead of T+1

Deduction disputes fell from 5‑8 per month to zero

Conclusion

Transform label deduction from “manual recording” to “system management”.

Automatic insufficient‑balance interception, discount calculation, traceable deduction records, and one‑click reconciliation turn thin logistics margins into pure profit.