mitul45 / expense-manager Goto Github PK

View Code? Open in Web Editor NEW

434.0 17.0 41.0 18.69 MB

💸 Take control back. Track your everyday spendings.

Home Page: https://mitul45.github.io/expense-manager/

License: MIT License

HTML 35.96% JavaScript 57.73% Shell 2.33% CSS 3.97%

javascript expense-tracker sheets-api service-worker progressive-web-app

expense-manager's Introduction

💸 expense-manager

"If you can't measure it, you can't improve it." - Peter Drucker

Take control back. Introducing Expense Manager, an app to track your daily spendings. It is made of two main components:

Main application: Used to add expenses to the sheet
Expense Sheet: This is where you can do all kinds of analysis/summarization of your expenses.

Why? Because Google Sheets is really good with numbers, but entering data from the mobile app is not very convenient. The idea is to make adding expense as simple as it can be. You should add them at the same moment you make a transaction. Make it like a habit.

Detailed analysis of the sheet can be deferred till you get an access to a computer. You can plot fancy charts at end of the month, set the budget for next week, etc. And I feel all of that need not necessarily be done on small screen.

Features

Built for the web - works cross-platform (iOS, Android, Mac, Windows, Linux).
Uses Google Sheet as a database to store expenses. Why?
1. Privacy. It's your personal data. It should belong to you.
2. Sheets is way better at handling numbers than me. You can do all kinds of analysis using graphs, formulas, etc.
3. I didn't want to write backend 🤓
Progressive Web App - Quick to load, can be installed as a standalone app on phone.
Easier sharing. Sharing expenses with someone (wife, family)? Share the expense sheet and all of your combined data belongs to the single sheet.
Backup. Didn't I tell you it uses Google Sheets to store expenses? Your data is always backed up on ⛅
Mobile friendly layout.
[NEW] Supports internal amount transfer enteries (things like withdrawing cash, investing to an retirement account, etc)

How to get started

Copy this sheet to your Google Drive. After sign in, choose File -> Make a Copy....
Don't rename it. It should be named Expense Sheet.
Update categories, account names, initial values in Data sheet. Clear our sample expenses in the first sheet.
That's it! You can start adding expenses now.

Permissions

Read access to Google Drive to find Expense Sheet.
Read and write access to Google Sheets to add expenses.

Check it out

https://mitul45.github.io/expense-manager/ 🚀

expense-manager's People

Contributors

Stargazers

Watchers

expense-manager's Issues

Set today's date by default in date picker

Demo doesn't work Android phone

Demo doesn't work Android phone, not sure about other options though.

Recurring payments

Nice project!

Are you planning to add support for recurring payments? What would be the easiest way to go about that?

Icon for Home Screen

Super cool! Was wondering if it would be possible to add an image so the site would display more like an app on phone home screens.

Doesn't work with iPhone 7+ with 10.3.2 beta3

how to deploy this on your own website.

i give a try to upload this code on my website but it shows loading no login page.

Unable to login "app not validated by Google"

When trying to login using Google account, it says "this application is not verified by Google to use this".

Errors on iphone 5s safari ios10.3.1

Got this from the debugger

SyntaxError: Can't create duplicate variable that shadows a global property: 'amount'
ReferenceError: Can't find variable: handleClientLoad
	onload (expense-manager:82)

Decimals support?

The app don't let introduce decimal numbers on amount. I try with "." and "," in Chrome

Date overlays the label in Chrome (Bug)

When you launch the app it displays Date and current Date in the same input making it hard to read.

Offer to create stylesheet

Instead of showing an error why not create the stylesheet?

Monthly records template (Google Sheets)

It would be awesome to have a month by month view of records and a summary how much you spent in the given month.

Do you have an idea how to create a sheet with this functionality?

Instruction to host on personal Server

Update service worker to refresh JS, CSS changes

Since current implementation caches both script.js and style.css using service workers, any changes are not being reflected to returning users.

Maybe useful: https://jakearchibald.com/2014/offline-cookbook/#network-falling-back-to-cache.

Offline support

What do you think about the ability to add expenses offline? We could leverage service workers and a cache for that.

Inquiry Regarding Deprecated Google Authentication Library

Hi @mitul45,

I came across your public GitHub repository, and I noticed that the code, last updated five or six years ago, is currently encountering an error related to the use of deprecated Google Sign-In JavaScript libraries.

You have created a new client application that uses libraries for user authentication or authorization that are deprecated. New clients must use the new libraries instead. See the Migration Guide for more information.

The console output suggests migrating to newer authentication and authorization methods, as outlined in the Migration Guide. Given the recent changes by Google, the existing code may not be functioning as expected.

I'm reaching out to inquire if you have any plans to address this deprecation and update the authentication libraries in your project.