Sales Service Fee Excel Conversion

What problem it solves

In fund sales-service-fee settlement, source statements often arrive as PDF or Excel with scattered fields and unrelated charges such as agency fees, subscription fees, redemption fees, management fees, and custody fees. Manual cleanup requires identifying sales service fee rows, adding the correct TA code, validating fund codes, and exporting a fixed Excel layout. sale-fee-convert codifies this workflow: after upload, it directly outputs a downloadable .xls (Excel 97-2003) file without follow-up questions or narrative summaries.

How it works and where to stop

The main steps are:
- Pre-check: accepts PDF / Excel files that are unencrypted, uncorrupted, and parseable.
- Extraction and mapping: identifies the full fund company name and binds it to a TA code using the built-in mapping table; extracts fund code and sales service fee amount.
- Strict filtering: keeps only sales service fee rows and excludes agency, subscription, redemption, conversion, management, custody, purchase, and other fees; fund codes must be six-digit numeric values or they are discarded.
- Standard output: writes rows with the fixed header order TA code, Fund code, Custody service fee amount, Algorithm name (optional), Month, and Month 2; the algorithm column is left blank, and start/end month values are placed only in the first row based on the reporting period.
- File naming: names the file using the reporting period and fund company name for easier archiving.

It is suitable for structured or semi-structured sales-service-fee statements where the company and fee field can be recognized. Do not rely on it for encrypted or damaged files, missing required fields, or work that requires preserving non-sales-service-fee line items.