FINANCIAL EXPENSE TRACKER

This repository hosts the source code for a Financial Expense Tracker web application. It enables users to conveniently manage their financial transactions.

[Blog] [Dashboard] [Demo App]

Features

• Add New Data: Input new expenses or income by specifying the account, category, transaction type, amount, and description.
• Show Data: View financial data in a Google Sheets document by clicking the "Show Data" button.
• Dashboard: Analyze and visualize financial data through an integrated dashboard.

Technologies Used

• HTML: Structure of the web pages.
• CSS: Styling and layout.
• JavaScript: Functionalities of the application.
• Google Sheets API: Storage and management of financial data.
• Google Data Studio: Dashboard for data visualization and analysis.

Usage

1. Clone the repository to your local machine by running git clone https://github.com/ahmedsalim3/Expense-Tracker.git in a command prompt.
2. Create a new google spreadsheet and add the columns: Date, Account, Category, Note, Amount, Income/Expense.
3. Go to Extensions > Apps Script in the menu bar to open the Google Apps Script editor.
4. Copy and paste the App Script.
5. Click Deploy at the top right of the App Script page and select New deployment.
6. Set the deployment type to Web App and grant access to Anyone.
7. Authorize access and copy the Web app URL.
8. Paste the script URL in the script.js file in your web browser.
9. Run index.html and start adding your financial transactions by filling out the form fields.

• Click the "Submit" button to add the transaction. To view your financial data, click the "Show Data" button. Note: Replace the Google Sheets link in Line 59 with your own Google Sheets document link.
• Create a new dashboard in Looker studio and connect your data to report via Google Sheets or BigQuery connectors.