INDEPENDENT SOFTWARE JOURNAL
TrebuchetJOURNAL
EST. 2026 · DIGITAL EDITIONExplore guides
LIBREOFFICE · CALC · HOW-TO GUIDE

Create a Simple Invoice in LibreOffice Calc

Build a reusable invoice spreadsheet with reliable line-item calculations and clear customer information.

Build a reusable invoice spreadsheet with reliable line-item calculations and clear customer information. This tutorial focuses on a repeatable real-world task you can test on a sample file, not an unverified performance claim. LibreOffice is a desktop office suite; application menus and options may differ by operating system and release.

How to do it: a practical workflow

Work on a copy of your files when learning a new application. The sequence below gives you a testable outcome and a way to verify the result.

  1. Step 1. Design a header with invoice number, invoice date, seller details and customer details.
  2. Step 2. Create columns for Item, Quantity, Unit Price and Line Total.
  3. Step 3. Use multiplication for each line and SUM for the subtotal; add tax only if applicable to your circumstances.
  4. Step 4. Add payment instructions and a clear due date, then proofread identifying information.
  5. Step 5. Export the final invoice to PDF while preserving a reusable ODS template for the next invoice.

Worked example you can recreate

Try this on a sample file

For 3 hours of design work at 45 per hour and 2 illustrations at 60 each, line totals are 135 and 120; the subtotal is 255. Verify the math before adding any jurisdiction-specific tax.

Common problems and what to verify

Tax rules and invoice requirements differ by location. Do not rely on a generic spreadsheet as a substitute for legal or accounting advice.

Before handing a document to someone else, open the output in the format that person will use. Check the content and key calculations rather than relying on an export-success notification.

Quick answer

Can I send an ODS invoice to a customer?

A PDF is usually easier to read consistently; keep ODS for your editable records unless the recipient asks otherwise.

Official reference and download

These instructions draw on documentation from The Document Foundation. For current user-interface details, refer to the official guide for this topic ↗. Download installation files only from LibreOffice's official download page ↗.

Keep learning

Each of these related guides answers a different task, so you can move from basic setup to a more specific workflow without repeating the same overview.

Independent educational coverage. Trebuchet is not affiliated with or endorsed by The Document Foundation. This article describes documented workflows and illustrative examples; it is not a report of hands-on benchmarking or testing.