Generate professional invoices that your clients can view and download instantly. This template includes all the fields you need for compliant invoicing: line item descriptions, quantities, unit prices, tax calculations, and payment terms. Each row represents a billable item, making it easy to calculate subtotals and apply discounts or tax rates programmatically. Whether you are a freelancer sending a single invoice or a SaaS platform generating thousands of invoices per month through the API, this template gives you a clean starting point. The column structure follows standard accounting conventions, so the data exports cleanly to PDF or XLSX for your records. You can extend it with custom columns for purchase order numbers, project codes, or currency fields to support international billing workflows.
| Item | Description | Quantity | Unit Price | Tax % | Total |
|---|---|---|---|---|---|
| Web Development | Frontend build — React dashboard | 40 | $150.00 | 0% | $6,000.00 |
| UI Design | Figma mockups for 12 screens | 1 | $2,400.00 | 0% | $2,400.00 |
| Hosting Setup | AWS infrastructure + CI/CD pipeline | 1 | $800.00 | 8% | $864.00 |
| QA Testing | Manual + automated test suite | 16 | $95.00 | 0% | $1,520.00 |
Generate this invoice programmatically with a single POST request. The API returns a shareable URL that anyone can open in the browser.
curl -X POST https://openofficeai.com/api/v1/sheets \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"title": "My Invoice",
"sheets": [{ "rows": [["Item","Description","Quantity","Unit Price","Tax %","Total"],["Web Development","Frontend build — React dashboard","40","$150.00","0%","$6,000.00"],["UI Design","Figma mockups for 12 screens","1","$2,400.00","0%","$2,400.00"]] }]
}'Returns { "id": "...", "url": "...", "created_at": "..." }. See the full API docs for formatting, formulas, and export options.
This template comes with 6 columns designed for a standard invoice workflow. Each column can be renamed, reordered, or extended through the API or the browser editor.
The name or title of the billable item or service you are invoicing for.
A brief explanation of the work performed or product delivered for this line item.
The number of units, hours, or items being billed on this line.
The price per unit before tax. Supports any currency format.
The tax rate applied to this line item, expressed as a percentage.
The calculated total for this line: quantity multiplied by unit price, plus tax.
This template is a starting point. Here are specific ways to adapt it to your workflow:
Add a "Discount %" column between Unit Price and Total to handle volume discounts or promotional pricing for specific line items.
Include a "Payment Terms" row at the bottom (e.g., Net 30, Net 60) and a "Notes" row for bank transfer details or late payment policies.
Add a "Currency" column if you bill international clients, and use per-cell styling (bold, colors, fontSize via the cells parameter) to apply number formatting to price columns.
Yes. You can include a Tax % column and a computed Total column. When you export the spreadsheet to PDF or XLSX, the values render exactly as you set them. For dynamic formulas, use the cells endpoint to apply Excel-style formulas like =C2*D2*(1+E2/100).
Every document created through the API gets a unique shareable URL. You can send this link directly to your client — they can view the invoice in their browser without signing up. If you need a PDF, request GET /api/v1/download/{id}?format=pdf.
The API does not auto-increment invoice numbers, but you can include an invoice number in the document title or as a metadata field. Most teams generate the invoice number in their own backend and pass it as part of the API request payload.
Plan and track your spending with a structured budget spreadsheet that breaks expenses into categori...
Submit and review employee expenses with a clear, auditable spreadsheet format. This template captur...
Build a clear profit and loss statement that summarizes revenue, costs, and net income over a given ...
Sign up for free and start building spreadsheets in seconds — from the browser or via the API.