Categories

← View All Tools

XLSX Invoice Generator

Generate professional invoice/quotation workbooks with auto totals, tax calculations, and company logo embedding

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

Example Results

1 examples

Generate Invoice with Logo and Tax

Create an invoice workbook with line-level tax, totals, and embedded company logo

xlsx-invoice-generator-example1.xlsx View File
View input parameters
{ "documentType": "invoice", "title": "Tax Invoice", "companyInfoJson": "{\n \"name\": \"Elysia Labs Ltd.\",\n \"address\": \"88 Innovation Road, Shanghai\",\n \"taxId\": \"CN-91440000-2026\",\n \"phone\": \"+86-21-8888-6666\",\n \"email\": \"[email protected]\"\n}", "customerInfoJson": "{\n \"name\": \"Nova Commerce\",\n \"address\": \"120 Market Street, Shenzhen\",\n \"email\": \"[email protected]\"\n}", "lineItemsJson": "[\n {\n \"description\": \"Implementation Service\",\n \"quantity\": 3,\n \"unitPrice\": 1200,\n \"taxRate\": 13\n },\n {\n \"description\": \"Support Package\",\n \"quantity\": 2,\n \"unitPrice\": 600\n }\n]", "defaultTaxRate": 13, "invoiceNumber": "INV-2026-031", "issueDate": "2026-03-06", "dueDate": "2026-03-20", "currencySymbol": "$", "logoFile": "/public/samples/images/logo.png" }

Click to upload file or drag and drop file here

Maximum file size: 10MB Supported formats: image/png, image/jpeg

Key Facts

Category
Format Conversion
Input Types
select, text, textarea, number, date, file
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX Invoice Generator allows you to create professional, ready-to-use invoice and quotation workbooks instantly. By providing your company and customer details alongside line items, the tool automatically calculates subtotals, tax amounts, and grand totals, while supporting custom branding through logo embedding.

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.

Examples

1. Professional Service Invoice

Freelance Consultant
Background
A consultant needs to bill a client for multiple services with varying tax requirements.
Problem
Manually calculating taxes and formatting Excel sheets is prone to errors.
How to Use
Input company and client details, define line items with specific tax rates, and upload a logo.
Example Config
{"documentType": "invoice", "defaultTaxRate": 13, "currencySymbol": "$"}
Outcome
A polished XLSX file with accurate tax breakdowns and totals, ready for client delivery.

Try with Samples

json, xlsx, xls
QR Code Samples
Sample QR code images for testing QR code reading and generation tools
preferred input family json,image
json, image
PDF Samples
Generated PDF samples from tools dated 2026-02-01 to 2026-02-10
preferred input family json,image
json, image
Grafana Advanced Application Samples
Comprehensive Grafana samples covering advanced dashboard design, alerting configurations, data source integrations, and plugin development
preferred input family json,image
json, image
SWC Rust Compiler Samples
Speedy Web Compiler (SWC) examples including configuration, plugins, and integration with modern JavaScript/TypeScript projects
preferred input family json,image
json, image

Related Hubs

Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Image Convert Tools
Explore 100 image tools for convert workflows and compare closely related utilities quickly.
Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.
Image Tools
Explore 40 image tools for utility workflows and compare closely related utilities quickly.

FAQ

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.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-invoice-generator

Request Parameters

Parameter Name Type Required Description
documentType select No -
title text No -
companyInfoJson textarea Yes -
customerInfoJson textarea Yes -
lineItemsJson textarea Yes -
defaultTaxRate number No -
invoiceNumber text No -
issueDate date No -
dueDate date No -
currencySymbol text No -
logoFile file (Upload required) No -
notes textarea No -

File type parameters need to be uploaded first via POST /upload/xlsx-invoice-generator to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-xlsx-invoice-generator": {
      "name": "xlsx-invoice-generator",
      "description": "Generate professional invoice/quotation workbooks with auto totals, tax calculations, and company logo embedding",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-invoice-generator",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]