/bills-tracker

Bills tracker with Google Spreadsheet

Primary LanguageJavaScript

Bills Tracker

This is a project based on a progressive web app to Track and share expenses with a Google Drive Spreadsheet in a very simple way.

Stars Last Commit Commit activity Maintenance

Table of Contents

Objectives

  • Save bills to a spreadsheet quickly and easily
  • Separate types of expenses
  • Show all the records with graphs
  • Share your expenses with others on the same spreadsheet
  • Identify how are you spending your money!

Screenshots

Architecture

public/img/Arch.png

Development Requirements

These instructions will allow you to obtain a copy of the running project on your local machine for development and testing purposes.

The first thing you need to do is create a fork of this project and clone it. To start using the software it is only necessary to have Node.js installed on your system.

Once the fork is cloned and Node installed.js on your system, you can install the project dependencies by following these steps;

Installs project dependencies

npm install

Add an .env file to the project root and enter your credentials

touch .env
REACT_APP_REDIRECT_URI=<REACT_APP_REDIRECT_URI>
REACT_APP_BASE_URI=<REACT_APP_BASE_URI>
REACT_APP_GOOGLE_OAUTH_CLIENT_ID=<REACT_APP_GOOGLE_OAUTH_CLIENT_ID>
REACT_APP_GOOGLE_OAUTH_CLIENT_SECRET=<REACT_APP_GOOGLE_OAUTH_CLIENT_SECRET>

Run the project

npm start

Onboarding

1. Create a spreadsheet

2. Onboarding process

Insert data into onboarding fields.

  • Insert you name in the "NAME" field
  • Insert the spreadsheet ID or URL
  • Click "Login" and magic!

Information

You can use the app with shared data if 2 or more users enter the same SpreadsheetID/URL using different names.

BillsTracker don’t save or track any information about you. All the data entered in the application belongs only and solely to the user, BillsTracker does not store any type of information since we do not have a database to do so. The code of the app is public and open source, we don’t have any back-end, it’s just front-end.

If you want to collaborate or support the project in any way, feel free to do so through the GitHub profile

Example

  • I have a functional example on Netlify

Next steps

  • Validate inputs
  • Show graphs
  • Editable expense type dropdown values
  • Improve the code
  • Google login
  • Show important information for the user on the home page
  • Monthly, weekly and daily recurring expenses automatically
  • Ability to create a monthly budget
  • Add income
  • Financial health analysis in plain text for the user
  • Improve categories

Author

Joaquin Beceiro

Contributors ✨


GFPdu

DerOrangeBaron

SirMendacium

Expressions of gratitude 🎁

  • Tell others about this project 📢
  • Invite someone on the team for a beer 🍺 or coffee ☕.
  • Give thanks publicly 🤓.
  • Star to the project ⭐

Invitame un café en cafecito.app