A minimum viable system, without software
If you want to fix this today with a spreadsheet:
| Date | Booking | Customer | Amount | Method | Reference | Type | Verified by |
|---|
One row per payment, never per booking. Sort by booking to see what is owed; sort by date to match against your GCash statement. Keep deposits on a separate sheet with a status column.
That is genuinely enough for a business under about eight vehicles, provided somebody fills it in the same day. The failure mode is not the spreadsheet. It is the two-week backlog.