How to create an invoice in Excel with formulas and PDF export

Knowing how to create an invoice in Excel means building both a calculation sheet and a customer document. A good workbook separates inputs from formulas, handles additional rows safely and prints to a readable PDF without exposing internal notes.

Design the workbook structure

Create separate areas for seller, customer, invoice number, issue and due dates, currency and terms. Build an item table with description, quantity, unit price and line amount columns. Keep internal notes or lookup data on a separate non-print sheet.

Use consistent number and date formats and a visible currency label. Freeze panes for long item tables if helpful, but design the print area for the customer rather than the editor. Save a clean master before adding live data.

Add reliable invoice formulas

For each row, calculate line amount with a formula equivalent to quantity multiplied by unit price, such as =B12*C12 for the relevant cells. Calculate subtotal with =SUM(D12:D21). Structure discount and tax formulas from clearly identified rates or amounts.

Test blank rows, zero quantities, decimals, negative values, inserted rows and copied formulas. Decide how rounding works and compare a sample total independently. Never copy an unverified tax rate into the master.

Protect the template and inputs

Visually distinguish editable cells and lock calculated cells where practical. Use data validation for dates or controlled values, but do not assume validation proves transaction correctness. Protect workbook structure so users do not delete formula columns accidentally.

Maintain version control and limit changes to payment instructions, tax logic and core formulas. A protected master reduces accidental damage, but authorized reviewers should still inspect formulas after any template update.

Configure and inspect PDF output

Set print area, margins, orientation, scaling, repeating headers and page breaks. Use Print Preview to ensure the item table and totals are not clipped. Export all intended pages to PDF and open the saved file in a separate viewer.

Check for hidden columns, internal notes, formula errors and unexpected blank pages. Send the final PDF instead of the editable workbook unless the recipient has a valid need for source data. Preserve the approved workbook and PDF under controlled access.

How to use Free Invoice Maker for this task

When your goal is how to create an invoice in Excel, start by matching the document to the transaction. Use a quotation before price approval, an invoice when an amount is due, a receipt after payment, and a waybill for delivery information. Free Invoice Maker combines all four workflows in one Android app, so you do not need a different template for every stage.

1. Install the official app from Google Play and open the appropriate document maker.
2. Add verified business and customer information rather than copying from an old document without checking it.
3. Enter document numbers, dates, products or services, quantities and unit prices.
4. Add a valid discount or tax only when it applies, then check the automatic total independently.
5. Preview the document, download the PDF, open the saved file and verify every page.
6. Send the final version to the correct recipient and retain a secure copy for your records.

Create a professional invoice on Android

Make unlimited invoices, receipts, quotations and waybills, then download or share the PDF.

Information every professional invoice should include

A reliable invoice identifies the seller and customer, uses a unique reference, states the issue date and relevant due date, and describes each product or service clearly. It should show quantities, unit prices, subtotal, agreed discount, applicable tax, final amount, currency and payment terms. Add only information that belongs in the document, and avoid passwords, full payment-card data or unrelated personal details.

Requirements differ by country, industry and tax status. A document generator organizes the information you provide; it does not decide whether VAT, GST or another tax applies. Check rules that govern your transaction and seek qualified advice when the amount, customer location or tax treatment is uncertain.

Why an Android invoice app can be more practical

Browser templates, Word files and spreadsheets can work, but they often require manual formatting, formulas or access to a particular computer. An Android invoice app is useful when work happens at a customer site, shop, delivery point or shared workspace. You can enter the details while they are fresh, create a consistent PDF and share it using compatible services already on the device.

The official listing for Invoice & Quotation Generator describes unlimited document creation, PDF download, printing, sharing, automatic totals, tax and discount support. It also identifies the app as containing ads. Store facts can change, so review the current Google Play listing before installation.

Frequently asked questions

Final recommendation

An Excel invoice is dependable when formulas, protected inputs and print settings are tested as carefully as the visible design. Export and inspect every customer PDF.

For a fast mobile workflow, download Free Invoice Maker from Google Play. Create a test document first, review the resulting PDF, and use real customer information only after you understand the fields and export process.

Editorial note: This guide was created from the official app listing, product documentation, current Google autocomplete language and common invoice questions. It does not provide legal, accounting or tax advice. Updated 24 August 2026.