Analysis of Japan Travel Expenses

Data Source: Analysis of Japan Travel Expenses (77 valid records, covering July 28, 2026 to August 14, 2026).

1. Overall Overview

Indicator	Amount (RMB)
Total Transactions	77
Travel Days	14 days
Total Book Amount (RMB Column)	20,402.83
Total Discounts/Deductions	13.76
Total Actual Paid (Actual Column)	20,389.07
Daily Average Actual Spending	1,456.36
Per Person Spending (Split by 2)	10,194.53
Repayment/Coupon Offset	-100.23

The actual payment for this trip to Japan was about 20,389 RMB. With two people sharing (marked as "PT" in the notes), the per-person cost was about 10,195 RMB; daily spending was about 1,456 RMB. The category with the highest share was "Transport," totaling 9,037 RMB. The total book amount (RMB column) was 20,402.83 RMB, and the difference of 13.76 RMB from the actual payment column is the total deduction, consistent with the discounts column.

2. Consumption Category Structure

Sorted by actual payment amount, here is the share of each category:

Category	Amount (RMB)	Share
Transport	9,037.02	44.1%
Accommodation	3,940.18	19.2%
Shopping	3,477.80	17.0%
Food	2,722.82	13.3%
Entertainment	927.48	4.5%
Communication	216.00	1.1%
Insurance	168.00	0.8%

Note: "Repayment" is a negative offset (coupon deduction) and is not included in the spending share, listed separately.

3. Payment Method Distribution

Payment Method	Amount (RMB)
Bank of China Debit Card	8,639.70
SPDB Credit Card	7,764.33
CGB Credit Card	3,922.08
CCB Debit Card	45.70
Alipay Huabei	17.26

Payments were primarily made via bank cards: the Bank of China Debit Card and SPDB Credit Card were the two main players, followed by the CGB Credit Card; Alipay Huabei and the CCB Debit Card were only used for sporadic small transactions.

4. Consumption Channel Distribution

Channel	Amount (RMB)
Physical Stores	8,725.47
OTA (Fliggy)	6,640.70
Official (Website)	5,022.90

Official channels and physical stores were the main consumption scenarios, while OTA was mostly used for booking major items like flights and accommodation.

5. Daily Consumption Trends

Daily consumption fluctuated significantly. Large expenses such as accommodation and transport (e.g., Shinkansen) were concentrated on specific dates, driving the cumulative curve to rise in steps; daily food and convenience store consumption formed a relatively stable baseline.

6. Summary and Suggestions

• Total actual expenditure was about 20,389 RMB, with a structure dominated by "Transport," "Shopping," and "Accommodation."
• Discounts saved a total of 13.76 RMB. It is recommended to continue making good use of credit card foreign cashback and tax-free/refund policies for future trips.
• Since transportation IC cards like Suica are used in scattered scenarios and original records are not broken down, it is advisable to track them separately in the future for precise calculation of transport costs.
• Only part of the cash (about 20,000 JPY) was used. Next time, the cash reserve can be appropriately reduced, and the proportion of electronic payments can be increased.