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.
