A month of invoicing is rarely one file. It’s a folder of near-identical workbooks — one per client, per job, per branch — and each one has to come out looking like your template: the header block whole, the line-item rows unbroken, the borders closed. Doing that through Excel’s Save as PDF, one file at a time, is where the evening goes.
Where Save as PDF lets invoices down
- A long list of line items gets a page break dropped through the middle of a row, so a quantity sits on one page and its price on the next.
- A wide invoice (many columns of rates, tax, running totals) has the right-hand columns sliced off at the paper edge.
- If a print area was set once and forgotten, the columns outside it are silently left out — and you don’t find out until the client does.
- And it’s one file at a time. Fifty invoices is fifty trips through the export dialog.
How CrazySmartPDF handles a batch of invoices
- Point it at the folder. Every workbook in it is rendered in a single pass, hands-off, with a run log at the end — the desktop app is built for exactly this kind of month-end run.
- Row-atomic layout. Each sheet is reflowed onto pages so a row or cell is never split across a page break. A line item stays in one piece.
- It works from your real workbook, so the PDF carries your invoice’s logo, number formats, colours and borders — the cover exports through Excel itself, and the data sheets are re-laid-out by the engine.
- Nothing vanishes quietly. CrazySmartPDF renders your full used range instead of cutting to a print area, so a stale or narrow print area doesn’t leave an invoice quietly missing a column — the PDF carries your real data.
- It checks its own output. Every finished PDF is rasterised and scanned for blank pages and clipped edges, and any that look off are noted in a per-file health report.
The honest part
CrazySmartPDF works from your real workbook, so the full-fidelity render needs Microsoft Excel installed on Windows (2016 or newer) — so your number formats, colours and styling carry through. The self-check flags blank and clipped pages; it doesn’t silently rewrite your invoice to fix them — you stay in control of what ships. The core is free to use, with no trial clock. Prefer not to install anything? The free web converter on the CrazySmartPDF home page runs the same smart engine on our server — your file is converted, then deleted (never stored) — it reads your cells and number formats and lays them out row-atomic; the self-check is what the Windows add-in and desktop app add.
