When a PDF is better than a spreadsheet
- Sending a report to a client who shouldn't edit it.
- Attaching a schedule to a loan file, a tax return or an audit request.
- Printing a long list with the header on every page.
For financial statements, the profit and loss and other templates on this site export formatted PDFs directly.
Why not use Excel's own export?
Excel can make a PDF with File > Export > Create PDF/XPS, but the result depends on the print area, page breaks and scaling of each sheet. Wide sheets are split across pages, and the header row only repeats if you set Page Layout > Print Titles first. This converter lays out the table for you: columns sized to their content, the header on every page, amounts aligned for easy reading, and page numbers. CSV files, which Excel can't export with any formatting, work the same way.
Getting a clean result
- Remove helper columns and notes you don't want the reader to see before converting.
- Format amounts in Excel (currency, two decimals): the PDF shows values as they're displayed.
- Choose landscape for ledgers and registers with many columns, portrait for lists and schedules.
- Split very long tables by period or account if the reader needs to find things quickly.
Combining with other documents
Month-end packages often mix a cover letter, a few schedules and statements. Convert each spreadsheet here, then put everything in one file with Merge PDF and fix the page order with Organize PDF pages.