📖 5–7 min read · 🎬 3 min video
A structured personal system for recording financial activity and understanding progress.
Read the article, watch the quick video walkthrough below, or explore both—whichever works best for you.
From Excel to Jira
In my eyes, this one is pretty cool — and probably one of the more extensive personal Jira setups I have. 😅
I’ve been tracking my transactions since 2020. For the first few years, everything lived in an Excel workbook with separate worksheets. Excel did the job, but by late 2024 I already had a lot of my personal projects and purchases in Jira and Jira Product Discovery, so keeping the financial side somewhere else started to feel unnecessary.
I migrated roughly 4,000 historical entries into Jira using a classic CSV import. It took some preparation to clean up the data, but having everything in one place has been worth it.
Why I started using Jira for this
The first reason is simple: I like Jira. If that wasn’t obvious enough. 😅
The more practical reason is that my finances don’t really exist in isolation. If I buy something related to a house project or an idea I’ve tracked in Jira Product Discovery, I can link the transaction directly to that work item.
That means I can start from an idea — a chair, appliance or another purchase — and quickly reach the receipt, purchase date, store and amount. It also works in reverse: if I only remember the store or approximate date, I can search the transactions and work backwards.
That connection is probably the main reason Jira became more useful to me than a large spreadsheet.
How the setup works
I’ve intentionally kept the structure relatively basic. There are two work types…
Transaction
Transaction is the main work type and represents either an expense or income.
I track the things I’m likely to search or report on later: transaction type, payment method, amount, date, expense/income category, store, receipt number and receipt details. I also still keep an HRK amount for older records, now calculated with a formula field rather than Automation.
If a transaction belongs to something larger — for example, a trip — I can also connect it through the Parent field.
Receipt Details is a rich-text (paragraph) field with a small table for item, quantity, price and total. At one point I even categorized every individual item. That turned out to be overkill. 😅
One lesson from this setup: just because Jira can store something doesn’t mean I need to track it.
Story — Monthly summaries
I use the Story work type as a monthly summary. Each one represents a calendar month and stores total income, total expenses and the difference between them.
Automation calculates those values at the end of the month, and I also have a manual recalculation rule for the inevitable moment when I find a forgotten transaction from two months ago. 👀
The newer List formatting rules make this particularly useful: if the Difference drops below zero, I can immediately highlight it in red.
Recurring transactions
Some entries are predictable: electricity, water, Internet, subscriptions, salary and similar transactions.
I currently have around 15 recurring entries that are automatically created on the first day of each month. Known values are pre-filled; for something variable, such as an electricity bill, I leave the amount empty until I know it.
Most of the time, I only need to confirm the final amount and move the transaction from Backlog to Done.
I’ll cover the actual rules and configuration in the separate Automation article (coming out in December) rather than turning this article into Automation documentation.
Turning the records into useful dashboards
Once you have several years of data, dashboards become much more interesting.
I originally wanted to recreate these views using newer Jira Reports or Home dashboards, but for this particular use case I still need more flexibility around custom finance fields. For now, I use a Marketplace app for a few simple visualizations.
I’m not trying to build a financial BI solution here. 😅 I mainly want quick answers:
- How much did I spend this month?
- Which categories are taking the biggest share?
- How does the current period compare with previous ones?
Trip summaries
One use case I particularly like is travel.
I have Epics in other Jira spaces for individual trips, and transactions can be linked back to the relevant Epic. That gives me a quick overview of what each trip actually cost and makes shared expenses easier to track — including whether somebody owes me money or, equally possible, whether I owe them. 😅
I can also, probably, build a dashboard for the trip and compare estimated versus actual spending, either overall or by category.
It’s a nice example of why I prefer having financial data connected to the rest of my personal Jira setup rather than sitting in a standalone spreadsheet.
A small connection to Atlassian Goals
I’ve also started connecting some transactions to Atlassian Goals, mainly around investments and loan repayment.
I won’t go deeper into that here because Goals has its own article in this series. The important distinction is that Jira contains the detailed financial records, while Goals tracks the longer-term outcome and progress.
Automating the boring part
The biggest weakness of this whole setup was never Jira. It was entering everything into Jira. 😅
I’ve gradually automated a lot of that work. Tasker on my phone can react to payment notifications and pass the relevant information on so a new Transaction can be created without me manually copying it from the banking app.
Receipt details are a different problem. Some receipts contain 20 or 30 items, and manually copying all of that is exactly as fun as it sounds. 🫠 That’s where I’ve been experimenting with Rovo and, more recently, ChatGPT/MCP to interpret the receipt, find the existing Transaction and fill in the missing information.
Together, Automation and AI have probably removed around 80–90% of the effort I used to spend on an individual transaction.
I’ll leave the technical rabbit holes for the dedicated Automation and Rovo/MCP articles — otherwise this finance article might accidentally turn into an integration guide. 😅
I’m curious how you’d approach this. Have you ever used Jira (or another Atlassian app) to track your spending? What would you track, and what would you happily leave out? 😅
← Previous articleㅤSeries HubㅤNext article →