Google SheetsTrip log · September
StaffTripReasonDays
AimanPenangClient visit3
Mei LingJohor BahruSite audit2
RaviKuantanTraining4
FarahIpohClient visit1
Trigger: month end, trip log closed
Google SheetsClaim rates 2026
GradeReasonPer day
ExecutiveClient visitRM 90
ManagerClient visitRM 120
ManagerTrainingRM 80
ExecutiveSite auditRM 100
Aiman is a manager on a client visit: RM 120
ChatGPTPricing each trip
Matching 4 trips to the rate table
- Aiman · 3 days × RM 120 = RM 360
- Mei Ling · 2 days × RM 100 = RM 200
- Ravi · 4 days × RM 80 = RM 320
- Farah · 1 day × RM 90 = RM 90
Google SheetsClaims · September
AimanRM 360
Mei LingRM 200
RaviRM 320
FarahRM 90
Total to payRM 970
Ready for finance to approve
33hrs saved a year
From 3 hours a month down to 15 minutes.
Outstation claims, priced on their own
- The problem
- Every staff member who travels is paid at a different rate, depending on who they are and why they went. Finance priced each claim by hand.
- The result
- The trip log goes in, the right rate is applied to every line, and the totals come back.