Supported spreadsheet columns and multi-line invoice grouping
Spreadsheets store flat rows, whereas real invoices often contain several billable lines for the same client. This bulk generator solves that mismatch by recognizing 15 standard columns (plus common header aliases) and grouping every row that shares a number value into one multi-item PDF.
Because CSV dialects vary across spreadsheet programs, the parser follows the quoting and escaping conventions in IETF RFC 4180 Common Format for CSV Files while accepting .csv, .tsv, .txt, and .xlsx files up to 10 MB. If you work with a complex multi-tab workbook, you can convert multi-sheet Excel workbooks to clean CSV files before importing.
| CSV column | Accepted header aliases | How the parser uses it |
|---|---|---|
number |
invoice number, invoice no, doc number, no |
Groups matching rows into one PDF document |
date / due_date |
invoice date, issue date, due, valid until |
Sets issue and payment due dates (YYYY-MM-DD or local) |
client_name |
client, customer, bill to, company |
Populates the Bill to recipient name |
description / details |
item, service, product, item details |
Adds line-item title and secondary description |
quantity / unit_price |
qty, hours, price, rate, amount |
Computes line totals from US or European decimals |
tax_percent |
tax rate, vat %, gst %, sales tax |
Maps to the matching rate for your selected Country |
How does bulk CSV import handle regional tax rates and currencies?
The tax_percent column matches each row’s numeric percentage against the tax codes configured for your selected Country and Province or state, while parseAmount() normalizes both US ($1,234.50) and European (1.234,50) number formats. Unmatched percentages or currency symbols are flagged in the review panel before PDF rendering starts.
Mapping tax_percent to country and province tax codes
When you choose a country under Country, the island loads that jurisdiction’s tax presets (such as 21% VAT in EU countries, 5% GST or 13% HST in Canadian provinces, or state sales tax in the US). Entering 0 maps to the jurisdiction’s non-taxed code, while leaving tax_percent blank uses the country’s default rate.
If you only need to create one custom document with specialized reverse-charge notes or custom tax labels, use the single-document invoice generator instead. Both tools share your saved business profile in IndexedDB so your logo and address carry over automatically.
Parsing US and European decimal formats across 10 MB files
European versions of Excel frequently export 1.234,50 with periods as thousands separators and commas as decimal points, or prepend a UTF-8 Byte Order Mark (EF BB BF) per the Unicode UTF-8 Byte Order Mark (BOM) FAQ. The parseAmount() helper strips currency signs and normalizes both decimal conventions cleanly inside a Web Worker.
Exporting multi-document batches as a ZIP archive
Switching the Make selector lets a single spreadsheet drive Invoices, Quotes, Receipts, and Credit notes without reformatting columns. All documents in a run inherit your branding and compile into a single .zip archive containing one PDF per document.
Shared business branding, logos, and live PDF previews
Expand Your business to enter your company name, address, email, phone, tax ID, payment details, terms, footer, logo, and one of seven accent colors. When multiple documents are parsed, the Preview dropdown and Full preview link render the real pdf-lib output for any selected invoice number so you can spot long-description wrapping before exporting.
Comparing bulk CSV batching against single-document editing
Bulk CSV generation works best for monthly retainers, membership renewals, or e-commerce order exports where dozens of clients share the same terms and layout. For personalized letters or certificates stamped onto an existing PDF background, you can merge spreadsheet rows onto custom PDF letterheads instead.
Unlike single-document editing, bulk runs apply one Terms, Footer, and Payment details block across the whole batch. Keep those fields concise and general enough for every recipient in the spreadsheet.
Troubleshooting Excel encoding, local history, and retention scope
Spreadsheet auto-formatting and local browser storage follow predictable rules that are easy to verify before a monthly billing run. Checking dates, leading zeros, and backup habits keeps your records audit-ready.
Fixing comma decimals, leading zeros, and date formatting
Excel often strips leading zeros from invoice numbers (0042 becomes 42) or flips DD/MM/YYYY dates when saving CSVs. Format invoice number columns as Text and dates as ISO YYYY-MM-DD before exporting, or upload the .xlsx workbook directly.
Tip: Download
invoices-template.csvfirst and test with three multi-line rows to verify your regionaltax_percentmapping and logo placement before importing a 200-row ledger.
IndexedDB device history and tax recordkeeping boundaries
Checking Keep a copy of each on this device stores generated documents in the browser’s MDN Web Docs IndexedDB Storage API without transmitting client data over the network. You can later export your saved browser invoices to a sales ledger as CSV or Excel.
Informational scope notice: Tax authorities such as the IRS in its IRS Small Business Recordkeeping Guidelines require businesses to retain supporting sales records and verify applicable tax rates. This bulk generator is an operational formatting tool and does not constitute tax or accounting advice; consult a qualified accountant to confirm local invoice retention and tax rules.