A step-by-step guide to documenting recharges, refunds, and weight adjustments for exact cost alignment on every consolidated shipment.
Precise financial tracking is the cornerstone of successful cross-border shipping with PinguBuy. The official PinguBuy Spreadsheet is your central tool for ensuring every yuan is accounted for. By meticulously logging three key transaction types—recharges, refunds, and weight adjustments—you maintain perfect alignment between your balance, parcel costs, and actual expenses.
1. Documenting Wallet Recharges
Recharges are the inflow of funds into your PinguBuy wallet. Accurate recording here sets your starting balance correctly.
How to Log:
- Open the "Balance Tracker" or "Transaction Log" tab in your PinguBuy Spreadsheet.
- For each recharge (via Alipay, PayPal, etc.), create a new row.
- Enter the Date, Amount (as a positive value), and the updated Total Balance.
- Note the transaction ID or payment method in the "Notes" column for verification.
Result:
2. Recording Refunds and Returns
Refunds from agents or sellers for returned items, overpayments, or coupons must be logged to reflect money returning to your wallet.
How to Log:
- In the same transaction log, create an entry for each refund notification you receive.
- Enter the Date, the Refund Amount (as a positive value), and the newly adjusted Total Balance.
- Crucially, link this entry to the original parcel or item. Include the Parcel ID/Number
Result:
3. Adjusting for Final Package Weight
The most critical step for cost accuracy. Parcels are often prepaid based on an estimated weight, then adjusted to the actual shipping weight
Result:
How to Log:
The Cycle of Accuracy
By consistently following this three-part documentation cycle for every transaction and parcel, you create a self-correcting financial model. The PinguBuy Spreadsheet becomes a single source of truth, enabling you to:
✅ Reconcile with Ease
Match your spreadsheet's ending balance to your PinguBuy wallet statement every month.
✅ Analyze True Costs
Identify which items, hauls, or shipping lines offer the best value based on final adjusted weights.
✅ Budget Confidently
Forecast future shipping expenses more accurately using historical, adjusted data.
Start today: