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 renders through your installed Excel, so the PDF carries your real invoice template — fonts, logo, borders, number formats — pixel for pixel, not an approximation.
- Nothing vanishes quietly. If a print area clamps columns or rows out of the render, CrazySmartPDF reports which ones (for example, dropped cols D–I, rows 40+) instead of dropping them without a word.
- It checks its own output. Every finished PDF is rasterised and scanned for blank pages and clipped edges, and any that look off are flagged so you catch them before they go out.
The honest part
CrazySmartPDF renders your real workbook, so it needs Microsoft Excel installed on Windows (2016 or newer) — that’s what keeps the output pixel-true. 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. There’s no public download to grab yet; you can watch the whole flow — read the sheets, respect the print areas, lay out a clean PDF — on the CrazySmartPDF home page.