Create a manageable household budget with transactions, categories and a monthly summary. 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.
- Step 1. Create a Transactions sheet with Date, Category, Description and Amount as column headers.
- Step 2. Choose a small set of categories you can maintain consistently: Housing, Food, Transport, Utilities, Other.
- Step 3. Use SUMIF or a pivot table to summarize spending by category.
- Step 4. Create a Budget sheet comparing planned amounts with actual amounts, then calculate the difference.
- Step 5. Check the total against account statements and preserve a backup before changing the structure.
Worked example you can recreate
Suppose the Food budget is 400 and actual spending is 357. The variance formula Planned minus Actual returns 43. Use a clearly labeled rule that negative values represent overspend.
Common problems and what to verify
A sample budget is a tracking tool, not personalized financial advice. Imported transactions may include refunds that need consistent handling.
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 Calc track spending without macros?
Yes. Basic formulas, filters and pivot summaries can create a useful monthly budget without macros.
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.
