# XLSX Invoice Generator Generate professional invoice/quotation workbooks with auto totals, tax calculations, and company logo embedding > Canonical page: https://elysiatools.com/en/tools/xlsx-invoice-generator - **Category:** Format Conversion - **Keywords:** xlsx, invoice, quotation, exceljs, tax, logo ## Overview Generate a polished invoice/quotation workbook. - Automatic subtotal, tax, and grand-total calculations - Supports per-line tax rate override - Embeds company logo (PNG/JPG) when provided - Works for both invoice and quotation scenarios ## Inputs - **Document Type** (select) - **Document Title** (text): Invoice - **Company Info JSON** (textarea): { "name": "Acme Inc.", "address": "123 Main St", "taxId": "TAX-001" } - **Customer Info JSON** (textarea): { "name": "Beta LLC", "address": "8 Pine Ave", "email": "finance@beta.com" } - **Line Items JSON** (textarea): \[ { "description": "Service A", "quantity": 2, "unitPrice": 500, "taxRate": 13 }, { "description": "Service B", "quantity": 1, "unitPrice": 300 } \] - **Default Tax Rate (%)** (number) - **Document Number** (text): INV-2026-0001 - **Issue Date** (date) - **Due Date** (date) - **Currency Symbol** (text) - **Company Logo** (file) - **Notes** (textarea): Thank you for your business. ## When to use - When you need to generate a standardized invoice or quotation document in Excel format. - When you want to automate the calculation of taxes and totals for multiple line items. - When you need to create professional billing documents that include your company logo and specific payment terms. ## How it works - Input your company and customer information using the required JSON fields. - Define your line items, including quantities, unit prices, and optional per-line tax rates. - Configure document settings such as the invoice number, dates, and currency symbol. - Upload your company logo and click generate to download your formatted XLSX file. ## Use cases - Freelancers generating monthly service invoices for clients. - Small business owners creating professional price quotations for potential customers. - Accounting departments standardizing billing templates with automated tax calculations. ## Frequently asked questions ### Can I use this tool to create quotations instead of invoices? Yes, you can select 'Quotation' as the document type in the settings to change the document header accordingly. ### Does the tool support different tax rates for different items? Yes, you can specify a unique tax rate for each line item in the Line Items JSON, or use the default tax rate for the entire document. ### What image formats are supported for the company logo? The tool supports PNG and JPEG image formats for embedding your company logo. ### Are the totals calculated automatically? Yes, the tool automatically calculates the subtotal, tax amount, and grand total based on the quantities and prices provided. ### Can I add custom notes to the invoice? Yes, you can use the 'Notes' field to include payment instructions, terms, or any other relevant information at the bottom of the document. ## Related tools - [PNG Table Screenshot to Excel](https://elysiatools.com/en/tools/png-table-screenshot-to-excel): Use MiniMax M3 vision to recognize a table from a PNG screenshot and export the reconstructed grid to Excel - [LibreOffice Office to Image](https://elysiatools.com/en/tools/libreoffice-office-to-image): Convert Office files to PNG/JPG previews with LibreOffice, with optional thumbnail resize - [XLSX Chart Embedder](https://elysiatools.com/en/tools/xlsx-chart-embedder): Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports - [Barcode Batch Generator](https://elysiatools.com/en/tools/barcode-batch-generator): Batch generate Code 128, EAN-13, UPC-A, ITF-14, QR Code, and Data Matrix outputs from CSV or multiline text - [PDF Invoice Generator](https://elysiatools.com/en/tools/pdf-invoice-generator): Generate a branded invoice PDF from structured line items - [Data URI Generator](https://elysiatools.com/en/tools/data-uri-generator): Convert files into Data URIs (Base64 or percent-encoded) for inlining images, fonts, and assets directly into HTML, CSS, or Markdown - [Image Palette to Design Tokens](https://elysiatools.com/en/tools/image-to-design-tokens): Extract a dominant color palette from an image (k-means clustering), then export it as CSS variables, SCSS variables, a Tailwind config, or JSON design tokens — with named colors and an auto-generated shade scale for each - [XLSX Data Validation Dropdown](https://elysiatools.com/en/tools/xlsx-data-validation-dropdown): Batch-create dropdowns, dependent cascading dropdowns, and input prompts in Excel workbooks using data validation rules ## Samples - [Web Image Processing Python Samples](https://elysiatools.com/en/samples/web-image-processing-python): Web Python image processing examples using PIL/Pillow including reading, saving, resizing, and format conversion - [Android Image Processing Java Samples](https://elysiatools.com/en/samples/android-image-processing-java): Android Java image processing examples including reading/saving images, scaling, and format conversion - [Android Image Processing Kotlin Samples](https://elysiatools.com/en/samples/android-image-processing-kotlin): Android Kotlin image processing examples including reading/saving images, scaling, and format conversion - [macOS Image Processing Objective-C Samples](https://elysiatools.com/en/samples/macos-image-processing-objectivec): macOS Objective-C image processing examples including image reading/saving, image scaling, and format conversion ## Related content - [Invoice, Receipt, and Tax Workflow](https://elysiatools.com/en/hubs/invoice-tax-workflows): Turn receipt or billing inputs into a checked invoice by normalizing amounts, applying the right tax path, validating identifiers, and producing a PDF, receipt, or XLSX record.