To enable automatic Excel dropdowns, install PhpSpreadsheet:

cd public_html/api-backend
composer require phpoffice/phpspreadsheet

Alternative: Use the regular Excel export button and manually add dropdowns:

1. Open the exported Excel file
2. Select Payment Type column (excluding header)
3. Data > Data Validation > List > Source: transferred_to_bank
4. Repeat for Payment Status: paid,unpaid,pending

← Go back to report