Fintrack

Fintrack is a personal finance tracker prototype for capturing, reviewing, and managing transactions from manual entries, SMS/email-style records, and receipt files. It uses a local-first SQLite database and a polished dashboard built with plain HTML, CSS, browser JavaScript, and Node.js.

• Server: Node.js HTTP server
• Frontend: HTML, CSS, and vanilla JavaScript
• Database: SQLite through better-sqlite3
• Receipt extraction: Gemini receipt file reading when GEMINI_API_KEY is configured
• Exchange Rate API: Converts receipt currencies when EXCHANGE_RATE_API_KEY is configured

• Landing page with onboarding entry points
• Local onboarding for profile, location, and capture preferences
• Dashboard with balance, income, expense, savings rate, top spending, and recent activity
• Receipt capture at /scan using image, PDF, Word document, or text-file upload
• Manual transaction entry
• Transaction management at /transactions
  • Search by merchant, category, or note
  • Filter by category and source
  • Edit merchant, amount, category, type, status, source, and note
  • Delete/remove transactions
• Settings screen for profile, currency, notifications, and capture toggles
• JSON APIs for users, categories, dashboard data, transactions, and receipt extraction

server.js Node server, SQLite access, API routes, static fallback
public/index.html Browser app shell
public/styles.css Fintrack visual system and responsive layout
public/app.js Vanilla JavaScript SPA, forms, routing, and UI rendering
dev.db Local SQLite database
DESIGN.md Design direction preserved from the original app

• Node.js 20 or newer
• npm

This project uses native better-sqlite3 bindings. If you switch Node versions after installing dependencies, rebuild the native package:

npm rebuild better-sqlite3

npm install

Create a .env.local file:

# Optional: enables Gemini receipt extraction
GEMINI_API_KEY="your-api-key"
GEMINI_MODEL="gemini-2.5-flash"
# Optional: exchange rates for converting receipt currencies into the user's default currency
EXCHANGE_RATE_API_URL="https://v6.exchangerate-api.com/v6/latest/{base}"
DATABASE_URL=file:./dev.db

The app stores data in dev.db. The server creates required SQLite tables/columns automatically if they are missing.

npm run dev

Open:

• Landing page: http://127.0.0.1:3000
• Onboarding: http://127.0.0.1:3000/onboarding
• Dashboard: http://127.0.0.1:3000/dashboard
• Capture: http://127.0.0.1:3000/scan
• Transactions: http://127.0.0.1:3000/transactions
• Settings: http://127.0.0.1:3000/settings

npm run dev # Start the Node development server
npm run build # Syntax-check server and browser JavaScript
npm run start # Start the Node server
npm run lint # Syntax-check server and browser JavaScript

• Receipt capture is implemented with a file input that accepts images, PDFs, Word documents, and text files. Mobile browsers may still offer camera capture for image selection.
• The app currently uses the first local user record as the active user. Full authentication is not implemented yet.
• Do not commit real API keys or production secrets in .env or .env.local.