Building a Custom Asset Tracker: Why I Made Asset Note Instead of Using Excel
Last updated on

Building a Custom Asset Tracker: Why I Made Asset Note Instead of Using Excel


I did not build Asset Note because there were no finance apps.

I built it because existing tools still pushed me back toward spreadsheets, manual calculation, or UI clutter when all I really wanted was a cleaner way to understand my own spending patterns.

Asset Note became a practical side project: part personal tool, part product experiment, and part lesson in building a focused app around a narrow user need.


What problem I wanted to solve

Many finance tools are powerful, but they often bundle too many things together:

  • heavy onboarding
  • ads or promotional clutter
  • broad feature sets
  • unclear summaries

What I wanted instead was much simpler:

  • fast entry
  • readable spending history
  • budget awareness
  • a view that felt calm enough to use every day

That narrower scope helped the product feel more manageable from the start.

The three product principles behind Asset Note

Before choosing technology, I tried to keep the product goals clear.

1. Make the UI easy to scan

Finance products can become visually exhausting quickly. Too many numbers, labels, and decorative elements make users work harder than necessary.

So the interface prioritized:

  • clean summaries
  • readable transaction lists
  • obvious category grouping
  • quick switching between views

2. Make budgeting feel actionable, not passive

I did not want the app to only record what happened after the month was already over.

The more useful version was one that helps answer:

  • am I overspending relative to my target?
  • how fast is my current burn rate?
  • how close am I to the savings goal I set?

That makes the tool feel more like a decision aid than a static diary.

3. Keep access lightweight

Because this was meant to be a tool I would actually use often, the product needed to feel reachable from both desktop and mobile without a large install barrier.

That pushed the project toward a responsive web product and PWA-style accessibility rather than a native-first build.

Why this stack made sense

The stack was not chosen for novelty. It was chosen because it fit a small product that needed to move quickly.

  • Next.js for a practical full-stack React workflow
  • Prisma for safer database access and quicker iteration
  • PostgreSQL for reliable relational data
  • Tailwind CSS for fast UI assembly

This combination reduced the number of architectural decisions I needed to keep revisiting.

What mattered technically during development

One of the more important technical questions was not “which library is coolest?” but “which parts of the product must stay responsive even as data grows?”

That led to a few priorities:

  • clean server-side data aggregation
  • predictable auth flow
  • responsive chart rendering
  • a UI that stayed readable on smaller screens

For a personal finance product, trust and clarity matter at least as much as raw feature count.

The main performance bottleneck: data visualization

The hardest part was not authentication or page routing. It was making the financial summaries feel fast when more historical data accumulated.

If a large range of transactions is loaded into the browser and all grouping happens on the client, chart rendering and summary calculations can become wasteful.

That is why the app leaned toward server-side aggregation where possible. Instead of asking the browser to do every grouping pass itself, the backend could return more prepared data for charts and summaries.

That tradeoff reduced unnecessary frontend work and made the reporting layer feel more stable.

What I learned on the product side

Shipping a focused finance tool reinforced a few product lessons:

1. Narrow scope is a strength

Trying to become a full-featured finance platform too early would have made the app weaker.

2. Daily-use products need calm UI

Users return more easily to products that feel low-friction and visually stable.

3. Small motivational signals matter

Budget pace, target reminders, and progress framing can make a tool feel much more alive than static record keeping alone.

What I would improve next

If I keep expanding Asset Note, the next useful improvements would probably be:

  • smarter categorization support
  • better recurring transaction workflows
  • stronger trend comparisons
  • clearer mobile-first summary states

These are better next steps than simply adding more settings or cosmetic features.

Why side projects like this are valuable

A product like Asset Note is useful even beyond its immediate feature set.

It forces decisions across:

  • product scope
  • UI clarity
  • data modeling
  • performance tradeoffs
  • deployment and iteration

That makes it a strong kind of side project for developers who want to practice both engineering and product judgment at the same time.

FAQ

Q. Why build a finance tracker when many already exist?

Because a narrower tool can still solve a personal workflow better than a broader, more cluttered product.

Q. What was the hardest technical part?

Keeping reporting and visualization responsive as the data model became more realistic.

Q. What made the project worth building?

It combined a real personal need with practical full-stack product decisions, which makes it more valuable than a purely decorative demo.

Start Here

Continue with the core guides that pull steady search traffic.