Maxx Health

Commission Statement Generator

Build the review workbook first, confirm the Summary and distributor tabs, then upload the verified workbook to create the final PDF zip.

1

Create Review Workbook

Upload the monthly spreadsheet template. The app will build a new Excel workbook with the Summary sheet plus individual distributor tabs for review.

Input for Step 1

Use the source commission worksheet that includes at least Invoice List and Dist Lookup.

SOURCE WORKBOOK

Drop the template file here or click to browse for a .xlsx worksheet.

Building the review workbook...

Parsing invoices -> creating Summary -> building distributor tabs
Excel review file ready

Review Workbook
Download, review, and make any needed edits before step 2.
Download Excel
2

Create PDF Zip

Upload the reviewed Excel workbook from step 1. This can be the original generated file or your edited version after accounting verifies it.

Input for Step 2

Upload the verified statements workbook with the Summary sheet and the distributor tabs you want turned into PDFs.

VERIFIED WORKBOOK

Drop the approved workbook here or click to browse for the reviewed .xlsx file.

Generating PDFs from the verified workbook...

Reading distributor tabs -> converting sheets -> creating zip
PDF bundle ready

PDF Zip File
Distributor PDFs packaged into a single zip file.
Download Zip

What's New

v2.0 Download & Reliability Fixes

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.

v1.9 Column Header Alignment Fix

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.

v1.8 Spacing Above Column Headers

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

v1.7 Header Text Wrapping Fix

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.

v1.6 P.O. Number Column Fix

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.

v1.5 Auto-Fit Column Widths

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.

v1.4 US Date Format in PDF Filenames

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

v1.3 What's New Feed

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

v1.2 PDF Generation Fixes

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.

v1.1 Light Theme & Statement Formatting

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.

v1.0 Initial Release

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.