Commission Statement Generator

Tightened the spacing of the Distributor and contact lines and gave the column-header row more room on every distributor statement, so rows 3-5 match the approved template. The corrected spacing is applied both when the Excel review file is created and when it is turned into PDFs.

Fixed a bug where the logo could overlap and hide the left-side column headers (Invoice Date, Invoice Num, P.O. Number, Surgeon, Name of Facility) on some PDFs — the logo is now always inserted at a fixed, header-safe size. Also: long facility/memo/P.O. values now grow their row instead of being clipped, large totals no longer risk showing as "####", the Invoice Amount header is right-aligned over its numbers, and invoice dates render in a consistent MM/DD/YYYY format.

Fixed a bug where the P.O. Number column collapsed to a narrow default width on some distributor PDFs, which made P.O. values wrap onto a second line and get clipped by the row height, and threw off the spacing next to the Surgeon column. Column widths are now copied faithfully from the reviewed workbook (including columns Excel groups together), so PDFs match the Excel layout.

Fixed a critical bug where clicking "Download Excel" after Step 1 could return the original uploaded source file instead of the generated review workbook. The download now always serves the correct Commission_Statements file. Also fixed the Summary sheet year (was hardcoded to 2026; now uses the year detected from the Invoice List), added a clear error if no distributor groups are found in the Invoice List, and PDF generation now reports a clear error if LibreOffice fails instead of silently producing an empty zip.

Column headers now center vertically in their row instead of being pinned to the top. Header row height also tightened for a cleaner, more professional look.

Added extra spacing between the rep contact info and the column header row so the table no longer looks scrunched.

Column headers now always display from the top of the cell so wrapped text is never clipped. "Invoice Number" shortened to "Invoice Num". Invoice Date column width adjusted for clean display.

P.O. Number column now expands wide enough to show long values like "MAX040126Distal Radius855" without cutting off text. Name of Facility column also has a wider maximum.

Column widths now automatically adjust to fit the actual content in each distributor tab. Long facility names and other text no longer get cut off.

PDF filenames now use US date format (MM-DD-YYYY) instead of DD Month YYYY. Example: S-Squared Surgical_Commission Statement Paid on 05-31-2026.pdf

Added a What's New link in the footer showing release history.

Column headers now repeat on every page of multi-page statements. PDFs print in landscape orientation. User edits to column widths are preserved when generating PDFs. Invoice Date column now wraps correctly in print.

Switched to a light, high-contrast theme for easier reading. Logo resized. Distributorship name now appears above contact info. Invoice Date and Invoice Number left-justified. Column F renamed to Name of Facility. Column widths adjusted for better text fit. PDF files renamed with distributor name and payment date.

Two-step commission statement workflow: upload a source worksheet to generate a review workbook with Summary and distributor tabs, then upload the verified workbook to create a PDF zip bundle.