Making my Own Expense Tracker WebApp

 My Own Expense Tracker - Sonic Ledger

I made a expense tracker management software. I call this as Sonic Ledger. This helps you to track your expenses and store personal notes. Here you can store your financial transactions. Deposit or spend is there with variety of categorization like entertainment, food, shopping etc. 

The Home dash board shows you a doughnut for your expense and deposit. It also helps you see your deposits , spends and spends classified in categories in the form of bar charts.

Features as per V 2.0

1.Multiple ledgers/Account support

2.Personal Notes/Blogs

3. Doughnut, Bar charts for deposits and expense overview

4. Identity Auth service with 2FA support

5. Expense categorization

This application is built using .NET 5 MVC. It uses ChartJs library for chart visualization pages. This uses SQLite database but it can be configured to work with Microsoft SQL Server or Postgres or My SQL as it uses the popular Micro ORM Dapper and ORM Entity Framework Core 5.

It is quite well built using the MVC design pattern and uses best practices for the EF Core library.

I am planning to built a  SPA version for the same project with Angular for web and Ionic for mobile app. Its half way there and it will be ready soon.

I haven't focused more on the design and UX as for now I will be the one using it. Even the registration is restricted to the admin only. I will share when i will host this. I am planning to do in Microsoft Azure as that is the one cloud provider i am familiar with. 

Home Page                        Login Page                    

 

Home dashboard                Features List

 

Expense Chart                Deposit Chart

Add New records
Ledger/Account Home


I will improve this as i develop and add new features also it will have a clean UI in the next versions planned. 
Few features i am working on for this project
1. Import/Export from Excel/Json/CSV
(Currently you can only export in json and Import is not supported)
2. Invoice and report generation
3. SPA and Mobile App
4. Payment reminders
5. Spending limit alerts
6. Debit/Credit Card or Password or Finance related sensitive info storage

Thanks for Reading, Hope you like it.
If not I will try again 😑





Comments

Post a Comment

Popular posts from this blog

Use SCSS with ASP.NET Core 5.x or 3.X

Image
Here we will see how we can use SCSS or SASS with ASP.NET Core 3.X or 5.X Here is the step to step guide for using SCSS in ASP.NET Core. Step 1: Install sass as global using npm: npm install --global sass Bash Copy Step 2: Create a new ASP.NET Core project , choose MVC or Razor Pages Add a SCSS file to the Web app, here I have added test.scss to the wwwroot/css folder. Add the following lines to the .csproj file to enable SCSS to CSS compilation in the web app. For  node-sass  and  ruby-sass  write this: sass --no-source-map $( ProjectDir ) wwwroot/css/test2.scss $( ProjectDir ) wwwroot/css/test2.css Bash Copy If you're using  dart-sass If you're using dart-sass the usage is --no-source-map sass --no-source-map $( ProjectDir ) wwwroot/css/test2.scss $( ProjectDir ) wwwroot/css/test2.css Bash Copy   < Target Name = " ScsstoCss " BeforeTargets = " Build " > < Exec Command = " mkdir $(ProjectDir)wwwroot/css " Condition = " !Exist
Read more

Building a Login Flow with .NET MAUI

Image
​ Let's build a Login Flow with .NET MAUI with Shell. Authentication in any mobile app is very common. Lets get started with this. Its obvious that it should ask for login only if it isn't authenticated. We will check for authentication , if not there we will move to Login page if login is success we will move to the Home page. For this example we will override the backbutton pressed event to quit the application but you can customize accordingly as per your need. For this post I am using a simple authentication but you can use JWT or any method you want.  Here is the example of the login flow:       All the pages that has to be used needs  to be registered with the Shell. If you are a bit familier with the Shell navigation the first content page is the one which is displayed after startup. So we need to structure the shell accordingly in order. The pages we are using here for the example: LoadingPage LoginPage HomePage SettingsPage Here is the AppShell.xaml <
Read more

PySpark Schema Generator - A simple tool to generate PySpark schema from JSON data

Image
 Hi Folks, I built a small tool that solves a problem for a data engineer while dealing with JSON data. As we know JSON data is semi-structured and we always ingest them and denormalize them to smaller tables properly for further processing. In my case I had to generate PySpark Schema from JSON to ingest the data and the JSON structure often gets changed. The JSON I was dealing was very complex but let me give you an example about the tool, what problem it solves. For example we have a JSON coming from Kafka like below {   "name": "PREETish ranjan",   "dob": "2022-03-04T18:30:00.000Z",   "status": "active",   "isActive": true,   "id": 102,   "address": {     "city": "Bhubaneswar",     "PIN": 500016   },   "mobiles": ["8989898989", "5656565656"],   "id_cards": [1, 2, 3, 4, 5] } The output i need is like this, StructType([     Str
Read more